wagoodoogoo

INSERT INTO `applications_closed`
SELECT *, '$close_user' as close_user
FROM `applications`
WHERE `id` = '$id'

// это если первый номер нужен
UPDATE tel_incoming SET caller_tel = (SELECT SUBSTRING_INDEX(SUBSTRING_INDEX(record, '_', 4), '_', -1))
// это для второго
UPDATE tel_incoming SET caller_tel = (SELECT SUBSTRING_INDEX(SUBSTRING_INDEX(SUBSTRING_INDEX(record, '_', 5), '_', -1), '.', 1))

if ($search){
$words = explode(' ', $search);
foreach ($words as $word) {
    $search = $db->Quote('%'.$db->escape( $word, true).'%');
    $conds1[] = ' prod.title LIKE '.$search;
$conds2[] = ' a.adres LIKE '.$search;
$conds3[] = ' prod.fio LIKE '.$search;
}
$query1 = implode(' OR ', $conds1);
$query2 = implode(' OR ', $conds2);
$query3 = implode(' OR ', $conds3);
$query->where('( '.$query1.' ) OR ( '.$query2.' ) OR ( '.$query3.')');
}

SELECT COUNT(id),  concat(MONTHNAME(date), ' ', YEAR(date)) as month FROM news
GROUP BY month