SELECT
mer.id,
mer.mer_email, mer.business_slogan,mer.logo,
mer.qualifications,
mer.location,
locations.location as location_nm,
locations.id as location_id,
(SELECT COUNT(*) FROM messages WHERE messages.user_id = mer.id limit 1) AS message_count
FROM merchant mer
LEFT JOIN locations
on locations.mid = mer.id
where (locations.location LIKE '%roof%') OR (qualifications LIKE '%roof%') AND is_merchant = 1 AND is_verify = 1
group by qualifications
ORDER BY
mer.id DESC
LIMIT 25
roof. Quotes: 0. Infinity Min. -Infinity Max.