Seaman's Choice
All crewing of the city of Odesa on the map
Company detailed:
Seaman's Choice is a maritime agency. Our main goal is to provide high-quality information and consulting services to seafarers in matters of employment. Flexibility in approach and knowledge of the seafarers' labor market allows us to work with different cases, such as starting a position or changing the fleet.
Query SELECT s.id, s.pos1, s.pos2, s.user_id, s.name, s.usvisa_expire, s.euvisa_expire, s.language_skill, s.minsalary, s.career_exp, s.career_exp2, UNIX_TIMESTAMP(s.update_date) as update_date, s.birth_year as birth_year, s.ready_date as onboard_date, c.end_date as с_end_date, c.agency, c.agency_id, null as view_time FROM seaman s INNER JOIN career c ON c.user_id = s.user_id INNER JOIN ( SELECT user_id, agency, agency_id, MAX(end_date) max_end_date FROM career WHERE ((agency LIKE 'Seaman's %' AND agency LIKE '% Choice%') OR (agency_id = 3288)) GROUP BY user_id ) c2 ON c.user_id = c2.user_id AND c.end_date = c2.max_end_date WHERE s.s_status='published' AND ((c.agency LIKE 'Seaman's %' AND c.agency LIKE '% Choice%') OR (c.agency_id = 3288)) GROUP BY s.user_id ORDER BY c.`end_date` DESC, s.`update_date` DESC LIMIT 0, 20: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 's %' AND agency LIKE '% Choice%') OR (agency_id = 3288)) ...' at line 26