DB Error: mySQL Error on Query : SELECT b1.*,CONCAT(b2.boat_name,' - ',b2.boat_brand) as boat_name,
c1.city_name, s1.state_name ,co1.country_name, CONCAT(u2.fname,' ',u2.lname) as crew_staff_name, u2.captain_resume, u2.captain_driver_license, u2.captain_license, u2.captain_certificate_insurance, u2.cpatain_w9_form, u2.cov_f_vaccination, u2.cov_f_vaccine, u2.cov_f_vaccine_date, u2.cov_s_vaccination, u2.cov_s_vaccine, u2.cov_s_vaccine_date
FROM yayval_crew_staff_list as b1
LEFT JOIN users as u2 ON b1.crew_staff_id = u2.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.owner_id =
AND b1.status = '1'
ORDER BY b1.create_date DESC
- 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 'AND b1.status = '1'
ORDER BY b1.create_date DESC' at line 10
- Date : December 7, 2022, 6:28 pm
- Script: /page/crew-staff-list/