EmlakSearch
SQL_ERROR_CODE 0
SQL_QUERY select * from t_services where ParentID='0' and PageLang='' and PageType='Services' and Visible='1' order by Seq asc
SQL_ERROR Table 'hayalimd_Emlakci.t_services' doesn't exist
Services
RefNo
EmailList
MailListSave
SQL_ERROR_CODE 0
SQL_QUERY select * from t_poll where PageLang='' and Visible='1' order by Seq asc
SQL_ERROR Table 'hayalimd_Emlakci.t_poll' doesn't existSQL_ERROR_TITLE
SQL_ERROR_CODE 0
SQL_QUERY select * from t_poll_details where PageLang='' and Visible='1' and ParentID='' and Visible='1' order by Seq asc
SQL_ERROR Table 'hayalimd_Emlakci.t_poll_details' doesn't exist
Poll
SQL_ERROR_CODE 0
SQL_QUERY select * from t_banner where Region='LeftColumn' and Visible='1' order by rand() LIMIT 0,1
SQL_ERROR Table 'hayalimd_Emlakci.t_banner' doesn't existSQL_ERROR_TITLE
SQL_ERROR_CODE 0
SQL_QUERY update t_banner set BannerView='1' where banner_val=''
SQL_ERROR Table 'hayalimd_Emlakci.t_banner' doesn't exist
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='' and t2.PageType='EstateStatus' left join t_properties t3 on t1.EstateType=t3.ItemID and t3.PageLang='' 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='' and t7.PageType='RoomType' where PrivateAdvert=1 and t1.visible=1 order by rand() limit 0,1
SQL_ERROR Table 'hayalimd_Emlakci.t_advert' doesn't existSQL_ERROR_TITLE
SQL_ERROR_CODE 0
SQL_QUERY select * from t_advert_images where ParentID='' and Visible=1 order by Seq asc limit 0,5
SQL_ERROR Table 'hayalimd_Emlakci.t_advert_images' doesn't existSQL_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='' and t2.PageType='EstateStatus' left join t_properties t3 on t1.EstateType=t3.ItemID and t3.PageLang='' 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 t1.AdvertSeq=0, t1.ADate desc
SQL_ERROR Table 'hayalimd_Emlakci.t_advert' doesn't exist
SQL_ERROR_TITLE
SQL_ERROR_CODE 0
SQL_QUERY select * from t_banner where Region='Main' and Visible='1' order by rand() LIMIT 0,1
SQL_ERROR Table 'hayalimd_Emlakci.t_banner' doesn't existSQL_ERROR_TITLE
SQL_ERROR_CODE 0
SQL_QUERY update t_banner set BannerView='1' where banner_val=''
SQL_ERROR Table 'hayalimd_Emlakci.t_banner' doesn't existSQL_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 'hayalimd_Emlakci.t_advert' doesn't existSQL_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='' and t2.PageType='EstateStatus' left join t_properties t3 on t1.EstateType=t3.ItemID and t3.PageLang='' 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 t1.AdvertSeq=0, t1.ADate desc limit 0,0
SQL_ERROR Table 'hayalimd_Emlakci.t_advert' doesn't exist
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='' and t2.PageType='EstateStatus' left join t_properties t3 on t1.EstateType=t3.ItemID and t3.PageLang='' 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='' and t7.PageType='RoomType' where PrivateAdvert=1 and t1.visible=1 order by rand() limit 0,1
SQL_ERROR Table 'hayalimd_Emlakci.t_advert' doesn't existSQL_ERROR_TITLE
SQL_ERROR_CODE 0
SQL_QUERY select * from t_advert_images where ParentID='' and Visible=1 order by Seq asc limit 0,5
SQL_ERROR Table 'hayalimd_Emlakci.t_advert_images' doesn't existSQL_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='' and t2.PageType='EstateStatus' left join t_properties t3 on t1.EstateType=t3.ItemID and t3.PageLang='' 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 t1.AdvertSeq=0, t1.ADate desc
SQL_ERROR Table 'hayalimd_Emlakci.t_advert' doesn't exist
SQL_ERROR_CODE 0
SQL_QUERY select * from t_banner where Region='Main' and Visible='1' order by rand() LIMIT 0,1
SQL_ERROR Table 'hayalimd_Emlakci.t_banner' doesn't existSQL_ERROR_TITLE
SQL_ERROR_CODE 0
SQL_QUERY update t_banner set BannerView='1' where banner_val=''
SQL_ERROR Table 'hayalimd_Emlakci.t_banner' doesn't existSQL_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 'hayalimd_Emlakci.t_advert' doesn't existSQL_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='' and t2.PageType='EstateStatus' left join t_properties t3 on t1.EstateType=t3.ItemID and t3.PageLang='' 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 t1.AdvertSeq=0, t1.ADate desc limit 0,0
SQL_ERROR Table 'hayalimd_Emlakci.t_advert' doesn't exist
- TotalRecord • Page 1/0
SQL_ERROR_TITLE
SQL_ERROR_CODE 0
SQL_QUERY select * from t_banner where Region='RightColumn' and Visible='1' order by rand() LIMIT 0,1
SQL_ERROR Table 'hayalimd_Emlakci.t_banner' doesn't existSQL_ERROR_TITLE
SQL_ERROR_CODE 0
SQL_QUERY update t_banner set BannerView='1' where banner_val=''
SQL_ERROR Table 'hayalimd_Emlakci.t_banner' doesn't exist SQL_ERROR_TITLE
SQL_ERROR_CODE 0
SQL_QUERY select * from t_authorized where Visible=1 order by Seq asc
SQL_ERROR Table 'hayalimd_Emlakci.t_authorized' doesn't exist
SQL_ERROR_TITLE
SQL_ERROR_CODE 0
SQL_QUERY select count(t1.EstateType) as total, t1.EstateStatus, t1.EstateType, t2.Name as estate_type, t3.Name as estate_status from t_advert t1 left join t_properties t2 on t1.EstateType=t2.ItemID and t2.PageType='EstateType' and t2.PageLang='' left join t_properties t3 on t1.EstateStatus=t3.ItemID and t3.PageType='EstateStatus' and t3.PageLang='' where t1.EstateStatus=1 and t1.Visible=1 group by t1.EstateType order by t2.Name asc
SQL_ERROR Table 'hayalimd_Emlakci.t_advert' doesn't exist
SQL_ERROR_TITLE
SQL_ERROR_CODE 0
SQL_QUERY select count(t1.EstateType) as total, t1.EstateStatus, t1.EstateType, t2.Name as estate_type, t3.Name as estate_status from t_advert t1 left join t_properties t2 on t1.EstateType=t2.ItemID and t2.PageType='EstateType' and t2.PageLang='' left join t_properties t3 on t1.EstateStatus=t3.ItemID and t3.PageType='EstateStatus' and t3.PageLang='' where t1.EstateStatus=2 and t1.Visible=1 group by t1.EstateType order by t2.Name asc
SQL_ERROR Table 'hayalimd_Emlakci.t_advert' doesn't exist
SQL_ERROR_TITLE
SQL_ERROR_CODE 0
SQL_QUERY select * from t_exchange where Currency!='TL' order by Seq asc
SQL_ERROR Table 'hayalimd_Emlakci.t_exchange' doesn't exist
SQL_ERROR_TITLE
SQL_ERROR_CODE 0
SQL_QUERY select * from t_weather
SQL_ERROR Table 'hayalimd_Emlakci.t_weather' doesn't exist
SQL_ERROR_CODE 0
SQL_QUERY select * from t_banner where Region='RightColumn' and Visible='1' order by rand() LIMIT 0,1
SQL_ERROR Table 'hayalimd_Emlakci.t_banner' doesn't existSQL_ERROR_TITLE
SQL_ERROR_CODE 0
SQL_QUERY update t_banner set BannerView='1' where banner_val=''
SQL_ERROR Table 'hayalimd_Emlakci.t_banner' doesn't exist SQL_ERROR_TITLE
SQL_ERROR_CODE 0
SQL_QUERY select * from t_authorized where Visible=1 order by Seq asc
SQL_ERROR Table 'hayalimd_Emlakci.t_authorized' doesn't exist
Consultant
SQL_ERROR_CODE 0
SQL_QUERY select count(t1.EstateType) as total, t1.EstateStatus, t1.EstateType, t2.Name as estate_type, t3.Name as estate_status from t_advert t1 left join t_properties t2 on t1.EstateType=t2.ItemID and t2.PageType='EstateType' and t2.PageLang='' left join t_properties t3 on t1.EstateStatus=t3.ItemID and t3.PageType='EstateStatus' and t3.PageLang='' where t1.EstateStatus=1 and t1.Visible=1 group by t1.EstateType order by t2.Name asc
SQL_ERROR Table 'hayalimd_Emlakci.t_advert' doesn't exist
Sale
SQL_ERROR_CODE 0
SQL_QUERY select count(t1.EstateType) as total, t1.EstateStatus, t1.EstateType, t2.Name as estate_type, t3.Name as estate_status from t_advert t1 left join t_properties t2 on t1.EstateType=t2.ItemID and t2.PageType='EstateType' and t2.PageLang='' left join t_properties t3 on t1.EstateStatus=t3.ItemID and t3.PageType='EstateStatus' and t3.PageLang='' where t1.EstateStatus=2 and t1.Visible=1 group by t1.EstateType order by t2.Name asc
SQL_ERROR Table 'hayalimd_Emlakci.t_advert' doesn't exist
Rent
SQL_ERROR_CODE 0
SQL_QUERY select * from t_exchange where Currency!='TL' order by Seq asc
SQL_ERROR Table 'hayalimd_Emlakci.t_exchange' doesn't exist
ExchangeInfo
| CurBuying | CurSell |
|---|
CreditCalculator
CurrencyConverter
SQL_ERROR_CODE 0
SQL_QUERY select * from t_weather
SQL_ERROR Table 'hayalimd_Emlakci.t_weather' doesn't exist