For Seafarers

For Employers

Maritime Medical Examination in Georgia Without a Queue. Special Conditions for Seafarers from Ukraine, Russia and Belarus

25 years of experience, P&I Club certificates, yellow fever vaccination, special offers for seafarers from other countries: transfer service, accommodation search, discounts on certificates in partner training centers, employment assistance through Georgian crewing companies.

Maritime Training Centers in Europe – Part 3: Germany and the Netherlands

In this material, we will focus on where to obtain or renew maritime certificates in Germany and the Netherlands, and we will also look at which training centers for seafarers prepare specialists to work on smart ships and with artificial intelligence technologies.

Artificial Intelligence: Will It Replace Seafarers in 2025?

New Year - new technologies. And new challenges. Many seafarers are increasingly asking questions: How long will human-employed professions exist? And will advancing artificial intelligence leave them without work?

She Only Wants My Money

This phrase is often presented as the «last argument» in a fight, in the heat of emotions as an extreme expression of resentment and it can reflect a man’s emotional experiences that his value in relationships is only reduced to material support.

Seaman's Choice

Country:Ukraine

City:Odesa

Address:Nezhenskaya

Phone number:+38 (066) 311-09-97

E-mail:seamanchoice@gmail.com (for seafarer)

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.

Back

< Previous

Employer list

Next >

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