string(2158) "SELECT m.*, l.*, IF(f.path IS NULL, 'https://res.brandsoutlet.ro/res/images/logo.png', concat('https://brandsoutlet.ro/',f.path ,'S')) as image, IFNULL(f.com, '') as altimg,
concat('RON') as curr, concat('lei') as currsign, IF(sl.i IS NULL,'','yes') as sale, IF(ds.i IS NULL,'','yes') as delaydelivery, ROUND(rrp.price9, 0) as rrp, rrp.price1 as priceeur, pl.price1*5.0757 as price, pl.price1x*5.0757 as price2, ROUND((pl.price1*5.0757*((100-m.discount)/100)), 2) as saleprice, ROUND(IF(m.discount>0, pl.price1, pl.price1x)*5.0757, 2) as oldprice,
IF(pl.price1=0.0000, '',concat(ROUND(pl.price1*5.0757, 2),' lei')) as pricecurr,
IF(pl.price1x=0.0000, '',concat(ROUND(pl.price1x*5.0757, 2),' lei')) as pricecurr2,
IF(pl.price1=0.0000, '',concat(ROUND(pl.price1*5.0757*((100-m.discount)/100), 2),' lei')) as salepricecurr,
concat(ROUND(IF(m.discount>0, pl.price1, pl.price1x)*5.0757, 2),' lei') as oldpricecurr,
IF(m.discount>0 OR pl.price1x>0, true, false) as onsale FROM (
SELECT mdb.* , a.amount as amount
FROM msu_db mdb
LEFT JOIN msu_ties cat ON (cat.msu=mdb.xid)
LEFT JOIN (
SELECT sa.msu as msu, SUM(sa.amount) as amount
FROM whs5_batchs sa WHERE sa.store='1' OR sa.store='7' GROUP BY sa.msu
) a ON (a.msu=mdb.xid)
LEFT JOIN (
SELECT om.name as name, COALESCE(SUM(om.amount), 0) as amount
FROM whs5_msu om LEFT JOIN whs5_docs od ON (od.i=om.doc)
WHERE od.s='e' AND od.l='y' AND od.type=17 AND (od.o='c' OR od.o='o') AND ( od.store='1' OR od.store='7')
GROUP BY om.name
) ord ON (ord.name=mdb.xid)
WHERE mdb.s='e' AND mdb.unpub<>'e' AND cat.cat='1166' AND a.amount>0 AND (ord.amount IS NULL OR ord.amount
string(2091) "SELECT m.*, l.*, IF(f.path IS NULL, 'https://res.brandsoutlet.ro/res/images/logo.png', concat('https://brandsoutlet.ro/',f.path ,'S')) as image, IFNULL(f.com, '') as altimg,
concat('RON') as curr, concat('lei') as currsign, IF(sl.i IS NULL,'','yes') as sale, IF(ds.i IS NULL,'','yes') as delaydelivery, ROUND(rrp.price9, 0) as rrp, rrp.price1 as priceeur, pl.price1*5.0757 as price, pl.price1x*5.0757 as price2, ROUND((pl.price1*5.0757*((100-m.discount)/100)), 2) as saleprice, ROUND(IF(m.discount>0, pl.price1, pl.price1x)*5.0757, 2) as oldprice,
IF(pl.price1=0.0000, '',concat(ROUND(pl.price1*5.0757, 2),' lei')) as pricecurr,
IF(pl.price1x=0.0000, '',concat(ROUND(pl.price1x*5.0757, 2),' lei')) as pricecurr2,
IF(pl.price1=0.0000, '',concat(ROUND(pl.price1*5.0757*((100-m.discount)/100), 2),' lei')) as salepricecurr,
concat(ROUND(IF(m.discount>0, pl.price1, pl.price1x)*5.0757, 2),' lei') as oldpricecurr,
IF(m.discount>0 OR pl.price1x>0, true, false) as onsale FROM (
SELECT mdb.* , a.amount as amount
FROM msu_db mdb
LEFT JOIN (
SELECT sa.msu as msu, SUM(sa.amount) as amount
FROM whs5_batchs sa WHERE sa.store='1' OR sa.store='7' GROUP BY sa.msu
) a ON (a.msu=mdb.xid)
LEFT JOIN (
SELECT om.name as name, COALESCE(SUM(om.amount), 0) as amount
FROM whs5_msu om LEFT JOIN whs5_docs od ON (od.i=om.doc)
WHERE od.s='e' AND od.l='y' AND od.type=17 AND (od.o='c' OR od.o='o') AND ( od.store='1' OR od.store='7')
GROUP BY om.name
) ord ON (ord.name=mdb.xid)
WHERE mdb.s='e' AND mdb.unpub<>'e' AND a.amount>0 AND (ord.amount IS NULL OR ord.amount0, pl.price1, pl.price1x)*5.0757, 2) as oldprice,
IF(pl.price1=0.0000, '',concat(ROUND(pl.price1*5.0757, 2),' lei')) as pricecurr,
IF(pl.price1x=0.0000, '',concat(ROUND(pl.price1x*5.0757, 2),' lei')) as pricecurr2,
IF(pl.price1=0.0000, '',concat(ROUND(pl.price1*5.0757*((100-m.discount)/100), 2),' lei')) as salepricecurr,
concat(ROUND(IF(m.discount>0, pl.price1, pl.price1x)*5.0757, 2),' lei') as oldpricecurr,
IF(m.discount>0 OR pl.price1x>0, true, false) as onsale FROM (
SELECT mdb.* , a.amount as amount
FROM msu_db mdb
LEFT JOIN msu_ties cat ON (cat.msu=mdb.xid)
LEFT JOIN (
SELECT sa.msu as msu, SUM(sa.amount) as amount
FROM whs5_batchs sa WHERE sa.store='1' OR sa.store='7' GROUP BY sa.msu
) a ON (a.msu=mdb.xid)
LEFT JOIN (
SELECT om.name as name, COALESCE(SUM(om.amount), 0) as amount
FROM whs5_msu om LEFT JOIN whs5_docs od ON (od.i=om.doc)
WHERE od.s='e' AND od.l='y' AND od.type=17 AND (od.o='c' OR od.o='o') AND ( od.store='1' OR od.store='7')
GROUP BY om.name
) ord ON (ord.name=mdb.xid)
WHERE mdb.s='e' AND mdb.unpub<>'e' AND cat.cat='1' AND a.amount>0 AND (ord.amount IS NULL OR ord.amount0, pl.price1, pl.price1x)*5.0757, 2) as oldprice,
IF(pl.price1=0.0000, '',concat(ROUND(pl.price1*5.0757, 2),' lei')) as pricecurr,
IF(pl.price1x=0.0000, '',concat(ROUND(pl.price1x*5.0757, 2),' lei')) as pricecurr2,
IF(pl.price1=0.0000, '',concat(ROUND(pl.price1*5.0757*((100-m.discount)/100), 2),' lei')) as salepricecurr,
concat(ROUND(IF(m.discount>0, pl.price1, pl.price1x)*5.0757, 2),' lei') as oldpricecurr,
IF(m.discount>0 OR pl.price1x>0, true, false) as onsale FROM (
SELECT mdb.* , a.amount as amount
FROM msu_db mdb
LEFT JOIN msu_ties cat ON (cat.msu=mdb.xid)
LEFT JOIN (
SELECT sa.msu as msu, SUM(sa.amount) as amount
FROM whs5_batchs sa WHERE sa.store='1' OR sa.store='7' GROUP BY sa.msu
) a ON (a.msu=mdb.xid)
LEFT JOIN (
SELECT om.name as name, COALESCE(SUM(om.amount), 0) as amount
FROM whs5_msu om LEFT JOIN whs5_docs od ON (od.i=om.doc)
WHERE od.s='e' AND od.l='y' AND od.type=17 AND (od.o='c' OR od.o='o') AND ( od.store='1' OR od.store='7')
GROUP BY om.name
) ord ON (ord.name=mdb.xid)
WHERE mdb.s='e' AND mdb.unpub<>'e' AND cat.cat='2' AND a.amount>0 AND (ord.amount IS NULL OR ord.amount0, pl.price1, pl.price1x)*5.0757, 2) as oldprice,
IF(pl.price1=0.0000, '',concat(ROUND(pl.price1*5.0757, 2),' lei')) as pricecurr,
IF(pl.price1x=0.0000, '',concat(ROUND(pl.price1x*5.0757, 2),' lei')) as pricecurr2,
IF(pl.price1=0.0000, '',concat(ROUND(pl.price1*5.0757*((100-m.discount)/100), 2),' lei')) as salepricecurr,
concat(ROUND(IF(m.discount>0, pl.price1, pl.price1x)*5.0757, 2),' lei') as oldpricecurr,
IF(m.discount>0 OR pl.price1x>0, true, false) as onsale FROM (
SELECT mdb.* , a.amount as amount
FROM msu_db mdb
LEFT JOIN msu_ties cat ON (cat.msu=mdb.xid)
LEFT JOIN (
SELECT sa.msu as msu, SUM(sa.amount) as amount
FROM whs5_batchs sa WHERE sa.store='1' OR sa.store='7' GROUP BY sa.msu
) a ON (a.msu=mdb.xid)
LEFT JOIN (
SELECT om.name as name, COALESCE(SUM(om.amount), 0) as amount
FROM whs5_msu om LEFT JOIN whs5_docs od ON (od.i=om.doc)
WHERE od.s='e' AND od.l='y' AND od.type=17 AND (od.o='c' OR od.o='o') AND ( od.store='1' OR od.store='7')
GROUP BY om.name
) ord ON (ord.name=mdb.xid)
WHERE mdb.s='e' AND mdb.unpub<>'e' AND cat.cat='1009' AND a.amount>0 AND (ord.amount IS NULL OR ord.amount
string(2158) "SELECT m.*, l.*, IF(f.path IS NULL, 'https://res.brandsoutlet.ro/res/images/logo.png', concat('https://brandsoutlet.ro/',f.path ,'S')) as image, IFNULL(f.com, '') as altimg,
concat('RON') as curr, concat('lei') as currsign, IF(sl.i IS NULL,'','yes') as sale, IF(ds.i IS NULL,'','yes') as delaydelivery, ROUND(rrp.price9, 0) as rrp, rrp.price1 as priceeur, pl.price1*5.0757 as price, pl.price1x*5.0757 as price2, ROUND((pl.price1*5.0757*((100-m.discount)/100)), 2) as saleprice, ROUND(IF(m.discount>0, pl.price1, pl.price1x)*5.0757, 2) as oldprice,
IF(pl.price1=0.0000, '',concat(ROUND(pl.price1*5.0757, 2),' lei')) as pricecurr,
IF(pl.price1x=0.0000, '',concat(ROUND(pl.price1x*5.0757, 2),' lei')) as pricecurr2,
IF(pl.price1=0.0000, '',concat(ROUND(pl.price1*5.0757*((100-m.discount)/100), 2),' lei')) as salepricecurr,
concat(ROUND(IF(m.discount>0, pl.price1, pl.price1x)*5.0757, 2),' lei') as oldpricecurr,
IF(m.discount>0 OR pl.price1x>0, true, false) as onsale FROM (
SELECT mdb.* , a.amount as amount
FROM msu_db mdb
LEFT JOIN msu_ties cat ON (cat.msu=mdb.xid)
LEFT JOIN (
SELECT sa.msu as msu, SUM(sa.amount) as amount
FROM whs5_batchs sa WHERE sa.store='1' OR sa.store='7' GROUP BY sa.msu
) a ON (a.msu=mdb.xid)
LEFT JOIN (
SELECT om.name as name, COALESCE(SUM(om.amount), 0) as amount
FROM whs5_msu om LEFT JOIN whs5_docs od ON (od.i=om.doc)
WHERE od.s='e' AND od.l='y' AND od.type=17 AND (od.o='c' OR od.o='o') AND ( od.store='1' OR od.store='7')
GROUP BY om.name
) ord ON (ord.name=mdb.xid)
WHERE mdb.s='e' AND mdb.unpub<>'e' AND cat.cat='1002' AND a.amount>0 AND (ord.amount IS NULL OR ord.amount
string(2158) "SELECT m.*, l.*, IF(f.path IS NULL, 'https://res.brandsoutlet.ro/res/images/logo.png', concat('https://brandsoutlet.ro/',f.path ,'S')) as image, IFNULL(f.com, '') as altimg,
concat('RON') as curr, concat('lei') as currsign, IF(sl.i IS NULL,'','yes') as sale, IF(ds.i IS NULL,'','yes') as delaydelivery, ROUND(rrp.price9, 0) as rrp, rrp.price1 as priceeur, pl.price1*5.0757 as price, pl.price1x*5.0757 as price2, ROUND((pl.price1*5.0757*((100-m.discount)/100)), 2) as saleprice, ROUND(IF(m.discount>0, pl.price1, pl.price1x)*5.0757, 2) as oldprice,
IF(pl.price1=0.0000, '',concat(ROUND(pl.price1*5.0757, 2),' lei')) as pricecurr,
IF(pl.price1x=0.0000, '',concat(ROUND(pl.price1x*5.0757, 2),' lei')) as pricecurr2,
IF(pl.price1=0.0000, '',concat(ROUND(pl.price1*5.0757*((100-m.discount)/100), 2),' lei')) as salepricecurr,
concat(ROUND(IF(m.discount>0, pl.price1, pl.price1x)*5.0757, 2),' lei') as oldpricecurr,
IF(m.discount>0 OR pl.price1x>0, true, false) as onsale FROM (
SELECT mdb.* , a.amount as amount
FROM msu_db mdb
LEFT JOIN msu_ties cat ON (cat.msu=mdb.xid)
LEFT JOIN (
SELECT sa.msu as msu, SUM(sa.amount) as amount
FROM whs5_batchs sa WHERE sa.store='1' OR sa.store='7' GROUP BY sa.msu
) a ON (a.msu=mdb.xid)
LEFT JOIN (
SELECT om.name as name, COALESCE(SUM(om.amount), 0) as amount
FROM whs5_msu om LEFT JOIN whs5_docs od ON (od.i=om.doc)
WHERE od.s='e' AND od.l='y' AND od.type=17 AND (od.o='c' OR od.o='o') AND ( od.store='1' OR od.store='7')
GROUP BY om.name
) ord ON (ord.name=mdb.xid)
WHERE mdb.s='e' AND mdb.unpub<>'e' AND cat.cat='1018' AND a.amount>0 AND (ord.amount IS NULL OR ord.amount
Comentati