DB function failed with error number 145
Table './bankstore_db/jos_bankstore_bank_deposits' is marked as crashed and should be repaired SQL=INSERT INTO jos_temp_deposits_sorting ( deposit_id, percent_min_duration_month, percent_max_duration_month, percent_min_percent, percent_max_percent, percent_min_sum, percent_max_sum ) SELECT deposit.id, MIN(percent.duration_month) as percent_min_duration_month, MAX(percent.duration_month) as percent_max_duration_month, MIN(percent.percent_rate) as percent_min_percent, MAX(percent.percent_rate) as percent_max_percent, MIN(percent.min_sum) as percent_min_sum, MAX(percent.max_sum) as percent_max_sum FROM jos_bankstore_bank_deposits deposit INNER JOIN jos_bankstore_banks bank ON deposit.bank_id = bank.id INNER JOIN jos_bankstore_service_types service ON service.id = deposit.service_type_id INNER JOIN jos_bankstore_bank_deposits_percents percent ON percent.bank_deposit_id = deposit.id WHERE deposit.published = 1 AND deposit.isarchive = 0 AND bank.id = 123554 GROUP BY deposit.id ORDER BY percent_max_percent DESC, percent_max_percent DESC, deposit.id




Пошук банківських продуктів

Популярные статьи

Реклама

DB function failed with error number 145
Table './bankstore_db/jos_artbannersplus' is marked as crashed and should be repaired SQL=SELECT jos_artbannersplus.* FROM jos_artbannersplus, jos_artbannersplus_categories, jos_artbannersplus_clients WHERE 1 AND (jos_artbannersplus.tid IN (6) AND jos_artbannersplus.cid IN (9)) AND ( ('2021-12-06' <= publish_down_date OR publish_down_date = '0000-00-00') AND '2021-12-06' >= publish_up_date AND ( (reccurtype = 0) OR (reccurtype = 1 AND reccurweekdays LIKE '%1%') ) AND '06:45:10' >= publish_up_time AND ('06:45:10' <= publish_down_time OR publish_down_time = '00:00:00') AND access <= '0' AND state = '1' AND jos_artbannersplus.tid = jos_artbannersplus_categories.id AND jos_artbannersplus_categories.published = 1 AND jos_artbannersplus.cid = jos_artbannersplus_clients.cid AND jos_artbannersplus_clients.published = 1 ) ORDER BY last_show ASC, msec ASC

Реклама

Деловые новости Украины

DB function failed with error number 145
Table './bankstore_db/jos_artbannersplus' is marked as crashed and should be repaired SQL=SELECT jos_artbannersplus.* FROM jos_artbannersplus, jos_artbannersplus_categories, jos_artbannersplus_clients WHERE 1 AND (jos_artbannersplus.tid IN (4) AND jos_artbannersplus.cid IN (17)) AND ( ('2021-12-06' <= publish_down_date OR publish_down_date = '0000-00-00') AND '2021-12-06' >= publish_up_date AND ( (reccurtype = 0) OR (reccurtype = 1 AND reccurweekdays LIKE '%1%') ) AND '06:45:10' >= publish_up_time AND ('06:45:10' <= publish_down_time OR publish_down_time = '00:00:00') AND access <= '0' AND state = '1' AND jos_artbannersplus.tid = jos_artbannersplus_categories.id AND jos_artbannersplus_categories.published = 1 AND jos_artbannersplus.cid = jos_artbannersplus_clients.cid AND jos_artbannersplus_clients.published = 1 ) ORDER BY last_show ASC, msec ASC

Реклама





загрузка...