Films
Announcements
-
Database ERROR HERE: Invalid SQL: select film.id as id,meta_data.name as url, film.annoucements_title as title,
film.annoucements_description as annoucements_description,film.original_title as original_title,
film.english_title as english_title,
film.annoucements_image_use_poster as annoucements_image_use_poster,
film.announcements_detail as announcements_detail,
film.announcements_start_date as announcements_start_date,
film.announcements_stop_date as announcements_stop_date,
film_images.image_name as image_name ,
UNIX_TIMESTAMP(film.announcements_start_date) as mys,
(select count(film_people.dir_age) from film_people where film_people.film_id=film.id AND dir_age='2' ) as made_by_kid
from film
left join meta_data on (meta_data.type='film' AND meta_data.primay_key_id=film.id)
left join film_images on (film_images.film_id=film.id AND order_by=1)
where film.annoucements_title!='' AND film.status='2'
AND film.target_audience_id='1'
AND 1593820800>=UNIX_TIMESTAMP(film.announcements_start_date)
AND 1593820800<=UNIX_TIMESTAMP(film.announcements_stop_date)
group by film.id
order by film.announcements_start_date desc
limit 0,3
MySQL error :1055 Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'ccfsouth_users.meta_data.name' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
Session halted.