DB function failed with error number 145 Table './bankstore_db/jos_bankstore_atms' is marked as crashed and should be repaired SQL=SELECT atm.city_id, atm.region_id, count( atm.city_id ) as atms_count,
city_int.name as city_name, city.googlemaps_lat as city_googlemaps_lat, city.googlemaps_lng as city_googlemaps_lng, city.googlemaps_acc as city_googlemaps_acc,
reg_int.name as region_name
FROM jos_bankstore_atms atm
LEFT JOIN jos_bankstore_cities city ON city.id = atm.city_id
LEFT JOIN jos_bankstore_cities_int city_int ON city_int.city_id = atm.city_id
AND ( city_int.lang_id = 2 )
LEFT JOIN jos_bankstore_regions_int reg_int ON reg_int.region_id = atm.region_id
AND ( reg_int.lang_id = 2 )
WHERE atm.published = 1
AND atm.isdeleted = 0
AND atm.googlemaps_acc > 1
GROUP BY atm.city_id
ORDER BY atms_count DESC
LIMIT 50
Экономика. Общество.
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 '17:40:58' >= publish_up_time
AND ('17:40:58' <= 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 '17:40:58' >= publish_up_time
AND ('17:40:58' <= 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
