SELECT t1.*,t7.slug_en, (SELECT t3.price FROM goods_prices as t3 WHERE t3.group_id='1' AND t3.good_id=t1.id LIMIT 1) as price,(SELECT t3.saleprice FROM goods_prices as t3 WHERE t3.group_id='1' AND t3.good_id=t1.id LIMIT 1) as saleprice, (SELECT t3.price FROM specprices as t3 WHERE t3.code=t1.good_n AND t3.uid='' LIMIT 1) as specprice, (SELECT t3.price FROM options as t3 WHERE t3.id=(SELECT t5.optionid FROM basket as t5 WHERE t5.good_id=t1.id AND t5.owner_id='' LIMIT 1) LIMIT 1) as optionprice, (SELECT columnValue FROM langs WHERE tableName='products ' AND tableId=t1.id AND tableColumn='title' AND shortname='en' LIMIT 1) AS titleen , (SELECT quantity FROM basket WHERE good_id=t1.id AND owner_id='' LIMIT 1) AS 'quantity' , (SELECT comment FROM basket WHERE good_id=t1.id AND owner_id='' LIMIT 1) AS 'comment' , (SELECT columnValue FROM langs WHERE tableName='products ' AND tableId=t1.id AND tableColumn='description' AND shortname='en' LIMIT 1 ) AS descriptionen FROM products AS t1 LEFT JOIN sitemap as t7 ON(t1.sitemapid=t7.id) WHERE t1.id in ('')