 47-230 Kędzierzyn-Koźle, J.V. Eichendorffa  2
47-230 Kędzierzyn-Koźle, J.V. Eichendorffa  2 
                        									
									 694 026 865
694 026 865 www.arkos.pl
www.arkos.pl
									 Bran�e:
										An error occured in:  Query: 
				SELECT ic.cat_id as idkategoria, 
					   cat_name as kategoria, 
					   cat_seo as cat_seo,
					   
					   ic.subcat_id as idpodkategoria, 
					   subcat.subcat_name as podkategoria, 
					   subcat.subcat_seo as subcat_seo,
					   
					   speccat.speccat_id as idspeckategoria, 
					   speccat.speccat_name as speckategoria, 
					   speccat.speccat_seo as speccat_seo, 
					   
					   
					   ics.cs_id 
				FROM ip_card_cs ics, 
					 ip_category cat, 
					 ip_subcategory subcat, 
					 ip_cs ic
				LEFT JOIN 
					 ip_speccategory speccat  ON (ic.speccat_id=speccat.speccat_id )
				WHERE 
					ics.cs_id=ic.cs_id 
				AND ics.card_id=686307 
				AND ic.cat_id=cat.cat_id 
				AND ic.subcat_id=subcat.subcat_id 
				
				ORDER BY kategoria, podkategoria, speckategoria
 Bran�e:
										An error occured in:  Query: 
				SELECT ic.cat_id as idkategoria, 
					   cat_name as kategoria, 
					   cat_seo as cat_seo,
					   
					   ic.subcat_id as idpodkategoria, 
					   subcat.subcat_name as podkategoria, 
					   subcat.subcat_seo as subcat_seo,
					   
					   speccat.speccat_id as idspeckategoria, 
					   speccat.speccat_name as speckategoria, 
					   speccat.speccat_seo as speccat_seo, 
					   
					   
					   ics.cs_id 
				FROM ip_card_cs ics, 
					 ip_category cat, 
					 ip_subcategory subcat, 
					 ip_cs ic
				LEFT JOIN 
					 ip_speccategory speccat  ON (ic.speccat_id=speccat.speccat_id )
				WHERE 
					ics.cs_id=ic.cs_id 
				AND ics.card_id=686307 
				AND ic.cat_id=cat.cat_id 
				AND ic.subcat_id=subcat.subcat_id 
				
				ORDER BY kategoria, podkategoria, speckategoria
										 Zobacz wi�cej
 Zobacz wi�cej
									 bramy ogrodzeniowe śląsk,producent bram,ogrodzenia Kędzierzyn-Koźle,balustrady Wrocła... wi�cej »w,bramy przemysłowe opolskie
 bramy ogrodzeniowe śląsk,producent bram,ogrodzenia Kędzierzyn-Koźle,balustrady Wrocła... wi�cej »w,bramy przemysłowe opolskie
									 00-716 Warszawa,  Bartycka  175/2
00-716 Warszawa,  Bartycka  175/2  
                        									
									 +48 22 423 31 31
+48 22 423 31 31 www.bramet.pl
www.bramet.pl
									 Bran�e:
										An error occured in:  Query: 
				SELECT ic.cat_id as idkategoria, 
					   cat_name as kategoria, 
					   cat_seo as cat_seo,
					   
					   ic.subcat_id as idpodkategoria, 
					   subcat.subcat_name as podkategoria, 
					   subcat.subcat_seo as subcat_seo,
					   
					   speccat.speccat_id as idspeckategoria, 
					   speccat.speccat_name as speckategoria, 
					   speccat.speccat_seo as speccat_seo, 
					   
					   
					   ics.cs_id 
				FROM ip_card_cs ics, 
					 ip_category cat, 
					 ip_subcategory subcat, 
					 ip_cs ic
				LEFT JOIN 
					 ip_speccategory speccat  ON (ic.speccat_id=speccat.speccat_id )
				WHERE 
					ics.cs_id=ic.cs_id 
				AND ics.card_id=41423 
				AND ic.cat_id=cat.cat_id 
				AND ic.subcat_id=subcat.subcat_id 
				
				ORDER BY kategoria, podkategoria, speckategoria
 Bran�e:
										An error occured in:  Query: 
				SELECT ic.cat_id as idkategoria, 
					   cat_name as kategoria, 
					   cat_seo as cat_seo,
					   
					   ic.subcat_id as idpodkategoria, 
					   subcat.subcat_name as podkategoria, 
					   subcat.subcat_seo as subcat_seo,
					   
					   speccat.speccat_id as idspeckategoria, 
					   speccat.speccat_name as speckategoria, 
					   speccat.speccat_seo as speccat_seo, 
					   
					   
					   ics.cs_id 
				FROM ip_card_cs ics, 
					 ip_category cat, 
					 ip_subcategory subcat, 
					 ip_cs ic
				LEFT JOIN 
					 ip_speccategory speccat  ON (ic.speccat_id=speccat.speccat_id )
				WHERE 
					ics.cs_id=ic.cs_id 
				AND ics.card_id=41423 
				AND ic.cat_id=cat.cat_id 
				AND ic.subcat_id=subcat.subcat_id 
				
				ORDER BY kategoria, podkategoria, speckategoria
										 Zobacz wi�cej
 Zobacz wi�cej
									 BRAMET Autoryzowany Dystrybutor produktów Firm Wiśniowski Nice bramy garażowe automatyk... wi�cej »a bram ogrodzenia Warszawa garażowe przemysłowe ogrodzeniowe
 BRAMET Autoryzowany Dystrybutor produktów Firm Wiśniowski Nice bramy garażowe automatyk... wi�cej »a bram ogrodzenia Warszawa garażowe przemysłowe ogrodzeniowe
									 32-800 Brzesko, Solskiego 14A
