Prikaži
Sortiraj po
0.002 SELECT `real_path` FROM `url_rewrites` WHERE `requested_path` = "/1200mm-673.html"
0.19 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.004 SELECT * FROM Category ORDER BY sequence
0.001 SELECT * FROM Category WHERE parentId = 516
0.001 SELECT * FROM Category WHERE parentId = 84
0.001 SELECT * FROM Category WHERE parentId = 919
0.001 SELECT * FROM Category WHERE parentId = 990
0.003 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,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,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 * FROM Category WHERE parentId = 800
0.001 SELECT * FROM Category WHERE parentId = 1005
0.003 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,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,5))
0.001 SELECT * FROM Category WHERE parentId = 5
0.002 SELECT * FROM Category WHERE parentId = 621
0.003 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,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,6))
0.001 SELECT * FROM Category WHERE parentId = 6
0.003 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,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,408))
0.001 SELECT id FROM Category WHERE parentID = 84
0.004 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,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,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.013 SELECT COUNT(*) AS product_count FROM Product WHERE (Product.categoryId IN (1,2,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,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,5,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,6,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,84,843,844,845,846,841,842,1079,1082,1081,847,848,849,850,853,1026,1215,877,1017,1093,1098,1099,1159,197,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,408,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,625,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,1152,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,1524,35,36,37,38,39,40,41,42,43,44,45,46,0) OR Product.category2Id IN (1,2,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,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,5,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,6,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,84,843,844,845,846,841,842,1079,1082,1081,847,848,849,850,853,1026,1215,877,1017,1093,1098,1099,1159,197,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,408,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,625,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,1152,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,1524,35,36,37,38,39,40,41,42,43,44,45,46,0))AND Product.active = "yes" GROUP BY Product.id ORDER BY Product.sequence ASC
0.003 SELECT Product.* FROM Product WHERE (Product.categoryId IN (1,2,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,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,5,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,6,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,84,843,844,845,846,841,842,1079,1082,1081,847,848,849,850,853,1026,1215,877,1017,1093,1098,1099,1159,197,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,408,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,625,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,1152,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,1524,35,36,37,38,39,40,41,42,43,44,45,46,0) OR Product.category2Id IN (1,2,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,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,5,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,6,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,84,843,844,845,846,841,842,1079,1082,1081,847,848,849,850,853,1026,1215,877,1017,1093,1098,1099,1159,197,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,408,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,625,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,1152,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,1524,35,36,37,38,39,40,41,42,43,44,45,46,0))AND Product.active = "yes" GROUP BY Product.id ORDER BY Product.sequence ASC LIMIT 0,20
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=3 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=22 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=33 AND definesPackagePart='yes'
0.031 SELECT Product.* FROM Product WHERE (Product.categoryId IN (1,2,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,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,5,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,6,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,84,843,844,845,846,841,842,1079,1082,1081,847,848,849,850,853,1026,1215,877,1017,1093,1098,1099,1159,197,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,408,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,625,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,1152,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,1524,35,36,37,38,39,40,41,42,43,44,45,46,0) OR Product.category2Id IN (1,2,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,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,5,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,6,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,84,843,844,845,846,841,842,1079,1082,1081,847,848,849,850,853,1026,1215,877,1017,1093,1098,1099,1159,197,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,408,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,625,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,1152,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,1524,35,36,37,38,39,40,41,42,43,44,45,46,0))AND Product.active = "yes" GROUP BY Product.id ORDER BY Product.sequence ASC
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=3 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=22 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=25 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=33 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=2058 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=62 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=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=64 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=65 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=66 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=67 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=70 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=73 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=83 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=87 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=89 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=96 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=118 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=123 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=127 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=144 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=149 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=154 AND definesPackagePart='yes'
0.006 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=232 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=235 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=236 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=241 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=291 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=384 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=386 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=392 AND definesPackagePart='yes'
0.002 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=393 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=395 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=399 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=400 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=401 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=402 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=403 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=404 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=405 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=406 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=408 AND definesPackagePart='yes'
0.004 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=409 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=411 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=414 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=424 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=426 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=429 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=455 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=461 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=462 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=473 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=475 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=476 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=479 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=480 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=483 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=484 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=487 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=488 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=494 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=495 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=498 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=499 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=502 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=506 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=507 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=510 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=517 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=531 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=533 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=536 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=553 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=571 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=572 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=575 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=583 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=584 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=585 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=588 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=606 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=610 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=618 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=619 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=623 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=624 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=625 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=626 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=630 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=631 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=634 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=640 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=643 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=648 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=656 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=664 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=665 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=667 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=721 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=772 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=868 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=952 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=1004 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=1005 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=1006 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=1010 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=1011 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=1012 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=1016 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=1017 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=1018 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=1019 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=1020 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=1022 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=1024 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=1025 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=1026 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=1027 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=1028 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=1029 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=1030 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=1031 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=1044 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=1045 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=1047 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=1048 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=1049 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=1050 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=1051 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=1052 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=1053 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=1054 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=1055 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=1056 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=1058 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=1059 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=1060 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=1061 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=1062 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=1063 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=1064 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=1065 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=1066 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=1068 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=1073 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=1077 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=1078 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=1079 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=1080 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=1081 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=1082 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=1083 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=1084 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=1086 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=1089 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=1092 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=1093 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=1094 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=1095 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=1097 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=1098 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=1100 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=1102 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=1103 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=1104 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=1106 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=1107 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=1108 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=1109 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=1111 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=1112 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=1113 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=1115 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=1116 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=1119 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=1120 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=1121 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=1123 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=1124 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=1125 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=1126 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=1127 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=1128 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=1129 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=1130 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=1131 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=1132 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=1133 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=1134 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=1135 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=1136 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=1137 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=1138 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=1139 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=1140 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=1141 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=1144 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=1148 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=1149 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=1150 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=1151 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=1152 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=1153 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=1154 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=1155 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=1156 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=1157 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=1159 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=1160 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=1161 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=1162 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=1163 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=1164 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=1166 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=1167 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=1168 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=1171 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=1172 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=1177 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=1178 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=1179 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=1180 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=1181 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=1182 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=1184 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=1185 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=1186 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=1188 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=1189 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=1197 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=1199 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=1205 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=1206 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=1209 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=1211 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=1212 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=1213 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=1216 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=1221 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=1223 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=1225 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=1232 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=1234 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=1235 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=1239 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=1253 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=1270 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=1284 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=1288 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=1330 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=1508 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=1527 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=1909 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=1549 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=1591 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=1618 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=1619 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=1783 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=1785 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=1786 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=1787 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=1789 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=1792 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=1793 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=1795 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=1799 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=1800 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=1803 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=1824 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=1826 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=1827 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=1828 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=1891 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=1893 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=1901 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=1921 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=1945 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=1946 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=1947 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=1988 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=1995 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=1998 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=2030 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=2020 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=2042 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=2052 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=2149 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=2163 AND definesPackagePart='yes'
0.002 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=2191 AND definesPackagePart='yes'
0.003 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,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,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,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,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,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,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,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,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,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,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.001 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.003 SELECT COUNT(*) AS product_count FROM Product WHERE (Product.categoryId IN (1,2,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,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,5,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,6,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,84,843,844,845,846,841,842,1079,1082,1081,847,848,849,850,853,1026,1215,877,1017,1093,1098,1099,1159,197,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,408,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,625,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,1152,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,1524,35,36,37,38,39,40,41,42,43,44,45,46,0) OR Product.category2Id IN (1,2,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,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,5,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,6,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,84,843,844,845,846,841,842,1079,1082,1081,847,848,849,850,853,1026,1215,877,1017,1093,1098,1099,1159,197,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,408,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,625,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,1152,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,1524,35,36,37,38,39,40,41,42,43,44,45,46,0))
0.004 SELECT Product.* FROM Product WHERE (Product.categoryId IN (1,2,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,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,5,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,6,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,84,843,844,845,846,841,842,1079,1082,1081,847,848,849,850,853,1026,1215,877,1017,1093,1098,1099,1159,197,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,408,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,625,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,1152,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,1524,35,36,37,38,39,40,41,42,43,44,45,46,0) OR Product.category2Id IN (1,2,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,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,5,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,6,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,84,843,844,845,846,841,842,1079,1082,1081,847,848,849,850,853,1026,1215,877,1017,1093,1098,1099,1159,197,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,408,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,625,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,1152,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,1524,35,36,37,38,39,40,41,42,43,44,45,46,0)) LIMIT 0,50
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=22 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=33 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=2058 AND definesPackagePart='yes'
0.003 SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 769 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0)
0.003 SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 760 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0)
0.002 SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 885 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0)
0.002 SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 880 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0)
0.003 SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 781 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0)
0.004 SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 778 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0)
0.002 SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 878 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0)
0.002 SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 876 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0)
0.003 SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 772 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0)
0.003 SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 881 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0)
0.002 SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 874 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0)
0.002 SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 918 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0)
0.003 SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 877 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0)
0.002 SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 884 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0)
0.002 SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 903 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0)
0.002 SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 879 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0)
0.004 SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 936 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0)
0.002 SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 801 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0)
0.003 SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 790 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0)
0.003 SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 864 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0)
0.003 SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 759 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0)
0.005 SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 766 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0)
0.003 SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 862 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0)
0.003 SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 839 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0)
0.004 SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 900 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0)
0.004 SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 786 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0)
0.005 SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 787 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0)
0.006 SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 767 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0)
0.003 SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 849 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0)
0.002 SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 871 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0)
0.002 SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 896 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0)
0.002 SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 863 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0)
0.002 SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 934 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0)
0.002 SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 845 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0)
0.002 SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 846 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0)
0.002 SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 883 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0)
0.002 SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 750 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0)
0.002 SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 838 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0)
0.002 SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 775 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0)
0.003 SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 768 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0)
0.002 SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 755 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0)
0.002 SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 757 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0)
0.002 SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 793 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0)
0.002 SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 922 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0)
0.001 SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 800 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0)
0.002 SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 857 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0)
0.001 SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 817 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0)
0.002 SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 795 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0)
0.001 SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 797 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0)
0.001 SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 806 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0)
0.001 SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 804 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0)
0.002 SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 796 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0)
0.001 SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 803 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0)
0.002 SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 816 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0)
0.002 SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 856 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0)
0.002 SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 930 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0)
0.002 SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 931 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0)
0.002 SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 854 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0)
0.002 SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 855 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0)
0.002 SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 889 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0)
0.002 SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 869 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0)
0.002 SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 870 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0)
0.002 SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 890 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0)
0.002 SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 791 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0)
0.002 SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 867 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0)
0.002 SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 868 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0)
0.002 SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 819 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0)
0.002 SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 920 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0)
0.002 SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 897 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0)
0.002 SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 820 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0)
0.002 SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 821 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0)
0.002 SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 898 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0)
0.002 SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 751 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0)
0.003 SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 814 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0)
0.002 SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 792 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0)
0.002 SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 844 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0)
0.002 SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 872 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0)
0.002 SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 873 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0)
0.002 SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 815 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0)
0.002 SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 887 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0)
0.002 SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 784 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0)
0.002 SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 785 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0)
0.001 SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 888 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0)
0.001 SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 752 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0)
0.002 SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 764 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0)
0.002 SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 832 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0)
0.002 SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 833 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0)
0.002 SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 765 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0)
0.002 SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 782 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0)
0.001 SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 783 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0)
0.002 SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 891 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0)
0.002 SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 899 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0)
0.002 SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 779 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0)
0.002 SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 860 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0)
0.001 SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 861 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0)
0.002 SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 780 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0)
0.002 SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 812 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0)
0.002 SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 847 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0)
0.001 SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 848 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0)
0.001 SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 813 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0)
0.002 SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 919 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0)
0.002 SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 753 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0)
0.002 SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 798 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0)
0.002 SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 802 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0)
0.002 SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 818 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0)
0.002 SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 805 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0)
0.002 SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 807 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0)
0.002 SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 901 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0)
0.001 SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 902 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0)
0.002 SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 776 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0)
0.002 SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 777 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0)
0.001 SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 754 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0)
0.002 SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 788 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0)
0.002 SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 789 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0)
0.002 SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 925 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0)
0.002 SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 808 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0)
0.001 SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 809 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0)
0.002 SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 773 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0)
0.001 SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 774 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0)
0.002 SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 865 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0)
0.001 SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 866 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0)
0.002 SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 842 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0)
0.002 SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 843 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0)
0.002 SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 810 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0)
0.002 SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 811 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0)
0.002 SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 923 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0)
0.002 SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 924 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0)
0.002 SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 932 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0)
0.004 SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 834 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0)
0.002 SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 835 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0)
0.003 SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 822 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0)
0.002 SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 823 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0)
0.003 SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 933 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0)
0.004 SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 761 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0)
0.002 SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 763 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0)
0.002 SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 794 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0)
0.002 SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 912 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0)
0.001 SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 913 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0)
0.002 SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 840 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0)
0.002 SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 841 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0)
0.002 SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 921 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0)
0.002 SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 892 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0)
0.002 SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 893 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0)
0.002 SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 836 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0)
0.001 SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 837 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0)
0.002 SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 770 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0)
0.001 SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 771 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0)
0.002 SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 826 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0)
0.001 SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 827 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0)
0.002 SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 858 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0)
0.002 SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 859 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0)
0.002 SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 850 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0)
0.002 SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 830 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0)
0.002 SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 831 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0)
0.002 SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 799 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0)
0.002 SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 851 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0)
0.002 SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 908 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0)
0.001 SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 909 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0)
0.002 SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 824 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0)
0.001 SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 825 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0)
0.002 SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 910 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0)
0.002 SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 911 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0)
0.002 SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 906 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0)
0.002 SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 907 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0)
0.002 SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 852 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0)
0.002 SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 853 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0)
0.002 SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 928 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0)
0.002 SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 929 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0)
0.002 SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 828 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0)
0.002 SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 829 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0)
0.002 SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 904 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0)
0.002 SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 905 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0)
0.002 SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 894 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0)
0.001 SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 895 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0)
0.002 SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 926 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0)
0.002 SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 927 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0)
0.002 SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 914 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0)
0.002 SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 915 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0)
0.002 SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 756 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0)
0.002 SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 916 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0)
0.002 SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 917 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0)
0.002 SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 944 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0)
0.002 SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 938 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0)
0.002 SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 937 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0)
0.002 SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 943 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0)
0.002 SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 935 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0)
0.002 SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 939 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0)
0.002 SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 941 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0)
0.002 SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 940 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0)
0.001 SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 942 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0)
0.002 SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 945 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0)
0.002 SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 946 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0)
0.002 SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 886 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0)
0.002 SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 882 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0)
0.002 SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 758 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0)
0.005 SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 762 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0)
0.004 SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 875 ) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0)