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 '%Hobbies%' AND u.profile_type = '3' OR 
					(concat(u.first_name,' ',u.last_name) LIKE '%Hobbies%')) AND u.profile_type = '3' OR 
					u.email LIKE '%Hobbies%'  AND u.profile_type = '3' OR
					u.address LIKE '%Hobbies%' AND u.profile_type = '3' OR
					u.zip_code LIKE '%Hobbies%' AND u.profile_type = '3' OR
					u.about_me LIKE '%Hobbies%' AND u.profile_type = '3' OR
					k.country_name LIKE '%Hobbies%' AND u.profile_type = '3' OR 
					st.state_name LIKE '%Hobbies%' AND u.profile_type = '3' OR
					ct.city_name LIKE '%Hobbies%' 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