Favorite vendor List

Upload Favorite Vendor from CSV: Sample CSV
DB Error: mySQL Error on Query : SELECT b1.*, fav.employer_name as fav_employer_name ,b1.status as vf_status, s2.services as vf_services, b1.id as vf_id, c1.city_name, s1.state_name ,co1.country_name,u1.id as vendorid, CONCAT(u1.fname,' ',u1.lname) as vendorname, u1.employer_name as vf_employer_name, u1.cov_f_vaccination, u1.cov_f_vaccine, u1.cov_f_vaccine_date, u1.cov_s_vaccination, u1.cov_s_vaccine, u1.cov_s_vaccine_date FROM vendor_favourite_list as b1 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 LEFT JOIN services as s2 ON b1.service_category_id = s2.id LEFT JOIN fav_vendor_user as fav ON fav.id = b1.vendor_id WHERE 1 AND b1.boat_owner_id =
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 '' at line 9
  • Date : July 13, 2024, 7:13 am
  • Referer:
  • Script: /page/vendor-favorite-list/
# Country State City Company Name Vessel Service Department Vessel Equipment Description Vaccine Name Vaccination Date Covid Certificates Status Action