Failed query('SELECT L.label_name, L.label_pic, SUM(R.net_revenue) as total, C.name, SUM(R.net_revenue * C.rate) as total_rub FROM report_doc_lines R, ( SELECT max(id) as id FROM report_docs WHERE visible=1 and closed=1 ) D, labels L, v_currencies C, v_users O, v_accounts A WHERE D.id=R.report_id and L.id=R.label and length(L.label_pic)>10 and C.id=R.currency and O.uid=L.owner_user_id and A.uid=O.account_uid and A.disabled=0 and A.active=1 and O.site_id='1' GROUP BY L.label_name ORDER BY total_rub desc LIMIT 10') : Table 'sundesir_dmb.report_doc_lines' doesn't exist
query_dbX('DMB','SELECT L.label_name, L.label_pic, SUM(R.net_revenue) as total, C.name, SUM(R.net_revenue * C.rate) as total_rub FROM report_doc_lines R, ( SELECT max(id) as id FROM report_docs WHERE visible=1 and closed=1 ) D, labels L, v_currencies C, v_users O, v_accounts A WHERE D.id=R.report_id and L.id=R.label and length(L.label_pic)>10 and C.id=R.currency and O.uid=L.owner_user_id and A.uid=O.account_uid and A.disabled=0 and A.active=1 and O.site_id='1' GROUP BY L.label_name ORDER BY total_rub desc LIMIT 10') : /srv/www/sdm/web/local/modules/customers/featured_labels_table.class.php:29
featured_labels_table->load() : /srv/www/sdm/web/local/modules/customers/featured_labels_table.class.php:119
featured_labels_table->get_list() : /srv/www/sdm/web/temp/compiled/sdm/04a90cd40153f26305485bd387103112cd4f92cb.vlfile.main.tpl.php:84
content_4ff2fdc06e1901_63856621('') : /srv/www/sdm/web/smarty/sysplugins/smarty_internal_templatebase.php:180
Smarty_Internal_TemplateBase->fetch('vlfile:main.tpl') : /srv/www/sdm/web/php/classes/pages/main/main_page.class.php:20
main_page->fetch_content() : /srv/www/sdm/web/local/modules/my_main_page/my_main_page.class.php:77
my_main_page->fetch_content() : /srv/www/sdm/web/php/classes/pages/pages.class.php:154
pages->get_content() : /srv/www/sdm/web/index.php:129
Failed query('SELECT L.label_name, L.label_pic, SUM(R.net_revenue) as total, C.name, SUM(R.net_revenue * C.rate) as total_rub FROM report_doc_lines R, ( SELECT max(id) as id FROM report_docs WHERE visible=1 and closed=1 ) D, labels L, v_currencies C, v_users O, v_accounts A WHERE D.id=R.report_id and L.id=R.label and length(L.label_pic)>10 and C.id=R.currency and O.uid=L.owner_user_id and A.uid=O.account_uid and A.disabled=0 and A.active=1 and O.site_id='1' GROUP BY L.label_name ORDER BY total_rub desc LIMIT 10'):Table 'sundesir_dmb.report_doc_lines' doesn't exist