Database Error
Message: MySQL Error has occured
MySQL Error:Expression #5 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'manusclu_manusclub.s.name' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
Query:SELECT m.id AS member_id,m.profile_pic, m.first_name, m.last_name, s.name AS state, c.name AS city FROM members m LEFT JOIN work_location w ON m.id = w.user_id LEFT JOIN states s ON (w.work_state_id =s.id) LEFT JOIN cities c ON (w.work_city_id =c.id) WHERE m.approved_status = '1' GROUP BY m.id ORDER BY m.first_name ASC LIMIT 0, 50
Trace:/home/manusclub/public_html/for-patients.php at line 103
/home/manusclub/public_html/classes/search.php at line 165
/home/manusclub/public_html/classes/database/class.database.php at line 539
/home/manusclub/public_html/classes/database/class.database.php at line 520