Incorrect DATETIME value: '0000-00-00 00:00:00'
SELECT *, (IF (NOW() >= `from` AND NOW() <= `to`, 1, 0) + IF (`id_group` = 1, 2, 0) + IF (`id_country` = 6, 4, 0) + IF (`id_currency` = 1, 8, 0)) `score` FROM `ps_specific_price` WHERE `id_product` = 50 AND `id_currency` IN (0, 1) AND `id_country` IN (0, 6) AND `id_group` IN (0, 1) AND `from_quantity` <= 1 AND ( (`from` = '0000-00-00 00:00:00' OR NOW() >= `from`) AND (`to` = '0000-00-00 00:00:00' OR NOW() <= `to`) ) ORDER BY `from_quantity` DESC, `score` DESC LIMIT 1