EZVIZ HP7 2-FAMILY KIT BARVNI VIDEO DOMOFON

399,00 €

335,16 €

Dvostanovanjska zunanja enota Wi-Fi + 2K kamera + 2x 7-palčni barvni zaslon na dotik + snemanje na microSD kartico + 2-žilna povezava + odklepanje z obeskom, notranjo enoto, aplikacijo, QR kodo + zaznavanje gibanja

Blagovna znamka:

EZVIZ
Koda:

EZVIZ-CS-HP7-2
Zaloga:

Na zalogi

Dodaj v košarico

Podeli :

Opis

EZVIZ HP7 2-Family Kit je napreden video domofonski sistem, zasnovan za dve družini, ki si delita glavni vhod. Sestavljen je iz zunanje enote z dvema ločenima gumboma in dveh notranjih 7-palčnih zaslonov na dotik, kar omogoča vsaki družini neodvisno upravljanje dostopa do doma. Sistem podpira 2K video ločljivost, dvosmerno komunikacijo, pametno zaznavanje gibanja in daljinsko odklepanje vrat preko aplikacije EZVIZ. Poleg tega omogoča odklepanje z RFID obeski (3 za vsako družino), ima nočni vid, vremensko odporno zasnovo in podpira Wi-Fi povezljivost ter shranjevanje posnetkov na microSD kartico ali v oblak EZVIZ CloudPlay. Idealna rešitev za varno in pametno upravljanje skupnega vhoda.

Specifikacije
Zunanja enota
Slikovno tipalo: 1/2.7-palčni progresivni CMOS (podpira visoko občutljivost pri šibki svetlobi)
Leča: 2,0 mm @ F2.2, kot gledanja: 162° (diagonalno)
Dan in noč: IR-cut filter z avtomatskim preklapljanjem, infrardeča svetloba 850 nm × 2 (največ 6 m)
Največja ločljivost: 2K (2048 × 1296)
DNR: 2D / 3D DNR
Kompresija videa: H.265 / H.264
Snemalna hitrost: Največ: 15 sličic/s; Samoprilagodljiva med prenosom po omrežju

Vmesnik zunanje enote
Avdio vhod: Vgrajen visokoobčutljiv mikrofon
Avdio izhod: Vgrajen zvočnik z visoko močjo
Gumb zvonca: Podpira 2 gumba; Možnost nastavitve osvetlitve (vklop/izklop)
Kartica z imenom: Podpira ročni vnos; vključene 3 nalepke za kartice (1 že nameščena na domofonski plošči)
Terminal: Dva priključka za povezavo z zaslonom. Dva priključka za povezavo z avtomatskimi vrati. Dva priključka za povezavo z električno ključavnico.

Funkcije
Pametni alarm: Pametno zaznavanje človeškega gibanja, zaznavanje zadrževanja
Alarm proti posegom: Podprto
Video domofon: Dvosmerni video pogovor na daljavo

Povezava in funkcije
Način povezave: Žična povezava (2-žična, združljiva s 4-žično), prenos digitalnega signala
Prenosna razdalja:
– Φ 2 x 0,75 mm²: največ 50 m
– Φ 2 x 1,5 mm²: največ 100 m
– Sukani par (twisted pair): največ 120 m
Video domofon: Dvosmerni video pogovor na daljavo
Odpiranje vrat (avtomatska vrata):
– Podpira 2 priključka; razdalja 1–10 m
– Domofonska enota zagotavlja "suhi" stik brez električnega toka za povezavo na gumb za avtomatska vrata
– Zmogljivost stika: 12V / 2A
Odklepanje (električna ključavnica):
– Podpira 2 priključka; razdalja 1–10 m
– Električna ključavnica, ki jo naročite, mora imeti mehanski spomin
– Napajalna napetost električne ključavnice ne sme presegati 12V / 1,1A, sicer ravnajte po navodilih za uporabo
Načini odpiranja vrat:
1.    Odklepanje z RFID obeskom (3 kosi / gospodinjstvo)
2.    Daljinsko odklepanje preko aplikacije
3.    Odklepanje preko notranjega monitorja
4.    Odklepanje s QR kodo

Splošno
Delovni pogoji: -30°C do 60°C, relativna vlažnost 95 % ali manj (brez kondenzacije)
IP zaščita: Vodoodporna, z zaščitnim pokrovom
Napajanje: 24V DC iz monitorja

