Loading... Please wait...

Shop Categories

Our Newsletter


Sort by:

Books

  • Pages:
  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • (184 items)

  • Pages:
  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • (184 items)



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 (1125,1103,134,127,128,1117,129,130,131,132,133,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,98,99,100,101,102,103,104,105,106,107,108,109,110,111,112,113,114,115,116,164,117,118,119,120,121,122,123,124,125,126,78) 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)