Loading... Please wait...

Shop Categories

Our Newsletter


Dr. Deer





class.category - loadproducts: SELECT p.*, FLOOR(prodratingtotal / prodnumratings) AS prodavgrating, pi.*, 0 AS prodgroupdiscount FROM ( SELECT DISTINCT ca.productid, FLOOR(prodratingtotal / prodnumratings) AS prodavgrating FROM [|PREFIX|]categoryassociations ca INNER JOIN [|PREFIX|]products p ON p.productid = ca.productid WHERE p.prodvisible=1 AND ca.categoryid IN (1107) ORDER BY p.prodnumsold desc, p.prodname ASC LIMIT 0, 20 ) AS ca INNER JOIN [|PREFIX|]products p ON p.productid = ca.productid LEFT JOIN [|PREFIX|]product_images pi ON (pi.imageisthumb = 1 AND p.productid = pi.imageprodid)