SELECT n_zbozi_ceny.vychozi_cena,n_zbozi.sazba_dph, n_zbozi.sazba_dph2, n_zbozi.anotace, n_zbozi.kod,n_zbozi.ean,n_zbozi.nazev, n_zbozi.kategorie_id,n_zbozi.sazba_dph3,n_zbozi.sazba_dph4,n_zbozi.typ,n_zbozi.trida,n_zbozi.kategorie_slev,n_zbozi.montaz as prodej_jina_sazba_dph, n_zbozi.zaruka,n_zbozi.zaruka_montaz,n_zbozi.phe,n_zbozi.link, n_zbozi.setovy, n_zbozi.vyrobce,n_zbozi.model,n_zbozi.akce,n_zbozi.novinka,n_zbozi.vyprodej,n_zbozi.doporucujeme,n_zbozi.end,n_zbozi.feed_cena, @rezervace:=(select COALESCE(sum(pocet),0) FROM n_zbozi_rezervace WHERE n_zbozi_rezervace.kod_zbozi=n_zbozi.kod) as rezervace, @pocet_skladem:=n_zbozi_skladova_karta.pocet_skladem-@rezervace as pocet_skladem, n_zbozi.nazev2 , @pocet_skladem_sort:=IF(n_zbozi_skladova_karta.pocet_skladem-@rezervace<0,0,n_zbozi_skladova_karta.pocet_skladem-@rezervace) as pocet_skladem_sort, n_zbozi.popis,n_zbozi.foto,n_zbozi.priznak,n_zbozi.poznamka,n_zbozi.nazev,n_zbozi.zobrazovat, n_zbozi_ceny.sleva, n_zbozi_ceny.cena, n_zbozi_ceny.cena as cena2, n_zbozi.dostupnost, n_zbozi_ceny.cena_bez_dph, n_zbozi.prodej, n_zbozi.prispevek_servis, @skupina := IF (n_zbozi.skupina <>'',n_zbozi.skupina ,n_zbozi.kod) as skupina, @is_darek := (SELECT count(id) FROM n_zbozi_bundle WHERE n_zbozi_bundle.kod_zbozi=n_zbozi.kod) as is_darek, @skupina as skupina_var, n_zbozi_ceny.cena_bez_dph as cena_bez_dph2 FROM n_zbozi INNER JOIN n_zbozi_kategorie ON n_zbozi_kategorie.kod_zbozi = n_zbozi.kod LEFT JOIN n_zbozi_ceny ON n_zbozi_ceny.kod_zbozi = n_zbozi.kod and n_zbozi_ceny.kategorie_dealer = 'M' LEFT JOIN n_zbozi_skladova_karta ON n_zbozi_skladova_karta.kod_zbozi = n_zbozi.kod LEFT JOIN n_zbozi_parametry ON n_zbozi.kod = n_zbozi_parametry.kod_zbozi WHERE n_zbozi.id IN (9,10,11,12,13,14,15,18,19,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,43,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,63,65,66,67,68,69,70,71,73,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,99,101,102,103,104,105,106,108,110,112,114,115,116,117,118,119,120,122,123,124,126,127,128,129,130,131,136,137,138,139,140,141,142,144,145,146,147,148,149,150,151,153,154,155,156,157,158,159,161,162,163,164,165,166,167,168,179,180,181,183,184,185,186,202,203,205,206,207,208,209,210,211,212,213,214,215,216,217,218,219,220,221,222,223,224,225,226,227,228,229,230,231,232,233,234,235,236,237,238,239,240,241,242,243,244,245,246,247,248,249,250,251,252,253,254,255,256,257,260,261,262,263,267,269,271,272,273,276,277,278,279,280,281,282,283,285,286,289,290,292,293,294,297,298,299,300,302,303,304,305,306,307,308,310,311,312,313,316,317,318,319,321,323,324,325,326,327,329,330,331,332,333,334,335,336,337,339,340,390,391,392,393,394,395,396,397,402,404,406,408,411,412,413,415,416,418,419,1056,1057,1127,1251,1252,1253,1270,1271,1272,1320,1400,1401,1402,1403,1404,1405,1406,1408,1409,1410,1411,1412,1413,1414,1415,1416,1417,1418,1419,1420,1421,1422,1423,1424,1425,1426,1427,1428,1430,1431,1432,1433,1434,1435,1436,1437,1438,1439,1440,1441,1442,1443,1444,1445,1446,1447,1448,1449,1450,1451,1452,1453,1454,1455,1456,1457,1458,1459,1460,1461,1462,1463,1464,1465,1466,1467,1468,1469,1470,1471,1472,1473,1474,1475,1476,1477,1478,1479,1480,1481,1482,1483,1484,1485,1504,1505,1506,1507,1508,1509,1510,1511,1512,1513,1514,1515,1516,1517,1518,1519,1520,1521,1522,1523,1524,1525,1526,1527,1528,1529,1530,1531,1532,1533,1534,1535,1536,1537,1538,1539,1540,1541,1542,1543,1544,1545,1546,1547,1548,1549,1550,1551,1557,1558,1559,1560,1561,1574,1575,1576,1665,1666,1667,1668,1669,1670,1671,1672,1673,1676,1677,1678,1679,1689,1690,1691,1692,1693,1694,1695,1696,1697,1700,1701,1702,1718,1723,1724,1726,1728,1729,1730,1731,1756,1757,1758,1837,1838,1839,1840,1841,1842,1843,1844,1845,1846,1847,1848,1849,1850,1851,1852,1853,1854,1855,1856,1857,1858,1859,1860,1861,1862,1863,1864,1865,1866,1867,1868,1869,1870,1871,1872,1873,1874,1875,1876,1877,1878,1879,1880,1881,1882,1883,1884,1885,1886,1887,1888,1889,1890,1891,1893,1894,1895,1896,1898,1899,1900,1901,1902,1903,1904,1905,1906,1989,1994,1995,2007,2009,2018,2019,2024,2063,2064,2065,2066,2067,2068,2069,2070,2071,2072,2073,2074,2075,2076,2077,2078,2079,2080,2081,2082,2083,2084,2085,2086,2087,2088,2089,2090,2091,2092,2093,2094,2095,2096,2097,2098,2099,2100,2101,2102,2103,2104,2105,2106,2107,2109,2110,2137,2138,2183,2184,2185,2186,2187,2188,2189,2190,2191,2192,2193,2194,2195,2196,2197,2198,2199,2200,2201,2202,2203,2204,2205,2206,2207,2208,2209,2210,2211,2212,2213,2214,2215,2216,2217,2218,2219,2220,2221,2222,2223,2224,2225,2226,2227,2228,2229,2230,2231,2232,2233,2234,2235,2236,2237,2238,2239,2240,2241,2242,2243,2244,2245,2246,2248,2249,2250,2251,2252,2253,2254,2255,2256,2257,2258,2259,2275,2276,2277,2278,2279,2280,2285,2286,2287,2288,2289,2290,2291,2292,2294,2295,2300,2301,2302,2303,2304,2305,2306,2307,2309,2310,2311,2312,2313,2314,2315,2316,2317,2318,2319,2320,2321,2322,2323,2324,2325,2326,2327,2328,2329,2330,2331,2332,2333,2334,2335,2336,2337,2338,2339,2340,2341,2342,2343,2359,2360,2361,2379,2380,2381,2382,2383,2384,2385,2392,2393,2394,2395,2403,2408,2409,2420,2421,2423,2424,2425,2426,2427,2428,2429,2430,2431,2432,2444,2445,2489,2498,2499,2500,2501,2502,2503,2504,2505,2506,2507,2508,2509,2510,2511,2512,2513,2514,2515,2516,2517,2518,2519,2520,2561,2562,2563,2564,2565,2566,2567,2568,2569,2576,2577,2578,2579,2608,2609,2610,2611,2612,2613,2614,2615,2735,2736,2741,2742,2743,2744,2745,2795,2796,2797,2798,2799,2800,2801,2802,2821,2822,2823,2824,2825,2826,2827,2828,2829,2837,2838,2853,2855,2856,2857,2858,2859,2860,2861,2862,2864,2865,2867,2868,2870,2871,2873,2874,2876,2877,2879,2880,2882,2883,2885,2886,2888,2889,2891,2892,2894,2895,2897,2898,2900,2901,2903,2904,2985,2986,2987,2988,2989,2990,2991,2992,3001,3004,3007,3010,3013,3016,3023,3024,3025,3026,3027,3028,3029,3040,3041,3139,3140,3159,3172,3173,3174,3183,3184,3185,3186,3187,3188,3189,3190,3191,3192,3193,3194,3195,3196,3197,3202,3204,3214,3215,3216,3222,3258,3259,3260,3261,3262,3263,3264,3282,3283,3284,3285,3313,3338,3340,3342,3343,3355,3356,3357,3642,3648,3649,3650,3651,3652,3653,3654,3655,3656,3657,3700,4197,4198,4199,4200,4201,4202,4203,4204,4205,4206,4207,4223,4224,4225,4247,4248,4249,4250,4266,4267,4268,4269,4270,4271,4272,4345,4346,4347,4348,4349,4350,4351,4352,4353,4354,4355,4356,4357,4358,4359,4360,4361,4362,4363,4364,4365,4366,4367,4368,4369,4370,4371,4372,4373,4374,4375,4376,4377,4378,4379,4467,4469,4471,4472,4473,4474,4478,4496,4497,4498,4499,4500,4501,4502,4503,4504,4505,4509,4516,4518,4520,4521,4522,4523,4526,4527,4528,4529,4530,4531,4532,4533,4534,4535,4536,4537,4538,4539,4540,4541,4542,4543,4544,4545,4551,4552,4553,4554,4555,4556,4557,4561,4568,4569,4573,4574,4575,4576,4577,4578,4579,4580,4581,4582,4583,4584,4585,4586,4587,4588,4589,4590,4591,4592,4593,4594,4595,4596,4597,4602,4603,4604,4605,4606,4607,4608,4609,4610,4611,4612,4613,4614,4615,4616,4617,4618,4621,4622,4623,4624,4625,4626,4627,4628,4629,4665,4666,4667,4668,4669,4670,4671,4672,4673,4674,4675,4676,4677,4685,4686,4687,4780,4781,4782,5136,5137,5471,5472,5473,5476,5477,5478,5479,5488,5489,5490,5491,5492,5493,5494,5495,5496,5497,5498,5499,5500,5501,5502,5507,5508,5509,5510,5511,5512,5513,5514,5515,5531,5532,5533,5534,5535,5536,5537,5538,5539,5540,5541,5542,5543,5544,5545,5546,5547,5548,5549,5550,5551,5552,5553,5554,5563,5564,5565,5572,5573,5574,5575,5576,5577,5578,5579,5611,5612,5613,5614,5615,5616,5622,5623,5624,5625,5626,5627,5628,5629,5630,5631,5632,5647,5648,5649,5650,5651,5652,5653,5654,5655,5656,5657,5658,5659,5764,5765,5766,5775,5776,5777,5778,5843,5844,5845,5846,5847,5848,5849,5850,5851,5852,5853,5854,5855,5856,5857,5858,5859,5860,5861,5862,5863,5864,5865,5866,5867,5868,5869,5870,5871,5872,5873,5874,5875,5876,5877,5878,5879,5880,5881,5882,5883,5884,5885,5886,5887,5888,5889,5890,5891,5892,5893,5894,5895,5896,5897,5898,5899,5900,5901,5902,5903,5904,5905,5911,5912,5913,5914,5915,5916,5917,5918,5919,5920,5921,5923,5924,5925,5926,5927,5928,5929,5930,5931,5932,5933,5934,5935,5936,5937,5938,5939,5949,5950,5951,5952,5953,5954,5955,5991,5992,5993,5994,5995,5996,5997,5998,5999,6000,6001,6002,6007,6008,6009,6010,6011,6012,6013,6014,6015,6016,6017,6064,6065,6066,6067,6068,6069,6070,6071,6072,6075,6076,6077,6078,6079,6080,6081,6082,6083,6084,6085,6182,6183,6184,6185,6193,6194,6195,6198,6199,6200,6201,6214,6215,6216,6217,6218,6219,6220,6221,6231,6232,6233,6234,6235,6236,6237,6238,6239,6240,6241,6242,6243,6244,6245,6246,6247,6248,6249,6250,6251,6252,6253,6254,6255,6256,6257,6258,6259,6260,6261,6262,6263,6264,6265,6266,6267,6268,6269,6270,6271,6272,6273,6274,6275,6276,6280,6281,6282,6283,6324,6339,6340,6344,6345,6346,6355,6356,6357,6358,6359,6360,6361,6362,6363,6403,6405,6413,6414,6427,6428,6429,6430,6458,6459,6460,6461,6462,6463,6464,6465,6466,6467,6469,6470,6471,6472,6473,6474,6485,6486,6487,6488,6489,6490,6491,6492,6493,6494,6495,6496,6497,6498,6499,6500,6501,6502,6503,6504,6505,6506,6507,6508,6509,6510,6511,6512,6513,6514,6515,6516,6517,6518,6519,6520,6521,6522,6523,6524,6525,6526,6527,6528,6529,6530,6531,6532,6533,6534,6535,6536,6537,6538,6539,6540,6541,6542,6543,6544,6545,6546,6547,6548,6549,6550,6551,6552,6553,6645,6646,6660,6699,6700,6701,6702,6703,6704,6705,6706,6707,6708,6709,6710,6711,6712,6715,6716,6717,6718,6723,6724,6725,6726,6727,6728,6729,6730,6731,6732,6767,6768,6769,6770,6771,6772,6799,6800,6804,6805,6807,6808,6810,6811,6813,6814,6816,6817,6819,6820,6822,6823,6825,6826,6828,6829,6831,6832,6834,6835,6837,6867,6877,6878,6879,6880,6951,6952,6953,6954,6956,6957,6958,6959,6960,6961,6962,6963,6964,6966,6970,6971,6972,6973,6974,6975,6976,6987,6988,6989,7001,7002,7003,7004,7005,7006,7007,7008,7009,7010,7011,7025,7027,7028,7031,7033,7035,7037,7040,7041,7042,7043,7044,7045,7046,7047,7048,7049,7050,7051,7052,7053,7054,7055,7056,7057,7058,7059,7060,7061,7062,7063,7064,7065,7066,7067,7068,7069,7070,7073,7074,7075,7076,7102,7103,7104,7105,7106,7107,7108,7109,7110,7111,7112,7113,7114,7115,7116,7117,7118,7119,7120,7121,7122,7123,7133,7134,7135,7136,7137,7138,7139,7140,7141,7142,7143,7144,7146,7147,7148,7149,7150,7151,7152,7153,7154,7155,7156,7157,7158,7159,7160,7161,7162,7163,7167,7176,7177,7178,7179,7180,7181,7182,7186,7187,7188,7189,7190,7191,7192,7193,7194,7195,7196,7197,7198,7199,7200,7201,7202,7205,7206,7210,7211,7212,7213,7214,7215,7216,7217,7218,7219,7220,7221,7222,7223,7224,7225,7227,7228,7229,7230,7231,7233,7240,7241,7242,7243,7248,7249,7250,7251,7252,7253,7260,7261,7262,7263,7284,7285,7319,7320,7344,7350,7351,7352,7353,7354,7355,7379,7384,7387,7389,7393,7394,7399,7433,7509,7510,7687,7977,8016,8017,8018,8019,8020,8021,8022,8023,8024,8032,8033,8034,8035,8036,8037,8039,8040,8041,8042,8043,8044,8045,8046,8048,8049,8050,8052,8064,8071,8072,8073,8092,8093,8095,8334,8356,8357,8358,8359,8360,8363,8364,8396,8467,8468,8469,8470,8471,8472,8473,8474,8475,8524,8525,8559,8560,8561,8562,8563,8564,8565,8566,8567,8568,8569,8570,8571,8572,8573,8574,8575,8576,8577,8578,8579,8580,8581,8582,8583,8584,8585,8586,8587,8588,8590,8592,8598,8599,8600,8601,8602,8603,8611,8612,8613,8614,8615,8616,8617,8618,8619,8620,8621,8622,8623,8624,8625,8627,8628,8629,8630,8631,8632,8633,8634,8635,8636,8637,8638,8639,8640,8641,8642,8643,8644,8645,8646,8647,8648,8649,8650,8651,8652,8653,8654,8655,8656,8657,8658,8659,8660,8661,8662,8663,8664,8667,8668,8669,8670,8671,8672,8673,8674,8675,8676,8677,8678,8679,8680,8681,8682,8683,8684,8685,8693,8694,8695,8696,8697,8698,8699,8700,8701,8702,8703,8704,8705,8706,8707,8708,8709,8710,8711,8712,8713,8714,8715,8716,8717,8718,8719,8720,8721,8722,8723,8724,8725,8726,8732,8733,8734,8735,8736,8737,8738,8739,8740,8741,8742,8743,8744,8745,8746,8747,8748,8749,8750,8751,8752,8753,8754,8755,8756,8757,8758,8759,8760,8761,8762,8763,8764,8765,8766,8767,8768,8769,8788,8789,8790,8791,8792,8832,8833,8834,8835,8837,8838,8839,8840,8841,8843,8844,8845,8865,8866,8867,8868,8869,8871,8872,8873,8886,8887,8888,8889,8890,8891,8892,8893,8895,8897,8898,8899,8900,8901,8902,8903,8904,8905,8907,8917,8918,8919,8920,8921,8922,8923,8924,8925,8926,8927,8928,8929,8930,8931,8932,8933,8934,8935,8936,8937,8938,8939,8940,8941,8942,8964,8965,8966,8967,8968,8969,8970,8971,8972,8973,8974,8975,8978,8979,8980,8981,8982,8983,8984,8985,8986,8987,8988,8992,8993,8994,8995,8996,8997,8998,8999,9000,9002,9003,9028,9029,9030,9031,9032,9033,9034,9035,9036,9037,9038,9039,9040,9041,9042,9060,9062,9064,9066,9068,9070,9072,9074,9076,9078,9080,9082,9084,9086,9088,9090,9092,9094,9098,9100,9104,9106,9112,9118,9120,9122,9126,9128,9130,9132,9134,9136,9140,9234,9236,9238,9240,9242,9244,9279,9281,9283,9285,9287,9289,9291,9293,9295,9297,9299,9301,9303,9305,9307,9309,9311,9313,9315,9317,9319,9321,9323,9325,9327,9329,9331,9333,9335,9337,9339,9341,9347,9349,9351,9353,9355,9357,9359,9361,9363,9365,9367,9369,9379,9387,9389,9391,9393,9395,9397,9399,9401,9403,9405,9407,9409,9411,9413,9415,9417,9419,9421,9423,9425,9427,9429,9431,9433,9435,9437,9439,9441,9443,9445,9447,9449,9451,9453,9455,9457,9591,9593,9595,9597,9599,9601,9603,9605,9607,9609,9611,9613,9615,9623,9625,9627,9629,9631,9633,9635,9637,9639,9641,9643,9645,9647,9649,9651,9653,9655,9657,9659,9661,9663,9665,9667,9669,9671,9673,9675,9677,9679,9681,9689,9691,9703,9705,9707,9709,9711,9713,9715,9717,9719,9721,9723,9725,9727,9729,9731,9733,9735,9737,9739,9747,9749,9751) AND (novinka=1) GROUP BY skupina_var DomovniSchranky.cz

