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
199,00 €
160,48 € (alv 0%)
129,00 €
104,03 € (alv 0%)