Bad request : SELECT properties.id_property,urls.url,urls.url_id_page,users.logo AS user_image,users.website AS user_website,properties.id_page,properties.link,properties.property_key,properties.title,properties.select_type,properties.select_price,properties.price,properties.real_price,properties.lot_size,properties.construction_size,properties.description,properties.logo FROM properties LEFT JOIN urls ON urls.url_table_name='properties' AND urls.url_id=properties.id_property LEFT JOIN users ON users.id_user=properties.id_user WHERE select_operation='2' GROUP BY properties.id_property ORDER BY date DESC LIMIT 0,12 error :Column 'date' in order clause is ambiguous