For Seafarers
For Employers
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.
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 < 'Marine Technical College's Shore Based Training Center' 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 's Shore Based Training Center' AND st.approved='1' AND u.approved='1' AND st...' at line 7