Table './realtor_db/real_estate' is marked as crashed and should be repaired
SELECT #_estate.*, #_estate_cat.name_de AS category, #_estate_cat.title_de AS category_title, #_estate_types.name_de AS type, #_regions.name_de AS Nregion, #_cities.name_de AS Ncity, #_masiv.name_de AS Nmasiv, #_currency.kod AS currency, (SELECT src FROM #_estate_img WHERE publish=1 AND o_id=22983 ORDER BY main DESC LIMIT 1) AS main_image FROM #_estate LEFT JOIN #_estate_cat ON #_estate_cat.id=#_estate.c_id LEFT JOIN #_estate_types ON #_estate_types.id=#_estate.t_id LEFT JOIN #_regions ON #_regions.id=#_estate.region LEFT JOIN #_cities ON #_cities.id=#_estate.city LEFT JOIN #_masiv ON #_masiv.id=#_estate.masiv LEFT JOIN #_currency ON #_currency.id=#_estate.price_val WHERE #_estate.c_id=1 AND #_estate.id=22983 LIMIT 1