could not execute query SELECT i.*,(datediff(i.end_date,i.start_date)+1) days,IFNULL(it.title_t, i.title ) title,IFNULL(it.description_t, i.description) description from v_items i left join v_items_t it on it.main_id=i.id and it.language_id=1 where i.type_id=287 and (i.end_date>=CURDATE()) and i.id<>1122 and i.active=1 and i.approved=1 and i.active_by_user=1 GROUP BY i.id