32-800 Brzesko, Solskiego 14A 
                        									
									 +48 531 221 248
+48 531 221 248 www.oknodem.eu
www.oknodem.eu
									 Bran�e:
										An error occured in:  Query: 
				SELECT ic.cat_id as idkategoria, 
					   cat_name as kategoria, 
					   cat_seo as cat_seo,
					   
					   ic.subcat_id as idpodkategoria, 
					   subcat.subcat_name as podkategoria, 
					   subcat.subcat_seo as subcat_seo,
					   
					   speccat.speccat_id as idspeckategoria, 
					   speccat.speccat_name as speckategoria, 
					   speccat.speccat_seo as speccat_seo, 
					   
					   
					   ics.cs_id 
				FROM ip_card_cs ics, 
					 ip_category cat, 
					 ip_subcategory subcat, 
					 ip_cs ic
				LEFT JOIN 
					 ip_speccategory speccat  ON (ic.speccat_id=speccat.speccat_id )
				WHERE 
					ics.cs_id=ic.cs_id 
				AND ics.card_id=689464 
				AND ic.cat_id=cat.cat_id 
				AND ic.subcat_id=subcat.subcat_id 
				
				ORDER BY kategoria, podkategoria, speckategoria
 Bran�e:
										An error occured in:  Query: 
				SELECT ic.cat_id as idkategoria, 
					   cat_name as kategoria, 
					   cat_seo as cat_seo,
					   
					   ic.subcat_id as idpodkategoria, 
					   subcat.subcat_name as podkategoria, 
					   subcat.subcat_seo as subcat_seo,
					   
					   speccat.speccat_id as idspeckategoria, 
					   speccat.speccat_name as speckategoria, 
					   speccat.speccat_seo as speccat_seo, 
					   
					   
					   ics.cs_id 
				FROM ip_card_cs ics, 
					 ip_category cat, 
					 ip_subcategory subcat, 
					 ip_cs ic
				LEFT JOIN 
					 ip_speccategory speccat  ON (ic.speccat_id=speccat.speccat_id )
				WHERE 
					ics.cs_id=ic.cs_id 
				AND ics.card_id=689464 
				AND ic.cat_id=cat.cat_id 
				AND ic.subcat_id=subcat.subcat_id 
				
				ORDER BY kategoria, podkategoria, speckategoria
										 Zobacz wi�cej
 Zobacz wi�cej
									 okna, drzwi, bramy garażowe, stolarka okienna, stolarka PCV... wi�cej »
 okna, drzwi, bramy garażowe, stolarka okienna, stolarka PCV... wi�cej »
									 34-623 Szczyrzyc, Szczyrzyć 115
34-623 Szczyrzyc, Szczyrzyć 115 
                        									
									 +48 18 332 00 18
+48 18 332 00 18 www.producentgarazy.pl
www.producentgarazy.pl
									 Bran�e:
										An error occured in:  Query: 
				SELECT ic.cat_id as idkategoria, 
					   cat_name as kategoria, 
					   cat_seo as cat_seo,
					   
					   ic.subcat_id as idpodkategoria, 
					   subcat.subcat_name as podkategoria, 
					   subcat.subcat_seo as subcat_seo,
					   
					   speccat.speccat_id as idspeckategoria, 
					   speccat.speccat_name as speckategoria, 
					   speccat.speccat_seo as speccat_seo, 
					   
					   
					   ics.cs_id 
				FROM ip_card_cs ics, 
					 ip_category cat, 
					 ip_subcategory subcat, 
					 ip_cs ic
				LEFT JOIN 
					 ip_speccategory speccat  ON (ic.speccat_id=speccat.speccat_id )
				WHERE 
					ics.cs_id=ic.cs_id 
				AND ics.card_id=41758 
				AND ic.cat_id=cat.cat_id 
				AND ic.subcat_id=subcat.subcat_id 
				
				ORDER BY kategoria, podkategoria, speckategoria
 Bran�e:
										An error occured in:  Query: 
				SELECT ic.cat_id as idkategoria, 
					   cat_name as kategoria, 
					   cat_seo as cat_seo,
					   
					   ic.subcat_id as idpodkategoria, 
					   subcat.subcat_name as podkategoria, 
					   subcat.subcat_seo as subcat_seo,
					   
					   speccat.speccat_id as idspeckategoria, 
					   speccat.speccat_name as speckategoria, 
					   speccat.speccat_seo as speccat_seo, 
					   
					   
					   ics.cs_id 
				FROM ip_card_cs ics, 
					 ip_category cat, 
					 ip_subcategory subcat, 
					 ip_cs ic
				LEFT JOIN 
					 ip_speccategory speccat  ON (ic.speccat_id=speccat.speccat_id )
				WHERE 
					ics.cs_id=ic.cs_id 
				AND ics.card_id=41758 
				AND ic.cat_id=cat.cat_id 
				AND ic.subcat_id=subcat.subcat_id 
				
				ORDER BY kategoria, podkategoria, speckategoria
										 Zobacz wi�cej
 Zobacz wi�cej
									 producent garaży, garaże blaszane, wojstal, blaszaki, producent garaży blaszanych, gara... wi�cej »ze blaszane, garaże blaszane małopolska, , ,
 producent garaży, garaże blaszane, wojstal, blaszaki, producent garaży blaszanych, gara... wi�cej »ze blaszane, garaże blaszane małopolska, , , 
									 62-860 Opatówek,  Helleny  6
62-860 Opatówek,  Helleny  6 
                        									
									 +48 62 761 80 07
+48 62 761 80 07 www.agromechanika.pl
www.agromechanika.pl
									 Bran�e:
										An error occured in:  Query: 
				SELECT ic.cat_id as idkategoria, 
					   cat_name as kategoria, 
					   cat_seo as cat_seo,
					   
					   ic.subcat_id as idpodkategoria, 
					   subcat.subcat_name as podkategoria, 
					   subcat.subcat_seo as subcat_seo,
					   
					   speccat.speccat_id as idspeckategoria, 
					   speccat.speccat_name as speckategoria, 
					   speccat.speccat_seo as speccat_seo, 
					   
					   
					   ics.cs_id 
				FROM ip_card_cs ics, 
					 ip_category cat, 
					 ip_subcategory subcat, 
					 ip_cs ic
				LEFT JOIN 
					 ip_speccategory speccat  ON (ic.speccat_id=speccat.speccat_id )
				WHERE 
					ics.cs_id=ic.cs_id 
				AND ics.card_id=40321 
				AND ic.cat_id=cat.cat_id 
				AND ic.subcat_id=subcat.subcat_id 
				
				ORDER BY kategoria, podkategoria, speckategoria
 Bran�e:
										An error occured in:  Query: 
				SELECT ic.cat_id as idkategoria, 
					   cat_name as kategoria, 
					   cat_seo as cat_seo,
					   
					   ic.subcat_id as idpodkategoria, 
					   subcat.subcat_name as podkategoria, 
					   subcat.subcat_seo as subcat_seo,
					   
					   speccat.speccat_id as idspeckategoria, 
					   speccat.speccat_name as speckategoria, 
					   speccat.speccat_seo as speccat_seo, 
					   
					   
					   ics.cs_id 
				FROM ip_card_cs ics, 
					 ip_category cat, 
					 ip_subcategory subcat, 
					 ip_cs ic
				LEFT JOIN 
					 ip_speccategory speccat  ON (ic.speccat_id=speccat.speccat_id )
				WHERE 
					ics.cs_id=ic.cs_id 
				AND ics.card_id=40321 
				AND ic.cat_id=cat.cat_id 
				AND ic.subcat_id=subcat.subcat_id 
				
				ORDER BY kategoria, podkategoria, speckategoria
										 Zobacz wi�cej
 Zobacz wi�cej
									 AGROMECHANIKA akcesoria bramowe automatyka do bram bramy garażowe bramy wjazdowe i ogrodz... wi�cej »enia garaże skręcane maszyny rolnicze Kalisz Opatówek wielkopolska
 AGROMECHANIKA akcesoria bramowe automatyka do bram bramy garażowe bramy wjazdowe i ogrodz... wi�cej »enia garaże skręcane maszyny rolnicze Kalisz Opatówek wielkopolska
									 62-800 Kalisz, Częstochowska 77
62-800 Kalisz, Częstochowska 77 
                        									
									 +48 502 101 073
+48 502 101 073 www.qualum.pl
www.qualum.pl
									 Bran�e:
										An error occured in:  Query: 
				SELECT ic.cat_id as idkategoria, 
					   cat_name as kategoria, 
					   cat_seo as cat_seo,
					   
					   ic.subcat_id as idpodkategoria, 
					   subcat.subcat_name as podkategoria, 
					   subcat.subcat_seo as subcat_seo,
					   
					   speccat.speccat_id as idspeckategoria, 
					   speccat.speccat_name as speckategoria, 
					   speccat.speccat_seo as speccat_seo, 
					   
					   
					   ics.cs_id 
				FROM ip_card_cs ics, 
					 ip_category cat, 
					 ip_subcategory subcat, 
					 ip_cs ic
				LEFT JOIN 
					 ip_speccategory speccat  ON (ic.speccat_id=speccat.speccat_id )
				WHERE 
					ics.cs_id=ic.cs_id 
				AND ics.card_id=689603 
				AND ic.cat_id=cat.cat_id 
				AND ic.subcat_id=subcat.subcat_id 
				
				ORDER BY kategoria, podkategoria, speckategoria
 Bran�e:
										An error occured in:  Query: 
				SELECT ic.cat_id as idkategoria, 
					   cat_name as kategoria, 
					   cat_seo as cat_seo,
					   
					   ic.subcat_id as idpodkategoria, 
					   subcat.subcat_name as podkategoria, 
					   subcat.subcat_seo as subcat_seo,
					   
					   speccat.speccat_id as idspeckategoria, 
					   speccat.speccat_name as speckategoria, 
					   speccat.speccat_seo as speccat_seo, 
					   
					   
					   ics.cs_id 
				FROM ip_card_cs ics, 
					 ip_category cat, 
					 ip_subcategory subcat, 
					 ip_cs ic
				LEFT JOIN 
					 ip_speccategory speccat  ON (ic.speccat_id=speccat.speccat_id )
				WHERE 
					ics.cs_id=ic.cs_id 
				AND ics.card_id=689603 
				AND ic.cat_id=cat.cat_id 
				AND ic.subcat_id=subcat.subcat_id 
				
				ORDER BY kategoria, podkategoria, speckategoria
										 Zobacz wi�cej
 Zobacz wi�cej
									 bramy, producent bram, bramy harmonijkowe, ogrodzenia, nowoczesne bramy, bramy aluminiowe... wi�cej »
 bramy, producent bram, bramy harmonijkowe, ogrodzenia, nowoczesne bramy, bramy aluminiowe... wi�cej »
									 33-350 Piwniczna-Zdrój, Krakowska 24
33-350 Piwniczna-Zdrój, Krakowska 24 
                        									
									 184778448
184778448 www.zemp.pl
www.zemp.pl
									 Bran�e:
										An error occured in:  Query: 
				SELECT ic.cat_id as idkategoria, 
					   cat_name as kategoria, 
					   cat_seo as cat_seo,
					   
					   ic.subcat_id as idpodkategoria, 
					   subcat.subcat_name as podkategoria, 
					   subcat.subcat_seo as subcat_seo,
					   
					   speccat.speccat_id as idspeckategoria, 
					   speccat.speccat_name as speckategoria, 
					   speccat.speccat_seo as speccat_seo, 
					   
					   
					   ics.cs_id 
				FROM ip_card_cs ics, 
					 ip_category cat, 
					 ip_subcategory subcat, 
					 ip_cs ic
				LEFT JOIN 
					 ip_speccategory speccat  ON (ic.speccat_id=speccat.speccat_id )
				WHERE 
					ics.cs_id=ic.cs_id 
				AND ics.card_id=689035 
				AND ic.cat_id=cat.cat_id 
				AND ic.subcat_id=subcat.subcat_id 
				
				ORDER BY kategoria, podkategoria, speckategoria
 Bran�e:
										An error occured in:  Query: 
				SELECT ic.cat_id as idkategoria, 
					   cat_name as kategoria, 
					   cat_seo as cat_seo,
					   
					   ic.subcat_id as idpodkategoria, 
					   subcat.subcat_name as podkategoria, 
					   subcat.subcat_seo as subcat_seo,
					   
					   speccat.speccat_id as idspeckategoria, 
					   speccat.speccat_name as speckategoria, 
					   speccat.speccat_seo as speccat_seo, 
					   
					   
					   ics.cs_id 
				FROM ip_card_cs ics, 
					 ip_category cat, 
					 ip_subcategory subcat, 
					 ip_cs ic
				LEFT JOIN 
					 ip_speccategory speccat  ON (ic.speccat_id=speccat.speccat_id )
				WHERE 
					ics.cs_id=ic.cs_id 
				AND ics.card_id=689035 
				AND ic.cat_id=cat.cat_id 
				AND ic.subcat_id=subcat.subcat_id 
				
				ORDER BY kategoria, podkategoria, speckategoria
										 Zobacz wi�cej
 Zobacz wi�cej
									 zemp, żemp, okna pcv, drzwi, producent okien pcv, producent drzwi pcv... wi�cej »
 zemp, żemp, okna pcv, drzwi, producent okien pcv, producent drzwi pcv... wi�cej »
									 31-987 Kraków, Jeziorko 13
31-987 Kraków, Jeziorko 13 
                        									
									 506 256 814
506 256 814
									 Bran�e:
										An error occured in:  Query: 
				SELECT ic.cat_id as idkategoria, 
					   cat_name as kategoria, 
					   cat_seo as cat_seo,
					   
					   ic.subcat_id as idpodkategoria, 
					   subcat.subcat_name as podkategoria, 
					   subcat.subcat_seo as subcat_seo,
					   
					   speccat.speccat_id as idspeckategoria, 
					   speccat.speccat_name as speckategoria, 
					   speccat.speccat_seo as speccat_seo, 
					   
					   
					   ics.cs_id 
				FROM ip_card_cs ics, 
					 ip_category cat, 
					 ip_subcategory subcat, 
					 ip_cs ic
				LEFT JOIN 
					 ip_speccategory speccat  ON (ic.speccat_id=speccat.speccat_id )
				WHERE 
					ics.cs_id=ic.cs_id 
				AND ics.card_id=61054 
				AND ic.cat_id=cat.cat_id 
				AND ic.subcat_id=subcat.subcat_id 
				
				ORDER BY kategoria, podkategoria, speckategoria
 Bran�e:
										An error occured in:  Query: 
				SELECT ic.cat_id as idkategoria, 
					   cat_name as kategoria, 
					   cat_seo as cat_seo,
					   
					   ic.subcat_id as idpodkategoria, 
					   subcat.subcat_name as podkategoria, 
					   subcat.subcat_seo as subcat_seo,
					   
					   speccat.speccat_id as idspeckategoria, 
					   speccat.speccat_name as speckategoria, 
					   speccat.speccat_seo as speccat_seo, 
					   
					   
					   ics.cs_id 
				FROM ip_card_cs ics, 
					 ip_category cat, 
					 ip_subcategory subcat, 
					 ip_cs ic
				LEFT JOIN 
					 ip_speccategory speccat  ON (ic.speccat_id=speccat.speccat_id )
				WHERE 
					ics.cs_id=ic.cs_id 
				AND ics.card_id=61054 
				AND ic.cat_id=cat.cat_id 
				AND ic.subcat_id=subcat.subcat_id 
				
				ORDER BY kategoria, podkategoria, speckategoria
										 Zobacz wi�cej
 Zobacz wi�cej
									 75-244 Koszalin, Niepodległości 51/30
75-244 Koszalin, Niepodległości 51/30 
                        									
									 668 393 183
668 393 183
									 Bran�e:
										An error occured in:  Query: 
				SELECT ic.cat_id as idkategoria, 
					   cat_name as kategoria, 
					   cat_seo as cat_seo,
					   
					   ic.subcat_id as idpodkategoria, 
					   subcat.subcat_name as podkategoria, 
					   subcat.subcat_seo as subcat_seo,
					   
					   speccat.speccat_id as idspeckategoria, 
					   speccat.speccat_name as speckategoria, 
					   speccat.speccat_seo as speccat_seo, 
					   
					   
					   ics.cs_id 
				FROM ip_card_cs ics, 
					 ip_category cat, 
					 ip_subcategory subcat, 
					 ip_cs ic
				LEFT JOIN 
					 ip_speccategory speccat  ON (ic.speccat_id=speccat.speccat_id )
				WHERE 
					ics.cs_id=ic.cs_id 
				AND ics.card_id=61057 
				AND ic.cat_id=cat.cat_id 
				AND ic.subcat_id=subcat.subcat_id 
				
				ORDER BY kategoria, podkategoria, speckategoria
 Bran�e:
										An error occured in:  Query: 
				SELECT ic.cat_id as idkategoria, 
					   cat_name as kategoria, 
					   cat_seo as cat_seo,
					   
					   ic.subcat_id as idpodkategoria, 
					   subcat.subcat_name as podkategoria, 
					   subcat.subcat_seo as subcat_seo,
					   
					   speccat.speccat_id as idspeckategoria, 
					   speccat.speccat_name as speckategoria, 
					   speccat.speccat_seo as speccat_seo, 
					   
					   
					   ics.cs_id 
				FROM ip_card_cs ics, 
					 ip_category cat, 
					 ip_subcategory subcat, 
					 ip_cs ic
				LEFT JOIN 
					 ip_speccategory speccat  ON (ic.speccat_id=speccat.speccat_id )
				WHERE 
					ics.cs_id=ic.cs_id 
				AND ics.card_id=61057 
				AND ic.cat_id=cat.cat_id 
				AND ic.subcat_id=subcat.subcat_id 
				
				ORDER BY kategoria, podkategoria, speckategoria
										 Zobacz wi�cej
 Zobacz wi�cej
									 66-400 Gorzów Wielkopolski, Walczaka 94
66-400 Gorzów Wielkopolski, Walczaka 94 
                        									
									 95 724 09 31
95 724 09 31
									 Bran�e:
										An error occured in:  Query: 
				SELECT ic.cat_id as idkategoria, 
					   cat_name as kategoria, 
					   cat_seo as cat_seo,
					   
					   ic.subcat_id as idpodkategoria, 
					   subcat.subcat_name as podkategoria, 
					   subcat.subcat_seo as subcat_seo,
					   
					   speccat.speccat_id as idspeckategoria, 
					   speccat.speccat_name as speckategoria, 
					   speccat.speccat_seo as speccat_seo, 
					   
					   
					   ics.cs_id 
				FROM ip_card_cs ics, 
					 ip_category cat, 
					 ip_subcategory subcat, 
					 ip_cs ic
				LEFT JOIN 
					 ip_speccategory speccat  ON (ic.speccat_id=speccat.speccat_id )
				WHERE 
					ics.cs_id=ic.cs_id 
				AND ics.card_id=689643 
				AND ic.cat_id=cat.cat_id 
				AND ic.subcat_id=subcat.subcat_id 
				
				ORDER BY kategoria, podkategoria, speckategoria
 Bran�e:
										An error occured in:  Query: 
				SELECT ic.cat_id as idkategoria, 
					   cat_name as kategoria, 
					   cat_seo as cat_seo,
					   
					   ic.subcat_id as idpodkategoria, 
					   subcat.subcat_name as podkategoria, 
					   subcat.subcat_seo as subcat_seo,
					   
					   speccat.speccat_id as idspeckategoria, 
					   speccat.speccat_name as speckategoria, 
					   speccat.speccat_seo as speccat_seo, 
					   
					   
					   ics.cs_id 
				FROM ip_card_cs ics, 
					 ip_category cat, 
					 ip_subcategory subcat, 
					 ip_cs ic
				LEFT JOIN 
					 ip_speccategory speccat  ON (ic.speccat_id=speccat.speccat_id )
				WHERE 
					ics.cs_id=ic.cs_id 
				AND ics.card_id=689643 
				AND ic.cat_id=cat.cat_id 
				AND ic.subcat_id=subcat.subcat_id 
				
				ORDER BY kategoria, podkategoria, speckategoria
										 Zobacz wi�cej
 Zobacz wi�cej