For Seafarers
For Employers
For Cadets. Preparing for a Job Interview in English.
The spoken language requirements for a cadet are usually much higher than, for example, for an ordinary seaman or motorman.Despite the fact that you have the same work document and their salary is higher. The thing is that the company considers cadets as potential officers for its ships.
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.
Query SELECT
st.id, st.chpu
FROM
seaman_trainers st
LEFT JOIN seaman_trainers_tariffs stt ON stt.id = st.tariff_id
LEFT JOIN users u ON u.id=st.user_id
WHERE st.name_l2 < 'Priazov Maritime Center (Berdyans'k)' AND st.approved='1' AND u.approved='1' AND st.tariff_id IS NOT NULL ORDER BY stt.weight, st.name_l2 LIMIT 1 :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 'k)' AND st.approved='1' AND u.approved='1' AND st.tariff_id IS NOT NULL OR...' at line 7