Chiudi Navigazione Ormeggio Manutenzione Impianti Attrezzatura Strumentazione Arredo Vela e sport
SPEDIZIONE GRATUITA OLTRE 249
Spedizione 9,90€ in tutta Italia, isole comprese | INFO e ORDINI: Lun-Ven 9-15 | GARANZIA CLIENTE NAUTICA PIU'

Strumentazione



SELECT pro_id, pro_nome, pro_ordine, pro_stato, MIN(sku_vendita) AS min, MAX(sku_vendita) as MAX, (sku_listino - sku_vendita) AS diff , url_seo FROM catalogo_prodotti LEFT JOIN catalogo_sku ON pro_id = sku_prodotto LEFT JOIN catalogo_categorie ON pro_categoria = cat_id LEFT JOIN pagine_url ON pro_id = url_rif WHERE pro_id IN (7925,4547,8105,1846,7540,7539,5707,1654,1665,1666,1668,1670,1672,1685,1686,1691,1847,1848,1849,1851,1852,1860,1861,1864,1866,1867,1868,1869,1870,1871,1872,1873,1874,1875,1876,1878,1879,1880,1881,1882,1883,1885,1886,1887,2057,2081,7638,3497,3499,3500,3501,3502,3509,3513,3521,3522,3523,3525,3526,3527,3528,3531,3543,3547,3548,3550,3553,3554,3555,3556,3557,3558,3559,3560,3561,3562,3563,3574,3575,3577,8911,4211,4212,4213,4214,4215,4223,4232,4233,4234,4235,4236,4237,4238,4239,4240,4354,4355,4358,4361,4362,4366,4548,7856,7690,4559,4769,4770,4771,4772,4773,4776,4780,4781,4784,4785,4786,4787,4788,4789,4790,4791,4792,4793,4794,4796,4804,4891,4892,4893,4894,4896,4897,4898,4899,4900,4901,4915,4916,4917,4918,4919,4920,4921,4923,4938,4939,4940,4941,4942,4943,4944,4945,4948,4949,4950,4951,4952,4953,4954,4960,4961,4962,4963,4964,4965,4966,4967,4968,4969,4970,4971,4972,4973,4974,4975,4977,4979,4980,4981,4982,4983,4985,4986,4987,4988,4989,4991,4992,4993,4994,4995,4996,4997,4998,4999,5000,5001,5002,5004,5005,5006,5007,5008,5009,5010,5027,5028,5029,5031,5032,5033,5035,5036,5037,5038,5039,5040,5041,5042,5043,5045,5046,5052,5053,5055,5065,5066,5067,5093,5389,5392,5394,7924,5708,5709,5712,5713,5714,5949,5950,5974,3336,5975,5976,5977,6031,5978,5979,5980,5981,6068,6069,6070,6071,6072,6073,6074,6075,6076,6077,6078,6079,6085,6086,6087,6088,6089,6090,6100,6101,6102,6129,6130,6131,6132,6133,6134,6135,6136,6137,6138,6139,6157,6321,6322,6323,6348,6351,6352,6353,6389,6595,6633,7202,7203,7204,7205,7206,7207,7208,7209,7210,7211,7212,7213,7215,7216,7217,7218,7220,7222,7233,7234,7235,7236,7237,7238,7239,7240,7241,7242,7243,7244,7245,7246,7247,7258,7259,7260,7261,7262,7337,7327,7340,7341,7445,7446,7483,7536,7541,7544,7591,7592,7610,7611,7612,7613,7614,7643,7926,7653,7655,7656,7659,7660,7661,7662,7663,7665,8106,7670,7671,7695,7696,7697,7698,7705,7724,7754,7762,7763,7764,7765,7766,7767,7768,7769,7770,7771,7777,7778,7779,7780,7781,7783,7784,7792,7823,7826,7887,7891,7913,7914,7915,7927,7928,7929,7930,7931,7932,7970,7971,7972,7973,8017,8018,8023,8052,8062,8065,8083,8107,8108,8653,8654,8655,8656,8657,8658,8659,8660,8661,8662,8663,8664,8665,8666,8912,8913,8914,8915,8916,8917,8918,8919,8920,8922,8923,8924,8925,8926,8927,8928,8929,8930,8931,8933,8934,8935,9026,9027,9028,9029,9030,9031,9032,9033,9034,9035,9074) GROUP BY pro_id ORDER BY pro_stato ASC, pro_ordine DESC, pro_nome ASC LIMIT 72,24
SELECT pro_id AS proid FROM catalogo_prodotti LEFT JOIN catalogo_sku ON pro_id = sku_prodotto LEFT JOIN catalogo_categorie ON pro_categoria = cat_id LEFT JOIN pagine_url ON pro_id = url_rif WHERE (cat_id = 7 OR cat_madre = 7) AND pro_stato <= 7 AND cat_stato >= 1 AND sku_stato = 1 GROUP BY pro_id