Scegli Categorie+
Scegli Marchi +
.png?box=48x30e)
.png?box=48x30e)
string(1932) "
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 = 198877 AND 1=1 AND (c.id_reparto = 3 OR c1.id_reparto = 3 OR c2.id_reparto = 3 OR c3.id_reparto = 3)
ORDER BY 1=1, IF(a.final_amount > 0 AND sold_out = 0 AND (availability > 0 OR availability IS NULL),1,0) DESC,
a.prezzo_si_vendita_no DESC,
sold_out = 0 DESC, IF(availability > 0 AND a.final_amount IS NOT NULL,1,0) DESC, id_cat <> 198877, a.final_amount ASC, a.ordering IS NOT NULL DESC, a.ordering ASC, a.title DESC
LIMIT 10968, 12
"
