SELECT `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` DESC
SELECT `name`
FROM `mp_tree`
WHERE :path LIKE CONCAT(`path`, '.%')
ORDER BY `path` DESC
SELECT `C`.`CI_NAME`, ISNULL(`P`.`CNT`, 0) AS `AMOUNT`
FROM `CINEMA` AS `C`
LEFT JOIN (
SELECT `CI_NAME`, COUNT(*) AS `CNT`
FROM `PROGRAM`
GROUP BY `CI_NAME`
) AS `P` ON `P`.`CI_NAME` = `C`.`CI_NAME`
WHERE (`CI_ADDRESS` LIKE '%Pilsner%')
ORDER BY `AMOUNT`
SELECT `P`.`CI_NAME`, `F`.`F_NAME`, `P`.`DATE`
FROM `FILMS` AS `F`
LEFT JOIN `PROGRAM` AS `P` ON `P`.`F_NAME` = `F`.`F_NAME`
ORDER BY `P`.`CI_NAME`, `P`.`DATE`
SELECT `C`.`CI_ADRESS`
FROM `CINEMA` AS `C`
LEFT JOIN (
SELECT DISTINCT `CI_NAME`
FROM `PROGRAM`
WHERE `F_NAME` = 'Forman'
) AS `P` ON `P`.`CI_NAME` = `C`.`CI_NAME`
WHERE `P`.`CI_NAME` IS NULL