Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in /var/www/user816929/data/www/exxxstase.ru/classes/MySQL.php on line 34 EXXXSTASE SEXSHOP
SELECT *, ( IF ('2024-04-26 02:35:37' >= `from` AND '2024-04-26 02:35:37' <= `to`, 1, 0) + IF (`id_group` = 1, 2, 0) + IF (`id_country` = 177, 4, 0) + IF (`id_currency` = 3, 8, 0) + IF (`id_shop` = 1, 16, 0)) AS `score`
FROM `ps_specific_price`
WHERE `id_product` IN (0, 6474)
AND `id_shop` IN (0, 1)
AND `id_currency` IN (0, 3)
AND `id_country` IN (0, 177)
AND `id_group` IN (0, 1)
AND `from_quantity` <= 1
AND
(
(`from` = '0000-00-00 00:00:00' OR '2024-04-26 02:35:37' >= `from`)
AND
(`to` = '0000-00-00 00:00:00' OR '2024-04-26 02:35:37' <= `to`)
)
ORDER BY `score` DESC, `from_quantity` DESC LIMIT 1