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,u1.id as vendorid, CONCAT(u1.fname,' ',u1.lname) as vendorname
FROM boat_request as b1
LEFT JOIN boats as b2 ON b1.boat_id = b2.boat_id
LEFT JOIN users as u1 ON b1.vendor_id = u1.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.request_owner_id = AND b1.status = 'Completed'
ORDER BY b1.request_added 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 = 'Completed'
ORDER BY b1.request_added DESC' at line 9
- Date : September 24, 2023, 5:01 pm
- Script: /page/boat-request-completed/