PDM

POSTVAR

GETVAR

explain
select m.idProduct, m.Num, m.CImage, m.OptRequired, m.State, m.AddDate , m.idTaxClass, m.Price, m.PriceTax , sp.Price as SPrice, sp.PriceTax as SPriceTax, sp.Rate as SRate , dp.Price as DPrice, dp.PriceTax as DPriceTax , IF(m.MaxQuantity <> 0, LEAST(m.MaxQuantity, m.Quantity), m.Quantity) as Quantity, IF(m.MinQuantity, m.MinQuantity, 1) as MinQuantity , ml.Name, ml.Description, ml.URLAlias , mols.Name as StateName , '1' as opt , m.idManufacturer, sm.CImage as ManuImage, mlm.Name as ManuName, mlm.URLAlias as MURLAlias , m.idCategory, cl.Name as CName, cl.URLAlias as CURLAlias
from mod_StoreProduct as m
inner join (
select tm.*
from mod_StoreProduct as tm
where (1) and (tm.State & '435') and (tm.idProduct in ('401','397','620','1581','1584','1585','758','1707','1635','1588','1641','2011','2207','1715','1645','1644','1631','1655','1630','1640','1712','1618','1621','1607','1619','1704','813','357','800','1613','389','1577','1259','1615','1606','1617','724'))
order by rand()
limit 37 ) as t on (t.idProduct = m.idProduct)
inner join mod_StoreLang ml on (t.idProduct = ml.idProduct) and (ml.idLanguage = 'bg')
inner join CategoryLang cl on (cl.idCategory = t.idCategory) and (cl.idLanguage = 'bg')
left join mod_StoreOtherLang mols on (mols.Source = 'state') and (mols.idRec = m.idState) and (mols.idLanguage = 'bg')
left join ( SELECT idProduct, Price, PriceTax, Rate, EndDate FROM v_StoreDiscount WHERE (Special = 1) AND (idUGroup IN (COALESCE('0', 0), 0)) ) as sp on (sp.idProduct = m.idProduct)
left join ( SELECT idProduct, Price, PriceTax, Rate, EndDate FROM v_StoreDiscount WHERE (Special = 0) AND (Quantity = 1) AND (idUGroup IN (COALESCE('0', 0), 0)) ) as dp on (dp.idProduct = m.idProduct)
left join mod_StoreManufacturer as sm on (sm.idManufacturer = m.idManufacturer)
left join mod_StoreMLang as mlm on (mlm.idManufacturer = m.idManufacturer) and (mlm.idLanguage = 'bg')
where (1)