SELECT `category`.*, `language`.`iso_code` FROM (`category`) JOIN `category_product` ON `category_product`.`category_tid`=`category`.`tid` JOIN `product` ON `product`.`tid`=`category_product`.`product_tid` JOIN `lang_support` ON `lang_support`.`article_id`=`category`.`id` JOIN `language` ON `language`.`id`=`lang_support`.`lang_id` WHERE `category`.`status` = 1 AND `lang_support`.`module` = 'category' ORDER BY `category`.`ordering` ASC
Error(1146) Table 'orients1_db.category_product' doesn't exist