DomovniSchranky.cz

Nahrávám
ČEKEJTE PROSÍM
SELECT n_zbozi_ceny.vychozi_cena,n_zbozi.sazba_dph, n_zbozi.sazba_dph2, n_zbozi.anotace, n_zbozi.kod,n_zbozi.ean,n_zbozi.nazev, n_zbozi.kategorie_id,n_zbozi.sazba_dph3,n_zbozi.sazba_dph4,n_zbozi.typ,n_zbozi.trida,n_zbozi.kategorie_slev,n_zbozi.montaz as prodej_jina_sazba_dph, n_zbozi.zaruka,n_zbozi.zaruka_montaz,n_zbozi.phe,n_zbozi.link, n_zbozi.setovy, n_zbozi.vyrobce,n_zbozi.model,n_zbozi.akce,n_zbozi.novinka,n_zbozi.vyprodej,n_zbozi.doporucujeme,n_zbozi.end,n_zbozi.feed_cena, @rezervace:=(select COALESCE(sum(pocet),0) FROM n_zbozi_rezervace WHERE n_zbozi_rezervace.kod_zbozi=n_zbozi.kod) as rezervace, @pocet_skladem:=n_zbozi_skladova_karta.pocet_skladem-@rezervace as pocet_skladem, n_zbozi.nazev2 , @pocet_skladem_sort:=IF(n_zbozi_skladova_karta.pocet_skladem-@rezervace<0,0,n_zbozi_skladova_karta.pocet_skladem-@rezervace) as pocet_skladem_sort, n_zbozi.popis,n_zbozi.foto,n_zbozi.priznak,n_zbozi.poznamka,n_zbozi.nazev,n_zbozi.zobrazovat, n_zbozi_ceny.sleva, n_zbozi_ceny.cena, n_zbozi_ceny.cena as cena2, n_zbozi.dostupnost, n_zbozi_ceny.cena_bez_dph, n_zbozi.prodej, n_zbozi.prispevek_servis, @skupina := IF (n_zbozi.skupina <>'',n_zbozi.skupina ,n_zbozi.kod) as skupina, @is_darek := (SELECT count(id) FROM n_zbozi_bundle WHERE n_zbozi_bundle.kod_zbozi=n_zbozi.kod) as is_darek, @skupina as skupina_var, n_zbozi_ceny.cena_bez_dph as cena_bez_dph2 FROM n_zbozi INNER JOIN n_zbozi_kategorie ON n_zbozi_kategorie.kod_zbozi = n_zbozi.kod LEFT JOIN n_zbozi_ceny ON n_zbozi_ceny.kod_zbozi = n_zbozi.kod and n_zbozi_ceny.kategorie_dealer = 'M' LEFT JOIN n_zbozi_skladova_karta ON n_zbozi_skladova_karta.kod_zbozi = n_zbozi.kod LEFT JOIN n_zbozi_parametry ON n_zbozi.kod = n_zbozi_parametry.kod_zbozi WHERE n_zbozi.id IN (9,10,11,12,13,14,15,18,19,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,43,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,63,65,66,67,68,69,70,71,73,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,99,101,102,103,104,105,106,108,110,112,114,115,116,117,118,119,120,122,123,124,126,127,128,129,130,131,136,137,138,139,140,141,142,144,145,146,147,148,149,150,151,153,154,155,156,157,158,159,161,162,163,164,165,166,167,168,179,180,181,183,184,185,186,202,203,205,206,207,208,209,210,211,212,213,214,215,216,217,218,219,220,221,222,223,224,225,226,227,228,229,230,231,232,233,234,235,236,237,238,239,240,241,242,243,244,245,246,247,248,249,250,251,252,253,254,255,256,257,260,261,262,263,267,269,271,272,273,276,277,278,279,280,281,282,283,285,286,289,290,292,293,294,297,298,299,300,302,303,304,305,306,307,308,310,311,312,313,316,317,318,319,321,323,324,325,326,327,329,330,331,332,333,334,335,336,337,339,340,390,391,392,393,394,395,396,397,402,404,406,408,411,412,413,415,416,418,419,1056,1057,1127,1251,1252,1253,1270,1271,1272,1320,1400,1401,1402,1403,1404,1405,1406,1408,1409,1410,1411,1412,1413,1414,1415,1416,1417,1418,1419,1420,1421,1422,1423,1424,1425,1426,1427,1428,1430,1431,1432,1433,1434,1435,1436,1437,1438,1439,1440,1441,1442,1443,1444,1445,1446,1447,1448,1449,1450,1451,1452,1453,1454,1455,1456,1457,1458,1459,1460,1461,1462,1463,1464,1465,1466,1467,1468,1469,1470,1471,1472,1473,1474,1475,1476,1477,1478,1479,1480,1481,1482,1483,1484,1485,1504,1505,1506,1507,1508,1509,1510,1511,1512,1513,1514,1515,1516,1517,1518,1519,1520,1521,1522,1523,1524,1525,1526,1527,1528,1529,1530,1531,1532,1533,1534,1535,1536,1537,1538,1539,1540,1541,1542,1543,1544,1545,1546,1547,1548,1549,1550,1551,1557,1558,1559,1560,1561,1574,1575,1576,1665,1666,1667,1668,1669,1670,1671,1672,1673,1676,1677,1678,1679,1689,1690,1691,1692,1693,1694,1695,1696,1697,1700,1701,1702,1718,1723,1724,1726,1728,1729,1730,1731,1756,1757,1758,1837,1838,1839,1840,1841,1842,1843,1844,1845,1846,1847,1848,1849,1850,1851,1852,1853,1854,1855,1856,1857,1858,1859,1860,1861,1862,1863,1864,1865,1866,1867,1868,1869,1870,1871,1872,1873,1874,1875,1876,1877,1878,1879,1880,1881,1882,1883,1884,1885,1886,1887,1888,1889,1890,1891,1893,1894,1895,1896,1898,1899,1900,1901,1902,1903,1904,1905,1906,1989,1994,1995,2007,2009,2018,2019,2024,2063,2064,2065,2066,2067,2068,2069,2070,2071,2072,2073,2074,2075,2076,2077,2078,2079,2080,2081,2082,2083,2084,2085,2086,2087,2088,2089,2090,2091,2092,2093,2094,2095,2096,2097,2098,2099,2100,2101,2102,2103,2104,2105,2106,2107,2109,2110,2137,2138,2183,2184,2185,2186,2187,2188,2189,2190,2191,2192,2193,2194,2195,2196,2197,2198,2199,2200,2201,2202,2203,2204,2205,2206,2207,2208,2209,2210,2211,2212,2213,2214,2215,2216,2217,2218,2219,2220,2221,2222,2223,2224,2225,2226,2227,2228,2229,2230,2231,2232,2233,2234,2235,2236,2237,2238,2239,2240,2241,2242,2243,2244,2245,2246,2248,2249,2250,2251,2252,2253,2254,2255,2256,2257,2258,2259,2275,2276,2277,2278,2279,2280,2285,2286,2287,2288,2289,2290,2291,2292,2294,2295,2300,2301,2302,2303,2304,2305,2306,2307,2309,2310,2311,2312,2313,2314,2315,2316,2317,2318,2319,2320,2321,2322,2323,2324,2325,2326,2327,2328,2329,2330,2331,2332,2333,2334,2335,2336,2337,2338,2339,2340,2341,2342,2343,2359,2360,2361,2379,2380,2381,2382,2383,2384,2385,2392,2393,2394,2395,2403,2408,2409,2420,2421,2423,2424,2425,2426,2427,2428,2429,2430,2431,2432,2444,2445,2489,2498,2499,2500,2501,2502,2503,2504,2505,2506,2507,2508,2509,2510,2511,2512,2513,2514,2515,2516,2517,2518,2519,2520,2561,2562,2563,2564,2565,2566,2567,2568,2569,2576,2577,2578,2579,2608,2609,2610,2611,2612,2613,2614,2615,2735,2736,2741,2742,2743,2744,2745,2795,2796,2797,2798,2799,2800,2801,2802,2821,2822,2823,2824,2825,2826,2827,2828,2829,2837,2838,2853,2855,2856,2857,2858,2859,2860,2861,2862,2864,2865,2867,2868,2870,2871,2873,2874,2876,2877,2879,2880,2882,2883,2885,2886,2888,2889,2891,2892,2894,2895,2897,2898,2900,2901,2903,2904,2985,2986,2987,2988,2989,2990,2991,2992,3001,3004,3007,3010,3013,3016,3023,3024,3025,3026,3027,3028,3029,3040,3041,3139,3140,3159,3172,3173,3174,3183,3184,3185,3186,3187,3188,3189,3190,3191,3192,3193,3194,3195,3196,3197,3202,3204,3214,3215,3216,3222,3258,3259,3260,3261,3262,3263,3264,3282,3283,3284,3285,3313,3338,3340,3342,3343,3355,3356,3357,3642,3648,3649,3650,3651,3652,3653,3654,3655,3656,3657,3700,4197,4198,4199,4200,4201,4202,4203,4204,4205,4206,4207,4223,4224,4225,4247,4248,4249,4250,4266,4267,4268,4269,4270,4271,4272,4345,4346,4347,4348,4349,4350,4351,4352,4353,4354,4355,4356,4357,4358,4359,4360,4361,4362,4363,4364,4365,4366,4367,4368,4369,4370,4371,4372,4373,4374,4375,4376,4377,4378,4379,4467,4469,4471,4472,4473,4474,4478,4496,4497,4498,4499,4500,4501,4502,4503,4504,4505,4509,4516,4518,4520,4521,4522,4523,4526,4527,4528,4529,4530,4531,4532,4533,4534,4535,4536,4537,4538,4539,4540,4541,4542,4543,4544,4545,4551,4552,4553,4554,4555,4556,4557,4561,4568,4569,4573,4574,4575,4576,4577,4578,4579,4580,4581,4582,4583,4584,4585,4586,4587,4588,4589,4590,4591,4592,4593,4594,4595,4596,4597,4602,4603,4604,4605,4606,4607,4608,4609,4610,4611,4612,4613,4614,4615,4616,4617,4618,4621,4622,4623,4624,4625,4626,4627,4628,4629,4665,4666,4667,4668,4669,4670,4671,4672,4673,4674,4675,4676,4677,4685,4686,4687,4780,4781,4782,5136,5137,5471,5472,5473,5476,5477,5478,5479,5488,5489,5490,5491,5492,5493,5494,5495,5496,5497,5498,5499,5500,5501,5502,5507,5508,5509,5510,5511,5512,5513,5514,5515,5531,5532,5533,5534,5535,5536,5537,5538,5539,5540,5541,5542,5543,5544,5545,5546,5547,5548,5549,5550,5551,5552,5553,5554,5563,5564,5565,5572,5573,5574,5575,5576,5577,5578,5579,5611,5612,5613,5614,5615,5616,5622,5623,5624,5625,5626,5627,5628,5629,5630,5631,5632,5647,5648,5649,5650,5651,5652,5653,5654,5655,5656,5657,5658,5659,5764,5765,5766,5775,5776,5777,5778,5843,5844,5845,5846,5847,5848,5849,5850,5851,5852,5853,5854,5855,5856,5857,5858,5859,5860,5861,5862,5863,5864,5865,5866,5867,5868,5869,5870,5871,5872,5873,5874,5875,5876,5877,5878,5879,5880,5881,5882,5883,5884,5885,5886,5887,5888,5889,5890,5891,5892,5893,5894,5895,5896,5897,5898,5899,5900,5901,5902,5903,5904,5905,5911,5912,5913,5914,5915,5916,5917,5918,5919,5920,5921,5923,5924,5925,5926,5927,5928,5929,5930,5931,5932,5933,5934,5935,5936,5937,5938,5939,5949,5950,5951,5952,5953,5954,5955,5991,5992,5993,5994,5995,5996,5997,5998,5999,6000,6001,6002,6007,6008,6009,6010,6011,6012,6013,6014,6015,6016,6017,6064,6065,6066,6067,6068,6069,6070,6071,6072,6075,6076,6077,6078,6079,6080,6081,6082,6083,6084,6085,6182,6183,6184,6185,6193,6194,6195,6198,6199,6200,6201,6214,6215,6216,6217,6218,6219,6220,6221,6231,6232,6233,6234,6235,6236,6237,6238,6239,6240,6241,6242,6243,6244,6245,6246,6247,6248,6249,6250,6251,6252,6253,6254,6255,6256,6257,6258,6259,6260,6261,6262,6263,6264,6265,6266,6267,6268,6269,6270,6271,6272,6273,6274,6275,6276,6280,6281,6282,6283,6324,6339,6340,6344,6345,6346,6355,6356,6357,6358,6359,6360,6361,6362,6363,6403,6405,6413,6414,6427,6428,6429,6430,6458,6459,6460,6461,6462,6463,6464,6465,6466,6467,6469,6470,6471,6472,6473,6474,6485,6486,6487,6488,6489,6490,6491,6492,6493,6494,6495,6496,6497,6498,6499,6500,6501,6502,6503,6504,6505,6506,6507,6508,6509,6510,6511,6512,6513,6514,6515,6516,6517,6518,6519,6520,6521,6522,6523,6524,6525,6526,6527,6528,6529,6530,6531,6532,6533,6534,6535,6536,6537,6538,6539,6540,6541,6542,6543,6544,6545,6546,6547,6548,6549,6550,6551,6552,6553,6645,6646,6660,6699,6700,6701,6702,6703,6704,6705,6706,6707,6708,6709,6710,6711,6712,6715,6716,6717,6718,6723,6724,6725,6726,6727,6728,6729,6730,6731,6732,6767,6768,6769,6770,6771,6772,6799,6800,6804,6805,6807,6808,6810,6811,6813,6814,6816,6817,6819,6820,6822,6823,6825,6826,6828,6829,6831,6832,6834,6835,6837,6867,6877,6878,6879,6880,6951,6952,6953,6954,6956,6957,6958,6959,6960,6961,6962,6963,6964,6966,6970,6971,6972,6973,6974,6975,6976,6987,6988,6989,7001,7002,7003,7004,7005,7006,7007,7008,7009,7010,7011,7025,7027,7028,7031,7033,7035,7037,7040,7041,7042,7043,7044,7045,7046,7047,7048,7049,7050,7051,7052,7053,7054,7055,7056,7057,7058,7059,7060,7061,7062,7063,7064,7065,7066,7067,7068,7069,7070,7073,7074,7075,7076,7102,7103,7104,7105,7106,7107,7108,7109,7110,7111,7112,7113,7114,7115,7116,7117,7118,7119,7120,7121,7122,7123,7133,7134,7135,7136,7137,7138,7139,7140,7141,7142,7143,7144,7146,7147,7148,7149,7150,7151,7152,7153,7154,7155,7156,7157,7158,7159,7160,7161,7162,7163,7167,7176,7177,7178,7179,7180,7181,7182,7186,7187,7188,7189,7190,7191,7192,7193,7194,7195,7196,7197,7198,7199,7200,7201,7202,7205,7206,7210,7211,7212,7213,7214,7215,7216,7217,7218,7219,7220,7221,7222,7223,7224,7225,7227,7228,7229,7230,7231,7233,7240,7241,7242,7243,7248,7249,7250,7251,7252,7253,7260,7261,7262,7263,7284,7285,7319,7320,7344,7350,7351,7352,7353,7354,7355,7379,7384,7387,7389,7393,7394,7399,7433,7509,7510,7687,7977,8016,8017,8018,8019,8020,8021,8022,8023,8024,8032,8033,8034,8035,8036,8037,8039,8040,8041,8042,8043,8044,8045,8046,8048,8049,8050,8052,8064,8071,8072,8073,8092,8093,8095,8334,8356,8357,8358,8359,8360,8363,8364,8396,8467,8468,8469,8470,8471,8472,8473,8474,8475,8524,8525,8559,8560,8561,8562,8563,8564,8565,8566,8567,8568,8569,8570,8571,8572,8573,8574,8575,8576,8577,8578,8579,8580,8581,8582,8583,8584,8585,8586,8587,8588,8590,8592,8598,8599,8600,8601,8602,8603,8611,8612,8613,8614,8615,8616,8617,8618,8619,8620,8621,8622,8623,8624,8625,8627,8628,8629,8630,8631,8632,8633,8634,8635,8636,8637,8638,8639,8640,8641,8642,8643,8644,8645,8646,8647,8648,8649,8650,8651,8652,8653,8654,8655,8656,8657,8658,8659,8660,8661,8662,8663,8664,8667,8668,8669,8670,8671,8672,8673,8674,8675,8676,8677,8678,8679,8680,8681,8682,8683,8684,8685,8693,8694,8695,8696,8697,8698,8699,8700,8701,8702,8703,8704,8705,8706,8707,8708,8709,8710,8711,8712,8713,8714,8715,8716,8717,8718,8719,8720,8721,8722,8723,8724,8725,8726,8732,8733,8734,8735,8736,8737,8738,8739,8740,8741,8742,8743,8744,8745,8746,8747,8748,8749,8750,8751,8752,8753,8754,8755,8756,8757,8758,8759,8760,8761,8762,8763,8764,8765,8766,8767,8768,8769,8788,8789,8790,8791,8792,8832,8833,8834,8835,8837,8838,8839,8840,8841,8843,8844,8845,8865,8866,8867,8868,8869,8871,8872,8873,8886,8887,8888,8889,8890,8891,8892,8893,8895,8897,8898,8899,8900,8901,8902,8903,8904,8905,8907,8917,8918,8919,8920,8921,8922,8923,8924,8925,8926,8927,8928,8929,8930,8931,8932,8933,8934,8935,8936,8937,8938,8939,8940,8941,8942,8964,8965,8966,8967,8968,8969,8970,8971,8972,8973,8974,8975,8978,8979,8980,8981,8982,8983,8984,8985,8986,8987,8988,8992,8993,8994,8995,8996,8997,8998,8999,9000,9002,9003,9028,9029,9030,9031,9032,9033,9034,9035,9036,9037,9038,9039,9040,9041,9042,9060,9062,9064,9066,9068,9070,9072,9074,9076,9078,9080,9082,9084,9086,9088,9090,9092,9094,9098,9100,9104,9106,9112,9118,9120,9122,9126,9128,9130,9132,9134,9136,9140,9234,9236,9238,9240,9242,9244,9279,9281,9283,9285,9287,9289,9291,9293,9295,9297,9299,9301,9303,9305,9307,9309,9311,9313,9315,9317,9319,9321,9323,9325,9327,9329,9331,9333,9335,9337,9339,9341,9347,9349,9351,9353,9355,9357,9359,9361,9363,9365,9367,9369,9379,9387,9389,9391,9393,9395,9397,9399,9401,9403,9405,9407,9409,9411,9413,9415,9417,9419,9421,9423,9425,9427,9429,9431,9433,9435,9437,9439,9441,9443,9445,9447,9449,9451,9453,9455,9457,9591,9593,9595,9597,9599,9601,9603,9605,9607,9609,9611,9613,9615,9623,9625,9627,9629,9631,9633,9635,9637,9639,9641,9643,9645,9647,9649,9651,9653,9655,9657,9659,9661,9663,9665,9667,9669,9671,9673,9675,9677,9679,9681,9689,9691,9703,9705,9707,9709,9711,9713,9715,9717,9719,9721,9723,9725,9727,9729,9731,9733,9735,9737,9739,9747,9749,9751) AND n_zbozi_kategorie.id_kategorie IN (0,0,280,379,380,386,387,388,382,384,417,385,415,418,419,420,421,423,12,407,15,371,16,389,119,32,276,358,275,370,277,279,247,267,269,268,410,25,237,165,167,164,128,36,123,180,184,333,346,183,334,185,140,143,144,145,373,374,34,13,120,125,107,361,369,411,372,367,368,282,283,251,422) GROUP BY skupina_var
Mikrotužkové baterie Longlife Power pro elektronické trezorové zámky, 4xAAA
Showroom Praha, FM

