SELECT SQL_CALC_FOUND_ROWS p.*, c.title as catalog, f.path as file FROM `partner` as p LEFT JOIN file f ON f.partner_id = p.id AND f.status = "show" LEFT JOIN catalog c ON c.id = p.cid WHERE p.status != "delete" AND p.pid IN () GROUP BY p.id ORDER BY p.id ASC
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 ') GROUP BY p.id ORDER BY p.id ASC' at line 1
Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in /var/www/u0517534/data/www/yarskmedia.ru/core/MySQL.class.php on line 195
Notice: Undefined offset: 0 in /var/www/u0517534/data/www/yarskmedia.ru/app/controller/index/Partners.class.php on line 36
Notice: Undefined offset: 0 in /var/www/u0517534/data/www/yarskmedia.ru/app/controller/index/Partners.class.php on line 41
Наименование | Формат | Период | Цена за | CTR | |||||
---|---|---|---|---|---|---|---|---|---|
Хосты | Хиты | День | Неделя | Месяц | 1000 |