Notranja enota
Velikost zaslona: 7-palčni zaslon na dotik
Ločljivost: 1024 × 600

Vmesnik
Avdio vhod: Vgrajen visokoobčutljiv mikrofon
Avdio izhod: Vgrajen zvočnik z visoko močjo
Gumb: Gumb za vklop/izklop zaslona
Terminal: Dva priključka za povezavo z zunanjo enoto
MicroSD kartica: Podpira microSD kartico (največ 512 GB)

Omrežni parametri
Protokol: Lastniški protokol EZVIZ Cloud
Vmesniški protokol: Lastniški protokol EZVIZ Cloud

Wi-Fi parametri
Wi-Fi standard: IEEE802.11b, 802.11g, 802.11n, 802.11ac
Frekvenčno območje: 2,4 GHz ~ 2,4835 GHz / 5,15 GHz ~ 5,25 GHz
Širina kanala: Podpira 20 MHz
Varnost: 64 / 128-bitni WEP, WPA / WPA2, WPA-PSK / WPA2-PSK
Hitrost prenosa: 11b: 11 Mbps, 11g: 54 Mbps, 11n: 150 Mbps, 11ac: 433,3 Mbps

Funkcionalnosti
Več melodij zvonjenja: Do 20 različnih melodij
Funkcije: Ogled v živo, predvajanje, dvosmerni pogovor, video klic

Splošno (notranji monitor)
Delovni pogoji: -10°C do 45°C, relativna vlažnost 95 % ali manj (brez kondenzacije)
Napajanje: Napajanje DC 24V / 1A, adapter (100–240 V AC)
Poraba energije: 8W, največ 24W

Splošno (HP7 komplet za 2 stanovanji)
Teža: Neto teža: 1010 g
Dimenzije:
– Monitorji: 180 × 111 × 15 mm
– Zunanja enota: 161 × 87 × 22 mm

Vsebina paketa
– Monitor × 2
– Stenski nosilec za monitor × 2
– Napajalnik za monitor × 2
– Šablona za vrtanje za monitor × 2
– Domofonska enota (zvonec) z vodoodpornim pokrovom
– Šablona za vrtanje za domofonsko enoto
– Izvijač
– Obeski × 6
– Komplet vijakov × 3
– Kartica z imenom × 2
– Kabli in konektorji × 2
– Konektorski kabel za napajanje DC 24V × 2
– Regulatorne informacije × 2
– Priročnik za hitro namestitev × 2

Certifikati
Certifikati: CE / REACH / WEEE / RoHS

Specifikacija

