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 *
FROM (
SELECT `iPageID`
FROM `page_city`
WHERE `iCityID` IN (101, 102)
GROUP BY `iPageID`
HAVING COUNT(*) = 2
) AS `t1`
JOIN (
SELECT `iPageID`
FROM `page_city`
GROUP BY `iPageID`
HAVING COUNT(*) = 2
) AS `t2` USING (`iPageID`)