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.

Distance From Family. Is it Possible to Make up for Lost Events? How to Mitigate the Effect of Absence?

Working away from home inevitably impinges on both the one who works - a seafarer, and his family members. The seafarer missed the whole “series” of family events and it is impossible to make up for them post factum.

How to Protect Yourself While Looking for a Job

You are looking for a job and dreaming of a successful career at sea. It is clear that you are looking for the most attractive option. This is on your aspirations and desires that scammers seek to make money.

Lately, scammers have been writing to seafarers through social networks or messengers, offering various types of services. It is not difficult to spot a scam.

Interview 2nd Engineer. Questions You Should be Prepare for

Dear friends, we present to your attention interview options for 2nd Engineer

For employment on tankers
General question about the main engin

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