|
0.003 |
SELECT `real_path` FROM `url_rewrites` WHERE `requested_path` = "/1200mm-673.html" |
|
0.249 |
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.006 |
SELECT * FROM Category ORDER BY sequence |
|
0.001 |
SELECT * FROM trademark ORDER BY name ASC |
|
0.001 |
SELECT * FROM Category WHERE parentId = 2 |
|
0.001 |
SELECT id FROM Category WHERE parentID = 788 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 81 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 482 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 587 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 1219 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 408 |
|
0.001 |
SELECT id FROM Category WHERE parentID = 1046 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 1203 |
|
0.001 |
SELECT id FROM Category WHERE parentID = 1012 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 197 |
|
0.001 |
SELECT id FROM Category WHERE parentID = 1020 |
|
0.001 |
SELECT id FROM Category WHERE parentID = 1021 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 729 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 672 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 672 |
|
0.001 |
SELECT id FROM Category WHERE parentID = 385 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 964 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 768 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 769 |
|
0.001 |
SELECT id FROM Category WHERE parentID = 378 |
|
0.001 |
SELECT id FROM Category WHERE parentID = 973 |
|
0.001 |
SELECT id FROM Category WHERE parentID = 896 |
|
0.001 |
SELECT id FROM Category WHERE parentID = 895 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 930 |
|
0.001 |
SELECT id FROM Category WHERE parentID = 933 |
|
0.002 |
SELECT * FROM Category WHERE parentId = 1051 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 1050 |
|
0.001 |
SELECT id FROM Category WHERE parentID = 1161 |
|
0.001 |
SELECT id FROM Category WHERE parentID = 2 |
|
0.004 |
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.001 |
SELECT * FROM Category WHERE parentId = 2 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 81 |
|
0.005 |
SELECT * FROM Category WHERE parentId = 691 |
|
0.002 |
SELECT * FROM Category WHERE parentId = 518 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 517 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 776 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 776 |
|
0.002 |
SELECT * FROM Category WHERE parentId = 474 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 580 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 482 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 800 |
|
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.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.002 |
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.003 |
SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (555,671,727,728,729,672,730,731,732,673,670,724,725,726,875,887,889,888,1020,1021,1095,354,356,357,359,358,383,384,385,274,313,838,334,335,336,839,931,964,1045,364,365,366,350,657,656,658,352,667,678,677,775,765,766,767,768,769,770,771,772,1054,377,378,379,401,402,403,404,405,1047,704,707,710,959,974,1078,1019,1022,1023,1044,1084,1085,1090,1096,1160,1204,1211,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.001 |
SELECT * FROM Category WHERE parentId = 197 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 838 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 336 |
|
0.002 |
SELECT * FROM Category WHERE parentId = 931 |
|
0.001 |
SELECT * FROM Category WHERE parentId = 364 |
|
0.003 |
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.001 |
SELECT * FROM Category WHERE parentId = 1169 |
|
0.001 |
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"AND pp.`value` IN (918) GROUP BY pp.productId HAVING COUNT(pp.productId) = 1 GROUP BY Product.id ORDER BY Product.sequence ASC |
|
0.001 |
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"AND pp.`value` IN (918) GROUP BY pp.productId HAVING COUNT(pp.productId) = 1 GROUP BY Product.id ORDER BY Product.sequence ASC |
|
0.001 |
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"AND pp.`value` IN (918) GROUP BY pp.productId HAVING COUNT(pp.productId) = 1 GROUP BY Product.id ORDER BY Product.sequence ASC |
|
0.004 |
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.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.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.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.002 |
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.003 |
SELECT COUNT(*) AS count FROM Product WHERE (categoryId IN (555,671,727,728,729,672,730,731,732,673,670,724,725,726,875,887,889,888,1020,1021,1095,354,356,357,359,358,383,384,385,274,313,838,334,335,336,839,931,964,1045,364,365,366,350,657,656,658,352,667,678,677,775,765,766,767,768,769,770,771,772,1054,377,378,379,401,402,403,404,405,1047,704,707,710,959,974,1078,1019,1022,1023,1044,1084,1085,1090,1096,1160,1204,1211,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.003 |
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.004 |
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.007 |
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=1 AND definesPackagePart='yes' |
|
0.001 |
SELECT p.*, pr.productId AS prProductId, pr.discount AS prDiscount, pr.gross1Discount AS prGross1Discount, pr.gross2Discount AS prGross2Discount, pr.quantity as prQuantity FROM ProductRelation pr JOIN Product p ON p.id=pr.relatedProductId WHERE productId=7 AND definesPackagePart='yes' |
|
0.001 |
SELECT p.*, pr.productId AS prProductId, pr.discount AS prDiscount, pr.gross1Discount AS prGross1Discount, pr.gross2Discount AS prGross2Discount, pr.quantity as prQuantity FROM ProductRelation pr JOIN Product p ON p.id=pr.relatedProductId WHERE productId=10 AND definesPackagePart='yes' |
|
0.001 |
SELECT p.*, pr.productId AS prProductId, pr.discount AS prDiscount, pr.gross1Discount AS prGross1Discount, pr.gross2Discount AS prGross2Discount, pr.quantity as prQuantity FROM ProductRelation pr JOIN Product p ON p.id=pr.relatedProductId WHERE productId=11 AND definesPackagePart='yes' |
|
0.001 |
SELECT p.*, pr.productId AS prProductId, pr.discount AS prDiscount, pr.gross1Discount AS prGross1Discount, pr.gross2Discount AS prGross2Discount, pr.quantity as prQuantity FROM ProductRelation pr JOIN Product p ON p.id=pr.relatedProductId WHERE productId=12 AND definesPackagePart='yes' |
|
0.001 |
SELECT p.*, pr.productId AS prProductId, pr.discount AS prDiscount, pr.gross1Discount AS prGross1Discount, pr.gross2Discount AS prGross2Discount, pr.quantity as prQuantity FROM ProductRelation pr JOIN Product p ON p.id=pr.relatedProductId WHERE productId=13 AND definesPackagePart='yes' |
|
0.001 |
SELECT p.*, pr.productId AS prProductId, pr.discount AS prDiscount, pr.gross1Discount AS prGross1Discount, pr.gross2Discount AS prGross2Discount, pr.quantity as prQuantity FROM ProductRelation pr JOIN Product p ON p.id=pr.relatedProductId WHERE productId=14 AND definesPackagePart='yes' |
|
0.001 |
SELECT p.*, pr.productId AS prProductId, pr.discount AS prDiscount, pr.gross1Discount AS prGross1Discount, pr.gross2Discount AS prGross2Discount, pr.quantity as prQuantity FROM ProductRelation pr JOIN Product p ON p.id=pr.relatedProductId WHERE productId=15 AND definesPackagePart='yes' |
|
0.001 |
SELECT p.*, pr.productId AS prProductId, pr.discount AS prDiscount, pr.gross1Discount AS prGross1Discount, pr.gross2Discount AS prGross2Discount, pr.quantity as prQuantity FROM ProductRelation pr JOIN Product p ON p.id=pr.relatedProductId WHERE productId=17 AND definesPackagePart='yes' |
|
0.001 |
SELECT p.*, pr.productId AS prProductId, pr.discount AS prDiscount, pr.gross1Discount AS prGross1Discount, pr.gross2Discount AS prGross2Discount, pr.quantity as prQuantity FROM ProductRelation pr JOIN Product p ON p.id=pr.relatedProductId WHERE productId=19 AND definesPackagePart='yes' |
|
0.001 |
SELECT p.*, pr.productId AS prProductId, pr.discount AS prDiscount, pr.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.001 |
SELECT p.*, pr.productId AS prProductId, pr.discount AS prDiscount, pr.gross1Discount AS prGross1Discount, pr.gross2Discount AS prGross2Discount, pr.quantity as prQuantity FROM ProductRelation pr JOIN Product p ON p.id=pr.relatedProductId WHERE productId=44 AND definesPackagePart='yes' |
|
0.001 |
SELECT p.*, pr.productId AS prProductId, pr.discount AS prDiscount, pr.gross1Discount AS prGross1Discount, pr.gross2Discount AS prGross2Discount, pr.quantity as prQuantity FROM ProductRelation pr JOIN Product p ON p.id=pr.relatedProductId WHERE productId=45 AND definesPackagePart='yes' |
|
0.001 |
SELECT p.*, pr.productId AS prProductId, pr.discount AS prDiscount, pr.gross1Discount AS prGross1Discount, pr.gross2Discount AS prGross2Discount, pr.quantity as prQuantity FROM ProductRelation pr JOIN Product p ON p.id=pr.relatedProductId WHERE productId=47 AND definesPackagePart='yes' |
|
0.007 |
SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 769 AND p.id IN (SELECT productId FROM productproperty WHERE value IN (918))) 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 = 760 AND p.id IN (SELECT productId FROM productproperty WHERE value IN (918))) 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 = 885 AND p.id IN (SELECT productId FROM productproperty WHERE value IN (918))) 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 = 880 AND p.id IN (SELECT productId FROM productproperty WHERE value IN (918))) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0) |
|
0.007 |
SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 781 AND p.id IN (SELECT productId FROM productproperty WHERE value IN (918))) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0) |
|
0.008 |
SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 778 AND p.id IN (SELECT productId FROM productproperty WHERE value IN (918))) 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 = 878 AND p.id IN (SELECT productId FROM productproperty WHERE value IN (918))) 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 = 876 AND p.id IN (SELECT productId FROM productproperty WHERE value IN (918))) 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 = 772 AND p.id IN (SELECT productId FROM productproperty WHERE value IN (918))) 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 = 881 AND p.id IN (SELECT productId FROM productproperty WHERE value IN (918))) 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 = 874 AND p.id IN (SELECT productId FROM productproperty WHERE value IN (918))) 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 = 918 AND p.id IN (SELECT productId FROM productproperty WHERE value IN (918))) 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 = 877 AND p.id IN (SELECT productId FROM productproperty WHERE value IN (918))) 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 = 884 AND p.id IN (SELECT productId FROM productproperty WHERE value IN (918))) 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 = 903 AND p.id IN (SELECT productId FROM productproperty WHERE value IN (918))) 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 = 879 AND p.id IN (SELECT productId FROM productproperty WHERE value IN (918))) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0) |
|
0.001 |
SELECT distinct value, id FROM producttypepropertyvalue where productTypePropertyId=159 and value is not null and value<>'' ORDER BY CAST( value AS SIGNED INTEGER ) ASC, value ASC |
|
0.008 |
SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 936 AND p.id IN (SELECT productId FROM productproperty WHERE value IN (918))) 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 = 801 AND p.id IN (SELECT productId FROM productproperty WHERE value IN (918))) 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 = 790 AND p.id IN (SELECT productId FROM productproperty WHERE value IN (918))) 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 = 864 AND p.id IN (SELECT productId FROM productproperty WHERE value IN (918))) 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 = 759 AND p.id IN (SELECT productId FROM productproperty WHERE value IN (918))) 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 AND p.id IN (SELECT productId FROM productproperty WHERE value IN (918))) 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 = 862 AND p.id IN (SELECT productId FROM productproperty WHERE value IN (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 = 839 AND p.id IN (SELECT productId FROM productproperty WHERE value IN (918))) 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 = 900 AND p.id IN (SELECT productId FROM productproperty WHERE value IN (918))) 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 = 786 AND p.id IN (SELECT productId FROM productproperty WHERE value IN (918))) 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 AND p.id IN (SELECT productId FROM productproperty WHERE value IN (918))) 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 = 767 AND p.id IN (SELECT productId FROM productproperty WHERE value IN (918))) 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 = 849 AND p.id IN (SELECT productId FROM productproperty WHERE value IN (918))) 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 = 871 AND p.id IN (SELECT productId FROM productproperty WHERE value IN (918))) 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 = 896 AND p.id IN (SELECT productId FROM productproperty WHERE value IN (918))) 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 = 863 AND p.id IN (SELECT productId FROM productproperty WHERE value IN (918))) 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 = 934 AND p.id IN (SELECT productId FROM productproperty WHERE value IN (918))) 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 = 845 AND p.id IN (SELECT productId FROM productproperty WHERE value IN (918))) 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 = 846 AND p.id IN (SELECT productId FROM productproperty WHERE value IN (918))) 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 = 883 AND p.id IN (SELECT productId FROM productproperty WHERE value IN (918))) 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 = 750 AND p.id IN (SELECT productId FROM productproperty WHERE value IN (918))) 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 = 838 AND p.id IN (SELECT productId FROM productproperty WHERE value IN (918))) 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 = 775 AND p.id IN (SELECT productId FROM productproperty WHERE value IN (918))) 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 = 768 AND p.id IN (SELECT productId FROM productproperty WHERE value IN (918))) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0) |
|
0.001 |
SELECT distinct value, id FROM producttypepropertyvalue where productTypePropertyId=160 and value is not null and value<>'' ORDER BY CAST( value AS SIGNED INTEGER ) ASC, value ASC |
|
0.003 |
SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 755 AND p.id IN (SELECT productId FROM productproperty WHERE value IN (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 = 757 AND p.id IN (SELECT productId FROM productproperty WHERE value IN (918))) 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 AND p.id IN (SELECT productId FROM productproperty WHERE value IN (918))) 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 = 922 AND p.id IN (SELECT productId FROM productproperty WHERE value IN (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 = 800 AND p.id IN (SELECT productId FROM productproperty WHERE value IN (918))) 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 AND p.id IN (SELECT productId FROM productproperty WHERE value IN (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 = 817 AND p.id IN (SELECT productId FROM productproperty WHERE value IN (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 = 795 AND p.id IN (SELECT productId FROM productproperty WHERE value IN (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 = 797 AND p.id IN (SELECT productId FROM productproperty WHERE value IN (918))) 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 = 806 AND p.id IN (SELECT productId FROM productproperty WHERE value IN (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 = 804 AND p.id IN (SELECT productId FROM productproperty WHERE value IN (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 = 796 AND p.id IN (SELECT productId FROM productproperty WHERE value IN (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 = 803 AND p.id IN (SELECT productId FROM productproperty WHERE value IN (918))) 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 = 816 AND p.id IN (SELECT productId FROM productproperty WHERE value IN (918))) 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 = 856 AND p.id IN (SELECT productId FROM productproperty WHERE value IN (918))) 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 = 930 AND p.id IN (SELECT productId FROM productproperty WHERE value IN (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 = 931 AND p.id IN (SELECT productId FROM productproperty WHERE value IN (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 = 854 AND p.id IN (SELECT productId FROM productproperty WHERE value IN (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 = 855 AND p.id IN (SELECT productId FROM productproperty WHERE value IN (918))) 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 = 889 AND p.id IN (SELECT productId FROM productproperty WHERE value IN (918))) 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 = 869 AND p.id IN (SELECT productId FROM productproperty WHERE value IN (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 = 870 AND p.id IN (SELECT productId FROM productproperty WHERE value IN (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 = 890 AND p.id IN (SELECT productId FROM productproperty WHERE value IN (918))) 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 = 791 AND p.id IN (SELECT productId FROM productproperty WHERE value IN (918))) 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 = 867 AND p.id IN (SELECT productId FROM productproperty WHERE value IN (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 = 868 AND p.id IN (SELECT productId FROM productproperty WHERE value IN (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 = 819 AND p.id IN (SELECT productId FROM productproperty WHERE value IN (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 = 920 AND p.id IN (SELECT productId FROM productproperty WHERE value IN (918))) 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 = 897 AND p.id IN (SELECT productId FROM productproperty WHERE value IN (918))) 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 = 820 AND p.id IN (SELECT productId FROM productproperty WHERE value IN (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 = 821 AND p.id IN (SELECT productId FROM productproperty WHERE value IN (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 = 898 AND p.id IN (SELECT productId FROM productproperty WHERE value IN (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 = 751 AND p.id IN (SELECT productId FROM productproperty WHERE value IN (918))) 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 = 814 AND p.id IN (SELECT productId FROM productproperty WHERE value IN (918))) 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 = 792 AND p.id IN (SELECT productId FROM productproperty WHERE value IN (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 = 844 AND p.id IN (SELECT productId FROM productproperty WHERE value IN (918))) 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 = 872 AND p.id IN (SELECT productId FROM productproperty WHERE value IN (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 = 873 AND p.id IN (SELECT productId FROM productproperty WHERE value IN (918))) 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 = 815 AND p.id IN (SELECT productId FROM productproperty WHERE value IN (918))) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0) |
|
0.007 |
SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 887 AND p.id IN (SELECT productId FROM productproperty WHERE value IN (918))) 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 = 784 AND p.id IN (SELECT productId FROM productproperty WHERE value IN (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 = 785 AND p.id IN (SELECT productId FROM productproperty WHERE value IN (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 = 888 AND p.id IN (SELECT productId FROM productproperty WHERE value IN (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 = 752 AND p.id IN (SELECT productId FROM productproperty WHERE value IN (918))) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0) |
|
0.007 |
SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 764 AND p.id IN (SELECT productId FROM productproperty WHERE value IN (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 = 832 AND p.id IN (SELECT productId FROM productproperty WHERE value IN (918))) 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 AND p.id IN (SELECT productId FROM productproperty WHERE value IN (918))) 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 = 765 AND p.id IN (SELECT productId FROM productproperty WHERE value IN (918))) 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 = 782 AND p.id IN (SELECT productId FROM productproperty WHERE value IN (918))) 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 = 783 AND p.id IN (SELECT productId FROM productproperty WHERE value IN (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 = 891 AND p.id IN (SELECT productId FROM productproperty WHERE value IN (918))) 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 AND p.id IN (SELECT productId FROM productproperty WHERE value IN (918))) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0) |
|
0.009 |
SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 779 AND p.id IN (SELECT productId FROM productproperty WHERE value IN (918))) 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 = 860 AND p.id IN (SELECT productId FROM productproperty WHERE value IN (918))) 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 = 861 AND p.id IN (SELECT productId FROM productproperty WHERE value IN (918))) 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 AND p.id IN (SELECT productId FROM productproperty WHERE value IN (918))) 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 = 812 AND p.id IN (SELECT productId FROM productproperty WHERE value IN (918))) 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 AND p.id IN (SELECT productId FROM productproperty WHERE value IN (918))) 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 = 848 AND p.id IN (SELECT productId FROM productproperty WHERE value IN (918))) 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 = 813 AND p.id IN (SELECT productId FROM productproperty WHERE value IN (918))) 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 = 919 AND p.id IN (SELECT productId FROM productproperty WHERE value IN (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 = 753 AND p.id IN (SELECT productId FROM productproperty WHERE value IN (918))) 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 = 798 AND p.id IN (SELECT productId FROM productproperty WHERE value IN (918))) 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 = 802 AND p.id IN (SELECT productId FROM productproperty WHERE value IN (918))) 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 = 818 AND p.id IN (SELECT productId FROM productproperty WHERE value IN (918))) 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 = 805 AND p.id IN (SELECT productId FROM productproperty WHERE value IN (918))) 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 AND p.id IN (SELECT productId FROM productproperty WHERE value IN (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 = 901 AND p.id IN (SELECT productId FROM productproperty WHERE value IN (918))) 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 = 902 AND p.id IN (SELECT productId FROM productproperty WHERE value IN (918))) 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 = 776 AND p.id IN (SELECT productId FROM productproperty WHERE value IN (918))) 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 AND p.id IN (SELECT productId FROM productproperty WHERE value IN (918))) 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 = 754 AND p.id IN (SELECT productId FROM productproperty WHERE value IN (918))) 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 = 788 AND p.id IN (SELECT productId FROM productproperty WHERE value IN (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 = 789 AND p.id IN (SELECT productId FROM productproperty WHERE value IN (918))) 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 = 925 AND p.id IN (SELECT productId FROM productproperty WHERE value IN (918))) 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 = 808 AND p.id IN (SELECT productId FROM productproperty WHERE value IN (918))) 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 = 809 AND p.id IN (SELECT productId FROM productproperty WHERE value IN (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 = 773 AND p.id IN (SELECT productId FROM productproperty WHERE value IN (918))) 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 = 774 AND p.id IN (SELECT productId FROM productproperty WHERE value IN (918))) 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 = 865 AND p.id IN (SELECT productId FROM productproperty WHERE value IN (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 = 866 AND p.id IN (SELECT productId FROM productproperty WHERE value IN (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 = 842 AND p.id IN (SELECT productId FROM productproperty WHERE value IN (918))) 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 AND p.id IN (SELECT productId FROM productproperty WHERE value IN (918))) 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 = 810 AND p.id IN (SELECT productId FROM productproperty WHERE value IN (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 = 811 AND p.id IN (SELECT productId FROM productproperty WHERE value IN (918))) 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 = 923 AND p.id IN (SELECT productId FROM productproperty WHERE value IN (918))) 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 AND p.id IN (SELECT productId FROM productproperty WHERE value IN (918))) 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 = 932 AND p.id IN (SELECT productId FROM productproperty WHERE value IN (918))) 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 = 834 AND p.id IN (SELECT productId FROM productproperty WHERE value IN (918))) 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 AND p.id IN (SELECT productId FROM productproperty WHERE value IN (918))) 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 = 822 AND p.id IN (SELECT productId FROM productproperty WHERE value IN (918))) 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 AND p.id IN (SELECT productId FROM productproperty WHERE value IN (918))) 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 = 933 AND p.id IN (SELECT productId FROM productproperty WHERE value IN (918))) 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 AND p.id IN (SELECT productId FROM productproperty WHERE value IN (918))) 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 AND p.id IN (SELECT productId FROM productproperty WHERE value IN (918))) 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 AND p.id IN (SELECT productId FROM productproperty WHERE value IN (918))) 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 = 912 AND p.id IN (SELECT productId FROM productproperty WHERE value IN (918))) 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 = 913 AND p.id IN (SELECT productId FROM productproperty WHERE value IN (918))) 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 = 840 AND p.id IN (SELECT productId FROM productproperty WHERE value IN (918))) 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 AND p.id IN (SELECT productId FROM productproperty WHERE value IN (918))) 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 = 921 AND p.id IN (SELECT productId FROM productproperty WHERE value IN (918))) 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 = 892 AND p.id IN (SELECT productId FROM productproperty WHERE value IN (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 = 893 AND p.id IN (SELECT productId FROM productproperty WHERE value IN (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 = 836 AND p.id IN (SELECT productId FROM productproperty WHERE value IN (918))) 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 = 837 AND p.id IN (SELECT productId FROM productproperty WHERE value IN (918))) 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 = 770 AND p.id IN (SELECT productId FROM productproperty WHERE value IN (918))) 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 = 771 AND p.id IN (SELECT productId FROM productproperty WHERE value IN (918))) 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 = 826 AND p.id IN (SELECT productId FROM productproperty WHERE value IN (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 = 827 AND p.id IN (SELECT productId FROM productproperty WHERE value IN (918))) 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 = 858 AND p.id IN (SELECT productId FROM productproperty WHERE value IN (918))) 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 AND p.id IN (SELECT productId FROM productproperty WHERE value IN (918))) 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 AND p.id IN (SELECT productId FROM productproperty WHERE value IN (918))) 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 = 830 AND p.id IN (SELECT productId FROM productproperty WHERE value IN (918))) 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 AND p.id IN (SELECT productId FROM productproperty WHERE value IN (918))) 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 AND p.id IN (SELECT productId FROM productproperty WHERE value IN (918))) 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 AND p.id IN (SELECT productId FROM productproperty WHERE value IN (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 = 908 AND p.id IN (SELECT productId FROM productproperty WHERE value IN (918))) 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 = 909 AND p.id IN (SELECT productId FROM productproperty WHERE value IN (918))) 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 = 824 AND p.id IN (SELECT productId FROM productproperty WHERE value IN (918))) 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 = 825 AND p.id IN (SELECT productId FROM productproperty WHERE value IN (918))) 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 = 910 AND p.id IN (SELECT productId FROM productproperty WHERE value IN (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 = 911 AND p.id IN (SELECT productId FROM productproperty WHERE value IN (918))) 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 = 906 AND p.id IN (SELECT productId FROM productproperty WHERE value IN (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 = 907 AND p.id IN (SELECT productId FROM productproperty WHERE value IN (918))) 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 = 852 AND p.id IN (SELECT productId FROM productproperty WHERE value IN (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 = 853 AND p.id IN (SELECT productId FROM productproperty WHERE value IN (918))) 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 = 928 AND p.id IN (SELECT productId FROM productproperty WHERE value IN (918))) 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 AND p.id IN (SELECT productId FROM productproperty WHERE value IN (918))) 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 = 828 AND p.id IN (SELECT productId FROM productproperty WHERE value IN (918))) 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 = 829 AND p.id IN (SELECT productId FROM productproperty WHERE value IN (918))) 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 = 904 AND p.id IN (SELECT productId FROM productproperty WHERE value IN (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 = 905 AND p.id IN (SELECT productId FROM productproperty WHERE value IN (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 = 894 AND p.id IN (SELECT productId FROM productproperty WHERE value IN (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 = 895 AND p.id IN (SELECT productId FROM productproperty WHERE value IN (918))) 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 = 926 AND p.id IN (SELECT productId FROM productproperty WHERE value IN (918))) 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 AND p.id IN (SELECT productId FROM productproperty WHERE value IN (918))) 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 = 914 AND p.id IN (SELECT productId FROM productproperty WHERE value IN (918))) 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 AND p.id IN (SELECT productId FROM productproperty WHERE value IN (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 = 756 AND p.id IN (SELECT productId FROM productproperty WHERE value IN (918))) 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 = 916 AND p.id IN (SELECT productId FROM productproperty WHERE value IN (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 = 917 AND p.id IN (SELECT productId FROM productproperty WHERE value IN (918))) 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 = 944 AND p.id IN (SELECT productId FROM productproperty WHERE value IN (918))) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0) |
|
0.009 |
SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 938 AND p.id IN (SELECT productId FROM productproperty WHERE value IN (918))) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0) |
|
0.013 |
SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 937 AND p.id IN (SELECT productId FROM productproperty WHERE value IN (918))) 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 = 943 AND p.id IN (SELECT productId FROM productproperty WHERE value IN (918))) 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 = 935 AND p.id IN (SELECT productId FROM productproperty WHERE value IN (918))) 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 = 939 AND p.id IN (SELECT productId FROM productproperty WHERE value IN (918))) 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 = 941 AND p.id IN (SELECT productId FROM productproperty WHERE value IN (918))) 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 = 940 AND p.id IN (SELECT productId FROM productproperty WHERE value IN (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 = 942 AND p.id IN (SELECT productId FROM productproperty WHERE value IN (918))) 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 = 945 AND p.id IN (SELECT productId FROM productproperty WHERE value IN (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 = 946 AND p.id IN (SELECT productId FROM productproperty WHERE value IN (918))) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0) |
|
0.001 |
SELECT distinct value, id FROM producttypepropertyvalue where productTypePropertyId=161 and value is not null and value<>'' ORDER BY CAST( value AS SIGNED INTEGER ) ASC, value ASC |
|
0.004 |
SELECT COUNT(*) AS count FROM productproperty pp JOIN Product p ON (pp.productId = p.id AND value = 886 AND p.id IN (SELECT productId FROM productproperty WHERE value IN (918))) 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 = 882 AND p.id IN (SELECT productId FROM productproperty WHERE value IN (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 = 758 AND p.id IN (SELECT productId FROM productproperty WHERE value IN (918))) 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 = 762 AND p.id IN (SELECT productId FROM productproperty WHERE value IN (918))) 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 = 875 AND p.id IN (SELECT productId FROM productproperty WHERE value IN (918))) WHERE p.active = 'yes' AND (p.categoryId = 0 OR p.category2Id = 0 OR p.category3Id = 0) |
