select u.*,f.teacher_id,f.subject,c.category_name,k.country_name,st.state_name,ct.city_name from youtumi_users as u LEFT JOIN youtumi_teacher_feature as f on( LEFT JOIN youtumi_category as c on(f.subject = c.category_id) LEFT JOIN youtumi_country as k on( = k.country_id) LEFT JOIN youtumi_state as st on(u.state = st.state_id) LEFT JOIN youtumi_city as ct on( = ct.city_id) Where u.user_status='1' AND u.profile_type = '3' GROUP BY ORDER BY u.registered_date desc
Expression #39 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'youtumi_db.f.subject' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by on 1055