Dostupnost: >5 ks skladem
79 Kč
65 Kč bez DPH

Baterie Longlife Power 9V pro elektronické trezorové zámky
Showroom Praha, FM

Dostupnost: >5 ks skladem
99 Kč
82 Kč bez DPH

Tužkové baterie Longlife Power pro elektronické trezorové zámky, 4xAA
Showroom Praha, FM

Dostupnost: >5 ks skladem
79 Kč
65 Kč bez DPH

Bezpečnostní schránka na klíče 5401EURD
Showroom Praha, FM

Dostupnost: >5 ks skladem
832 Kč
688 Kč bez DPH

TIP
Nouzová skříňka na klíč NSK1 s kladivkem
Showroom Praha, FM

Dostupnost: >5 ks skladem
271 Kč
224 Kč bez DPH

-5%

QUER barevný rozlišovač klíčů, černá (balení 10ks)
Showroom FM

Dostupnost: >5 ks skladem
96 Kč
79 Kč bez DPH

VÝPRODEJ

-5%

Bezpečnostní schránka na klíče KEY SAFE 20 SB
Showroom Praha, FM

Dostupnost: >5 ks skladem
928 Kč
767 Kč bez DPH

NOVÉ

-20%

QUER barevný rozlišovač klíčů, žlutá (balení 10ks)
Showroom FM

