select `categories`.*, (selectcount(*) from `products` where `categories`.`id` = `products`.`category_id`) as `products_count` from `categories` where `level` =0orderby `order_level` desc limit 11
select `categories`.*, (selectcount(*) from `products` where `categories`.`id` = `products`.`category_id`) as `products_count` from `categories` where `parent_id` =156orderby `order_level` desc
select `categories`.*, (selectcount(*) from `products` where `categories`.`id` = `products`.`category_id`) as `products_count` from `categories` where `parent_id` =157orderby `order_level` desc
select `categories`.*, (selectcount(*) from `products` where `categories`.`id` = `products`.`category_id`) as `products_count` from `categories` where `parent_id` =158orderby `order_level` desc
select `categories`.*, (selectcount(*) from `products` where `categories`.`id` = `products`.`category_id`) as `products_count` from `categories` where `parent_id` =159orderby `order_level` desc
select `categories`.*, (selectcount(*) from `products` where `categories`.`id` = `products`.`category_id`) as `products_count` from `categories` where `parent_id` =160orderby `order_level` desc