string(1838) " SELECT a.id, a.art_code, a.image, a.epsdoc, a.title, a.vtiger_product_no, a.concorrenti, a.disponibilita_negozio, a.availability, a.delivery_time, a.supplier, a.id_brand, a.amount_with_tax, a.fissa_prezzo_vendita, a.content, a.prezzo_negozio, a.prezzo_promo_negozio, a.prezzo_web, c.id AS cat_id, c.title AS cat_title , c.id AS cat_id, c.id_reparto AS cat_id_reparto, c1.id AS cat_id_c1, c1.title AS cat_title_c1, c1.id_reparto AS cat_id_reparto_c1, c1.state AS cat_state_c1, c2.id AS cat_id_c2, c2.title AS cat_title_c2, c2.id_reparto AS cat_id_reparto_c2, c2.state AS cat_state_c2, c3.id AS cat_id_c3, c3.title AS cat_title_c3, c3.id_reparto AS cat_id_reparto_c3, c3.state AS cat_state_c3, br.title AS brand, br.image as brand_image, a.amount AS original_amount, a.amount*(1+IFNULL(a.vat_perc,0)/100) as amount, a.shipping_first, if(a.sold_out or a.availability=0, 1, 0) as sold_out, a.discount, a.vat_perc, a.final_amount, a.buy_price, a.content2, a.prezzo_si_vendita_no, a.no_vendita_online FROM site_catalog_art a INNER JOIN site_catalog_cat c ON a.id_cat = c.id AND c.state = 1 LEFT JOIN site_catalog_cat c1 ON c.id_parent = c1.id AND c1.state = 1 LEFT JOIN site_catalog_cat c2 ON c1.id_parent = c2.id AND c2.state = 1 LEFT JOIN site_catalog_cat c3 ON c2.id_parent = c3.id AND c3.state = 1 LEFT JOIN site_catalog_brands br ON a.id_brand = br.id WHERE -- c.id_instance = 101 AND a.state = 1 AND (a.id_cat = 196076 OR c.id_parent = 196076 OR (c1.id_parent = 196076) OR (c2.id_parent = 196076))AND a.prezzo_promo_negozio IS NOT NULL ORDER BY a.id_cat = '196076' DESC, 1=1, sold_out = 0 DESC, IFNULL(a.final_amount, a.amount*(1+IFNULL(a.vat_perc,0)/100)*(1-IFNULL(a.discount,0)/100)), a.ordering IS NOT NULL DESC, a.ordering ASC, a.title DESC LIMIT 568, 8 "