LEFT JOIN users_app AS b ON b.id = a.id_contact AND a.type_contact = 0
LEFT JOIN apps AS f ON f.id = a.id_contact AND a.type_contact = 1SELECT `r`.`id`, `r`.`name`, `r`.`description`
FROM `recept`
LEFT JOIN (
SELECT DISTINCT `cr`.`parent_id` AS `parent_id`
FROM `component_recept` AS `cr`
LEFT JOIN (
SELECT `parent_id`
FROM `user_component`
WHERE `user_id` = :uid
) AS `uc` ON `uc`.`parent_id` = `cr`.`parent_id`
WHERE `uc`.`parent_id` IS NULL
) AS `xr` ON `xr`.`parent_id` = `r`.`id`
WHERE `xr`.`parent_id` IS NULLSELECT `n`.`id`, IFNULL(`c`.`count`, 0)
FROM `news` AS `n`
LEFT JOIN (
SELECT `news_id`, COUNT(*) AS `count`
FROM `like`
WHERE `date` > date_sub(NOW(), INTERVAL 7 day)
GROUP BY `news_id`
) AS `c` ON `c`.`news_id` = `n`.`id`
ORDER BY `c`.`count` DESC
LIMIT 100SELECT `news_id`, COUNT(*) AS `count`
FROM `like`
WHERE `date` > date_sub(NOW(), INTERVAL 7 day)
GROUP BY `news_id`
ORDER BY `count` DESC
LIMIT 100SELECT `t2`.`name`
FROM `mp_tree` AS `t1`
JOIN `mp_tree` AS `t2`
ON `t1`.`path` LIKE CONCAT(`t2`.`path`, '.%')
WHERE `t1`.`id` = :id
ORDER BY `t2`.`path` DESCSELECT `name`
FROM `mp_tree`
WHERE :path LIKE CONCAT(`path`, '.%')
ORDER BY `path` DESC