SELECT `product_attr`.*, `attr`.* , `product_attr_lang`.`langtext`, `attr_lang`.`title`, `attr_lang`.`langtextafter`, `attr_lang`.`langimage` FROM `attr` LEFT JOIN `product_attr` ON `product_attr`.`attr_id` = `attr`.`id` LEFT JOIN `product_attr_lang` ON `product_attr_lang`.`productid` = `product_attr`.`productid` AND `product_attr_lang`.`attr_id` = `product_attr`.`attr_id` AND `product_attr_lang`.`langid` = '1001' LEFT JOIN `attr_lang` ON `attr_lang`.`indexid` = `attr`.`id` AND `attr_lang`.`langid` = '1001' WHERE `product_attr`.`productid` IN ('220') ORDER BY `attr`.`parent_id`, `attr`.`sort` SELECT `product_attr`.*, `attr`.* , `product_attr_lang`.`langtext`, `attr_lang`.`title`, `attr_lang`.`langtextafter`, `attr_lang`.`langimage` FROM `attr` LEFT JOIN `product_attr` ON `product_attr`.`attr_id` = `attr`.`id` LEFT JOIN `product_attr_lang` ON `product_attr_lang`.`productid` = `product_attr`.`productid` AND `product_attr_lang`.`attr_id` = `product_attr`.`attr_id` AND `product_attr_lang`.`langid` = '1001' LEFT JOIN `attr_lang` ON `attr_lang`.`indexid` = `attr`.`id` AND `attr_lang`.`langid` = '1001' WHERE `product_attr`.`productid` IN ('220') ORDER BY `attr`.`parent_id`, `attr`.`sort` SELECT `product_attr`.*, `attr`.* , `product_attr_lang`.`langtext`, `attr_lang`.`title`, `attr_lang`.`langtextafter`, `attr_lang`.`langimage` FROM `attr` LEFT JOIN `product_attr` ON `product_attr`.`attr_id` = `attr`.`id` LEFT JOIN `product_attr_lang` ON `product_attr_lang`.`productid` = `product_attr`.`productid` AND `product_attr_lang`.`attr_id` = `product_attr`.`attr_id` AND `product_attr_lang`.`langid` = '1001' LEFT JOIN `attr_lang` ON `attr_lang`.`indexid` = `attr`.`id` AND `attr_lang`.`langid` = '1001' WHERE `product_attr`.`productid` IN ('228','288','227','287','216','565') ORDER BY `attr`.`parent_id`, `attr`.`sort` SELECT `product_attr`.*, `attr`.* , `product_attr_lang`.`langtext`, `attr_lang`.`title`, `attr_lang`.`langtextafter`, `attr_lang`.`langimage` FROM `attr` LEFT JOIN `product_attr` ON `product_attr`.`attr_id` = `attr`.`id` LEFT JOIN `product_attr_lang` ON `product_attr_lang`.`productid` = `product_attr`.`productid` AND `product_attr_lang`.`attr_id` = `product_attr`.`attr_id` AND `product_attr_lang`.`langid` = '1001' LEFT JOIN `attr_lang` ON `attr_lang`.`indexid` = `attr`.`id` AND `attr_lang`.`langid` = '1001' WHERE `product_attr`.`productid` IN ('289','287','288','228','227','218','314','214') ORDER BY `attr`.`parent_id`, `attr`.`sort`