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(u.id=f.teacher_id) LEFT JOIN youtumi_category as c on(f.subject = c.category_id) LEFT JOIN youtumi_country as k on(u.country = k.country_id) LEFT JOIN youtumi_state as st on(u.state = st.state_id) LEFT JOIN youtumi_city as ct on(u.city = ct.city_id) Where u.user_status='1' AND u.profile_type = '3' AND (c.category_name LIKE '%Marketing%' AND u.profile_type = '3' OR (concat(u.first_name,' ',u.last_name) LIKE '%Marketing%')) AND u.profile_type = '3' OR u.email LIKE '%Marketing%' AND u.profile_type = '3' OR u.address LIKE '%Marketing%' AND u.profile_type = '3' OR u.zip_code LIKE '%Marketing%' AND u.profile_type = '3' OR u.about_me LIKE '%Marketing%' AND u.profile_type = '3' OR k.country_name LIKE '%Marketing%' AND u.profile_type = '3' OR st.state_name LIKE '%Marketing%' AND u.profile_type = '3' OR ct.city_name LIKE '%Marketing%' AND u.profile_type = '3' GROUP BY u.id 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