0 THEN 1 ELSE 0 END AS hasquantity, products.prodescriptionen AS prodescription, products.discount AS discountx, products.prodcode, products.checkcode, products.menudescen AS menudesc, products.desc1en AS desc1, products.desc2en AS desc2, products.txts, CASE WHEN (SELECT COUNT(checkcode) FROM [index] WHERE checkcode = products.checkcode) > 1 THEN 1 ELSE 0 END AS counter, (SELECT TOP (1) foto1 FROM [index] WHERE checkcode = products.checkcode AND foto1 <> '') AS foto1, CASE WHEN products.discount > 0 THEN 1 ELSE 0 END AS offer FROM products LEFT OUTER JOIN catalogues c ON c.catid = products.pricesid AND c.custcatid = 18 WHERE (1=1 AND products.activity = 1 ) order by fotoexists desc , FT2ID,ordervalue, aa desc' name='test'>