SELECT a.attribute_id, pa.product_id, pa.text, ad.name FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON a.attribute_id = pa.attribute_id LEFT JOIN oc_attribute_description ad ON ad.attribute_id = pa.attribute_id AND ad.language_id = 3 WHERE pa.language_id = 3 AND pa.product_id IN (1271,1278,1302,1304,1306,1307,1308,6266,6267,8365,6781,6270) AND pa.attribute_id IN (1287) ORDER BY a.sort_order