0.003	SELECT `real_path` FROM `url_rewrites` WHERE `requested_path` = "/ezviz-hp7-2-family-kit-barvni-video-domofon-1691.html"
0.222	SELECT c.id AS category_id, c.CategoryTree, COUNT(DISTINCT p.id) AS product_count FROM Category c JOIN Product p ON ( p.categoryId = c.id OR p.category2Id = c.id OR p.category3Id = c.id OR p.category4Id = c.id OR p.category5Id = c.id OR p.category6Id = c.id ) WHERE p.active = 'yes' GROUP BY c.id ORDER BY c.CategoryTree DESC
0.007	SELECT * FROM Category ORDER BY sequence
0.001	SELECT Product.*, t.name AS tm_name, t.homepage AS tm_homepage, t.garancijskaDoba as tm_garancija, Product.preorder, count(productdiscount.productId)>0 AS hasqdisc FROM Product LEFT JOIN trademark AS t ON t.id=Product.trademarkId LEFT JOIN productdiscount ON Product.id=productdiscount.productId WHERE Product.id=1691 GROUP BY Product.id
0.001	SELECT * FROM trademark ORDER BY name ASC
0.001	SELECT id FROM Category WHERE parentID = 171
0.001	SELECT id FROM Category WHERE parentID = 1070
0.001	SELECT id FROM Category WHERE parentID = 1069
0.003	SELECT id FROM Category WHERE parentID = 333
0.001	SELECT * FROM Category WHERE parentId = 1076
0.001	SELECT * FROM Category WHERE parentId = 989
0.001	SELECT id FROM Category WHERE parentID = 835
0.001	SELECT id FROM Category WHERE parentID = 871
0.001	SELECT id FROM Category WHERE parentID = 274
0.001	SELECT * FROM Category WHERE parentId = 658
0.002	SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (81,171,470,535,206,1070,1072,1073,1069,1075,1074,1071,1068,1076,264,311,333,691,518,734,684,685,686,687,688,689,517,683,534,1101,1102,573,645,653,776,833,783,784,785,786,787,788,979,802,1029,91,281,282,283,324,1230,474,502,1035,1036,1037,504,506,611,580,581,596,481,855,856,857,858,482,1056,1057,496,497,498,587,709,739,748,750,1083,892,655,503,1063,1064,472,514,600,601,603,602,475,552,553,554,476,690,576,577,578,588,626,708,738,751,752,756,477,516,682,680,681,840,1194,515,1062,1065,624,629,630,632,634,635,636,637,638,793,794,795,796,797,798,799,800,960,1125,631,639,640,641,642,643,1041,1042,1043,1200,1201,1202,644,712,976,1005,1006,1007,1008,963,965,975,988,989,1027,1032,1149,1148,1106,1107,1108,1109,1110,1111,1112,1113,1126,1133,1134,1135,1136,1137,1138,1139,1140,1141,1216,2) OR category2Id IN (81,171,470,535,206,1070,1072,1073,1069,1075,1074,1071,1068,1076,264,311,333,691,518,734,684,685,686,687,688,689,517,683,534,1101,1102,573,645,653,776,833,783,784,785,786,787,788,979,802,1029,91,281,282,283,324,1230,474,502,1035,1036,1037,504,506,611,580,581,596,481,855,856,857,858,482,1056,1057,496,497,498,587,709,739,748,750,1083,892,655,503,1063,1064,472,514,600,601,603,602,475,552,553,554,476,690,576,577,578,588,626,708,738,751,752,756,477,516,682,680,681,840,1194,515,1062,1065,624,629,630,632,634,635,636,637,638,793,794,795,796,797,798,799,800,960,1125,631,639,640,641,642,643,1041,1042,1043,1200,1201,1202,644,712,976,1005,1006,1007,1008,963,965,975,988,989,1027,1032,1149,1148,1106,1107,1108,1109,1110,1111,1112,1113,1126,1133,1134,1135,1136,1137,1138,1139,1140,1141,1216,2))
0.001	SELECT * FROM Category WHERE parentId = 2
0.001	SELECT * FROM Category WHERE parentId = 795
0.002	SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (115,174,597,599,598,740,982,983,621,424,540,425,426,427,428,832,741,742,743,744,882,986,987,745,891,984,985,746,747,876,958,1086,1087,1088,1089,1097,1100,1128,1227,1226,5) OR category2Id IN (115,174,597,599,598,740,982,983,621,424,540,425,426,427,428,832,741,742,743,744,882,986,987,745,891,984,985,746,747,876,958,1086,1087,1088,1089,1097,1100,1128,1227,1226,5))
0.002	SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (957,956,139,233,250,991,992,993,994,995,996,997,998,999,1000,1067,244,367,245,246,1077,389,943,946,947,948,949,950,951,952,953,955,1033,773,834,835,1002,1003,837,941,940,836,939,1034,945,1016,1030,1129,1127,1214,1217,1218,1219,1228,6) OR category2Id IN (957,956,139,233,250,991,992,993,994,995,996,997,998,999,1000,1067,244,367,245,246,1077,389,943,946,947,948,949,950,951,952,953,955,1033,773,834,835,1002,1003,837,941,940,836,939,1034,945,1016,1030,1129,1127,1214,1217,1218,1219,1228,6))
0.001	SELECT * FROM Category WHERE parentId = 6
0.002	SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (1046,1004,859,860,861,862,863,864,865,977,980,1203,866,868,869,870,1038,1039,1040,1198,1199,1197,871,872,873,874,981,966,1009,1010,1011,1012,1013,1014,1015,1025,1028,1091,1103,1151,1193,1190,1191,1192,1205,1220,1221,1222,1223,1225,408) OR category2Id IN (1046,1004,859,860,861,862,863,864,865,977,980,1203,866,868,869,870,1038,1039,1040,1198,1199,1197,871,872,873,874,981,966,1009,1010,1011,1012,1013,1014,1015,1025,1028,1091,1103,1151,1193,1190,1191,1192,1205,1220,1221,1222,1223,1225,408))
0.001	SELECT * FROM Category WHERE parentId = 408
0.001	SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (843,844,845,846,841,842,1079,1082,1081,847,848,849,850,853,1026,1215,877,1017,1093,1098,1099,1159,84) OR category2Id IN (843,844,845,846,841,842,1079,1082,1081,847,848,849,850,853,1026,1215,877,1017,1093,1098,1099,1159,84))
0.001	SELECT * FROM Category WHERE parentId = 853
0.003	SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (555,671,727,728,729,672,730,731,732,673,670,724,725,726,875,887,889,888,1020,1021,1095,354,356,357,359,358,383,384,385,274,313,838,334,335,336,839,931,964,1045,364,365,366,350,657,656,658,352,667,678,677,775,765,766,767,768,769,770,771,772,1054,377,378,379,401,402,403,404,405,1047,704,707,710,959,974,1078,1019,1022,1023,1044,1084,1085,1090,1096,1160,1204,1211,1224,1229,1231,197) OR category2Id IN (555,671,727,728,729,672,730,731,732,673,670,724,725,726,875,887,889,888,1020,1021,1095,354,356,357,359,358,383,384,385,274,313,838,334,335,336,839,931,964,1045,364,365,366,350,657,656,658,352,667,678,677,775,765,766,767,768,769,770,771,772,1054,377,378,379,401,402,403,404,405,1047,704,707,710,959,974,1078,1019,1022,1023,1044,1084,1085,1090,1096,1160,1204,1211,1224,1229,1231,197))
0.001	SELECT * FROM Category WHERE parentId = 354
0.001	SELECT * FROM Category WHERE parentId = 358
0.002	SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (893,935,897,899,921,925,926,898,920,919,927,928,929,930,967,968,969,970,971,972,973,896,895,901,903,904,905,906,909,910,913,938,990,1018,1053,937,894,934,932,933,914,915,916,917,918,961,1024,936,1048,1049,1051,1050,1052,1130,625) OR category2Id IN (893,935,897,899,921,925,926,898,920,919,927,928,929,930,967,968,969,970,971,972,973,896,895,901,903,904,905,906,909,910,913,938,990,1018,1053,937,894,934,932,933,914,915,916,917,918,961,1024,936,1048,1049,1051,1050,1052,1130,625))
0.003	SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (1153,1156,1154,1155,1157,1158,1212,1161,1162,1163,1164,1167,1166,1165,1206,1207,1175,1176,1177,1178,1168,1172,1173,1174,1170,1169,1171,1179,1180,1181,1182,1183,1184,1187,1185,1186,1188,1189,1195,1196,1210,1209,1208,1213,1152) OR category2Id IN (1153,1156,1154,1155,1157,1158,1212,1161,1162,1163,1164,1167,1166,1165,1206,1207,1175,1176,1177,1178,1168,1172,1173,1174,1170,1169,1171,1179,1180,1181,1182,1183,1184,1187,1185,1186,1188,1189,1195,1196,1210,1209,1208,1213,1152))
0.001	SELECT * FROM Category WHERE parentId = 1152
0.002	SELECT * FROM Category WHERE parentId = 1155
0.001	SELECT * FROM Category WHERE parentId = 1167
0.001	SELECT * FROM Category WHERE parentId = 1175
0.001	SELECT Product.*, t.name AS tm_name, t.homepage AS tm_homepage, t.garancijskaDoba as tm_garancija, Product.preorder, count(productdiscount.productId)>0 AS hasqdisc FROM Product LEFT JOIN trademark AS t ON t.id=Product.trademarkId LEFT JOIN productdiscount ON Product.id=productdiscount.productId WHERE Product.id=1691 GROUP BY Product.id
0.001	SELECT * FROM productdiscount WHERE productId=1691 AND priceType='normal' ORDER BY minquantity
0.001	SELECT p.*, pr.productId AS prProductId, pr.discount AS prDiscount, pr.gross1Discount AS prGross1Discount, pr.gross2Discount AS prGross2Discount, pr.quantity as prQuantity FROM ProductRelation pr JOIN Product p ON p.id=pr.relatedProductId WHERE productId=1691 AND definesPackagePart='yes'
0.001	SELECT * FROM Product WHERE id IN (SELECT DISTINCT relatedProductId FROM ProductRelation WHERE productId = 1691 AND definesPackagePart='no' AND additional_product = '0') AND active='yes' ORDER BY (Product.unitPrice*(1-Product.discount/100))
0.002	SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (81,171,470,535,206,1070,1072,1073,1069,1075,1074,1071,1068,1076,264,311,333,691,518,734,684,685,686,687,688,689,517,683,534,1101,1102,573,645,653,776,833,783,784,785,786,787,788,979,802,1029,91,281,282,283,324,1230,474,502,1035,1036,1037,504,506,611,580,581,596,481,855,856,857,858,482,1056,1057,496,497,498,587,709,739,748,750,1083,892,655,503,1063,1064,472,514,600,601,603,602,475,552,553,554,476,690,576,577,578,588,626,708,738,751,752,756,477,516,682,680,681,840,1194,515,1062,1065,624,629,630,632,634,635,636,637,638,793,794,795,796,797,798,799,800,960,1125,631,639,640,641,642,643,1041,1042,1043,1200,1201,1202,644,712,976,1005,1006,1007,1008,963,965,975,988,989,1027,1032,1149,1148,1106,1107,1108,1109,1110,1111,1112,1113,1126,1133,1134,1135,1136,1137,1138,1139,1140,1141,1216,2) OR category2Id IN (81,171,470,535,206,1070,1072,1073,1069,1075,1074,1071,1068,1076,264,311,333,691,518,734,684,685,686,687,688,689,517,683,534,1101,1102,573,645,653,776,833,783,784,785,786,787,788,979,802,1029,91,281,282,283,324,1230,474,502,1035,1036,1037,504,506,611,580,581,596,481,855,856,857,858,482,1056,1057,496,497,498,587,709,739,748,750,1083,892,655,503,1063,1064,472,514,600,601,603,602,475,552,553,554,476,690,576,577,578,588,626,708,738,751,752,756,477,516,682,680,681,840,1194,515,1062,1065,624,629,630,632,634,635,636,637,638,793,794,795,796,797,798,799,800,960,1125,631,639,640,641,642,643,1041,1042,1043,1200,1201,1202,644,712,976,1005,1006,1007,1008,963,965,975,988,989,1027,1032,1149,1148,1106,1107,1108,1109,1110,1111,1112,1113,1126,1133,1134,1135,1136,1137,1138,1139,1140,1141,1216,2))
0.002	SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (115,174,597,599,598,740,982,983,621,424,540,425,426,427,428,832,741,742,743,744,882,986,987,745,891,984,985,746,747,876,958,1086,1087,1088,1089,1097,1100,1128,1227,1226,5) OR category2Id IN (115,174,597,599,598,740,982,983,621,424,540,425,426,427,428,832,741,742,743,744,882,986,987,745,891,984,985,746,747,876,958,1086,1087,1088,1089,1097,1100,1128,1227,1226,5))
0.002	SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (957,956,139,233,250,991,992,993,994,995,996,997,998,999,1000,1067,244,367,245,246,1077,389,943,946,947,948,949,950,951,952,953,955,1033,773,834,835,1002,1003,837,941,940,836,939,1034,945,1016,1030,1129,1127,1214,1217,1218,1219,1228,6) OR category2Id IN (957,956,139,233,250,991,992,993,994,995,996,997,998,999,1000,1067,244,367,245,246,1077,389,943,946,947,948,949,950,951,952,953,955,1033,773,834,835,1002,1003,837,941,940,836,939,1034,945,1016,1030,1129,1127,1214,1217,1218,1219,1228,6))
0.001	SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (1046,1004,859,860,861,862,863,864,865,977,980,1203,866,868,869,870,1038,1039,1040,1198,1199,1197,871,872,873,874,981,966,1009,1010,1011,1012,1013,1014,1015,1025,1028,1091,1103,1151,1193,1190,1191,1192,1205,1220,1221,1222,1223,1225,408) OR category2Id IN (1046,1004,859,860,861,862,863,864,865,977,980,1203,866,868,869,870,1038,1039,1040,1198,1199,1197,871,872,873,874,981,966,1009,1010,1011,1012,1013,1014,1015,1025,1028,1091,1103,1151,1193,1190,1191,1192,1205,1220,1221,1222,1223,1225,408))
0.001	SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (843,844,845,846,841,842,1079,1082,1081,847,848,849,850,853,1026,1215,877,1017,1093,1098,1099,1159,84) OR category2Id IN (843,844,845,846,841,842,1079,1082,1081,847,848,849,850,853,1026,1215,877,1017,1093,1098,1099,1159,84))
0.002	SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (555,671,727,728,729,672,730,731,732,673,670,724,725,726,875,887,889,888,1020,1021,1095,354,356,357,359,358,383,384,385,274,313,838,334,335,336,839,931,964,1045,364,365,366,350,657,656,658,352,667,678,677,775,765,766,767,768,769,770,771,772,1054,377,378,379,401,402,403,404,405,1047,704,707,710,959,974,1078,1019,1022,1023,1044,1084,1085,1090,1096,1160,1204,1211,1224,1229,1231,197) OR category2Id IN (555,671,727,728,729,672,730,731,732,673,670,724,725,726,875,887,889,888,1020,1021,1095,354,356,357,359,358,383,384,385,274,313,838,334,335,336,839,931,964,1045,364,365,366,350,657,656,658,352,667,678,677,775,765,766,767,768,769,770,771,772,1054,377,378,379,401,402,403,404,405,1047,704,707,710,959,974,1078,1019,1022,1023,1044,1084,1085,1090,1096,1160,1204,1211,1224,1229,1231,197))
0.002	SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (893,935,897,899,921,925,926,898,920,919,927,928,929,930,967,968,969,970,971,972,973,896,895,901,903,904,905,906,909,910,913,938,990,1018,1053,937,894,934,932,933,914,915,916,917,918,961,1024,936,1048,1049,1051,1050,1052,1130,625) OR category2Id IN (893,935,897,899,921,925,926,898,920,919,927,928,929,930,967,968,969,970,971,972,973,896,895,901,903,904,905,906,909,910,913,938,990,1018,1053,937,894,934,932,933,914,915,916,917,918,961,1024,936,1048,1049,1051,1050,1052,1130,625))
0.002	SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (1153,1156,1154,1155,1157,1158,1212,1161,1162,1163,1164,1167,1166,1165,1206,1207,1175,1176,1177,1178,1168,1172,1173,1174,1170,1169,1171,1179,1180,1181,1182,1183,1184,1187,1185,1186,1188,1189,1195,1196,1210,1209,1208,1213,1152) OR category2Id IN (1153,1156,1154,1155,1157,1158,1212,1161,1162,1163,1164,1167,1166,1165,1206,1207,1175,1176,1177,1178,1168,1172,1173,1174,1170,1169,1171,1179,1180,1181,1182,1183,1184,1187,1185,1186,1188,1189,1195,1196,1210,1209,1208,1213,1152))
0.001	SELECT COUNT(*) AS product_count FROM Product WHERE Product.id IN (4,63,88,182,196,241,306,415,561,577,617,640,658,799,1180,1184,1195,1213,1309,1360,1570,1575,1751,1801,1938,2020,2330) AND Product.active = "yes" GROUP BY Product.id ORDER BY Product.sequence ASC
0.001	SELECT Product.* FROM Product WHERE Product.id IN (4,63,88,182,196,241,306,415,561,577,617,640,658,799,1180,1184,1195,1213,1309,1360,1570,1575,1751,1801,1938,2020,2330) AND Product.active = "yes" GROUP BY Product.id ORDER BY Product.sequence ASC LIMIT 5
0.001	SELECT p.*, pr.productId AS prProductId, pr.discount AS prDiscount, pr.gross1Discount AS prGross1Discount, pr.gross2Discount AS prGross2Discount, pr.quantity as prQuantity FROM ProductRelation pr JOIN Product p ON p.id=pr.relatedProductId WHERE productId=63 AND definesPackagePart='yes'
0.001	SELECT p.*, pr.productId AS prProductId, pr.discount AS prDiscount, pr.gross1Discount AS prGross1Discount, pr.gross2Discount AS prGross2Discount, pr.quantity as prQuantity FROM ProductRelation pr JOIN Product p ON p.id=pr.relatedProductId WHERE productId=182 AND definesPackagePart='yes'
0.001	SELECT p.*, pr.productId AS prProductId, pr.discount AS prDiscount, pr.gross1Discount AS prGross1Discount, pr.gross2Discount AS prGross2Discount, pr.quantity as prQuantity FROM ProductRelation pr JOIN Product p ON p.id=pr.relatedProductId WHERE productId=617 AND definesPackagePart='yes'

EZVIZ HP7 2-FAMILY KIT BARVNI VIDEO DOMOFON

Opis

Specifikacija

Kategorije

Naj izdelki