CategoryEntity SQL dotazy výpis stromu

SELECT `id`, `code`
FROM `language`
WHERE (`code` = 'cs')

SELECT `id`, `order`, `parent_id`
FROM `category`
WHERE (`category`.`id` = 137)

SELECT `category_path`.`descendant`, `ancestor`
FROM `category_path`
WHERE (`category_path`.`descendant` IN (137))
ORDER BY `category_path`.`descendant` DESC, `path_length` DESC

SELECT `id`, `parent_id`, `order`
FROM `category`
WHERE (`parent_id` IN (0, 16, 137))
ORDER BY `order`

SELECT `id`, `category_id`, `name`, `language_code`
FROM `category_locale`
WHERE (`category_locale`.`category_id` IN (541, 137, 886, 16, 81, 1359, 1621, 79, 897, 545, 82, 958,
393, 83, 844, 8, 654, 265, 13, 802, 266, 686, 77, 263, 9, 78, 153, 361, 270, 268, 281, 102, 139, 14,
111, 655, 806, 422, 645, 15, 425, 815, 930, 597, 138, 316, 682, 140, 500, 713, 141, 712, 845, 269,
476, 1211, 3014, 1716, 1222, 858, 619, 1960, 533, 728, 534, 216, 535, 18, 587, 25, 673, 360, 827,
116, 854, 294, 856, 297, 857, 329, 859, 376, 861, 494, 862, 502, 860, 300, 863, 578, 893, 622, 895,
704, 896, 632, 900, 716, 910, 745, 981, 766, 992, 908, 1299, 940, 1618, 969, 2065, 1009, 2338, 1076,
3013, 1605, 2015, 2038, 542, 2064, 2197, 2309, 2328, 2911)) AND (`language_code` = 'cs')