Top Mierniki  Inne mierniki
Porównaj kategorię Opis:Sortuj:typem | ceną | ceną a A A

Inne mierniki

Database error: Invalid SQL: SELECT product.*,category.category_id,product.cdate as data1,ifnull(ps.product_stock,0) vendor_product_stock ,if(ifnull(f.quantity,0)+ifnull(z.quantity,0)+product.product_in_stock>0,0,1) sort_qty,if((REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(product.product_sku,'/',''),'.',''),'-',''),'+',''),' ',''),' ',''),',','')='')||(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(product.product_p_sku,'/',''),'.',''),'-',''),'+',''),' ',''),' ',''),',','')=''),1,0) sort_s,if((REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(product.product_sku,'/',''),'.',''),'-',''),'+',''),' ',''),' ','') ,',','')LIKE '%%')||(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(product.product_p_sku,'/',''),'.',''),'-',''),'+',''),' ',''),' ','') ,',','')LIKE '%%'),1,0) sort0,if(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(product.product_category,'/',''),'.',''),'-',''),'+',''),' ',''),' ',''),',','') LIKE '%%',1,0) sort01,if(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(pf.tag,'/',''),'-',''),' ',''),' ',''),',','') LIKE '%%',1,0) sort02,if(LOCATE('',pf.name)!=0,LOCATE('',pf.name),99999) sort1 FROM (product, product_category_xref, category ,product_flypage pf ) left join (select f.product_id,sum(f.quantity) quantity from produkty_fr_stock f group by f.product_id) as f on product.product_id=f.product_id left join (select z.product_sku, sum(z.quantity) quantity from produkty_zewnerz z group by product_sku) as z on product.product_sku=z.product_sku LEFT JOIN product_stock ps ON ps.product_id=product.product_id AND ps.vendor_id=1 WHERE product.product_publish='Y' and category.category_publish='Y' And pf.product_id=product.product_id and pf.lang_id='1' AND product.product_parent_id='' AND product.product_id=product_category_xref.product_id AND category.category_id=product_category_xref.category_id and product.product_price_hurt!=7 and product_category_xref.category_id =1486 group by product.product_id ORDER BY sort_s desc,sort0 desc,sort_qty,sort01 desc,sort02 desc,sort1 ,product_sort_order,pf.name LIMIT 0, 40
MySQL Error: 1021 (Disk full (/var/tmp/#sql_26d2_2); waiting for someone to free some space...)