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 196 AND 210
Zobrazeno 196-210 z celkem 1617 kontaktů
AUTOCENTRUM PRAHA-UHŘÍNĚVES s.r.o.
Přátelství 551/4,
Praha
AUTOCENTRUM SLIVENEC, s.r.o.
K Lochkovu 3,
Praha
AUTOCENTRUM STEHLÍK s.r.o.
Nádražní 10,
Praha 5
AUTOCOLOR s.r.o.
Podohradská 1720/21,
Praha 515
AUTOCOMSOFT s.r.o.
U kolejí 51,
Praha
AUTOCONSULT spol. s r.o.
28. pluku 524/25,
Praha 10
AUTODENGLER s.r.o.
K Ládví 907/6a,
Praha
AUTODENT PRAHA
U laboratoře 552/18,
Praha 616
AUTODÍLNA BURIAN
Poděbradská 366/20b,
Praha
AUTODÍLNA MAIER s.r.o.
Podbělohorská 190/73,
Praha 5
AUTODÍLNA MARTÍNEK
Pod Stárkou 103/12,
Praha 4
AUTODÍLNA RŮŽIČKA
Travná 472,
Praha
AUTODÍLY BĚHÁLEK s.r.o.
Tiskařská 599/12,
Praha
AUTODÍLY ČERNÝ
Makovského 1392/2b,
Praha
AUTODÍLY DUFEK s.r.o.
K Zelenči 2901/12,
Praha