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 '%web%' OR area LIKE '%web%' OR contact_form.message LIKE '%web%' ) AND (keyphrase LIKE '%design%' OR area LIKE '%design%' OR contact_form.message LIKE '%design%' ) AND (keyphrase LIKE '%developer%' OR area LIKE '%developer%' OR contact_form.message LIKE '%developer%' ) AND (keyphrase LIKE '%cost%' OR area LIKE '%cost%' OR contact_form.message LIKE '%cost%' ) AND (keyphrase LIKE '%prices.php%' OR area LIKE '%prices.php%' OR contact_form.message LIKE '%prices.php%' ) AND contact_form.is_verify = 1
GROUP BY contact_form.cid
ORDER BY `contact_form`.`cid` DESC LIMIT 25