DAHUA NVR2108-I2 NVR SNEMALNIK WizSense

222,00 €
155,40 €

8 kanalni do 12Mp / Snemanje do 80Mbps / 1x AI (zaščiteno območje) / 4x SMD + (zaznavanje ljudi in vozil) / 1x prepoznava obrazov

  • Blagovna znamka:
    DAHUA
  • Koda:
    01DIP08-NVR2108-I2
  • Zaloga:
    Na zalogi

Opis

Sistem
Glavni procesor: Vgrajeni procesor industrijskega razreda
Operacijski sistem: Vgrajen Linux
Operacijski vmesnik: Splet; lokalni GUI

AI
AI s kamero: Zaznavanje obrazov; prepoznavanje obraza; zaščita perimetra; SMD Plus
AI s snemalnikom: Zaznavanje obrazov; prepoznavanje obraza; zaščita perimetra; SMD Plus

Zaščita perimetra
Perimetrska zmogljivost AI s snemalnikom (število kanalov): 1
Perimetrska zmogljivost AI s kamero (število kanalov): 4

Zaznavanje obrazov
Lastnosti obraza: 6 lastnosti: Spol; starostna skupina (6); očala; izrazi (8); zaščitna maska; brada
Zmogljivost zaznavanja obrazov AI s snemalnikom (1080P) (število kanalov): 1 (do 12 slik obraza/sekundo)
Učinkovitost zaznavanja obrazov AI s kamero (število kanalov): 5

Prepoznavanje obraza
Zmogljivost zbirke podatkov o obrazih: Do 10 zbirk podatkov o obrazih s 5000 slikami
Zmogljivost prepoznavanja obraza AI s snemalnikom (1080P) (število kanalov): 1 (do 4 slike obraza/sekundo)
Učinkovitost prepoznavanja obraza AI s kamero (število kanalov): 5

SMD Plus
SMD Plus s snemalnikom: 4
SMD Plus s kamero: 6-kanalni SMD Plus (AI s kamero): Zazna prestop linije in vdor človeka ali vozila; filtrira lažne alarme, ki jih povzročajo listi, dežne kaplje in sprememba svetlosti

Video
Dostopni kanal: 8 kanalov
Pasovna širina omrežja: 80 Mb/s za dostop, 80 Mb/s za shranjevanje in 60 Mb/s za posredovanje.
Ločljivost: 12 MP; 8 MP; 5MP; 4MP; 3MP; 2 MP; 720p; D1
Zmogljivost dekodiranja: AI onemogočen: 1-kanal 12MP@30 fps; 1-kanal 8MP@30fps; 2-kanala 5MP@30 fps; 3-kanali 4MP@30 fps; 6-kanalov 1080p@30fps
AI omogočen: 1-kanal 8MP@30 fps; 1-kanal 5MP@30 fps; 2-kanala 4MP@30 fps; 4-kanali 1080p@30 fps
Video izhod: 1 × VGA, 1 × HDMI (simultano)
Večzaslonski prikaz: 1, 4, 8, 9 pogledi
Dostop do kamer drugih znamk: Onvif; RTSP;

Stiskanje
Video: Smart H.265+; H.265; Pametni H.264+; H.264; MJPEG
Avdio: PCM; G711A; G711U; G726

Omrežje
Omrežni protokol: HTTP; HTTPS; TCP/IP; IPv4; RTSP; UDP; NTP; DHCP; DNS; SMTP; UPnP; IP filter; DDNS; Alarmni strežnik; Iskanje IP (podpira IP kamere Dahua, DVR, NVS itd.); P2P; Samodejna registracija
Dostop prek mobilnega telefona: Android; iOS
Interoperabilnost: ONVIF (profil T; profil S; profil G); CGI; SDK
Brskalnik: Chrome; IE9 ali novejši; Firefox

Predvajanje posnetkov
Večkanalno predvajanje: Do 8 kanalov
Način snemanja: Ročno snemanje; alarmni posnetki; posnetki zaznavanja gibanja; načrtovana snemanja
Shranjevanje: Lokalni trdi disk in omrežje
Varnostno kopiranje: Naprava USB
Funkcija predvajanja: 1. Predvajaj; pavza; stop; hitro naprej; hitro nazaj; previjanje nazaj; predvajanje po kadru; 2. Cel zaslon; varnostna kopija (videoposnetek/datoteka); delni zoom; vklop/izklop zvoka

