SELECT * FROM (SELECT *, ROW_NUMBER() OVER (ORDER BY tarif DESC, name ASC) AS RowNum FROM companies WHERE (category IN (1848,1863,2775,1860,1867,2776,2777,2778,2779,2780,2781,2782,2783,2784,2785,2786,2787,2790,2791,2788,2789,2799) OR categories LIKE '%,1848,%' OR (categories LIKE '%,1848,%' OR categories LIKE '%,1863,%' OR categories LIKE '%,2775,%' OR categories LIKE '%,1860,%' OR categories LIKE '%,1867,%' OR categories LIKE '%,2776,%' OR categories LIKE '%,2777,%' OR categories LIKE '%,2778,%' OR categories LIKE '%,2779,%' OR categories LIKE '%,2780,%' OR categories LIKE '%,2781,%' OR categories LIKE '%,2782,%' OR categories LIKE '%,2783,%' OR categories LIKE '%,2784,%' OR categories LIKE '%,2785,%' OR categories LIKE '%,2786,%' OR categories LIKE '%,2787,%' OR categories LIKE '%,2790,%' OR categories LIKE '%,2791,%' OR categories LIKE '%,2788,%' OR categories LIKE '%,2789,%' OR categories LIKE '%,2799,%')) AND admin_lock=0 AND deleted<>1 AND host='praha') AS Results WHERE RowNum BETWEEN 76 AND 90
Zobrazeno 76-90 z celkem 2674 kontaktů
AIM GROUP PRAGUE s.r.o.
Panská 890/7,
Praha
AIR CONTROL s.r.o.
Oldřichova 247/5,
Praha
AIR PRAGUE s.r.o.
Lohniského 848/17,
Praha
AIR SUPPORT s.r.o.
Roháčova 145/14,
Praha
AIR TRANSPORT SOLUTIONS spol. s r.o.
K letišti 1049/57,
Praha
AIR WORLD SERVICES a.s.
Milady Horákové 382/75,
Praha
AIRCAP s.r.o.
Šífařská 534/7,
Praha
AIRGYM s.r.o.
K zahrádkám 1028/51,
Praha
AIRKISS, spol. s r.o.
Na strži 1202/45,
Praha
AIRSOFT PRAHA, s.r.o.
Upravená 253/5a,
Praha
AIRSTREAM a.s.
K letišti 1073/25,
Praha
AIX s.r.o.
Lukavecká 1732,
Praha
AJURVÉDA KUTI
Bártlova 47/27,
Praha
AKADEMIE AEROBIKU PRAHA
Kukelská 904/3,
Praha
AKADEMIE VĚDOMÍ s.r.o.
Dřevná 382/2,
Praha