SELECT `products`.*, `categories2products`.`rank` AS `pagerank` FROM `products`
LEFT JOIN `categories2products` ON categories2products.product_id = products.id
LEFT JOIN `products` AS `p` ON products.code = p.parent_code WHERE (products.only_login = 0) AND (products.state = 'active') AND (categories2products.category_id IN('79')) GROUP BY `products`.`id` ORDER BY `products`.`category_ranking` DESC
Ymparistönhoitotuotteet
