You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '8,9,10,11,12,14,17,18,19,20,21,23,24,29,30,34,35,36,38,46,47,48,49,50,51,52,53,5' at line 29SELECT p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity,
pl.`description`, pl.`description_short`, pl.`link_rewrite`, pl.`meta_description`,
pl.`meta_keywords`, pl.`meta_title`, pl.`name`,
m.`name` AS manufacturer_name, p.`id_manufacturer` as id_manufacturer,
MAX(image_shop.`id_image`) id_image, il.`legend`,
ps.`quantity` AS sales, t.`rate`, pl.`meta_keywords`, pl.`meta_title`, pl.`meta_description`,
DATEDIFF(p.`date_add`, DATE_SUB(NOW(),
INTERVAL 200 DAY)) > 0 AS new
FROM `esadownictwo_product_sale` ps
LEFT JOIN `esadownictwo_product` p ON ps.`id_product` = p.`id_product`
LEFT JOIN esadownictwo_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `esadownictwo_product_lang` pl
ON p.`id_product` = pl.`id_product`
AND pl.`id_lang` = 1 AND pl.id_shop = 1
LEFT JOIN `esadownictwo_image` i ON (i.`id_product` = p.`id_product`) LEFT JOIN esadownictwo_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1 AND image_shop.cover=1)
LEFT JOIN `esadownictwo_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1)
LEFT JOIN `esadownictwo_manufacturer` m ON (m.`id_manufacturer` = p.`id_manufacturer`)
LEFT JOIN `esadownictwo_tax_rule` tr ON (product_shop.`id_tax_rules_group` = tr.`id_tax_rules_group`)
AND tr.`id_country` = 14
AND tr.`id_state` = 0
LEFT JOIN `esadownictwo_tax` t ON (t.`id_tax` = tr.`id_tax`)
LEFT
JOIN esadownictwo_stock_available stock
ON (stock.id_product = p.id_product AND stock.id_shop = 1 )
WHERE product_shop.`active` = 1
AND p.`visibility` != 'none'
AND p.`id_product` IN (,8,9,10,11,12,14,17,18,19,20,21,23,24,29,30,34,35,36,38,46,47,48,49,50,51,52,53,54,55,57,58,59,60,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,98,99,100,101,102,103,104,105,106,107,108,109,110,113,115,116,117,118,119,121,122,123,125,126,127,129,130,132,133,135,136,137,138,139,141,142,143,144,145,146,147,148,152,153,154,155,156,158,159,160,161,163,165,166,167,168,169,170,171,172,173,174,175,176,177,178,179,180,182,184,186,187,188,189,190,191,192,193,194,195,196,198,199,200,202,203,204,205,206,207,208,211,213,214,216,217,218,219,220,222,223,225,226,227,228,229,230,231,232,233,234,238,241,242,243,244,246,254,256,258,259,260,261,262,268,270,271,272,275,276,277,278,279,282,283,284,285,286,287,288,289,290,292,296,297,298,299,300,301,302,303,304,305,306,307,308,309,311,313,320,322,329,338,339,350,351,352,353,354,355,356,357,358,359,360,361,362,363,364,365,369,370,371,372,375,378,380,383,387,390,393,394,398,399,402,404,406,408,410,411,412,413,414,416,418,419,438,439,440,456,457,459,460,463,464,465,466,468,469,470,471,472,474,476,477,478,480,482,484,485,490,491,496,497,498,499,514,515,517,519,520,521,522,527,529,531,532,533,535,538,539,540,541,542,543,544,546,547,550,551,554,557,560,561,562,563,564,565,567,569,570,573,574,575,578,579,582,583,584,586,587,588,596,597,598,600,601,602,603,604,605,606,607,609,610,611,612,614,615,616,618,623,624,625,626,627,628,629,630,631,633,635,636,637,638,640,641,642,643,644,645,646,647,648,649,650,651,652,653,654,655,659,660,661,662,666,668,670,671,672,673,674,675,676,677,678,679,680,681,682,683,684,685,686,687,688,694,695,696,697,698,700,703,704,705,706,707,708,710,711,712,715,716,717,718,719,720,721,723,724,725,726,727,728,729,731,732,736,737,738,739,740,741,743,744,745,746,749,750,751,752,753,754,755,756,757,761,762,763,766,768,769,770,773,774,775,776,777,778,780,781,783,784,785,786,788,789,790,791,792,793,794,795,796,797,798,799,800,801,802,803,806,807,808,809,810,811,812,813,814,815,816,817,818,819,820,821,822,824,826,827,828,829,830,831,833,834,835,838,839,840,841,842,843,844,845,846,847,848,849,850,851,852,853,854,855,856,857,858,859,860,861,862,863,864,865,866,867,869,870,871,872,873,874,875,876,877,878,879,880,881,882,883,884,885,886,887,888,889,890,891,892,893,894,895,896,897,898,899,900,902,903,904,905,906,907,908,910,911,912,913,914,915,916,917,918,919,920,921,922,923,924,925,927,928,929,930,931,932,933,934,935,936,938,939,940,941,942,943,944,945,946,947,948,949,950,951,952,953,954,955,956,957,958,959,960,961,962,963,964,965,966,967,968,969,970,971,972,973,974,975,977,978,979,980,981,982,983,984,985,986,987,988,989,990,991,992,993,994,995,996,997,998,999,1000,1001,1002,1004,1005,1006,1007,1008,1009,1010,1011,1012,1013,1014,1015,1016,1017,1018,1019,1020,1021,1022,1023,1024,1025,1026,1027,1028,1029,1030,1031,1032,1033,1034,1035,1036,1037,1038,1039,1040,1041,1042,1043,1044,1045,1047,1048,1049,1050,1051,1052,1054,1055,1056,1057,1058,1059,1060,1061,1062,1063,1064,1065,1066,1067,1068,1069,1070,1071,1072,1073,1074,1075,1076,1077,1078,1079,1080,1081,1082,1083,1084,1085,1088,1089,1090,1091,1092,1093,1094,1095,1096,1098,1099,1100,1101,1102,1103,1104,1105,1106,1107,1108,1109,1110,1112,1113,1114,1115,1116,1117,1118,1119,1120,1121,1122,1123,1124,1125,1126,1127,1128,1129,1130,1131,1132,1133,1134,1135,1136,1137,1138,1139,1140,1141,1142,1143,1144,1145,1146,1147,1148,1149,1150,1151,1152,1153,1154,1155,1156,1157,1158,1159,1160,1161,1162,1163,1164,1165,1166,1167,1168,1169,1170,1171,1172,1173,1174,1175,1176,1177,1178,1179,1180,1181,1182,1184,1185,1186,1187,1188,1189,1190,1191,1192,1193,1194,1195,1196,1197,1198,1199,1200,1201,1203,1204,1205,1206,1207,1208,1209,1211,1212,1213,1214,1215,1218,1219,1220,1221,1222,1223,1224,1225,1226,1227,1228,1229,1230,1231,1232,1233,1234,1235,1236,1237,1238,1239,1240,1241,1242,1243,1244,1245,1246,1247,1248,1249,1250,1251,1252,1253,1254,1255,1256,1257,1258,1259,1260,1261,1262,1263,1264,1265,1266,1267,1268,1269,1270,1271,1272,1273,1274,1276,1277,1278,1279,1280,1281,1282,1283,1284,1285,1286,1287,1288,1289,1290,1291,1292,1293,1294,1295,1296,1297,1298,1299,1300,1301,1302,1304,1305,1306,1307,1308,1309,1310,1311,1312,1313,1314,1315,1316,1317,1318,1319,1320,1321,1322,1323,1324,1325,1326,1327,1328,1329,1331,1332,1333,1334,1335,1336,1337,1338,1339,1340,1341,1342,1343,1344,1345,1346,1347,1348,1349,1350,1351,1352,1353,1354,1355,1356,1357,1358,1359,1360,1361,1362,1363,1364,1365,1366,1367,1369,1370,1371,1372,1373,1375,1376,1377,1378,1380,1382,1383,1384,1385,1386,1387,1388,1389,1390,1391,1392,1393,1394,1395,1397,1398,1399,1400,1401,1402,1403,1404,1405,1406,1407,1408,1409,1410,1411,1412,1413,1414,1415,1416,1417,1418,1419,1420,1421,1423,1424,1425,1426,1428,1429,1430,1431,1432,1433,1434,1435,1437,1438,1439,1440,1441,1442,1443,1444,1445,1446,1447,1448,1450,1451,1452,1453,1454,1455,1456,1457,1458,1459,1460,1461,1462,1463,1464,1465,1466,1467,1469,1470,1471,1472,1473,1474,1475,1476,1477,1478,1479,1480,1481,1482,1483,1484,1485,1486,1487,1488,1489,1490,1491,1492,1493,1494,1495,1496,1497,1498,1499,1500,1501,1502,1503,1504,1505,1506,1507,1508,1510,1511,1513,1514,1515,1516,1517,1518,1519,1520,1521,1522,1523,1524,1525,1526,1527,1528,1529,1530,1531,1532,1533,1534,1535,1536,1537,1538,1539,1540,1541,1542,1543,1544,1545,1546,1547,1548,1549,1550,1551,1552,1553,1554,1555,1556,1557,1558,1559,1560,1561,1562,1563,1564,1565,1566,1568,1569,1570,1571,1572,1573,1574,1575,1576,1577,1578,1579,1580,1581,1582,1583,1584,1585,1586)
GROUP BY product_shop.id_product
ORDER BY `sales` DESC
LIMIT 0, 10
at line 613 in file classes/db/Db.php
607. WebserviceRequest::getInstance()->setError(500, '[SQL Error] '.$this->getMsgError().'. From '.(isset($dbg[3]['class']) ? $dbg[3]['class'] : '').'->'.$dbg[3]['function'].'() Query was : '.$sql, 97);
608. }
609. else if (_PS_DEBUG_SQL_ && $errno && !defined('PS_INSTALLATION_IN_PROGRESS'))
610. {
611. if ($sql)
612. throw new PrestaShopDatabaseException($this->getMsgError().'<br /><br /><pre>'.$sql.'</pre>');
613. throw new PrestaShopDatabaseException($this->getMsgError());
614. }
615. }
616.
617. /**
307. if ($sql instanceof DbQuery)
308. $sql = $sql->build();
309.
310. $this->result = $this->_query($sql);
311. if (_PS_DEBUG_SQL_)
312. $this->displayError($sql);
313. return $this->result;
314. }
315.
316. /**
317. * Execute an INSERT query
Argument [0] SELECT p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, pl.`description`, pl.`description_short`, pl.`link_rewrite`, pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, m.`name` AS manufacturer_name, p.`id_manufacturer` as id_manufacturer, MAX(image_shop.`id_image`) id_image, il.`legend`, ps.`quantity` AS sales, t.`rate`, pl.`meta_keywords`, pl.`meta_title`, pl.`meta_description`, DATEDIFF(p.`date_add`, DATE_SUB(NOW(), INTERVAL 200 DAY)) > 0 AS new FROM `esadownictwo_product_sale` ps LEFT JOIN `esadownictwo_product` p ON ps.`id_product` = p.`id_product` LEFT JOIN esadownictwo_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) LEFT JOIN `esadownictwo_product_lang` pl ON p.`id_product` = pl.`id_product` AND pl.`id_lang` = 1 AND pl.id_shop = 1 LEFT JOIN `esadownictwo_image` i ON (i.`id_product` = p.`id_product`) LEFT JOIN esadownictwo_image_shop image_shop ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1 AND image_shop.cover=1) LEFT JOIN `esadownictwo_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1) LEFT JOIN `esadownictwo_manufacturer` m ON (m.`id_manufacturer` = p.`id_manufacturer`) LEFT JOIN `esadownictwo_tax_rule` tr ON (product_shop.`id_tax_rules_group` = tr.`id_tax_rules_group`) AND tr.`id_country` = 14 AND tr.`id_state` = 0 LEFT JOIN `esadownictwo_tax` t ON (t.`id_tax` = tr.`id_tax`) LEFT JOIN esadownictwo_stock_available stock ON (stock.id_product = p.id_product AND stock.id_shop = 1 ) WHERE product_shop.`active` = 1 AND p.`visibility` != 'none' AND p.`id_product` IN (,8,9,10,11,12,14,17,18,19,20,21,23,24,29,30,34,35,36,38,46,47,48,49,50,51,52,53,54,55,57,58,59,60,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,98,99,100,101,102,103,104,105,106,107,108,109,110,113,115,116,117,118,119,121,122,123,125,126,127,129,130,132,133,135,136,137,138,139,141,142,143,144,145,146,147,148,152,153,154,155,156,158,159,160,161,163,165,166,167,168,169,170,171,172,173,174,175,176,177,178,179,180,182,184,186,187,188,189,190,191,192,193,194,195,196,198,199,200,202,203,204,205,206,207,208,211,213,214,216,217,218,219,220,222,223,225,226,227,228,229,230,231,232,233,234,238,241,242,243,244,246,254,256,258,259,260,261,262,268,270,271,272,275,276,277,278,279,282,283,284,285,286,287,288,289,290,292,296,297,298,299,300,301,302,303,304,305,306,307,308,309,311,313,320,322,329,338,339,350,351,352,353,354,355,356,357,358,359,360,361,362,363,364,365,369,370,371,372,375,378,380,383,387,390,393,394,398,399,402,404,406,408,410,411,412,413,414,416,418,419,438,439,440,456,457,459,460,463,464,465,466,468,469,470,471,472,474,476,477,478,480,482,484,485,490,491,496,497,498,499,514,515,517,519,520,521,522,527,529,531,532,533,535,538,539,540,541,542,543,544,546,547,550,551,554,557,560,561,562,563,564,565,567,569,570,573,574,575,578,579,582,583,584,586,587,588,596,597,598,600,601,602,603,604,605,606,607,609,610,611,612,614,615,616,618,623,624,625,626,627,628,629,630,631,633,635,636,637,638,640,641,642,643,644,645,646,647,648,649,650,651,652,653,654,655,659,660,661,662,666,668,670,671,672,673,674,675,676,677,678,679,680,681,682,683,684,685,686,687,688,694,695,696,697,698,700,703,704,705,706,707,708,710,711,712,715,716,717,718,719,720,721,723,724,725,726,727,728,729,731,732,736,737,738,739,740,741,743,744,745,746,749,750,751,752,753,754,755,756,757,761,762,763,766,768,769,770,773,774,775,776,777,778,780,781,783,784,785,786,788,789,790,791,792,793,794,795,796,797,798,799,800,801,802,803,806,807,808,809,810,811,812,813,814,815,816,817,818,819,820,821,822,824,826,827,828,829,830,831,833,834,835,838,839,840,841,842,843,844,845,846,847,848,849,850,851,852,853,854,855,856,857,858,859,860,861,862,863,864,865,866,867,869,870,871,872,873,874,875,876,877,878,879,880,881,882,883,884,885,886,887,888,889,890,891,892,893,894,895,896,897,898,899,900,902,903,904,905,906,907,908,910,911,912,913,914,915,916,917,918,919,920,921,922,923,924,925,927,928,929,930,931,932,933,934,935,936,938,939,940,941,942,943,944,945,946,947,948,949,950,951,952,953,954,955,956,957,958,959,960,961,962,963,964,965,966,967,968,969,970,971,972,973,974,975,977,978,979,980,981,982,983,984,985,986,987,988,989,990,991,992,993,994,995,996,997,998,999,1000,1001,1002,1004,1005,1006,1007,1008,1009,1010,1011,1012,1013,1014,1015,1016,1017,1018,1019,1020,1021,1022,1023,1024,1025,1026,1027,1028,1029,1030,1031,1032,1033,1034,1035,1036,1037,1038,1039,1040,1041,1042,1043,1044,1045,1047,1048,1049,1050,1051,1052,1054,1055,1056,1057,1058,1059,1060,1061,1062,1063,1064,1065,1066,1067,1068,1069,1070,1071,1072,1073,1074,1075,1076,1077,1078,1079,1080,1081,1082,1083,1084,1085,1088,1089,1090,1091,1092,1093,1094,1095,1096,1098,1099,1100,1101,1102,1103,1104,1105,1106,1107,1108,1109,1110,1112,1113,1114,1115,1116,1117,1118,1119,1120,1121,1122,1123,1124,1125,1126,1127,1128,1129,1130,1131,1132,1133,1134,1135,1136,1137,1138,1139,1140,1141,1142,1143,1144,1145,1146,1147,1148,1149,1150,1151,1152,1153,1154,1155,1156,1157,1158,1159,1160,1161,1162,1163,1164,1165,1166,1167,1168,1169,1170,1171,1172,1173,1174,1175,1176,1177,1178,1179,1180,1181,1182,1184,1185,1186,1187,1188,1189,1190,1191,1192,1193,1194,1195,1196,1197,1198,1199,1200,1201,1203,1204,1205,1206,1207,1208,1209,1211,1212,1213,1214,1215,1218,1219,1220,1221,1222,1223,1224,1225,1226,1227,1228,1229,1230,1231,1232,1233,1234,1235,1236,1237,1238,1239,1240,1241,1242,1243,1244,1245,1246,1247,1248,1249,1250,1251,1252,1253,1254,1255,1256,1257,1258,1259,1260,1261,1262,1263,1264,1265,1266,1267,1268,1269,1270,1271,1272,1273,1274,1276,1277,1278,1279,1280,1281,1282,1283,1284,1285,1286,1287,1288,1289,1290,1291,1292,1293,1294,1295,1296,1297,1298,1299,1300,1301,1302,1304,1305,1306,1307,1308,1309,1310,1311,1312,1313,1314,1315,1316,1317,1318,1319,1320,1321,1322,1323,1324,1325,1326,1327,1328,1329,1331,1332,1333,1334,1335,1336,1337,1338,1339,1340,1341,1342,1343,1344,1345,1346,1347,1348,1349,1350,1351,1352,1353,1354,1355,1356,1357,1358,1359,1360,1361,1362,1363,1364,1365,1366,1367,1369,1370,1371,1372,1373,1375,1376,1377,1378,1380,1382,1383,1384,1385,1386,1387,1388,1389,1390,1391,1392,1393,1394,1395,1397,1398,1399,1400,1401,1402,1403,1404,1405,1406,1407,1408,1409,1410,1411,1412,1413,1414,1415,1416,1417,1418,1419,1420,1421,1423,1424,1425,1426,1428,1429,1430,1431,1432,1433,1434,1435,1437,1438,1439,1440,1441,1442,1443,1444,1445,1446,1447,1448,1450,1451,1452,1453,1454,1455,1456,1457,1458,1459,1460,1461,1462,1463,1464,1465,1466,1467,1469,1470,1471,1472,1473,1474,1475,1476,1477,1478,1479,1480,1481,1482,1483,1484,1485,1486,1487,1488,1489,1490,1491,1492,1493,1494,1495,1496,1497,1498,1499,1500,1501,1502,1503,1504,1505,1506,1507,1508,1510,1511,1513,1514,1515,1516,1517,1518,1519,1520,1521,1522,1523,1524,1525,1526,1527,1528,1529,1530,1531,1532,1533,1534,1535,1536,1537,1538,1539,1540,1541,1542,1543,1544,1545,1546,1547,1548,1549,1550,1551,1552,1553,1554,1555,1556,1557,1558,1559,1560,1561,1562,1563,1564,1565,1566,1568,1569,1570,1571,1572,1573,1574,1575,1576,1577,1578,1579,1580,1581,1582,1583,1584,1585,1586) GROUP BY product_shop.id_product ORDER BY `sales` DESC LIMIT 0, 10
482. {
483. $this->last_cached = true;
484. return $result;
485. }
486.
487. $this->result = $this->query($sql);
488. if (!$this->result)
489. return false;
490.
491. $this->last_cached = false;
492. if (!$array)
Argument [0] SELECT p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, pl.`description`, pl.`description_short`, pl.`link_rewrite`, pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, m.`name` AS manufacturer_name, p.`id_manufacturer` as id_manufacturer, MAX(image_shop.`id_image`) id_image, il.`legend`, ps.`quantity` AS sales, t.`rate`, pl.`meta_keywords`, pl.`meta_title`, pl.`meta_description`, DATEDIFF(p.`date_add`, DATE_SUB(NOW(), INTERVAL 200 DAY)) > 0 AS new FROM `esadownictwo_product_sale` ps LEFT JOIN `esadownictwo_product` p ON ps.`id_product` = p.`id_product` LEFT JOIN esadownictwo_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) LEFT JOIN `esadownictwo_product_lang` pl ON p.`id_product` = pl.`id_product` AND pl.`id_lang` = 1 AND pl.id_shop = 1 LEFT JOIN `esadownictwo_image` i ON (i.`id_product` = p.`id_product`) LEFT JOIN esadownictwo_image_shop image_shop ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1 AND image_shop.cover=1) LEFT JOIN `esadownictwo_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1) LEFT JOIN `esadownictwo_manufacturer` m ON (m.`id_manufacturer` = p.`id_manufacturer`) LEFT JOIN `esadownictwo_tax_rule` tr ON (product_shop.`id_tax_rules_group` = tr.`id_tax_rules_group`) AND tr.`id_country` = 14 AND tr.`id_state` = 0 LEFT JOIN `esadownictwo_tax` t ON (t.`id_tax` = tr.`id_tax`) LEFT JOIN esadownictwo_stock_available stock ON (stock.id_product = p.id_product AND stock.id_shop = 1 ) WHERE product_shop.`active` = 1 AND p.`visibility` != 'none' AND p.`id_product` IN (,8,9,10,11,12,14,17,18,19,20,21,23,24,29,30,34,35,36,38,46,47,48,49,50,51,52,53,54,55,57,58,59,60,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,98,99,100,101,102,103,104,105,106,107,108,109,110,113,115,116,117,118,119,121,122,123,125,126,127,129,130,132,133,135,136,137,138,139,141,142,143,144,145,146,147,148,152,153,154,155,156,158,159,160,161,163,165,166,167,168,169,170,171,172,173,174,175,176,177,178,179,180,182,184,186,187,188,189,190,191,192,193,194,195,196,198,199,200,202,203,204,205,206,207,208,211,213,214,216,217,218,219,220,222,223,225,226,227,228,229,230,231,232,233,234,238,241,242,243,244,246,254,256,258,259,260,261,262,268,270,271,272,275,276,277,278,279,282,283,284,285,286,287,288,289,290,292,296,297,298,299,300,301,302,303,304,305,306,307,308,309,311,313,320,322,329,338,339,350,351,352,353,354,355,356,357,358,359,360,361,362,363,364,365,369,370,371,372,375,378,380,383,387,390,393,394,398,399,402,404,406,408,410,411,412,413,414,416,418,419,438,439,440,456,457,459,460,463,464,465,466,468,469,470,471,472,474,476,477,478,480,482,484,485,490,491,496,497,498,499,514,515,517,519,520,521,522,527,529,531,532,533,535,538,539,540,541,542,543,544,546,547,550,551,554,557,560,561,562,563,564,565,567,569,570,573,574,575,578,579,582,583,584,586,587,588,596,597,598,600,601,602,603,604,605,606,607,609,610,611,612,614,615,616,618,623,624,625,626,627,628,629,630,631,633,635,636,637,638,640,641,642,643,644,645,646,647,648,649,650,651,652,653,654,655,659,660,661,662,666,668,670,671,672,673,674,675,676,677,678,679,680,681,682,683,684,685,686,687,688,694,695,696,697,698,700,703,704,705,706,707,708,710,711,712,715,716,717,718,719,720,721,723,724,725,726,727,728,729,731,732,736,737,738,739,740,741,743,744,745,746,749,750,751,752,753,754,755,756,757,761,762,763,766,768,769,770,773,774,775,776,777,778,780,781,783,784,785,786,788,789,790,791,792,793,794,795,796,797,798,799,800,801,802,803,806,807,808,809,810,811,812,813,814,815,816,817,818,819,820,821,822,824,826,827,828,829,830,831,833,834,835,838,839,840,841,842,843,844,845,846,847,848,849,850,851,852,853,854,855,856,857,858,859,860,861,862,863,864,865,866,867,869,870,871,872,873,874,875,876,877,878,879,880,881,882,883,884,885,886,887,888,889,890,891,892,893,894,895,896,897,898,899,900,902,903,904,905,906,907,908,910,911,912,913,914,915,916,917,918,919,920,921,922,923,924,925,927,928,929,930,931,932,933,934,935,936,938,939,940,941,942,943,944,945,946,947,948,949,950,951,952,953,954,955,956,957,958,959,960,961,962,963,964,965,966,967,968,969,970,971,972,973,974,975,977,978,979,980,981,982,983,984,985,986,987,988,989,990,991,992,993,994,995,996,997,998,999,1000,1001,1002,1004,1005,1006,1007,1008,1009,1010,1011,1012,1013,1014,1015,1016,1017,1018,1019,1020,1021,1022,1023,1024,1025,1026,1027,1028,1029,1030,1031,1032,1033,1034,1035,1036,1037,1038,1039,1040,1041,1042,1043,1044,1045,1047,1048,1049,1050,1051,1052,1054,1055,1056,1057,1058,1059,1060,1061,1062,1063,1064,1065,1066,1067,1068,1069,1070,1071,1072,1073,1074,1075,1076,1077,1078,1079,1080,1081,1082,1083,1084,1085,1088,1089,1090,1091,1092,1093,1094,1095,1096,1098,1099,1100,1101,1102,1103,1104,1105,1106,1107,1108,1109,1110,1112,1113,1114,1115,1116,1117,1118,1119,1120,1121,1122,1123,1124,1125,1126,1127,1128,1129,1130,1131,1132,1133,1134,1135,1136,1137,1138,1139,1140,1141,1142,1143,1144,1145,1146,1147,1148,1149,1150,1151,1152,1153,1154,1155,1156,1157,1158,1159,1160,1161,1162,1163,1164,1165,1166,1167,1168,1169,1170,1171,1172,1173,1174,1175,1176,1177,1178,1179,1180,1181,1182,1184,1185,1186,1187,1188,1189,1190,1191,1192,1193,1194,1195,1196,1197,1198,1199,1200,1201,1203,1204,1205,1206,1207,1208,1209,1211,1212,1213,1214,1215,1218,1219,1220,1221,1222,1223,1224,1225,1226,1227,1228,1229,1230,1231,1232,1233,1234,1235,1236,1237,1238,1239,1240,1241,1242,1243,1244,1245,1246,1247,1248,1249,1250,1251,1252,1253,1254,1255,1256,1257,1258,1259,1260,1261,1262,1263,1264,1265,1266,1267,1268,1269,1270,1271,1272,1273,1274,1276,1277,1278,1279,1280,1281,1282,1283,1284,1285,1286,1287,1288,1289,1290,1291,1292,1293,1294,1295,1296,1297,1298,1299,1300,1301,1302,1304,1305,1306,1307,1308,1309,1310,1311,1312,1313,1314,1315,1316,1317,1318,1319,1320,1321,1322,1323,1324,1325,1326,1327,1328,1329,1331,1332,1333,1334,1335,1336,1337,1338,1339,1340,1341,1342,1343,1344,1345,1346,1347,1348,1349,1350,1351,1352,1353,1354,1355,1356,1357,1358,1359,1360,1361,1362,1363,1364,1365,1366,1367,1369,1370,1371,1372,1373,1375,1376,1377,1378,1380,1382,1383,1384,1385,1386,1387,1388,1389,1390,1391,1392,1393,1394,1395,1397,1398,1399,1400,1401,1402,1403,1404,1405,1406,1407,1408,1409,1410,1411,1412,1413,1414,1415,1416,1417,1418,1419,1420,1421,1423,1424,1425,1426,1428,1429,1430,1431,1432,1433,1434,1435,1437,1438,1439,1440,1441,1442,1443,1444,1445,1446,1447,1448,1450,1451,1452,1453,1454,1455,1456,1457,1458,1459,1460,1461,1462,1463,1464,1465,1466,1467,1469,1470,1471,1472,1473,1474,1475,1476,1477,1478,1479,1480,1481,1482,1483,1484,1485,1486,1487,1488,1489,1490,1491,1492,1493,1494,1495,1496,1497,1498,1499,1500,1501,1502,1503,1504,1505,1506,1507,1508,1510,1511,1513,1514,1515,1516,1517,1518,1519,1520,1521,1522,1523,1524,1525,1526,1527,1528,1529,1530,1531,1532,1533,1534,1535,1536,1537,1538,1539,1540,1541,1542,1543,1544,1545,1546,1547,1548,1549,1550,1551,1552,1553,1554,1555,1556,1557,1558,1559,1560,1561,1562,1563,1564,1565,1566,1568,1569,1570,1571,1572,1573,1574,1575,1576,1577,1578,1579,1580,1581,1582,1583,1584,1585,1586) GROUP BY product_shop.id_product ORDER BY `sales` DESC LIMIT 0, 10
116. AND p.`id_product` IN ('.$ids.')
117. GROUP BY product_shop.id_product
118. ORDER BY '.(!empty($order_table) ? '`'.pSQL($order_table).'`.' : '').'`'.pSQL($order_by).'` '.pSQL($order_way).'
119. LIMIT '.(int)($page_number * $nb_products).', '.(int)$nb_products;
120.
121. $result = Db::getInstance(_PS_USE_SQL_SLAVE_)->executeS($sql);
122.
123. if ($final_order_by == 'price')
124. Tools::orderbyPrice($result, $order_way);
125. if (!$result)
126. return false;
Argument [0] SELECT p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, pl.`description`, pl.`description_short`, pl.`link_rewrite`, pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, m.`name` AS manufacturer_name, p.`id_manufacturer` as id_manufacturer, MAX(image_shop.`id_image`) id_image, il.`legend`, ps.`quantity` AS sales, t.`rate`, pl.`meta_keywords`, pl.`meta_title`, pl.`meta_description`, DATEDIFF(p.`date_add`, DATE_SUB(NOW(), INTERVAL 200 DAY)) > 0 AS new FROM `esadownictwo_product_sale` ps LEFT JOIN `esadownictwo_product` p ON ps.`id_product` = p.`id_product` LEFT JOIN esadownictwo_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) LEFT JOIN `esadownictwo_product_lang` pl ON p.`id_product` = pl.`id_product` AND pl.`id_lang` = 1 AND pl.id_shop = 1 LEFT JOIN `esadownictwo_image` i ON (i.`id_product` = p.`id_product`) LEFT JOIN esadownictwo_image_shop image_shop ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1 AND image_shop.cover=1) LEFT JOIN `esadownictwo_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1) LEFT JOIN `esadownictwo_manufacturer` m ON (m.`id_manufacturer` = p.`id_manufacturer`) LEFT JOIN `esadownictwo_tax_rule` tr ON (product_shop.`id_tax_rules_group` = tr.`id_tax_rules_group`) AND tr.`id_country` = 14 AND tr.`id_state` = 0 LEFT JOIN `esadownictwo_tax` t ON (t.`id_tax` = tr.`id_tax`) LEFT JOIN esadownictwo_stock_available stock ON (stock.id_product = p.id_product AND stock.id_shop = 1 ) WHERE product_shop.`active` = 1 AND p.`visibility` != 'none' AND p.`id_product` IN (,8,9,10,11,12,14,17,18,19,20,21,23,24,29,30,34,35,36,38,46,47,48,49,50,51,52,53,54,55,57,58,59,60,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,98,99,100,101,102,103,104,105,106,107,108,109,110,113,115,116,117,118,119,121,122,123,125,126,127,129,130,132,133,135,136,137,138,139,141,142,143,144,145,146,147,148,152,153,154,155,156,158,159,160,161,163,165,166,167,168,169,170,171,172,173,174,175,176,177,178,179,180,182,184,186,187,188,189,190,191,192,193,194,195,196,198,199,200,202,203,204,205,206,207,208,211,213,214,216,217,218,219,220,222,223,225,226,227,228,229,230,231,232,233,234,238,241,242,243,244,246,254,256,258,259,260,261,262,268,270,271,272,275,276,277,278,279,282,283,284,285,286,287,288,289,290,292,296,297,298,299,300,301,302,303,304,305,306,307,308,309,311,313,320,322,329,338,339,350,351,352,353,354,355,356,357,358,359,360,361,362,363,364,365,369,370,371,372,375,378,380,383,387,390,393,394,398,399,402,404,406,408,410,411,412,413,414,416,418,419,438,439,440,456,457,459,460,463,464,465,466,468,469,470,471,472,474,476,477,478,480,482,484,485,490,491,496,497,498,499,514,515,517,519,520,521,522,527,529,531,532,533,535,538,539,540,541,542,543,544,546,547,550,551,554,557,560,561,562,563,564,565,567,569,570,573,574,575,578,579,582,583,584,586,587,588,596,597,598,600,601,602,603,604,605,606,607,609,610,611,612,614,615,616,618,623,624,625,626,627,628,629,630,631,633,635,636,637,638,640,641,642,643,644,645,646,647,648,649,650,651,652,653,654,655,659,660,661,662,666,668,670,671,672,673,674,675,676,677,678,679,680,681,682,683,684,685,686,687,688,694,695,696,697,698,700,703,704,705,706,707,708,710,711,712,715,716,717,718,719,720,721,723,724,725,726,727,728,729,731,732,736,737,738,739,740,741,743,744,745,746,749,750,751,752,753,754,755,756,757,761,762,763,766,768,769,770,773,774,775,776,777,778,780,781,783,784,785,786,788,789,790,791,792,793,794,795,796,797,798,799,800,801,802,803,806,807,808,809,810,811,812,813,814,815,816,817,818,819,820,821,822,824,826,827,828,829,830,831,833,834,835,838,839,840,841,842,843,844,845,846,847,848,849,850,851,852,853,854,855,856,857,858,859,860,861,862,863,864,865,866,867,869,870,871,872,873,874,875,876,877,878,879,880,881,882,883,884,885,886,887,888,889,890,891,892,893,894,895,896,897,898,899,900,902,903,904,905,906,907,908,910,911,912,913,914,915,916,917,918,919,920,921,922,923,924,925,927,928,929,930,931,932,933,934,935,936,938,939,940,941,942,943,944,945,946,947,948,949,950,951,952,953,954,955,956,957,958,959,960,961,962,963,964,965,966,967,968,969,970,971,972,973,974,975,977,978,979,980,981,982,983,984,985,986,987,988,989,990,991,992,993,994,995,996,997,998,999,1000,1001,1002,1004,1005,1006,1007,1008,1009,1010,1011,1012,1013,1014,1015,1016,1017,1018,1019,1020,1021,1022,1023,1024,1025,1026,1027,1028,1029,1030,1031,1032,1033,1034,1035,1036,1037,1038,1039,1040,1041,1042,1043,1044,1045,1047,1048,1049,1050,1051,1052,1054,1055,1056,1057,1058,1059,1060,1061,1062,1063,1064,1065,1066,1067,1068,1069,1070,1071,1072,1073,1074,1075,1076,1077,1078,1079,1080,1081,1082,1083,1084,1085,1088,1089,1090,1091,1092,1093,1094,1095,1096,1098,1099,1100,1101,1102,1103,1104,1105,1106,1107,1108,1109,1110,1112,1113,1114,1115,1116,1117,1118,1119,1120,1121,1122,1123,1124,1125,1126,1127,1128,1129,1130,1131,1132,1133,1134,1135,1136,1137,1138,1139,1140,1141,1142,1143,1144,1145,1146,1147,1148,1149,1150,1151,1152,1153,1154,1155,1156,1157,1158,1159,1160,1161,1162,1163,1164,1165,1166,1167,1168,1169,1170,1171,1172,1173,1174,1175,1176,1177,1178,1179,1180,1181,1182,1184,1185,1186,1187,1188,1189,1190,1191,1192,1193,1194,1195,1196,1197,1198,1199,1200,1201,1203,1204,1205,1206,1207,1208,1209,1211,1212,1213,1214,1215,1218,1219,1220,1221,1222,1223,1224,1225,1226,1227,1228,1229,1230,1231,1232,1233,1234,1235,1236,1237,1238,1239,1240,1241,1242,1243,1244,1245,1246,1247,1248,1249,1250,1251,1252,1253,1254,1255,1256,1257,1258,1259,1260,1261,1262,1263,1264,1265,1266,1267,1268,1269,1270,1271,1272,1273,1274,1276,1277,1278,1279,1280,1281,1282,1283,1284,1285,1286,1287,1288,1289,1290,1291,1292,1293,1294,1295,1296,1297,1298,1299,1300,1301,1302,1304,1305,1306,1307,1308,1309,1310,1311,1312,1313,1314,1315,1316,1317,1318,1319,1320,1321,1322,1323,1324,1325,1326,1327,1328,1329,1331,1332,1333,1334,1335,1336,1337,1338,1339,1340,1341,1342,1343,1344,1345,1346,1347,1348,1349,1350,1351,1352,1353,1354,1355,1356,1357,1358,1359,1360,1361,1362,1363,1364,1365,1366,1367,1369,1370,1371,1372,1373,1375,1376,1377,1378,1380,1382,1383,1384,1385,1386,1387,1388,1389,1390,1391,1392,1393,1394,1395,1397,1398,1399,1400,1401,1402,1403,1404,1405,1406,1407,1408,1409,1410,1411,1412,1413,1414,1415,1416,1417,1418,1419,1420,1421,1423,1424,1425,1426,1428,1429,1430,1431,1432,1433,1434,1435,1437,1438,1439,1440,1441,1442,1443,1444,1445,1446,1447,1448,1450,1451,1452,1453,1454,1455,1456,1457,1458,1459,1460,1461,1462,1463,1464,1465,1466,1467,1469,1470,1471,1472,1473,1474,1475,1476,1477,1478,1479,1480,1481,1482,1483,1484,1485,1486,1487,1488,1489,1490,1491,1492,1493,1494,1495,1496,1497,1498,1499,1500,1501,1502,1503,1504,1505,1506,1507,1508,1510,1511,1513,1514,1515,1516,1517,1518,1519,1520,1521,1522,1523,1524,1525,1526,1527,1528,1529,1530,1531,1532,1533,1534,1535,1536,1537,1538,1539,1540,1541,1542,1543,1544,1545,1546,1547,1548,1549,1550,1551,1552,1553,1554,1555,1556,1557,1558,1559,1560,1561,1562,1563,1564,1565,1566,1568,1569,1570,1571,1572,1573,1574,1575,1576,1577,1578,1579,1580,1581,1582,1583,1584,1585,1586) GROUP BY product_shop.id_product ORDER BY `sales` DESC LIMIT 0, 10
34. $this->productSort();
35. $nbProducts = (int)ProductSale::getNbSales();
36. $this->pagination($nbProducts);
37.
38. $this->context->smarty->assign(array(
39. 'products' => ProductSale::getBestSales($this->context->language->id, $this->p - 1, $this->n, $this->orderBy, $this->orderWay),
40. 'add_prod_display' => Configuration::get('PS_ATTRIBUTE_CATEGORY_DISPLAY'),
41. 'nbProducts' => $nbProducts,
42. 'homeSize' => Image::getSize(ImageType::getFormatedName('home')),
43. 'comparator_max_item' => Configuration::get('PS_COMPARATOR_MAX_ITEM')
44. ));
Argument [0] 1 Argument [1] 0 Argument [2] 10 Argument [3] position Argument [4] asc
161.
162. if (!$this->content_only && ($this->display_header || (isset($this->className) && $this->className)))
163. $this->initHeader();
164.
165. if ($this->viewAccess())
166. $this->initContent();
167. else
168. $this->errors[] = Tools::displayError('Access denied.');
169.
170. if (!$this->content_only && ($this->display_footer || (isset($this->className) && $this->className)))
171. $this->initFooter();
342. // Execute hook dispatcher
343. if (isset($params_hook_action_dispatcher))
344. Hook::exec('actionDispatcher', $params_hook_action_dispatcher);
345.
346. // Running controller
347. $controller->run();
348. }
349. catch (PrestaShopException $e)
350. {
351. $e->displayMessage();
352. }
22. * @license http://opensource.org/licenses/osl-3.0.php Open Software License (OSL 3.0)
23. * International Registered Trademark & Property of PrestaShop SA
24. */
25.
26. require(dirname(__FILE__).'/config/config.inc.php');
27. Dispatcher::getInstance()->dispatch();
28.