string(743) "SELECT `site_categories`.*, `site_categories_description`.*, (
 select
 count(*) from site_product
 join site_product_description on site_product_description.id_product = site_product.id
 where
 id_language = site_categories_description.id_language
 and site_categories.id = site_product.id_category
 and site_product_description.title != ""
 ) as tem_produtos
FROM (`site_categories`)
JOIN `site_categories_description` ON `site_categories_description`.`id_categories`=`site_categories`.`id`
JOIN `ez_language` ON `ez_language`.`id`=`site_categories_description`.`id_language`
WHERE `site_categories`.`status` =  1
AND `ez_language`.`code` =  'en'
AND `site_categories_description`.`slug` =  'steel-mats'
ORDER BY `site_categories`.`order_by`"