Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in /var/www/tutete_pro/tienda/includes/functions/database.php on line 46
1525 - Incorrect DATETIME value: '0000-00-00 00:00:00'
SELECT C.categories_id, D.categories_name,
COUNT(P.products_id) AS cantidad_productos,
ROUND((1 - s.specials_new_products_price / P.products_price_text) * 100, -1) AS descuento
FROM products P
LEFT JOIN products_to_categories P2C on P2C.products_id = P.products_id
LEFT JOIN categories C ON P2C.categories_id = C.categories_id
INNER JOIN manufacturers M ON M.manufacturers_id = 561 AND P.manufacturers_id = M.manufacturers_id
LEFT JOIN specials s ON
P.products_id = s.products_id AND s.status=1 AND (s.expires_date>now() OR s.expires_date='0000-00-00 00:00:00') AND s.es_vip = 0
JOIN categories_description D ON C.categories_id = D.categories_id AND D.language_id = 10
JOIN products_description PD ON P.is_exclusive='0' AND P.manufacturers_id = 561 AND PD.language_id = 10 AND PD.publicar = 1 AND P.products_status = '1' AND PD.products_id = P.products_id AND (10 !='15' OR PD.ya_editado='1')
WHERE P.manufacturers_id = 561 AND P.products_type!='4' AND P.products_type!='8'
AND C.categories_id IN (
SELECT categories_id
FROM categories CV
WHERE CV.parent_id=0 OR CV.parent_id IN (
SELECT categories_id
FROM categories
WHERE parent_id=0
)
)
GROUP BY descuento
ORDER by descuento ASC
[TEP STOP]