Vacancy Chief Engineer on Container
CV Vacancies UA RU
 - 
 - 
 - 
 - 


 - 

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.

Where to Update Maritime Certificates in Europe? Maritime Training for Seafarers – Part 4: Norway, Italy, Spain

A career at sea is impossible without continuous training and certification. Friends, we continue our series of articles on training centers in Europe where sailors can undergo training and obtain the necessary certificates to work at sea.


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?

How to Live After Finishing Your Seafaring? It is Possible to be Successful on the Shore

Changing a profession is a serious step that requires courage and determination. Sometimes it’s difficult to understand yourself: what do I want, how to realize it, maybe I’m wrong and will regret it?




Query SELECT v.id, UNIX_TIMESTAMP(v.posted_date) as posted_date, cast(contract_duration as unsigned) as contract_duration, CASE WHEN vtop.toDate >= CURRENT_DATE() THEN 1 ELSE 0 END AS is_top FROM vacancy v LEFT JOIN agency a ON a.user_id=v.agency_id LEFT JOIN position p ON p.id=v.position LEFT JOIN vessel_type vt ON vt.id=v.vessel_type LEFT JOIN fleets f ON f.id=v.fleet_id LEFT JOIN vacancy_top vtop ON vtop.vacancy_id=v.id WHERE 1=1 AND onboard_date>=CURRENT_DATE() AND a.approved='1' AND is_hide = 0 AND (vtop.toDate >= CURRENT_DATE() OR vtop.toDate IS NULL) ORDER BY (vtop.toDate >= CURRENT_DATE()) DESC, -- 1. топовые первыми CASE WHEN vtop.toDate < CURRENT_DATE() OR vtop.toDate IS NULL THEN CAST(contract_duration AS UNSIGNED) ASC END: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 'ASC END' at line 19