Alarm
Splošni alarm: Zaznavanje gibanja; maskiranje zasebnosti; izguba videa; PIR alarm; IPC alarm
Alarm za nepravilnosti: Kamera brez povezave; napaka pri shranjevanju; disk poln; konflikt IP; konflikt MAC; zaklepanje prijave; izjema kibernetske varnosti
Inteligentni alarm: Zaznavanje obraza; prepoznavanje obraza; zaščita perimetra (vdor in prestop linije); IVS; SMD Plus
Povezava alarma: Snemanje; posnetek; brenčalo; dnevnik; prednastavitev; E-naslov; tura

Vrata
Trdi disk: 1 SATA priključek, do 10 TB. Največja zmogljivost HDD se spreminja glede na temperaturo okolja
USB: 2 vrata USB 2.0 zadaj
HDMI: 1 (maks. ločljivost: 4K)
VGA: 1
Omrežje: 1 × RJ-45 (10 ali 100 Mbps)
RCA vhod: 1
RCA izhod: 1
 
Splošni parametri
Napajanje: 12 V DC, 1.5 A
Poraba energije: Skupna izhodna moč NVR je ≤ 10 W (brez HDD)
Neto teža: 0,45 kg
Bruto teža: 1,07 kg
Mere izdelka: 204.6 mm × 206.4 mm × 48.1 mm (Š × D × V)
Delovna temperatura: –10 °C do +55 °C
Temperatura shranjevanja: 0 °C do 40 °C
Delovna vlažnost: 10%–93%
Vlažnost pri shranjevanju: 30%–85%
Nadmorska višina delovanja: 3.000 m
Namestitev: Namizna

Certifikati:
FCC:47 CFR FCC Part15,SubpartB,Class A
CE-EMC:EN 55032:2015,Class A;EN IEC 61000-3-2:2019;EN 61000-3-3:2013+A1:2019;EN 55024:2010+A1:2015;EN 55035:2017;EN 50130-4:2011+A1:2014
CE-LVD:EN 62368-1:2014+A11:2017

 

Disk za shranjevanje posnetkov in PoE stikalo za povezavo ter napajanje kamer nista vključena in se dokupita po potrebi.


Specifikacija


Kompatibilen Brother
Barva cyan
Kapaciteta 15,00
Garancija 24,00
0.003 SELECT `real_path` FROM `url_rewrites` WHERE `requested_path` = "/dahua-nvr2108-i2-nvr-snemalnik-wizsense-25.html"
0.263 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.003 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=25 GROUP BY Product.id
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=25 AND definesPackagePart='yes'
0.001 SELECT * FROM Category WHERE parentId = 2
0.001 SELECT id FROM Category WHERE parentID = 734
0.001 SELECT * FROM Category WHERE parentId = 1075
0.001 SELECT id FROM Category WHERE parentID = 283
0.001 SELECT id FROM Category WHERE parentID = 516
0.004 SELECT id FROM Category WHERE parentID = 798
0.004 SELECT * FROM Category WHERE parentId = 641
0.001 SELECT * FROM Category WHERE parentId = 1202
0.001 SELECT id FROM Category WHERE parentID = 1006
0.001 SELECT * FROM Category WHERE parentId = 1008
0.001 SELECT * FROM Category WHERE parentId = 5
0.001 SELECT id FROM Category WHERE parentID = 889
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 = 506
0.001 SELECT * FROM Category WHERE parentId = 580
0.001 SELECT * FROM Category WHERE parentId = 498
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.006 SELECT * FROM Category WHERE parentId = 998
0.001 SELECT * FROM Category WHERE parentId = 952
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.001 SELECT * FROM Category WHERE parentId = 850
0.001 SELECT id FROM Category WHERE parentID = 197
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 = 658
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 * FROM Category WHERE parentId = 897
0.002 SELECT * FROM Category WHERE parentId = 899
0.006 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 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=25 GROUP BY Product.id
0.001 SELECT * FROM productdiscount WHERE productId=25 AND priceType='normal' ORDER BY minquantity
0.001 SELECT * FROM Product WHERE id IN (SELECT DISTINCT relatedProductId FROM ProductRelation WHERE productId = 25 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.001 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.001 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.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 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'