


| товаров: | 0 шт. |
| на сумму: | 0 руб. |
|
| товаров: | 0 шт. |
| на сумму: | 0.00 руб. |
|
| Личный кабинет |
|
| |
|
|
FILE: /home/kaiser_su5/public_html/direct/spec.php
LINE: 25
ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'and CURDATE()>=s.start_date and CURDATE()<=s.end_date' at line 7
QUERY: SELECT *, COUNT(*) as cnt, MOD(COUNT(*),10) as md, FLOOR(COUNT(*)/10) as fl
FROM sell s
left join model m ON s.id_new = m.ModelID
LEFT JOIN group_model gm ON m.group_model_id = gm.id
LEFT JOIN grouppa g ON g.id = gm.group_id
LEFT JOIN class c ON c.id = g.class_id
where c.id= and CURDATE()>=s.start_date and CURDATE()<=s.end_date