(SELECT t1.*, COUNT(DISTINCTROW t3.`id`) num_links, '0' `crossed` FROM `t_categories` t1 LEFT JOIN `t_flat_structure` t2 ON t1.`id` = t2.`id_parent` LEFT JOIN `t_links` t3 ON t2.`id_category` = t3.`id_category` AND t3.`status` = 'active' WHERE t1.`id_parent` = '' AND t1.`id` >= 0 AND t1.`status` = 'active' AND t1.`id_region` IS NULL GROUP BY t1.`id` ORDER BY t1.`title` LIMIT 0, 10000) UNION ALL (SELECT t1.*, COUNT(DISTINCTROW t4.`id`) num_links, '1' `crossed` FROM `t_categories` t1 RIGHT JOIN `t_crossed` t2 ON t1.`id` = t2.`id_crossed` LEFT JOIN `t_flat_structure` t3 ON t1.`id` = t3.`id_parent` LEFT JOIN `t_links` t4 ON t3.`id_category` = t4.`id_category` AND t4.`status` = 'active' WHERE t2.`id_category` = '' GROUP BY t2.`id` ORDER BY t1.`title` LIMIT 0, 10000) <br />Unknown column 't1.order' in 'field list'