SELECT `prod`.`name`, `prod`.`price`,
GROUP_CONCAT(CONCAT(`atr`.`nameAttribute`, '=' , `val`.`attributeValue`) as `attribute`,
FROM `products` as `prod`
LEFT JOIN `productAttribute` as `atr` ON `prod`.`idProduct` = `atr`.`idProduct`
LEFT JOIN `attributeValue` as `val` ON `atr`.`idAttribute` = `val`.`idAttribute`
WHERE `prod`.`idCategory` = :idCategory
GROUP BY `prod`.`idProduct`;SELECT `u1`.`name`, `u2`.`name`, COUNT(*) AS `count`
FROM `users_groups` AS `ug1`
JOIN `users_groups` AS `ug2`
ON `ug2`.`group_id` = `ug1`.`group_id`
AND `ug2`.`user_id` > `ug1`.`user_id`
JOIN `users` AS `u1`
ON `u1`.`id` = `ug1`.`user_id`
JOIN `users` AS `u2`
ON `u2`.`id` = `ug2`.`user_id`
GROUP BY `ug1`.`user_id`, `ug2`.`user_id`
ORDER BY `count` DESC
LIMIT 1FROM products prodINNER JOIN categories cat ON prod.idCategory = cat.idCategoryINNER JOIN productAttribute atr ON cat.idCategory = atr.idCategoryINNER JOIN attributeValue val ON cat.idCategory = val.idCategoryINSERT INTO `table` (`two`, `three`)
SELECT `t1`.`two`, `t1`.`three`
FROM (
SELECT :two AS `two`, :three AS `three`
) AS `t1`
LEFT JOIN `table` AS `t2` USING (`two`, `three`)
WHERE `t2`.`two` IS NULL;SELECT `p`.`title`, GROUP_CONCAT(`t`.`tag` SEPARATOR ',')
FROM `page_tag` AS `pt`
JOIN `tag` AS `t` ON `t`.`id` = `pt`.`tag_id`
JOIN `pages` AS `p` ON `p`.`id` = `pt`.`page_id`
GROUP BY `p`.`id`UPDATE `advert`
SET `last` = NOW()
WHERE `status` = 1
ORDER BY `last`
LIMIT 1;SELECT `t1`.`friendid`
FROM `friends` AS `t1`
JOIN `friends` AS `t2` ON `t2`.`userid` = `t1`.`friendid`
AND `t2`.`friendid` = `t1`.`userid`
WHERE `t1`.`userid` = :myIdSELECT `t2`.*
FROM (
SELECT `userId`, MAX(`uploadAt`) AS `uploadAt`
FROM `files`
GROUP BY `userId`
) AS `t1`
JOIN `files` AS `t2` USING (`userId`, `uploadAt`);SELECT `dates`.`date`, IFNULL(`t1`.`count`, 0) AS `cnt1`,
IFNULL(`t2`.`count`, 0) AS `cnt2`, IFNULL(`t3`.`count`, 0) AS `cnt3`
FROM (
SELECT `date` FROM `table1`
UNION SELECT `date` FROM `table2`
UNION SELECT `date` FROM `table3`
) AS `dates`
LEFT JOIN (
SELECT `date`, COUNT(*) AS `count` FROM `table1` GROUP BY `date`
) AS `t1` ON `t1`.`date` = `dates`.`date`
LEFT JOIN (
SELECT `date`, COUNT(*) AS `count` FROM `table2` GROUP BY `date`
) AS `t1` ON `t2`.`date` = `dates`.`date`
LEFT JOIN (
SELECT `date`, COUNT(*) AS `count` FROM `table3` GROUP BY `date`
) AS `t1` ON `t3`.`date` = `dates`.`date`
ORDER BY `dates`.`date`UPDATE `table`
SET `time` = `time` + INTERVAL 1 DAY
WHERE @id := `id` AND `time` <= NOW()
ORDER BY `time`
LIMIT 1;
SELECT *
FROM `table`
WHERE `id` = @id;SELECT `e`.`email`, IFNULL(`t1`.`name`, `t2`.`name`) AS `name`
FROM (
SELECT DISTINCT `email` FROM `table1`
UNION DISTINCT SELECT `email` FROM `table2`
) AS `e`
LEFT JOIN `table1` AS `t1` ON `t1`.`email` = `e`.`email`
LEFT JOIN `table2` AS `t2` ON `t2`.`email` = `e`.`email`$date = date_create($x[0]['time']);
echo date_format($date, 'd.m.Y H:i');