DB function failed with error number 1030
Got error 28 from storage engine SQL=SELECT bank.*, COALESCE(bank_int.short_name, '') as short_name, bank_int_def.short_name as short_name_def, COALESCE(bank_int.full_name, '') as full_name, bank_int_def.full_name as full_name_def, COALESCE(bank_int.description_title, '') as description_title, bank_int_def.description_title as description_title_def, COALESCE(bank_int.description_full, '') as description_full, bank_int_def.description_full as description_full_def, COALESCE(bank_int.address, '') as address, bank_int_def.address as address_def, COALESCE(city_int.name, '') as city_name, city_int_def.name as city_name_def, COALESCE(reg_int.name, '') as region_name, reg_int_def.name as region_name_def, ( 6371 * acos( cos( radians(48.663270) ) * cos( radians( bank.googlemaps_lat ) ) * cos( radians( bank.googlemaps_lng ) - radians(33.096788) ) + sin( radians(48.663270) ) * sin( radians( bank.googlemaps_lat ) ) ) )*1000 AS distance FROM jos_bankstore_banks bank LEFT JOIN jos_bankstore_banks_int bank_int ON bank_int.bank_id = bank.id AND ( bank_int.lang_id = 2 ) LEFT JOIN jos_bankstore_banks_int bank_int_def ON bank_int_def.bank_id = bank.id AND ( bank_int_def.lang_id = 2 ) LEFT JOIN jos_bankstore_cities_int city_int ON city_int.city_id = bank.city_id AND ( city_int.lang_id = 2 ) LEFT JOIN jos_bankstore_cities_int city_int_def ON city_int_def.city_id = bank.city_id AND ( city_int_def.lang_id = 2 ) LEFT JOIN jos_bankstore_regions_int reg_int ON reg_int.region_id = bank.region_id AND ( reg_int.lang_id = 2 ) LEFT JOIN jos_bankstore_regions_int reg_int_def ON reg_int_def.region_id = bank.region_id AND ( reg_int_def.lang_id = 2 ) WHERE bank.published = 1 AND bank.isdeleted = 0 AND ( bank.parent_id = 124408 OR bank.id = 124408 ) AND bank_int.address != '' AND bank_int_def.address != '' AND bank.googlemaps_acc > 3 AND bank.city_id = 5950 HAVING distance < 5000 ORDER BY bank_int.full_name, bank.id




Экономика. Общество.

Реклама

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

Реклама





загрузка...