SELECT * FROM (SELECT *, ROW_NUMBER() OVER (ORDER BY tarif DESC, name ASC) AS RowNum FROM companies WHERE (category IN (4,21,2204,27,29,31,36,33,35,42,40,41,43,2550,51,53,2723,2758,2759,2760,3,2258,5,6,7,8,12,14,16,17,44,2004) OR categories LIKE '%,4,%' OR (categories LIKE '%,4,%' OR categories LIKE '%,21,%' OR categories LIKE '%,2204,%' OR categories LIKE '%,27,%' OR categories LIKE '%,29,%' OR categories LIKE '%,31,%' OR categories LIKE '%,36,%' OR categories LIKE '%,33,%' OR categories LIKE '%,35,%' OR categories LIKE '%,42,%' OR categories LIKE '%,40,%' OR categories LIKE '%,41,%' OR categories LIKE '%,43,%' OR categories LIKE '%,2550,%' OR categories LIKE '%,51,%' OR categories LIKE '%,53,%' OR categories LIKE '%,2723,%' OR categories LIKE '%,2758,%' OR categories LIKE '%,2759,%' OR categories LIKE '%,2760,%' OR categories LIKE '%,3,%' OR categories LIKE '%,2258,%' OR categories LIKE '%,5,%' OR categories LIKE '%,6,%' OR categories LIKE '%,7,%' OR categories LIKE '%,8,%' OR categories LIKE '%,12,%' OR categories LIKE '%,14,%' OR categories LIKE '%,16,%' OR categories LIKE '%,17,%' OR categories LIKE '%,44,%' OR categories LIKE '%,2004,%')) AND admin_lock=0 AND deleted<>1 AND host='praha') AS Results WHERE RowNum BETWEEN 211 AND 225
Zobrazeno 211-225 z celkem 1617 kontaktů
AUTODÍLY FK
Přistoupimská 395/10,
Praha
AUTODÍLY INTEGRAM s.r.o.
Nuselská 375/98,
Praha
AUTODOPRAVA MALEČEK
Pod větrolamem 569/1,
Praha
AUTODRAFT ČR s.r.o.
Pod soutratím 1559/5,
Praha
AUTODRUŽSTVO PODBABSKÁ
Pod Paťankou 217/1,
Praha 6
AUTODRUŽSTVO PRAHA
Spojovací 783/41,
Praha 9
AUTOELEKTRIKA NA BĚLIDLE
V korytech 1537/10,
Praha
AUTOELEKTRIKA PŘESLIČKA
Mezivrší 974/21,
Praha
AUTOELEKTRIKA TORN
Výpadová 2311,
Praha
AutoESA a.s.
Průmyslová 1306/7,
Praha 10
AUTO-FAJT
Koněvova 53/51,
Praha
AUTOFINANCE CONSUMER s.r.o.
Náchodská 2500/250,
Praha
AUTOFLEX, s.r.o.
Bělohorská 166/166,
Praha
AUTOFOLIA
Bubenská 1536/43,
Praha
AUTOFÓLIE LLUMAR
V listnáčích 24,
Praha