Database error: Invalid SQL: SELECT vw.warehouse_kind,vw.id,vw.vendor_id,vw.warehouse_id,vw.warehouse_name,vw.warehouse_short_name,vw.warehouse_char_name,
vw.realization_time,round(ifnull(t.product_stock,0)) product_stock,
pas.a_r,@a_r:=ifnull(pas.a_r,0) a_r_var,
case
WHEN pas.a_r*2<50 && round(ifnull(t.product_stock,0))>50 THEN '+50'
WHEN pas.a_r*2>100000 && round(ifnull(t.product_stock,0))>100000 THEN '+100000'
WHEN pas.a_r*2>50000 && round(ifnull(t.product_stock,0))>50000 THEN '+50000'
WHEN pas.a_r*2>10000 && round(ifnull(t.product_stock,0))>10000 THEN '+10000'
WHEN pas.a_r*2>5000 && round(ifnull(t.product_stock,0))>5000 THEN '+5000'
WHEN pas.a_r*2>1000 && round(ifnull(t.product_stock,0))>1000 THEN '+1000'
WHEN pas.a_r*2>500 && round(ifnull(t.product_stock,0))>500 THEN '+500'
WHEN pas.a_r*2>100 && round(ifnull(t.product_stock,0))>100 THEN '+100'
WHEN pas.a_r*2>50 && round(ifnull(t.product_stock,0))>50 THEN '+50'
ELSE round(if(t.product_stock<0 || ifnull(t.product_stock,0)=0,0,t.product_stock))
END product_stock_pres,
round(ifnull(t.stock_reservation,0)) stock_reservation,vw.sort,vw.style,vw.style2 FROM (vendor_warehouse vw,product p)
LEFT JOIN product_stock_warehouse t ON t.vendor_id=vw.vendor_id AND t.warehouse_id=vw.warehouse_id AND p.product_id=t.product_id
LEFT JOIN product_avg_sale pas ON pas.product_sku=p.product_sku
WHERE vw.publish='Y' AND p.product_id=8798 AND vw.vendor_id=1
UNION
SELECT 'R,' warehouse_kind,77 id ,1 'vendor_id',7 'warehouse_id','LABEL_DESC_STOCK_PRES3' AS 'warehouse_name','LABEL_DESC_STOCK_PRES3' AS 'warehouse_short_name','Ex' as 'warehouse_char_name', 2 as'vw.realization_time', ifnull(sum(z.quantity),0) product_stock,
@a_r a_r,@a_r a_r_var,
case
WHEN @a_r*2<50 && round(ifnull(sum(z.quantity),0))>50 THEN '+50'
WHEN @a_r*2>100000 && round(ifnull(sum(z.quantity),0))>100000 THEN '+100000'
WHEN @a_r*2>50000 && round(ifnull(sum(z.quantity),0))>50000 THEN '+50000'
WHEN @a_r*2>10000 && round(ifnull(sum(z.quantity),0))>10000 THEN '+10000'
WHEN @a_r*2>5000 && round(ifnull(sum(z.quantity),0))>5000 THEN '+5000'
WHEN @a_r*2>1000 && round(ifnull(sum(z.quantity),0))>1000 THEN '+1000'
WHEN @a_r*2>500 && round(ifnull(sum(z.quantity),0))>500 THEN '+500'
WHEN @a_r*2>100 && round(ifnull(sum(z.quantity),0))>100 THEN '+100'
WHEN @a_r*2>50 && round(ifnull(sum(z.quantity),0))>50 THEN '+50'
ELSE ifnull(sum(z.quantity),0)
END product_stoc_pres,
0 stock_reservation,99 sort
,'background-color:#e5e5e5;color:black;;border:1px solid #9b9b9b' as 'style','color:black;' AS 'style2'
FROM product p
INNER JOIN produkty_zewnerz z on z.product_sku=p.product_sku
WHERE product_id=8798
UNION
SELECT 'F,' warehouse_kind,88 id ,1 'vendor_id',8 'warehouse_id',z.catalog AS 'warehouse_name',z.catalog AS 'warehouse_short_name','Ex' as 'warehouse_char_name', z.delivery_time as'vw.realization_time', ifnull(z.quantity,0) product_stock,
@a_r a_r,@a_r a_r_var,
case
WHEN @a_r*2<50 && round(ifnull(z.quantity,0))>50 THEN '+50'
WHEN @a_r*2>100000 && round(ifnull(z.quantity,0))>100000 THEN '+100000'
WHEN @a_r*2>50000 && round(ifnull(z.quantity,0))>50000 THEN '+50000'
WHEN @a_r*2>10000 && round(ifnull(z.quantity,0))>10000 THEN '+10000'
WHEN @a_r*2>5000 && round(ifnull(z.quantity,0))>5000 THEN '+5000'
WHEN @a_r*2>1000 && round(ifnull(z.quantity,0))>1000 THEN '+1000'
WHEN @a_r*2>500 && round(ifnull(z.quantity,0))>500 THEN '+500'
WHEN @a_r*2>100 && round(ifnull(z.quantity,0))>100 THEN '+100'
WHEN @a_r*2>50 && round(ifnull(z.quantity,0))>50 THEN '+50'
ELSE ifnull(z.quantity,0)
END product_stoc_pres,
0 stock_reservation,199 sort
,'background-color:#e5e5e5;color:black;;border:1px solid #9b9b9b' as 'style','color:black;' AS 'style2'
FROM product p
INNER JOIN produkty_fr_stock z on z.product_id=p.product_id
WHERE z.catalog!='KOP' AND p.product_id=8798
ORDER BY sort MySQL Error: 1021 (Disk full (/var/tmp/#sql_26d2_0); waiting for someone to free some space...)
Polski
Български
Český
Dansk
Deutsch
Eesti
Ελληνικά
English
Español
Français
Italiano
Latviešu 
Lietuvių 
Magyar
Nederlands
Norsk
Português
Pусский
Română
Slovenski
Slovenský
Suomi
Svenska
AUD
BGN
CAD
CHF
CZK
DKK
EUR
GBP
HUF
NOK
PLN
SEK
USD
Home
Kontakt
Nowe produkty