Dostupnost: >5 ks skladem
96 Kč
79 Kč bez DPH

VÝPRODEJ

-5%

Pokladnička HOMESTAR CASH 1 černá
Showroom Praha, FM

Dostupnost: >5 ks skladem
223 Kč
184 Kč bez DPH

NOVÉ

-5%

Bezpečnostní schránka na klíče KEY SAFE 10 SB
Showroom Praha, FM

Dostupnost: >5 ks skladem
627 Kč
518 Kč bez DPH

NOVÉ

-20%

QUER barevný rozlišovač klíčů, červená (balení 10ks)
Showroom FM

Dostupnost: >5 ks skladem
96 Kč
79 Kč bez DPH

VÝPRODEJ

-5%

Bezpečnostní schránka na klíče 5403EURD
Showroom Praha, FM

Dostupnost: >5 ks skladem
982 Kč
812 Kč bez DPH

TIP
Bezpečnostní schránka na klíče 5425EURD
Showroom Praha, FM

Dostupnost: >5 ks skladem
1 024 Kč
846 Kč bez DPH

TIP
QUER barevný rozlišovač klíčů, modrá (balení 10ks)
Showroom FM

Dostupnost: >5 ks skladem
96 Kč
79 Kč bez DPH

VÝPRODEJ

-5%

QUER barevný rozlišovač klíčů, zelená (balení 10ks)
Showroom FM

Dostupnost: >5 ks skladem
96 Kč
79 Kč bez DPH

VÝPRODEJ

-5%

Bezpečnostní schránka na klíče 207EURD
Showroom Praha, FM

Dostupnost: >5 ks skladem
179 Kč
148 Kč bez DPH


Zapomenuté heslo
Zboží k porovnání:0ks
Nahrávám
COVID-19: Fungujeme a zboží expresně expedujeme za akční ceny včetně dodání do výdejních míst.
Osobní odběry jsou obnoveny v plném rozsahu, od 3.12. se opět na Vás těšíme na našich prodejnách. V případě potřeby nás neváhejte kontaktovat. Děkujeme.