A Database Error Occurred

Error Number: 1055

Expression #40 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'landcom_lsnakecom.for_sale_pictures.picture_file_name' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

SELECT for_sale.*, for_sale_pictures.picture_file_name AS file_name, 3957 * 2 * atan2(sqrt(pow((sin(0.0174*(for_sale.sled_latitude-39.0395)/2)),2)+cos(0.0174*39.0395) * cos(0.0174*for_sale.sled_latitude)*pow((sin(0.0174*(for_sale.sled_longitude--77.4918)/2)),2)),sqrt(1-(pow((sin(0.0174*(for_sale.sled_latitude-39.0395)/2)),2)+cos(0.0174*39.0395) * cos(0.0174*for_sale.sled_latitude)* pow((sin(0.0174*(for_sale.sled_longitude--77.4918)/2)),2)))) AS distance FROM for_sale, for_sale_pictures WHERE for_sale_pictures.sled_id_fk = for_sale.sled_id AND for_sale.sled_status = 'for_sale' AND for_sale.fk_manufacturer = 'S' AND for_sale.ad_status != 'scammer' AND for_sale.ad_status != 'inactive' AND for_sale_pictures.picture_file_name IS NOT NULL AND for_sale_pictures.picture_file_name !='' AND for_sale.sled_id != '183' GROUP BY for_sale.sled_id ORDER BY distance LIMIT 7

Copyright © 2010 - 2024 Land Snakes. All Rights Reserved. DMCA