Boat Owner Details

DB Error: mySQL Error on Query : SELECT b1.*,CONCAT(b2.boat_name,' - ',b2.boat_brand) as boat_name, b2.boat_id as boat_id, c1.city_name, s1.state_name ,co1.country_name, CONCAT(u2.fname,' ',u2.lname) as owner_name FROM yayval_crew_staff_list as b1 LEFT JOIN users as u2 ON b1.owner_id = LEFT JOIN boats as b2 ON b1.vessel_id = b2.boat_id LEFT JOIN ineed_country as co1 ON b1.country_id = co1.country_id LEFT JOIN ineed_state as s1 ON b1.state_id = s1.state_id LEFT JOIN ineed_city as c1 ON b1.city_id = c1.city_id WHERE 1 AND b1.crew_staff_id = ORDER BY b1.create_date DESC
More Information:
  • Mysql Error : 1064
  • Mysql Error no # : You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ORDER BY b1.create_date DESC' at line 10
  • Date : July 13, 2024, 6:53 am
  • Referer:
  • Script: /page/boat-owner-crew-staff-list/
# Vessel Name - Brand Owner City, State, Country Added On Request Status Hire Status Actions