Ошибка базы данных.

Error Number: 1064

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 u.status = '1' ORDER BY field_39 ASC,a.date_up desc' at line 1

SELECT COUNT(*) as total,(SELECT CAST(value AS decimal(10, 2)) FROM gcadmiral_ad_param WHERE ad_id = a.ad_id AND field_id = 39 LIMIT 1 ) AS 'field_39' FROM gcadmiral_ad a LEFT JOIN gcadmiral_user u ON (a.user_id = u.user_id) WHERE a.deleted = 0 AND a.published = 1 AND a.locked = 0 AND a.lang_id = 2 AND EXISTS ( SELECT 1 FROM gcadmiral_ad_param WHERE ad_id = a.ad_id AND field_id = '39' AND ) AND u.status = '1' ORDER BY field_39 ASC,a.date_up desc

Filename: /home/h/h1jackug/yuzhanochka.rf/public_html/models/bulletin_board_model.php

Line Number: 664