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
)