For Seafarers

For Employers

Friends, we are getting informed about cases of fraud against seafarers. Therefore, we decided to create a page on which we will write details of fraudulent schemes, names and telephone numbers.

CONFLICTS. Why Do They Happen and What Can They Teach Me?

Each of us has once faced, been a participant, onlooker or instigator of conflict. What actually happens when emotions overshadow common sense, and it is almost impossible to manage a process that was completely manageable just a second ago?

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.

Why is an interview scary? We tell you how to deal with basic fears.

An interviewis a necessary procedure, part of the business process and a source of stress for many people, especially if it is conducted in a foreign language.

You can often hear: "I was nervous and talked a lot of nonsense", "I forgot some simple words because of anxiety", etc.

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