Seaman's Choice
нет лицензииIssued by:
—Issued on:
00.00.0000
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, null as view_time FROM seaman s INNER JOIN career c ON c.user_id = s.user_id WHERE s.s_status='published' AND c.agency LIKE '%Seaman's%' AND c.agency LIKE '%Choice%' 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 c.agency LIKE '%Choice%' GROUP BY s.user_id ORDER BY c.`end_date` DES...' at line 19