Error: <br />Error No: <br />SELECT p.product_id,
                pd.name,
                pd.short_description,
                pd.description,
                p.is_legacy,
                p.image,
                p.model_name,
                p.model,
                p2s.price,
                p.novelty,
                p2s.old_price,
                p.tax_class_id,
                cd.singular_name,
                cd.name as category,
                cd.category_id as category_id
                FROM product p
                INNER JOIN product_description pd ON (p.product_id = pd.product_id)
                INNER JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
                LEFT JOIN product_to_category p2c ON (p2c.product_id = p.product_id)
                LEFT JOIN category_to_store c2s ON (c2s.category_id = p2c.category_id)
                LEFT  JOIN category_description cd ON (cd.category_id = c2s.category_id)
                WHERE p.date_available <= NOW() AND p.status = '1'
                    AND pd.language_id = '1'
                    AND p2s.store_id = '3'
                    AND c2s.store_id = '3' AND (p2s.old_price >0 OR p.novelty = 1)
                   GROUP BY p.product_id
                   ORDER BY p.novelty ASC, p2s.old_price DESC ORDER BY  p2s.price LIMIT 0,12