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 = 125399
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
(
('2024-09-07' <= publish_down_date OR publish_down_date = '0000-00-00')
AND '2024-09-07' >= publish_up_date
AND ( (reccurtype = 0) OR (reccurtype = 1 AND reccurweekdays LIKE '%6%') )
AND '19:38:12' >= publish_up_time
AND ('19:38:12' <= 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
(
('2024-09-07' <= publish_down_date OR publish_down_date = '0000-00-00')
AND '2024-09-07' >= publish_up_date
AND ( (reccurtype = 0) OR (reccurtype = 1 AND reccurweekdays LIKE '%6%') )
AND '19:38:12' >= publish_up_time
AND ('19:38:12' <= 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
