SELECT `g`.`id`, `g`.`name`, `g`.`description`, `g`.`price`, `i`.`images`
FROM `goods` AS `g`
LEFT JOIN (
SELECT `good_id`, GROUP_CONCAT(`link` SEPARATOR ',') AS `images`
FROM `images`
GROUP BY `good_id`
) AS `i` ON `i`.`good_id` = `g`.`id`
WHERE `g`.`id_category` = :category
ORDER BY `g`.`id` DESC;SELECT `a`.`name`, IFNULL(`c`.`count`, 0)
FROM `author_user` AS `au`
JOIN `authors` AS `a` ON `au`.`user` = :user AND `a`.`id` = `au`.`author_id`
LEFT JOIN (
SELECT `p`.`author_id`, COUNT(*) AS `count`
FROM `posts` AS `p`
LEFT JOIN `post_user` AS `pu` ON `pu`.`user_id` = :user AND `pu`.`post_id` = `p`.`id`
WHERE `pu`.`post_id` IS NULL
GROUP BY `p`.`author_id`
) AS `c` ON `c`.`author_id` = `au`.`author_id`SELECT `id`
FROM `table`
WHERE `f_id` IN (27, 47)
GROUP BY `id`
HAVING COUNT(`id`) = 2print md5('a'.''.md5('b'));
57e9f61da712c151b9d535392036223fSELECT MD5(CONCAT('a', MD5('b')))
57e9f61da712c151b9d535392036223f9. ОБЪЕМ ЛИЦЕНЗИИ.
...
Вы не имеете права:
...
· предоставлять программное обеспечение в прокат, в аренду или во временное
пользование;