message_sqlSELECT contact_form.*, COUNT(messages.qoute_id) AS message_count
FROM contact_form
LEFT JOIN messages ON contact_form.cid = messages.qoute_id
WHERE (keyphrase LIKE '%img%' OR area LIKE '%img%' OR contact_form.message LIKE '%img%') AND contact_form.is_verify = 1
GROUP BY messages.user_id
ORDER BY message_count DESC
LIMIT 1
Array ( [cid] => 7574 [name] => [email] => [email protected] [phone] => [message] => fix a broken lock on patio door. I cant open it. img included.. [files] => fix-patio-door-repair-locksmith-dublin-clondalkin.jpg [keyphrase] => fix a broken lock on patio door. I cant open it. [urgent] => 0 [status] => 0 [created_on] => 2025-03-27 14:11:50 [updated_on] => 0000-00-00 00:00:00 [img1] => [img2] => [img3] => [ip] => 80.233.41.31 [location] => , [area] => Clondalkin, Dublin [completion_date] => 0000-00-00 [completion_time] => 00:00:00 [blacklist] => 0 [subscribed] => 0 [lat] => 53.32030260000001 [lng] => -6.3946345 [country] => Ireland [is_verify] => 1 [reg_id] => 0 [vet] => 0 [message_count] => 1 )