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' 
			
					GROUP BY u.id ORDER BY u.registered_date desc<br>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