DB function failed with error number 1030
Got error -1 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.517974) ) * cos( radians( bank.googlemaps_lat ) ) * cos( radians( bank.googlemaps_lng ) - radians(32.233775) ) + sin( radians(48.517974) ) * 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 = 5949 HAVING distance < 5000 ORDER BY bank_int.full_name, bank.id




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

Реклама

Последние сообщения в форуме

RE: 269486876922 3687
MatthewKeere 05.06.20 15:12
RE: yeti tank 85 review
Jimcar 05.06.20 14:53
RE: yeti tank 85 review
Jimcar 05.06.20 13:23
RE: yeti tank 85 review
Kimcar 05.06.20 12:57
RE: 269486876922 3687
ScottCax 05.06.20 12:55
RE: 269486876922 3687
StevenRaife 05.06.20 12:40
RE: yeti tank 85 review
Nickcar 05.06.20 12:23
RE: 269486876922 3687
Robinanavy 05.06.20 11:14
RE: yeti tank 85 review
Nickcar 05.06.20 10:22
RE: yeti tank 85 review
Nickcar 05.06.20 09:22

Читать все...

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

Реклама



загрузка...