Подскажите какого поля мне не хватает?
В /tmp/sql_errors
Код: Выделить всё
SELECT at.id, at.name, ul.comments, at.price, at.period,
ul.service_count,
max(ul.date) AS date,
if (at.nonfix_period = 1,
if (at.period = 0, ul.date+ INTERVAL 1 DAY,
if (at.period = 1, ul.date + INTERVAL 1 MONTH,
if (at.period = 2, ul.date + INTERVAL 3 MONTH,
if (at.period = 3, ul.date + INTERVAL 6 MONTH,
if (at.period = 4, ul.date + INTERVAL 1 YEAR,
'-'
)
)
)
)
),
@next_abon := if (at.period = 0, ul.date+ INTERVAL 1 DAY,
if (at.period = 1, DATE_FORMAT(ul.date + INTERVAL 1 MONTH, '%Y-%m-01'),
if (at.period = 2, CONCAT(YEAR(ul.date + INTERVAL 3 MONTH), '-' ,(QUARTER((ul.date + INTERVAL 3 MONTH))*3-2), '-01'),
if (at.period = 3, CONCAT(YEAR(ul.date + INTERVAL 6 MONTH), '-', if(MONTH(ul.date + INTERVAL 6 MONTH) > 6, '06', '01'), '-01'),
if (at.period = 4, DATE_FORMAT(ul.date + INTERVAL 1 YEAR, '%Y-01-01'),
'-'
)
)
)
)
)
) AS next_abon,
ul.manual_fee,
ul.discount,
count(ul.uid) AS active_service,
ul.notification1,
ul.notification1_account_id,
ul.notification2,
ul.create_docs,
ul.send_docs,
at.manual_activate,
if (@next_abon < curdate(), 1, 0) AS missing
FROM abon_tariffs at
LEFT JOIN abon_user_list ul ON (at.id=ul.tp_id and ul.uid='')
GROUP BY at.id
ORDER BY 1 ;
--1054
--Unknown column 'at.id' in 'field list'
Код: Выделить всё
[Sun Aug 25 17:27:32 2013] [error] [client 188.233.XX.XX] DBD::mysql::st execute failed: Unknown column 'at.id' in 'field list' at ../Abills/mysql//main.pm line 187., referer: https://XXX.ru/