Errore:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND tb_rate.CRUISE_ONLY='N' AND best_price_cruise>0 GROUP BY itin_code_cruise,ye' at line 1
Query:SELECT tb_cruise.id_cruise,tb_cruise_area.id_cruise_area,tb_cruise.day_cruise,tb_cruise_area.title_cruise_area,tb_cruise_area.keyurl_cruise_area,tb_destination.name_destination,tb_destination.keyurl_destination,tb_ship.name_ship,tb_ship.keyurl_ship,tb_ship.image_ship,tb_shipowner.logo_shipowner,tb_shipowner.keyurl_shipowner,itin_code_cruise,DATE_FORMAT(datefrom_cruise,"%Y-%m") as yearmonth,2A,description_shipowner,itineraryext_cruise as itinerary_cruise,best_price_cruise as best_price,datefrom_cruise,cod_cruise,best_id_rate_cruise,CRUISE_ONLY,pathimage_ship,image_default_ship,name_shipowner FROM (tb_cruise INNER JOIN tb_ship ON tb_cruise.id_ship=tb_ship.id_ship) INNER JOIN tb_rate ON tb_cruise.id_cruise=tb_rate.id_cruise INNER JOIN tb_shipowner ON tb_ship.id_shipowner=tb_shipowner.id_shipowner INNER JOIN tb_destination ON tb_cruise.id_departure=tb_destination.id_destination INNER JOIN tb_cruise_area ON tb_cruise.id_cruise_area=tb_cruise_area.id_cruise_area WHERE AND tb_rate.CRUISE_ONLY='N' AND best_price_cruise>0 GROUP BY itin_code_cruise,yearmonth ORDER BY best_price ASC, datefrom_cruise ASC LIMIT 0,10