# Запрос номер 1: SELECT @@sql_mode (0.0002 sec ) /var/www/html/mg-core/lib/db.php (line 49)
# Запрос номер 2: SET @@sql_mode='NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION' (0.0001 sec ) /var/www/html/mg-core/lib/db.php (line 59)
# Запрос номер 5: SELECT `value` FROM `mg_setting` WHERE `option` = 'useDefaultSettings' (0.0002 sec ) /var/www/html/mg-core/lib/mg.php (line 1096)
# Запрос номер 6: SELECT `option`, `value` FROM `mg_setting` (0.0007 sec ) /var/www/html/mg-core/lib/mg.php (line 1103)
Ошибка в SQL запросе: SELECT MD5(T.phone) as phone, external_id, email, birthday FROM ( SELECT REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(mg_user.phone, '+', ''), ' ', ''), '-', ''), '(', ''), ')', '') as phone, mg_user.id as external_id FROM mg_user JOIN mg_order ON REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(mg_order.phone, '+', ''), ' ', ''), '-', ''), '(', ''), ')', '') = REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(mg_user.phone, '+', ''), ' ', ''), '-', ''), '(', ''), ')', '') WHERE mg_order.phone <> '' AND mg_order.add_date BETWEEN DATE('2024-06-01') AND DATE('2024-06-30') GROUP BY phone, external_id ) as T JOIN mg_user ON mg_user.id = T.external_id;/var/www/html/mg-pages/for_matching.php (line 4)
/var/www/html/mg-core/lib/mg.php (line 3222)
/var/www/html/mg-core/lib/mg.php (line 1632)
/var/www/html/mg-core/mg-start.php (line 71)
/var/www/html/mg-core/index-start.php (line 128)
/var/www/html/index.php (line 6)