Əmlak axtarışı
Faydalı Məlumatlar
Əmlak Kodu
SQL_ERROR_TITLE
SQL_ERROR_CODE 0
SQL_QUERY select t1.ID as advert_id, t1.advert_title, t1.SquareMeter, t1.Location, t1.RentPrice, t1.RentCurrency, t1.AdvertType, t2.Name as estate_status, t3.Name as estate_type, t4.Name as estate_city, t5.Name as estate_township, t6.Name as estate_area, t7.Name as room_type, (select Images from t_advert_images where Visible='1' and ParentID=t1.ID order by Seq asc LIMIT 0,1) as estate_images from t_advert t1 left join t_properties t2 on t1.EstateStatus=t2.ItemID and t2.PageLang='Azərbaycan dili' and t2.PageType='EstateStatus' left join t_properties t3 on t1.EstateType=t3.ItemID and t3.PageLang='Azərbaycan dili' and t3.PageType='EstateType' left join t_city t4 on t1.City=t4.ID left join t_township t5 on t1.Township=t5.ID left join t_area t6 on t1.Area=t6.ID left join t_properties t7 on t1.RoomType=t7.ItemID and t7.PageLang='Azərbaycan dili' and t7.PageType='RoomType' where PrivateAdvert=1 and t1.visible=1 order by rand() limit 0,1
SQL_ERROR Table './evim_hb2k2/t_advert' is marked as crashed and should be repairedSQL_ERROR_TITLE
SQL_ERROR_CODE 0
SQL_QUERY select t1.ID, t1.RentPrice, t1.RentCurrency, t1.ID as advert_id, t2.Name as estate_status, t3.Name as estate_type, t4.Name as estate_city, t5.Name as estate_township, (select Images from t_advert_images where Visible='1' and ParentID=t1.ID order by Seq asc LIMIT 0,1) as estate_images from t_advert t1 left join t_properties t2 on t1.EstateStatus=t2.ItemID and t2.PageLang='Azərbaycan dili' and t2.PageType='EstateStatus' left join t_properties t3 on t1.EstateType=t3.ItemID and t3.PageLang='Azərbaycan dili' and t3.PageType='EstateType' left join t_city t4 on t1.City=t4.ID left join t_township t5 on t1.Township=t5.ID where t1.PrivateAdvert=1 and t1.visible=1 order by ADate desc
SQL_ERROR Table './evim_hb2k2/t_advert' is marked as crashed and should be repaired
SQL_ERROR_CODE 0
SQL_QUERY select t1.ID as advert_id, t1.advert_title, t1.SquareMeter, t1.Location, t1.RentPrice, t1.RentCurrency, t1.AdvertType, t2.Name as estate_status, t3.Name as estate_type, t4.Name as estate_city, t5.Name as estate_township, t6.Name as estate_area, t7.Name as room_type, (select Images from t_advert_images where Visible='1' and ParentID=t1.ID order by Seq asc LIMIT 0,1) as estate_images from t_advert t1 left join t_properties t2 on t1.EstateStatus=t2.ItemID and t2.PageLang='Azərbaycan dili' and t2.PageType='EstateStatus' left join t_properties t3 on t1.EstateType=t3.ItemID and t3.PageLang='Azərbaycan dili' and t3.PageType='EstateType' left join t_city t4 on t1.City=t4.ID left join t_township t5 on t1.Township=t5.ID left join t_area t6 on t1.Area=t6.ID left join t_properties t7 on t1.RoomType=t7.ItemID and t7.PageLang='Azərbaycan dili' and t7.PageType='RoomType' where PrivateAdvert=1 and t1.visible=1 order by rand() limit 0,1
SQL_ERROR Table './evim_hb2k2/t_advert' is marked as crashed and should be repairedSQL_ERROR_TITLE
SQL_ERROR_CODE 0
SQL_QUERY select t1.ID, t1.RentPrice, t1.RentCurrency, t1.ID as advert_id, t2.Name as estate_status, t3.Name as estate_type, t4.Name as estate_city, t5.Name as estate_township, (select Images from t_advert_images where Visible='1' and ParentID=t1.ID order by Seq asc LIMIT 0,1) as estate_images from t_advert t1 left join t_properties t2 on t1.EstateStatus=t2.ItemID and t2.PageLang='Azərbaycan dili' and t2.PageType='EstateStatus' left join t_properties t3 on t1.EstateType=t3.ItemID and t3.PageLang='Azərbaycan dili' and t3.PageType='EstateType' left join t_city t4 on t1.City=t4.ID left join t_township t5 on t1.Township=t5.ID where t1.PrivateAdvert=1 and t1.visible=1 order by ADate desc
SQL_ERROR Table './evim_hb2k2/t_advert' is marked as crashed and should be repaired
SQL_ERROR_TITLE
SQL_ERROR_CODE 0
SQL_QUERY select count(*) as count_row from t_advert where Visible='1' and DisplayAdvert='1'
SQL_ERROR Table './evim_hb2k2/t_advert' is marked as crashed and should be repairedSQL_ERROR_TITLE
SQL_ERROR_CODE 0
SQL_QUERY select t1.ID as advert_id, advert_title, t1.SquareMeter, t1.RentPrice, t1.RentCurrency, t1.AdvertType, t2.Name as estate_status, t3.Name as estate_type, t4.Name as estate_city, t5.Name as estate_township, t6.Name as estate_area, (select Images from t_advert_images where Visible='1' and ParentID=t1.ID order by Seq asc LIMIT 0,1) as estate_images from t_advert t1 left join t_properties t2 on t1.EstateStatus=t2.ItemID and t2.PageLang='Azərbaycan dili' and t2.PageType='EstateStatus' left join t_properties t3 on t1.EstateType=t3.ItemID and t3.PageLang='Azərbaycan dili' and t3.PageType='EstateType' left join t_city t4 on t1.City=t4.ID left join t_township t5 on t1.Township=t5.ID left join t_area t6 on t1.Area=t6.ID where t1.Visible='1' and t1.DisplayAdvert='1' order by ADate desc limit 0,0
SQL_ERROR Table './evim_hb2k2/t_advert' is marked as crashed and should be repaired
SQL_ERROR_CODE 0
SQL_QUERY select count(*) as count_row from t_advert where Visible='1' and DisplayAdvert='1'
SQL_ERROR Table './evim_hb2k2/t_advert' is marked as crashed and should be repairedSQL_ERROR_TITLE
SQL_ERROR_CODE 0
SQL_QUERY select t1.ID as advert_id, advert_title, t1.SquareMeter, t1.RentPrice, t1.RentCurrency, t1.AdvertType, t2.Name as estate_status, t3.Name as estate_type, t4.Name as estate_city, t5.Name as estate_township, t6.Name as estate_area, (select Images from t_advert_images where Visible='1' and ParentID=t1.ID order by Seq asc LIMIT 0,1) as estate_images from t_advert t1 left join t_properties t2 on t1.EstateStatus=t2.ItemID and t2.PageLang='Azərbaycan dili' and t2.PageType='EstateStatus' left join t_properties t3 on t1.EstateType=t3.ItemID and t3.PageLang='Azərbaycan dili' and t3.PageType='EstateType' left join t_city t4 on t1.City=t4.ID left join t_township t5 on t1.Township=t5.ID left join t_area t6 on t1.Area=t6.ID where t1.Visible='1' and t1.DisplayAdvert='1' order by ADate desc limit 0,0
SQL_ERROR Table './evim_hb2k2/t_advert' is marked as crashed and should be repaired
- Cəmi qeyd: • Səhifə : 4/0
Kredit hesablama