SELECT contact_form.*, messages.user_id AS user_id, COUNT(messages.qoute_id) AS message_count FROM contact_form
LEFT JOIN messages ON contact_form.cid = messages.qoute_id
WHERE ((keyphrase LIKE '%logos%' AND keyphrase NOT LIKE '%snag list%') OR (area LIKE '%logos%' AND area NOT LIKE '%snag list%') OR (contact_form.message LIKE '%logos%' AND contact_form.message NOT LIKE '%snag list%') ) AND contact_form.is_verify = 1
GROUP BY contact_form.cid
ORDER BY `contact_form`.`cid` DESC LIMIT 25