Ref. Code
E-Mail List
Please subscribe for E-Mail list to get information about our updates.
Poll
Test question
  • Excellent
  • test
  • test1
  • Test2
  • Test3
  • test
Poll Result
Tags
SQL_ERROR_TITLE
SQL_ERROR_CODE 0
SQL_QUERY select count(t1.EstateType) as total, t1.EstateStatus, t1.EstateType, t2.Name as estate_type from t_advert t1 left join t_properties t2 on t1.EstateType=t2.ItemID and t2.PageType='EstateType' and t2.PageLang='English' where t1.Visible=1 group by t1.EstateStatus, t1.EstateType order by rand()
SQL_ERROR Expression #4 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'ozkar1.t2.Name' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by