You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ') AND work_orders.id <> 28900
GROUP BY work_orders.id
' at line 59 [ SELECT work_orders.id,
work_orders.title,
work_orders.description,
work_orders.price,
work_orders.deadline,
work_orders.created,
work_orders.updated,
work_orders.vip_catalog,
work_categories.title AS work_type,
work_categories.category_image AS work_image_class,
subject.id AS subject_id,
subject.title AS subject_name,
subject.parent_id AS discipline_id,
rating_statuses.icon AS status_icon,
rating_statuses.title AS status_title,
roles_users.role_id AS vip_customer,
COUNT(bids.id) AS bids_count,
MIN(bids.price) AS min_bid,
MAX(bids.price) AS max_bid,
user_bid.price AS user_bid,
user_bid.id AS user_bid_id,
users.username AS user_name,
users.id AS user_id,
users.rating_customer AS user_rating,
users.avatar AS user_avatar
FROM work_orders
LEFT JOIN users ON (users.id = work_orders.user_id)
LEFT JOIN rating_statuses ON (rating_statuses.user_type = 1
AND rating_statuses.points_from <= users.rating_customer
AND (
rating_statuses.points_to >= users.rating_customer
OR rating_statuses.points_to = 0
OR rating_statuses.points_to = ''
OR rating_statuses.points_to IS NULL
))
LEFT JOIN field_data_worktype ON (field_data_worktype.entity_id = work_orders.id)
LEFT JOIN work_categories ON (work_categories.id = field_data_worktype.value)
LEFT JOIN field_data_science_branch ON (field_data_science_branch.entity_id = work_orders.id)
LEFT JOIN taxonomy_terms AS subject ON (subject.id = field_data_science_branch.value)
LEFT JOIN bids ON (bids.target_model = 'workorder' AND bids.target_id = work_orders.id)
LEFT JOIN bids AS user_bid ON (user_bid.target_model = 'workorder' AND user_bid.target_id = work_orders.id )
LEFT JOIN roles_users ON (roles_users.user_id = work_orders.user_id AND roles_users.role_id = 5)
LEFT JOIN authors_workorders ON (authors_workorders.workorder_id = work_orders.id)
WHERE work_orders.is_deleted = 0
AND work_orders.status = 10
AND work_orders.author_id IS NULL
AND field_data_science_branch.entity_fieldinstance_id = 174
AND field_data_worktype.entity_fieldinstance_id = 80
AND subject.vocabulary_id = 1
AND (
authors_workorders.author_id = null
OR authors_workorders.author_id IS NULL
) AND subject.id IN (557,580,605,541,539,187,189,447,153,155,190,191,194,193,520,196,198,105,200,449,202,203,205,207,209,211,501,213,215,216,456,218,502,445,220,223,222,455,225,227,521,229,454,231,233,453,235,237,239,450,241,242,244,522,246,451,452,248,391) AND field_data_science_branch.value IN (501) AND field_data_worktype.value IN () AND work_orders.id <> 28900
GROUP BY work_orders.id
ORDER BY IF (work_orders.vip_catalog,1,0) DESC, work_orders.created DESC
LIMIT 0, 5 ]/home/web/professor.by/www/modules/database/classes/Kohana/Database/MySQL.php:194