RUNTIME ERROR
Date: 17.05.2012 19:38:26
Script: /projects/himtrade/www/runtime.htm (line 169)
Request URI: /product_reference_abonent_0_1_4478_1.htm
ERROR DESCRIPTION
Unable to execute SQL statement
SQL: SELECT COUNT(p.id), SUM(p.amount) FROM price p WHERE p.date_to>='20120517' AND p.is_buy=0 AND p.rus=1 AND p.product_id=4478 AND p.package=1 AND p.id IN ()
Error 0:
RUNTIME ERROR
Date: 17.05.2012 19:38:26
Script: /projects/himtrade/www/runtime.htm (line 169)
Request URI: /product_reference_abonent_0_1_4478_1.htm
ERROR DESCRIPTION
Unable to execute SQL statement
SQL: SELECT COUNT(p.id) FROM price p WHERE p.date_to>='20120517' AND p.odate='20120517' AND p.is_buy=0 AND p.rus=1 AND p.product_id=4478 AND p.package=1 AND p.id IN ()
Error 0:
RUNTIME ERROR
Date: 17.05.2012 19:38:26
Script: /projects/himtrade/www/runtime.htm (line 169)
Request URI: /product_reference_abonent_0_1_4478_1.htm
ERROR DESCRIPTION
Unable to execute SQL statement
SQL: SELECT a.name, a.idmd5_email, p.abonent_id, COUNT(p.id) AS count, SUM(p.amount) as sumA, a.region, a.country, pg.is_rr FROM (price p, abonent a) LEFT JOIN product_guide pg ON p.product_id=pg.id WHERE a.abonent_id=p.abonent_id AND p.date_to>='20120517' AND p.is_buy=0 AND p.rus=1 AND p.product_id=4478 AND p.package=1 AND p.id IN () GROUP BY 1 ORDER BY a.stars DESC, a.name
Error 0: