Nexxon - Gamă variată de anvelope
| Comenzi web: 0760 780 538   /   0732 950 671 |Parteneri: 0267 364 170
Comenzi web:
0760 780 538   /   0732 950 671
Parteneri: 0267 364 170
SELECT DISTINCT productattributeid, value FROM (SELECT prodfilt.productid, productattributevalues.productattributeid, productattributevalues.value 
		FROM (
				SELECT productid FROM products WHERE charismacategoryid IN (51824, 51830, 51838, 51825, 51831, 51839, 51826, 51832, 51840, 51836, 51844, 51757, 51779, 156775, 156768, 156777, 156757, 156760, 156761, 156769) AND stock > 0
			) AS prodfilt
		INNER JOIN productattributevalues ON prodfilt.productid = productattributevalues.productid WHERE productattributevalues.productattributeid = 183
		) AS productlat;
SELECT DISTINCT productattributeid, value FROM (SELECT prodfilt.productid, productattributevalues.productattributeid, productattributevalues.value 
		FROM (
				SELECT productid FROM products WHERE charismacategoryid IN (51824, 51830, 51838, 51825, 51831, 51839, 51826, 51832, 51840, 51836, 51844, 51757, 51779, 156775, 156768, 156777, 156757, 156760, 156761, 156769) AND stock > 0
			) AS prodfilt
		INNER JOIN productattributevalues ON prodfilt.productid = productattributevalues.productid WHERE productattributevalues.productattributeid = 217
		) AS productlat;
SELECT DISTINCT productattributeid, value FROM (SELECT prodfilt.productid, productattributevalues.productattributeid, productattributevalues.value 
		FROM (
				SELECT productid FROM products WHERE charismacategoryid IN (51824, 51830, 51838, 51825, 51831, 51839, 51826, 51832, 51840, 51836, 51844, 51757, 51779, 156775, 156768, 156777, 156757, 156760, 156761, 156769) AND stock > 0
			) AS prodfilt
		INNER JOIN productattributevalues ON prodfilt.productid = productattributevalues.productid WHERE productattributevalues.productattributeid = 218
		) AS productlat;
SELECT DISTINCT productattributeid, value FROM (SELECT prodfilt.productid, productattributevalues.productattributeid, productattributevalues.value 
		FROM (
				SELECT productid FROM products WHERE charismacategoryid IN (51824, 51830, 51838, 51825, 51831, 51839, 51826, 51832, 51840, 51836, 51844, 51757, 51779, 156775, 156768, 156777, 156757, 156760, 156761, 156769) AND stock > 0
			) AS prodfilt
		INNER JOIN productattributevalues ON prodfilt.productid = productattributevalues.productid WHERE productattributevalues.productattributeid = 225
		) AS productlat;
SELECT DISTINCT productattributeid, value FROM (SELECT prodfilt.productid, productattributevalues.productattributeid, productattributevalues.value 
		FROM (
				SELECT productid FROM products WHERE charismacategoryid IN (51824, 51830, 51838, 51825, 51831, 51839, 51826, 51832, 51840, 51836, 51844, 51757, 51779, 156775, 156768, 156777, 156757, 156760, 156761, 156769) AND stock > 0
			) AS prodfilt
		INNER JOIN productattributevalues ON prodfilt.productid = productattributevalues.productid WHERE productattributevalues.productattributeid = 168
		) AS productlat;
SELECT DISTINCT productattributeid, value FROM (SELECT prodfilt.productid, productattributevalues.productattributeid, productattributevalues.value 
		FROM (
				SELECT productid FROM products WHERE charismacategoryid IN (51824, 51830, 51838, 51825, 51831, 51839, 51826, 51832, 51840, 51836, 51844, 51757, 51779, 156775, 156768, 156777, 156757, 156760, 156761, 156769) AND stock > 0
			) AS prodfilt
		INNER JOIN productattributevalues ON prodfilt.productid = productattributevalues.productid WHERE productattributevalues.productattributeid = 167
		) AS productlat;
SELECT DISTINCT productattributeid, value FROM (SELECT prodfilt.productid, productattributevalues.productattributeid, productattributevalues.value 
		FROM (
				SELECT productid FROM products WHERE charismacategoryid IN (51824, 51830, 51838, 51825, 51831, 51839, 51826, 51832, 51840, 51836, 51844, 51757, 51779, 156775, 156768, 156777, 156757, 156760, 156761, 156769) AND stock > 0
			) AS prodfilt
		INNER JOIN productattributevalues ON prodfilt.productid = productattributevalues.productid WHERE productattributevalues.productattributeid = 172
		) AS productlat;
SELECT DISTINCT productattributeid, value FROM (SELECT prodfilt.productid, productattributevalues.productattributeid, productattributevalues.value 
		FROM (
				SELECT productid FROM products WHERE charismacategoryid IN (51824, 51830, 51838, 51825, 51831, 51839, 51826, 51832, 51840, 51836, 51844, 51757, 51779, 156775, 156768, 156777, 156757, 156760, 156761, 156769) AND stock > 0
			) AS prodfilt
		INNER JOIN productattributevalues ON prodfilt.productid = productattributevalues.productid WHERE productattributevalues.productattributeid = 220
		) AS productlat;
SELECT DISTINCT productattributeid, value FROM (SELECT prodfilt.productid, productattributevalues.productattributeid, productattributevalues.value 
		FROM (
				SELECT productid FROM products WHERE charismacategoryid IN (51824, 51830, 51838, 51825, 51831, 51839, 51826, 51832, 51840, 51836, 51844, 51757, 51779, 156775, 156768, 156777, 156757, 156760, 156761, 156769) AND stock > 0
			) AS prodfilt
		INNER JOIN productattributevalues ON prodfilt.productid = productattributevalues.productid WHERE productattributevalues.productattributeid = 232
		) AS productlat;
SELECT DISTINCT productattributeid, value FROM (SELECT prodfilt.productid, productattributevalues.productattributeid, productattributevalues.value 
		FROM (
				SELECT productid FROM products WHERE charismacategoryid IN (51824, 51830, 51838, 51825, 51831, 51839, 51826, 51832, 51840, 51836, 51844, 51757, 51779, 156775, 156768, 156777, 156757, 156760, 156761, 156769) AND stock > 0
			) AS prodfilt
		INNER JOIN productattributevalues ON prodfilt.productid = productattributevalues.productid WHERE productattributevalues.productattributeid = 233
		) AS productlat;
SELECT DISTINCT productattributeid, value FROM (SELECT prodfilt.productid, productattributevalues.productattributeid, productattributevalues.value 
		FROM (
				SELECT productid FROM products WHERE charismacategoryid IN (51824, 51830, 51838, 51825, 51831, 51839, 51826, 51832, 51840, 51836, 51844, 51757, 51779, 156775, 156768, 156777, 156757, 156760, 156761, 156769) AND stock > 0
			) AS prodfilt
		INNER JOIN productattributevalues ON prodfilt.productid = productattributevalues.productid WHERE productattributevalues.productattributeid = 234
		) AS productlat;
SELECT DISTINCT productattributeid, value FROM (SELECT prodfilt.productid, productattributevalues.productattributeid, productattributevalues.value 
		FROM (
				SELECT productid FROM products WHERE charismacategoryid IN (51824, 51830, 51838, 51825, 51831, 51839, 51826, 51832, 51840, 51836, 51844, 51757, 51779, 156775, 156768, 156777, 156757, 156760, 156761, 156769) AND stock > 0
			) AS prodfilt
		INNER JOIN productattributevalues ON prodfilt.productid = productattributevalues.productid WHERE productattributevalues.productattributeid = 202
		) AS productlat;
SELECT DISTINCT productattributeid, value FROM (SELECT prodfilt.productid, productattributevalues.productattributeid, productattributevalues.value 
		FROM (
				SELECT productid FROM products WHERE charismacategoryid IN (51824, 51830, 51838, 51825, 51831, 51839, 51826, 51832, 51840, 51836, 51844, 51757, 51779, 156775, 156768, 156777, 156757, 156760, 156761, 156769) AND stock > 0
			) AS prodfilt
		INNER JOIN productattributevalues ON prodfilt.productid = productattributevalues.productid WHERE productattributevalues.productattributeid = 198
		) AS productlat;
SELECT DISTINCT productattributeid, value FROM (SELECT prodfilt.productid, productattributevalues.productattributeid, productattributevalues.value 
		FROM (
				SELECT productid FROM products WHERE charismacategoryid IN (51824, 51830, 51838, 51825, 51831, 51839, 51826, 51832, 51840, 51836, 51844, 51757, 51779, 156775, 156768, 156777, 156757, 156760, 156761, 156769) AND stock > 0
			) AS prodfilt
		INNER JOIN productattributevalues ON prodfilt.productid = productattributevalues.productid WHERE productattributevalues.productattributeid = 206
		) AS productlat;
SELECT DISTINCT productattributeid, value FROM (SELECT prodfilt.productid, productattributevalues.productattributeid, productattributevalues.value 
		FROM (
				SELECT productid FROM products WHERE charismacategoryid IN (51824, 51830, 51838, 51825, 51831, 51839, 51826, 51832, 51840, 51836, 51844, 51757, 51779, 156775, 156768, 156777, 156757, 156760, 156761, 156769) AND stock > 0
			) AS prodfilt
		INNER JOIN productattributevalues ON prodfilt.productid = productattributevalues.productid WHERE productattributevalues.productattributeid = 205
		) AS productlat;
SELECT DISTINCT productattributeid, value FROM (SELECT prodfilt.productid, productattributevalues.productattributeid, productattributevalues.value 
		FROM (
				SELECT productid FROM products WHERE charismacategoryid IN (51824, 51830, 51838, 51825, 51831, 51839, 51826, 51832, 51840, 51836, 51844, 51757, 51779, 156775, 156768, 156777, 156757, 156760, 156761, 156769) AND stock > 0
			) AS prodfilt
		INNER JOIN productattributevalues ON prodfilt.productid = productattributevalues.productid WHERE productattributevalues.productattributeid = 204
		) AS productlat;
SELECT DISTINCT productattributeid, value FROM (SELECT prodfilt.productid, productattributevalues.productattributeid, productattributevalues.value 
		FROM (
				SELECT productid FROM products WHERE charismacategoryid IN (51824, 51830, 51838, 51825, 51831, 51839, 51826, 51832, 51840, 51836, 51844, 51757, 51779, 156775, 156768, 156777, 156757, 156760, 156761, 156769) AND stock > 0
			) AS prodfilt
		INNER JOIN productattributevalues ON prodfilt.productid = productattributevalues.productid WHERE productattributevalues.productattributeid = 203
		) AS productlat;
SELECT DISTINCT productattributeid, value FROM (SELECT prodfilt.productid, productattributevalues.productattributeid, productattributevalues.value 
		FROM (
				SELECT productid FROM products WHERE charismacategoryid IN (51824, 51830, 51838, 51825, 51831, 51839, 51826, 51832, 51840, 51836, 51844, 51757, 51779, 156775, 156768, 156777, 156757, 156760, 156761, 156769) AND stock > 0
			) AS prodfilt
		INNER JOIN productattributevalues ON prodfilt.productid = productattributevalues.productid WHERE productattributevalues.productattributeid = 201
		) AS productlat;
SELECT DISTINCT productattributeid, value FROM (SELECT prodfilt.productid, productattributevalues.productattributeid, productattributevalues.value 
		FROM (
				SELECT productid FROM products WHERE charismacategoryid IN (51824, 51830, 51838, 51825, 51831, 51839, 51826, 51832, 51840, 51836, 51844, 51757, 51779, 156775, 156768, 156777, 156757, 156760, 156761, 156769) AND stock > 0
			) AS prodfilt
		INNER JOIN productattributevalues ON prodfilt.productid = productattributevalues.productid WHERE productattributevalues.productattributeid = 200
		) AS productlat;
SELECT DISTINCT productattributeid, value FROM (SELECT prodfilt.productid, productattributevalues.productattributeid, productattributevalues.value 
		FROM (
				SELECT productid FROM products WHERE charismacategoryid IN (51824, 51830, 51838, 51825, 51831, 51839, 51826, 51832, 51840, 51836, 51844, 51757, 51779, 156775, 156768, 156777, 156757, 156760, 156761, 156769) AND stock > 0
			) AS prodfilt
		INNER JOIN productattributevalues ON prodfilt.productid = productattributevalues.productid WHERE productattributevalues.productattributeid = 199
		) AS productlat;
SELECT DISTINCT productattributeid, value FROM (SELECT prodfilt.productid, productattributevalues.productattributeid, productattributevalues.value 
		FROM (
				SELECT productid FROM products WHERE charismacategoryid IN (51824, 51830, 51838, 51825, 51831, 51839, 51826, 51832, 51840, 51836, 51844, 51757, 51779, 156775, 156768, 156777, 156757, 156760, 156761, 156769) AND stock > 0
			) AS prodfilt
		INNER JOIN productattributevalues ON prodfilt.productid = productattributevalues.productid WHERE productattributevalues.productattributeid = 173
		) AS productlat;
Istoric de navigare

Garanția Calității

Noutăți

Anvelope

MĂRCI COMERCIALIZATE

   SOL SAL-PICTOGRAMA
Înscrie-te la newsletter-ul Info Nexxon și primești ghid-ul gratuit:
10 aspecte de verificat înainte să pornești la drum cu mașina.

Ne poți găsi
în următoarele locații

SEDIUL CENTRAL

SC NEXXON SRL

  • 525400 Târgu Secuiesc, judetul Covasna,str.Orban Balazs nr.14 Romania
  • Nr. Telefon:: +40 267 364 170
  • E-mail: office@nexxon.ro

Puncte de lucru

Baia Mare

  • Str: Victoriei nr. 178, Baia Mare, jud. Maramureș, Cod Postal: 430061
  • Nr. Telefon:: +40 262-294600

București

  • Pantelimon-Ilfov, B-dul Biruintei nr. 143, Cod Postal: 739571
  • Nr. Telefon:: +40 730-600401

Cluj Napoca

  • str.Clujului nr.5, Sannicoara, jud. Cluj, Cod postal: 407042
  • Nr. Telefon:: 0760780529

Galați

  • Str. Drumul de Centura nr. 1B, Tarla 131, Parcela 6, Galati, jud. Galati
  • Nr. Telefon:: 0799 000 046

Sfântu Gheorghe

  • Str. Lunca Oltului, nr.54, Sfantu Gheorghe, jud. Covasna,Cod postal: 520036
  • Nr. Telefon:: 0799 900 410

Constanța

  • Str. DN2 A Centura Vest (spre Ovidiu), Constanta, jud. Constanta, Cod postal: 900330
  • Nr. Telefon:: +40 372-714771

Timișoara

  • Str: Aradului nr. 109, Timisoara, jud. Timis, Cod postal: 300645
  • Nr. Telefon:: 0760 780 559

Târgu Secuiesc

  • Str.Fabricii nr.1, Targu Secuiesc, jud. Covasna, Cod postal: 525400
  • Nr. Telefon:: +40 760 780 536

Utilaje agricole

  • Str. Gării Nr. 48/A Târgu Secuiesc, Covasna, Romania
  • Nr. Telefon:: 0267-364 054