Vacancy Chief Engineer on Feeder Container

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.

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.

TOP European Maritime Training Centers. Part 2: Latvia, Romania, Croatia, Cyprus

"Crewing Guide" has previously covered training centers with branches both in Ukraine and worldwide, and has also focused on maritime training centers in Poland. In this article, we've compiled training centers from Latvia, Romania, Croatia, and Cyprus for you.

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 onboard_date 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