Incorrect key file for table '/var/tmp/#sql_9f6_0.MYI'; try to repair it
SELECT
p.*,
product_shop.*,
product_shop.id_category_default,
pl.*,
i.id_image,
il.legend,
m.name manufacturer_name,
DATEDIFF(product_shop.`date_add`, DATE_SUB(NOW(), INTERVAL 20 DAY)) > 0 AS new
FROM `eh_category_product` cp
LEFT JOIN eh_category c ON (c.id_category = cp.id_category)
LEFT JOIN `eh_product` p ON p.`id_product` = cp.`id_product`
INNER JOIN eh_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
LEFT JOIN eh_product_lang pl ON (pl.id_product = p.id_product)
LEFT JOIN eh_image i ON (i.id_product = p.id_product AND i.cover = 1)
LEFT JOIN eh_image_lang il ON (i.id_image = il.id_image AND il.id_lang = 7)
LEFT JOIN eh_manufacturer m ON (m.id_manufacturer = p.id_manufacturer)
WHERE product_shop.`active` = 1 AND
c.nleft >= 5
AND c.nright
at line 605 in file classes/db/Db.php
599. WebserviceRequest::getInstance()->setError(500, '[SQL Error] '.$this->getMsgError().'. From '.(isset($dbg[3]['class']) ? $dbg[3]['class'] : '').'->'.$dbg[3]['function'].'() Query was : '.$sql, 97);
600. }
601. else if (_PS_DEBUG_SQL_ && $errno && !defined('PS_INSTALLATION_IN_PROGRESS'))
602. {
603. if ($sql)
604. throw new PrestaShopDatabaseException($this->getMsgError().'<br /><br /><pre>'.$sql.'</pre>');
605. throw new PrestaShopDatabaseException($this->getMsgError());
606. }
607. }
608.
609. /**
301. if ($sql instanceof DbQuery)
302. $sql = $sql->build();
303.
304. $this->result = $this->_query($sql);
305. if (_PS_DEBUG_SQL_)
306. $this->displayError($sql);
307. return $this->result;
308. }
309.
310. /**
311. * Execute an INSERT query
Argument [0] SELECT p.*, product_shop.*, product_shop.id_category_default, pl.*, i.id_image, il.legend, m.name manufacturer_name, DATEDIFF(product_shop.`date_add`, DATE_SUB(NOW(), INTERVAL 20 DAY)) > 0 AS new FROM `eh_category_product` cp LEFT JOIN eh_category c ON (c.id_category = cp.id_category) LEFT JOIN `eh_product` p ON p.`id_product` = cp.`id_product` INNER JOIN eh_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) LEFT JOIN eh_product_lang pl ON (pl.id_product = p.id_product) LEFT JOIN eh_image i ON (i.id_product = p.id_product AND i.cover = 1) LEFT JOIN eh_image_lang il ON (i.id_image = il.id_image AND il.id_lang = 7) LEFT JOIN eh_manufacturer m ON (m.id_manufacturer = p.id_manufacturer) WHERE product_shop.`active` = 1 AND c.nleft >= 5 AND c.nright <= 122 AND c.active = 1 AND pl.id_lang = 7 AND p.id_product IN (5662,5663,5664,5665,5666,5667,5668,5669,5670,5671,5672,5678,5679,5680,5682,5683,5684,5685,5686,5687,5688,5689,5690,5691,5692,5693,5694,5696,5698,5700,5701,5702,5703,5706,5707,5710,5711,5712,5713,5715,5716,5717,5718,5719,5720,5721,5722,5723,5724,5725,5727,5729,5730,5731,5733,5734,5742,5743,5744,5745,5746,5747,5748,5749,5750,5751,5752,5753,5754,5755,5756,5757,5758,5759,5760,5761,5762,5763,5764,5765,5766,5767,5768,5769,5770,5773,5774,5775,5776,5777,5778,5779,5780,5781,5782,5783,5784,5785,5786,5787,5788,5789,5790,5791,5792,5793,5794,5795,5796,5797,5798,5799,5800,5801,5803,5804,5805,5836,5863,5864,5865,6016,6017,6018,6019,6020,6021,6022,6023,6024,6025,6026,6027,6028,6029,6030,6031,6032,6033,6034,6035,6036,6037,6038,6039,6040,6041,6042,6043,6044,6047,6048,6049,6050,6051,6052,6053,6054,6055,6056,6057,6058,6059,6060,6061,6062,6063,6064,6065,6066,6067,6068,6069,6070,6071,6072,6073,6074,6075,6076,6077,6078,6079,6080,6081,6082,6083,6084,6085,6087,6088,6089,6090,6091,6092,6093,6094,6095,6096,6097,6098,6099,6100,6118,6119,6120,6121,6122,6123,6124,6125,6126,6127,6128,6129,6130,6131,6135,6136,6137,6138,6140,6141,6142,6143,6144,6145,6146,6147,6148,6149,6150,6151,6152,6153,6154,6155,6156,6157,6158,6159,6160,6161,6162,6163,6164,6165,6166,6167,6168,6169,6170,6171,6172,6173,6174,6175,6176,6177,6178,6179,6180,6181,6182,6183,6184,6185,6186,6187,6188,6189,6190,6191,6192,6193,6194,6195,6196,6197,6198,6199,6200,6201,6202,6203,6204,6205,6206,6207,6208,6209,6210,6211,6212,6213,6214,6215,6216,6217,6218,6219,6220,6221,6222,6223,6224,6225,6226,6227,6228,6229,6230,6231,6232,6233,6234,6235,6236,6237,6238,6239,6240,6241,6242,6243,6244,6245,6246,6247,6248,6249,6250,6251,6252,6253,6254,6255,6256,6257,6258,6259,6260,6261,6262,6263,6264,6265,6266,6267,6268,6269,6270,6271,6272,6273,6274,6275,6276,6277,6278,6279,6280,6283,6284,6285,6286,6287,6288,6289,6290,6291,6292,6293,6294,6295,6296,6297,6298,6299,6300,6301,6302,6303,6304,6305,6306,6307,6308,6309,6310,6311,6312,6313,6314,6315,6316,6317,6318,6319,6320,6321,6322,6324,6325,6326,6327,6328,6329,6330,6331,6332,6333,6334,6335,6336,6337,6338,6339,6340,6341,6342,6343,6344,6345,6346,6347,6348,6349,6350,6351,6352,6353,6354,6355,6356,6357,6358,6359,6360,6361,6362,6363,6364,6365,6366,6367,6368,6369,6370,6371,6372,6373,6374,6375,6376,6377,6378,6379,6380,6381,6382,6383,6384,6385,6386,6387,6388,6389,6390,6391,6392,6393,6394,6395,6396,6397,6398,6399,6400,6401,6402,6403,6404,6405,6406,6407,6408,6409,6410,6411,6412,6413,6414,6415,6416,6417,6418,6419,6420,6421,6422,6423,6424,6425,6426,6427,6428,6429,6430,6431,6432,6433,6434,6435,6436,6437,6438,6439,6440,6441,6442,6443,6444,6445,6446,6447,6448,6449,6450,6451,6452,6453,6454,6455,6456,6457,6458,6459,6460,6461,6462,6463,6464,6465,6466,6467,6468,6469,6470,6471,6472,6473,6474,6475,6476,6477,6478,6479,6480,6481,6482,6483,6484,6485,6486,6487,6488,6489,6490,6491,6492,6493,6494,6495,6496,6497,6498,6499,6500,6501,6502,6503,6504,6505,6506,6507,6508,6509,6510,6511,6512,6513,6514,6515,6516,6517,6518,6519,6520,6521,6529,6530,6531,6532,6533,6534,6535,6536,6537,6538,6540,6541,6542,6543,6544,6545,6546,6547,6548,6549,6550,6551,6552,6553,6554,6555,6556,6557,6558,6559,6560,6561,6562,6563,6564,6565,6566,6567,6568,6569,6570,6571,6572,6573,6574,6575,6576,6577,6578,6579,6580,6581,6582,6583,6584,6585,6586,6587,6588,6589,6590,6591,6592,6593,6594,6595,6596,6597,6598,6599,6600,6601,6602,6603,6604,6605,6606,6607,6608,6609,6610,6611,6612,6613,6614,6615,6616,6617,6618,6619,6620,6621,6622,6623,6624,6625,6626,6627,6628,6629,6630,6631,6632,6633,6634,6635,6636,6637,6638,6639,6640,6641,6642,6643,6644,6645,6646,6647,6648,6649,6650,6651,6652,6653,6654,6655,6656,6657,6658,6659,6660,6661,6662,6663,6664,6665,6666,6667,6668,6669,6670,6671,6672,6673,6674,6675,6676,6677,6678,6679,6680,6761,6777,6778,6785,6786,6787,6788,6789,6790,6791,6792,6794,6795,6796,6797,6798,6799,6800,6801,6802,6803,6804,6805,6806,6807,6808,6809,6810,6811,6812,6813,6814,6815,6816,6817,6818,6819,6820,6821,6822,6823,6824,6825,6826,6827,6828,6829,6830,6831,6832,6833,6834,6835,6836,6837,6838,6839,6840,6841,6842,6843,6844,6845,6846,6847,6848,6864,6865,7071,7072,7077,7078,7079,7080,7081,7082,7083,7084,7085,7086,7087,7088,7089,7090,7091,7092,7093,7094,7095,7096,7097,7099,7100,7108,7109,7110,7111,7115,7116,7117,7118,7119,7120,7121,7122,7123,7124,7125,7127,7128,7260,7262,7263,7264,7265,7266,7267,7268,7269,7270,7272,7273,7275,7277,7278,7279,7280,7281,7282,7283,7284,7285,7286,7287,7288,7289,7290,7291,7292,7293,7294,7295,7296,7297,7298,7299,7300,7301,7302,7303,7304,7305,7306,7307,7308,7309,7310,7311,7312,7313,7314,7315,7316,7317,7318,7319,7320,7321,7322,7323,7324,7325,7326,7327,7328,7329,7330,7331,7332,7333,7334,7335,7336,7337,7338,7339,7340,7341,7342,7343,7344,7345,7346,7347,7348,7349,7351,7352,7353,7378,7379,7381,7397,7408,7409,7410,7411,7412,7413,7414,7415,7416,7417,7418,7419,7420,7452,7467,7468,7469,7470,7471,7472,7473,7474,8445,8446,8447,8448,8474,8475,8476,8477,8478,8479,8480,8481,8482,8483,8711,8716,8717,8719,8720,8721,8722,8725,8726,8727,8728,8729,8730,8731,8732,8733,8734,8735,8736,8737,8738,8739,8742,8754,8755,8756,8757,8758,8759,8760,8761,8762,8763,8764,8765,8767,8768,8769,8770,8771,8772,8773,8774,8775,8776,8777,8778,8779,8781,8791,8870,8871,8872,8873,8874,8875,8876,8877,8878,8879,8880,8881,8882,8883,8884,8885,8886,8887,8888,8889,8890,8891,8892,8893,8894,8895,8896,8898,8899,8900,8901,8905,8906,8907,8908,8909,8915,8916,8917,8918,8919,8920,8921,8922,8923,8924,8925,8926,8927,8928,8929,8930,8931,8932,8933,8934,8935,8936,8947,8948,8949,8950,8951,9126,9128,9131,9132,9133,9134,9135,9136,9137,9138,9139,9140,9141,9142,9143,9144,9147,9148,9149,9150,9151,9152,9154,9155,9156,9157,9158,9160,9161,9162,9164,9165,9166,9171,9172,9173,9174,9175,9176,9177,9178,9179,9180,9181,9182,9183,9184,9185,9186,9189,9194,9196,9213,9214,9215,9219,9220,9268,9272,9276,9278,9279,9280,9281,9282,9283,9284,9285,9286,9287,9288,9289,9290,9291,9292,9293,9294,9295,9296,9297,9300,9301,9303,9304,9305,9306,9307,9308,9309,9310,9311,9312,9313,9314,9315,9316,9317,9318,9319,9320,9321,9322,9323,9324,9325,9326,9327,9328,9329,9330,9331,9333,9334,9335,9337,9338,9341,9343,9344,9345,9346,9347,9448,9449,9450,9451,9452,9453,9454,9479,9480,9481,9482,9483,9484,9485,9486,9487,9488,9489,9490,9491,9492,9495,9496,9497,9498,9499,9500,9502,9503,9504,9505,9506,9507,9509,9510,9511,9512,9513,9514,9515,9516,9518,9519,9520,9521,9522,9523,9526,9528,9556,9564,9567,9803,10274,10400,10460,10461,10462,10464,10465,10528,10529,10560,10851,11014,11015,11017,11018,11323,11324,11325,11326,11327,11328,11329,11331,11332,11334,11336,11337,11339,11340,11341,11342,11343,11344,11345,11346,11348,11349,11351,11352,11353,11354,11355,11356,11357,11360,11365,11366,11367,11368,11369,11371,11372,11373,11374,11375,11376,11377,11378,11379,11383,11652,11656,11658,11660,11661,11694,11695,11696,11697,11698,11700,11702,11709,11824,11825,12045,12049,12050,12059,12063,12067,12069,12078,12166,13210,13215,13231,13232,13236,13237,13240,13241,13246,13247,13248,13257,13268,13269,13270,13271,13272,13273,13274,13275,13278,13279,13280,13283,13284,13287,13290,13291,13298,13305,13306,13307,13308,13309,13318,13319,13320,13327,13329,13330,13331,13332,13333,13334,13337,13338,13339,13340,13341,13342,13355,13357,13358,13359,13360,13361,13370,13371,13378,13379,13380,13381,13390,13841,13842,13857,13872,13891,13895,13897,13900,13903,13905,13908,13911,13912,13917,13918,13921,13931,13935,13936,13937,13941,13955,13958,13963,13966,13967,13973,13974,13980,13981,13984,13990,13992,13996,13997,14001,14005,14007,14008,14019,14025,14026,14031,14036,14037,14038,14040,14044,14049,14050,14056,14059,14061,14062,14070,14073,14074,14075,14082,14083,14084,14086,14088,14089,14090,14108,14111,14114,14116,14118,14125,14127,14129,14130,14133,14134,14135,14138,14140,14141,14146,14147,14157,14162,14163,14164,14166,14170,14173,14176,14177,14184,14185,14191,14201,14202,14208,14210,14216,14224,14242,14243,14250,14254,14610,14614,14646,14649,14655,14656,14659,14663,14667,14690,14717,14718,14719,14722,14723,14724,14725,14726,14728,14731,14735,14736,14738,14739,14740,14741,14744,14745,14750,14751,14752,14753,14754,14756,14757,14759,14760,14761,14762,14763,14765,14766,14767,14768,14769,14770,14772,14773,14774,14775,14776,14777,14779,14780,14781,14782,14783,14785,14786,14787,14788,14789,14790,14791,14792,14793,14794,14795,14796,14797,14798,14800,14801,14803,14805,14806,14807,14808,14809,14811,14812,14813,14814,14815,14816,14817,14818,14819,14820,14822,14823,14824,14825,14826,14827,14828,14829,14830,14831,14832,14833,14834,14835,14836,14837,14838,14839,14840,14841,14842,14843,14844,14845,14846,14847,14848,14849,14850,14851,14852,14853,14854,14855,14856,14857,14858,14859,14860,14861,14862,14863,14864,14865,14867,14868,14869,14871,14872,14897,14906,14912,14922,14927,14930,14947,14952,14953,14967,14972,14987,14990,15710,15711,15724,15736,16294,16352,16355,16363,16366,16370,16371,16373,16374,16375,16379,16381,16383,16386,16389,16395,16396,16399,16405,16449,16563,16613,16615,16617,16618,16619,16625,16626,16636,16644,16645,16647,16728,16774,16775,16776,16777,16887,16949,16996,17008,17014,17022,17067,17127,17146,17162,17169,17240,17425,17446,17451,17478,17479,17480,17482,17483,17600,17601,17602,17631,17656,17677,17689,17699,17700,17705,17718,17721,17722,17724,17731,17745,17747,17753,17757,17765,17771,17775,17776,17777,17784,17785,17786,17787,17790,17792,17793,17796,17801,17802,17804,17805,17807,17810,17812,17813,17814,17821,17822,17826,17829,17831,17832,17833,17924,17929,17931,17955,17956,17958,17963,17964,17965,17966,17967,17969,17971,17972,17973,17975,17978,17979,17980,17986,17989,18014,18030,18031,18034,18048,18054,18063,18074,18080,18890,18891,18892,18893,18894,18898,18899,18900,18901,18902,18903,18904,18905,18906,18908,18909,18910,18911,18912,18913,18914,18915,18916,18917,18918,18919,18920,18921,18943,18944,18949,18950,18952,18953,18957,18971,18974,18985,18986,18987,19009,19010,19015,19016,19020,19021,19035,19037,19038,19048,19049,19050,19051,19052,19054,19065,19067,19068,19073,19079,19080,19081,19083,19084,19105,19117,19124,19125,19130,19131,19132,19133,19134,19135,19136,19141,19149,19151,19156,19157,19159,19161,19163,19166,19167,19169,19170,19172,19173,19176,19177,19178,19179,19180,19183,19185,19186,19187,19189,19191,19193,19194,19200,19201,19203,19205,19206,19208,19209,19211,19212,19216,19217,19218,19221,19222,19223,19224,19225,19226,19227,19228,19229,19230,19231,19232,19233,19234,19235,19236,19237,19238,19239,19240,19241,19242,19243,19244,19245,19246,19247,19248,19254,19255,19257,19258,19259,19260,19261,19262,19263,19264,19265,19266,19267,19268,19269,19270,19271,19272,19273,19274,19275,19276,19277,19278,19279,19281,19282,19283,19284,19285,19286,19287,19288,19289,19290,19291,19292,19293,19294,19295,19296,19297,19298,19299,19300,19301,19302,19303,19304,19305,19306,19307,19308,19309,19310,19311,19312,19313,19314,19315,19316,19317,19318,19319,19320,19321,19322,19323,19324,19325,19326,19327,19328,19329,19330,19331,19332,19333,19334,19335,19337,19338,19339,19340,19341,19342,19343,19350,19353,19354,19355,19360,19361,19362,19363,19364,19365,19366,19367,19368,19369,19370,19371,19372,19373,19374,19375,19376,19377,19378,19379,19380,19381,19382,19383,19384,19385,19386,19387,19388,19389,19390,19391,19392,19393,19394,19395,19396,19397,19398,19399,19400,19401,19402,19403,19404,19405,19406,19407,19408,19409,19410,19411,19412,19413,19414,19420,19421,19422,19423,19424,19425,19426,19427,19428,19430,19431,19432,19433,19434,19435,19436,19438,19439,19441,19442,19443,19444,19445,19446,19447,19448,19450,19451,19452,19453,19457,19458,19459,19460,19461,19463,19464,19465,19466,19467,19469,19470,19471,19472,19473,19474,19478,19479,19480,19482,19483,19484,19485,19486,19487,19488,19489,19524,19525,19526,19527,19530,19531,19537,19538,19539,19542,19543,19544,19545,19547,19548,19549,19550,19560,19561,19562,19563,19564,19566,19567,19577,19578,19579,19580,19581,19582,19583,19584,19605,19606,19616,19619,19620,19621,19622,19623,19628,19629,19630,19640,19641,19642,19643,19644,19645,19647,19648,19654,19655,19656,19658,19659,19660,19665,19666,19667,19669,19673,19674,19675,19687,19688,19689,19690,19691,19692,19693,19704,19705,19706,19707,19708,19731,19734,19735,19737,19738,19741,19751,19754,19755,19757,19758,19760,19761,19767,19801,19802,19803,19804,19805,19806,19807,19808,19809,19815,19816,19817,19818,19820,19824,19833,19834,19835,19836,19837,19838,19840,19841,19842,19846,19847,19848,19849,19850,19851,19852,19853,19854,19855,19856,19857,19860,19861,19862,19864,19867,19868,19869,19870,19872,19873,19874,19875,19876,19877,19878,19879,19880,19881,19882,19883,19884,19885,19886,19887,19888,19889,19890,19891,19892,19893,19894,19895,19896,19897,19898,19899,19903,19904,19905,19906,19907,19908,19909,19910,19911,19912,19913,19914,19915,19917,19918,19919,19925,19926,19927,19928,19929,19930,19931,19932,19933,19934,19935,19936,19937,19938,19939,19941,19942,19944,19945,19946,19948,19958,19959,19960,19961,19964,19970,19971,19972,19981,19982,19983,19984,19985,19987,19988,19993,19995,19996,19997,20003,20005,20006,20008,20009,20010,20011,20012,20025,20026,20027,20028,20029,20030,20031,20032,20033,20035,20059,20064,20065,20067,20071,20085,20086,20087,20089,20090,20091,20107,20108,20109,20112,20113,20114,20115,20116,20117,20118,20119,20120,20121,20122,20123,20124,20125,20126,20127,20128,20129,20130,20131,20132,20133,20134,20136,20137,20140,20144,20145,20146,20147,20148,20149,20150,20151,20152,20155,20160,20163,20164,20165,20166,20167,20168,20169,20170,20171,20172,20177,20179,20180,20182,20183,20184,20185,20186,20187,20188,20189,20193,20200,20204,20205,20206,20209,20210,20211,20215,20220,20225,20226,20227,20228,20229,20230,20231,20233,20235,20236,20241,20242,20243,20247,20248,20249,20251,20252,20253,20254,20255,20257,20259,20260,20261,20270,20271,20272,20273,20274,20275,20276,20294,20310,20314,20315,20316,20317,20318,20319,20320,20321,20322,20323,20324,20325,20326,20327,20328,20329,20332,20333,20334,20335,20336,20337,20338,20339,20340,20342,20343,20349,20350,20351,20352,20353,20354,20355,20356,20357,20358,20359,20360,20361,20362,20363,20364,20366,20367,20368,20370,20371,20372,20373,20380,20381,20384,20390,20391,20604,20609,20610,20611,20614,20615,20616,20617,20618,20619,20620,20622,20623,20624,20625,20626,20627,20628,20655,20656,20657,20658,20659,20663,20670,20680,20684,20695,20705,20706,20707,20708,20709,20710,20711,20712,20713,20714,20715,20717,20718,20719,20721,20723,20724,20725,20726,20727,20728,20732,20733,20740,20741,20742,20744,20745,20746,20747,20749,20750,20751,20752,20753,20754,20755,20756,20757,20758,20759,20760,20761,20762,20763,20764,20765,20766,20767,20768,20769,20770,20772,20773,20774,20775,20777,20778,20780,20781,20784,20785,20786,20787,20788,20789,20790,20795,20796,20797,20798,20799,20800,20801,20802,20803,20806,20807,20808,20809,20811,20812,20823,20824,20826,20827,20828,20829,20830,20831,20833,20834,20835,20837,20838,20839,20840,20841,20842,20843,20844,20845,20846,20847,20848,20849,20850,20851,20862,20863,20864,20865,20866,20867,20868,20869,20871,20873,20875,20876,20877,20878,20879,20881,20882,20883,20884,20885,20886,20888,20889,20890,20891,20892,20893,20894,20895,20896,20899,20900,20901,20902,20906,20907,20908,20909,20910,20913,20914,20915,20916,20924,20925,20926,20927,20928,20929,20930,20932,20937,20939,20940,20941,20942,20943,20944,20945,20946,20947,20948,20949,20950,20952,20953,20954,20955,20962,20963,20964,20965,20966,20967,20968,20969,20971,20972,20973,20974,20975,20976,20980,20981,20982,20983,20984,20986,20989,20990,20991,20992,20993,20994,20995,20996,20997,21012,21013,21014,21015,21016,21017,21018,21019,21020,21024,21025,21026,21027,21028,21029,21030,21053,21054,21055,21056,21057,21058,21059,21060,21061,21062,21063,21064,21065,21066,21068,21069,21070,21071,21072,21073,21074,21075,21076,21081,21082,21083,21084,21085,21086,21087,21088,21089,21090,21091,21092,21094,21095,21096,21097,21098,21099,21100,21101,21102,21103,21104,21105,21106,21107,21110,21111,21112,21113,21120,21121,21122,21123,21124,21125,21126,21127,21128,21129,21141,21142,21143,21145,21146,21147,21148,21149,21159,21169,21170,21171,21172,21173,21174,21175,21177,21178,21179,21180,21181,21182,21184,21185,21186,21187,21188,21189,21190,21192,21194,21195,21196,21198,21199,21200,21201,21202,21204,21206,21207,21208,21209,21210,21211,21236,21237,21239,21241,21242,21243,21244,21245,21246,21247,21249,21250,21251,21252,21253,21254,21255,21256,21257,21258,21259,21260,21261,21279,21280,21281,21282,21283,21311,21312,21314,21315,21316,21317,21318,21319,21331,21332,21333,21334,21335,21336,21337,21338,21342,21343,21344,21362,21363,21365,21366,21368,21370,21372,21374,21375,22216,22217,22219,22220,22221,22222,22223,22224,22360,22361,22362,22404,22415,22454,22475,22480,22484,22487,22488,22652,22697,22791,22846,22880,22910,22964,23093,23125,23135,23154,23185,23233,23300,23301,23302,23303,23308,23316,23319,23321,23342,23344,23345,23347,23348,23354,23460,23461,23469,23483,23486,23503,23519,23520,23522,23524,23554,23555,23556,23583,23592,23593,23594,23596,23597,23598,23599,23600,23601,23602,23603,23604,23605,23615,23616,23618,23619,23624,23625,23626,23630,23637,23638,23640,23644,23649,23656,23657,23658,23659,23660,23664,23665,23668,23677,23681,23682,23683,23684,23685,23690,23691,23696,23697,23698,23700,23701,23702,23704,23705,23708,23709,23713,23714,23716,23717,23718,23719,23721,23722,23723,23724,23726,23728,23731,23732,23733,23734,23735,23736,23737,23741,23748,23749,23750,23751,23752,23753,23756,23757,23758,23760,23761,23762,23763,23764,23765,23766,23767,23768,23770,23771,23772,23773,23774,23775,23776,23777,23778,23779,23781,23782,23783,23785,23787,23796,23797,23799,23826,23827,23828,23829,23830,23833,23834,23835,23837,23838,23839,23840,23841,23842,23843,23845,23846,23848,23850,23852,23853,23854,23856,23857,23859,23860,23865,23866,23869,23870,23876,23878,23880,23881,23900,23901,23907,23909,23916,23919,23920,23921,23922,23923,23924,23925,23926,23927,23928,23929,23930,23931,23932,23933,23934,23935,23936,23937,23938,23940,23941,23942,23943,23949,23950,23951,23952,23953,23954,23958,23959,23960,23961,23962,23964,23965,23966,23967,23968,23969,23970,23971,23972,23974,23978,23979,23980,23981,23982,23983,23984,23988,23989,23990,23991,23992,23993,23996,23997,23998,23999,24000,24001,24012,24053,24054,24055,24056,24057,24058,24059,24060,24062,24063,24064,24065,24066,24067,24068,24069,24070,24071,24072,24073,24074,24075,24076,24077,24078,24079,24080,24081,24082,24083,24084,24085,24086,24102,24103,24104,24105,24106,24117,24125,24131,24132,24133,24134,24135,24136,24137,24138,24139,24140,24141,24142,24143,24144,24145,24146,24147,24148,24149,24150,24151,24152,24153,24154,24155,24156,24158,24159,24160,24161,24162,24163,24164,24166,24167,24168,24169,24170,24171,24172,24173,24174,24175,24176,24177,24178,24182,24183,24184,24185,24186,24188,24190,24192,24193,24194,24196,24197,24198,24199,24200,24201,24202,24203,24204,24205,24206,24207,24208,24210,24226,24227,24228,24229,24230,24231,24232,24233,24234,24235,24236,24237,24238,24239,24240,24241,24242,24243,24244,24245,24246,24247,24248,24249,24250,24251,24252,24253,24254,24255,24256,24257,24258,24259,24260,24261,24262,24263,24264,24265,24266,24267,24268,24269,24270,24271,24272,24273,24274,24275,24276,24277,24278,24279,24280,24281,24282,24283,24284,24285,24286,24287,24288,24289,24290,24291,24292,24293,24294,24295,24296,24297,24298,24299,24300,24301,24302,24303,24304,24305,24306,24310,24311,24312,24313) GROUP BY p.id_product ORDER BY cp.position asc LIMIT 3400,50
476. {
477. $this->last_cached = true;
478. return $result;
479. }
480.
481. $this->result = $this->query($sql);
482. if (!$this->result)
483. return false;
484.
485. $this->last_cached = false;
486. if (!$array)
Argument [0] SELECT p.*, product_shop.*, product_shop.id_category_default, pl.*, i.id_image, il.legend, m.name manufacturer_name, DATEDIFF(product_shop.`date_add`, DATE_SUB(NOW(), INTERVAL 20 DAY)) > 0 AS new FROM `eh_category_product` cp LEFT JOIN eh_category c ON (c.id_category = cp.id_category) LEFT JOIN `eh_product` p ON p.`id_product` = cp.`id_product` INNER JOIN eh_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) LEFT JOIN eh_product_lang pl ON (pl.id_product = p.id_product) LEFT JOIN eh_image i ON (i.id_product = p.id_product AND i.cover = 1) LEFT JOIN eh_image_lang il ON (i.id_image = il.id_image AND il.id_lang = 7) LEFT JOIN eh_manufacturer m ON (m.id_manufacturer = p.id_manufacturer) WHERE product_shop.`active` = 1 AND c.nleft >= 5 AND c.nright <= 122 AND c.active = 1 AND pl.id_lang = 7 AND p.id_product IN (5662,5663,5664,5665,5666,5667,5668,5669,5670,5671,5672,5678,5679,5680,5682,5683,5684,5685,5686,5687,5688,5689,5690,5691,5692,5693,5694,5696,5698,5700,5701,5702,5703,5706,5707,5710,5711,5712,5713,5715,5716,5717,5718,5719,5720,5721,5722,5723,5724,5725,5727,5729,5730,5731,5733,5734,5742,5743,5744,5745,5746,5747,5748,5749,5750,5751,5752,5753,5754,5755,5756,5757,5758,5759,5760,5761,5762,5763,5764,5765,5766,5767,5768,5769,5770,5773,5774,5775,5776,5777,5778,5779,5780,5781,5782,5783,5784,5785,5786,5787,5788,5789,5790,5791,5792,5793,5794,5795,5796,5797,5798,5799,5800,5801,5803,5804,5805,5836,5863,5864,5865,6016,6017,6018,6019,6020,6021,6022,6023,6024,6025,6026,6027,6028,6029,6030,6031,6032,6033,6034,6035,6036,6037,6038,6039,6040,6041,6042,6043,6044,6047,6048,6049,6050,6051,6052,6053,6054,6055,6056,6057,6058,6059,6060,6061,6062,6063,6064,6065,6066,6067,6068,6069,6070,6071,6072,6073,6074,6075,6076,6077,6078,6079,6080,6081,6082,6083,6084,6085,6087,6088,6089,6090,6091,6092,6093,6094,6095,6096,6097,6098,6099,6100,6118,6119,6120,6121,6122,6123,6124,6125,6126,6127,6128,6129,6130,6131,6135,6136,6137,6138,6140,6141,6142,6143,6144,6145,6146,6147,6148,6149,6150,6151,6152,6153,6154,6155,6156,6157,6158,6159,6160,6161,6162,6163,6164,6165,6166,6167,6168,6169,6170,6171,6172,6173,6174,6175,6176,6177,6178,6179,6180,6181,6182,6183,6184,6185,6186,6187,6188,6189,6190,6191,6192,6193,6194,6195,6196,6197,6198,6199,6200,6201,6202,6203,6204,6205,6206,6207,6208,6209,6210,6211,6212,6213,6214,6215,6216,6217,6218,6219,6220,6221,6222,6223,6224,6225,6226,6227,6228,6229,6230,6231,6232,6233,6234,6235,6236,6237,6238,6239,6240,6241,6242,6243,6244,6245,6246,6247,6248,6249,6250,6251,6252,6253,6254,6255,6256,6257,6258,6259,6260,6261,6262,6263,6264,6265,6266,6267,6268,6269,6270,6271,6272,6273,6274,6275,6276,6277,6278,6279,6280,6283,6284,6285,6286,6287,6288,6289,6290,6291,6292,6293,6294,6295,6296,6297,6298,6299,6300,6301,6302,6303,6304,6305,6306,6307,6308,6309,6310,6311,6312,6313,6314,6315,6316,6317,6318,6319,6320,6321,6322,6324,6325,6326,6327,6328,6329,6330,6331,6332,6333,6334,6335,6336,6337,6338,6339,6340,6341,6342,6343,6344,6345,6346,6347,6348,6349,6350,6351,6352,6353,6354,6355,6356,6357,6358,6359,6360,6361,6362,6363,6364,6365,6366,6367,6368,6369,6370,6371,6372,6373,6374,6375,6376,6377,6378,6379,6380,6381,6382,6383,6384,6385,6386,6387,6388,6389,6390,6391,6392,6393,6394,6395,6396,6397,6398,6399,6400,6401,6402,6403,6404,6405,6406,6407,6408,6409,6410,6411,6412,6413,6414,6415,6416,6417,6418,6419,6420,6421,6422,6423,6424,6425,6426,6427,6428,6429,6430,6431,6432,6433,6434,6435,6436,6437,6438,6439,6440,6441,6442,6443,6444,6445,6446,6447,6448,6449,6450,6451,6452,6453,6454,6455,6456,6457,6458,6459,6460,6461,6462,6463,6464,6465,6466,6467,6468,6469,6470,6471,6472,6473,6474,6475,6476,6477,6478,6479,6480,6481,6482,6483,6484,6485,6486,6487,6488,6489,6490,6491,6492,6493,6494,6495,6496,6497,6498,6499,6500,6501,6502,6503,6504,6505,6506,6507,6508,6509,6510,6511,6512,6513,6514,6515,6516,6517,6518,6519,6520,6521,6529,6530,6531,6532,6533,6534,6535,6536,6537,6538,6540,6541,6542,6543,6544,6545,6546,6547,6548,6549,6550,6551,6552,6553,6554,6555,6556,6557,6558,6559,6560,6561,6562,6563,6564,6565,6566,6567,6568,6569,6570,6571,6572,6573,6574,6575,6576,6577,6578,6579,6580,6581,6582,6583,6584,6585,6586,6587,6588,6589,6590,6591,6592,6593,6594,6595,6596,6597,6598,6599,6600,6601,6602,6603,6604,6605,6606,6607,6608,6609,6610,6611,6612,6613,6614,6615,6616,6617,6618,6619,6620,6621,6622,6623,6624,6625,6626,6627,6628,6629,6630,6631,6632,6633,6634,6635,6636,6637,6638,6639,6640,6641,6642,6643,6644,6645,6646,6647,6648,6649,6650,6651,6652,6653,6654,6655,6656,6657,6658,6659,6660,6661,6662,6663,6664,6665,6666,6667,6668,6669,6670,6671,6672,6673,6674,6675,6676,6677,6678,6679,6680,6761,6777,6778,6785,6786,6787,6788,6789,6790,6791,6792,6794,6795,6796,6797,6798,6799,6800,6801,6802,6803,6804,6805,6806,6807,6808,6809,6810,6811,6812,6813,6814,6815,6816,6817,6818,6819,6820,6821,6822,6823,6824,6825,6826,6827,6828,6829,6830,6831,6832,6833,6834,6835,6836,6837,6838,6839,6840,6841,6842,6843,6844,6845,6846,6847,6848,6864,6865,7071,7072,7077,7078,7079,7080,7081,7082,7083,7084,7085,7086,7087,7088,7089,7090,7091,7092,7093,7094,7095,7096,7097,7099,7100,7108,7109,7110,7111,7115,7116,7117,7118,7119,7120,7121,7122,7123,7124,7125,7127,7128,7260,7262,7263,7264,7265,7266,7267,7268,7269,7270,7272,7273,7275,7277,7278,7279,7280,7281,7282,7283,7284,7285,7286,7287,7288,7289,7290,7291,7292,7293,7294,7295,7296,7297,7298,7299,7300,7301,7302,7303,7304,7305,7306,7307,7308,7309,7310,7311,7312,7313,7314,7315,7316,7317,7318,7319,7320,7321,7322,7323,7324,7325,7326,7327,7328,7329,7330,7331,7332,7333,7334,7335,7336,7337,7338,7339,7340,7341,7342,7343,7344,7345,7346,7347,7348,7349,7351,7352,7353,7378,7379,7381,7397,7408,7409,7410,7411,7412,7413,7414,7415,7416,7417,7418,7419,7420,7452,7467,7468,7469,7470,7471,7472,7473,7474,8445,8446,8447,8448,8474,8475,8476,8477,8478,8479,8480,8481,8482,8483,8711,8716,8717,8719,8720,8721,8722,8725,8726,8727,8728,8729,8730,8731,8732,8733,8734,8735,8736,8737,8738,8739,8742,8754,8755,8756,8757,8758,8759,8760,8761,8762,8763,8764,8765,8767,8768,8769,8770,8771,8772,8773,8774,8775,8776,8777,8778,8779,8781,8791,8870,8871,8872,8873,8874,8875,8876,8877,8878,8879,8880,8881,8882,8883,8884,8885,8886,8887,8888,8889,8890,8891,8892,8893,8894,8895,8896,8898,8899,8900,8901,8905,8906,8907,8908,8909,8915,8916,8917,8918,8919,8920,8921,8922,8923,8924,8925,8926,8927,8928,8929,8930,8931,8932,8933,8934,8935,8936,8947,8948,8949,8950,8951,9126,9128,9131,9132,9133,9134,9135,9136,9137,9138,9139,9140,9141,9142,9143,9144,9147,9148,9149,9150,9151,9152,9154,9155,9156,9157,9158,9160,9161,9162,9164,9165,9166,9171,9172,9173,9174,9175,9176,9177,9178,9179,9180,9181,9182,9183,9184,9185,9186,9189,9194,9196,9213,9214,9215,9219,9220,9268,9272,9276,9278,9279,9280,9281,9282,9283,9284,9285,9286,9287,9288,9289,9290,9291,9292,9293,9294,9295,9296,9297,9300,9301,9303,9304,9305,9306,9307,9308,9309,9310,9311,9312,9313,9314,9315,9316,9317,9318,9319,9320,9321,9322,9323,9324,9325,9326,9327,9328,9329,9330,9331,9333,9334,9335,9337,9338,9341,9343,9344,9345,9346,9347,9448,9449,9450,9451,9452,9453,9454,9479,9480,9481,9482,9483,9484,9485,9486,9487,9488,9489,9490,9491,9492,9495,9496,9497,9498,9499,9500,9502,9503,9504,9505,9506,9507,9509,9510,9511,9512,9513,9514,9515,9516,9518,9519,9520,9521,9522,9523,9526,9528,9556,9564,9567,9803,10274,10400,10460,10461,10462,10464,10465,10528,10529,10560,10851,11014,11015,11017,11018,11323,11324,11325,11326,11327,11328,11329,11331,11332,11334,11336,11337,11339,11340,11341,11342,11343,11344,11345,11346,11348,11349,11351,11352,11353,11354,11355,11356,11357,11360,11365,11366,11367,11368,11369,11371,11372,11373,11374,11375,11376,11377,11378,11379,11383,11652,11656,11658,11660,11661,11694,11695,11696,11697,11698,11700,11702,11709,11824,11825,12045,12049,12050,12059,12063,12067,12069,12078,12166,13210,13215,13231,13232,13236,13237,13240,13241,13246,13247,13248,13257,13268,13269,13270,13271,13272,13273,13274,13275,13278,13279,13280,13283,13284,13287,13290,13291,13298,13305,13306,13307,13308,13309,13318,13319,13320,13327,13329,13330,13331,13332,13333,13334,13337,13338,13339,13340,13341,13342,13355,13357,13358,13359,13360,13361,13370,13371,13378,13379,13380,13381,13390,13841,13842,13857,13872,13891,13895,13897,13900,13903,13905,13908,13911,13912,13917,13918,13921,13931,13935,13936,13937,13941,13955,13958,13963,13966,13967,13973,13974,13980,13981,13984,13990,13992,13996,13997,14001,14005,14007,14008,14019,14025,14026,14031,14036,14037,14038,14040,14044,14049,14050,14056,14059,14061,14062,14070,14073,14074,14075,14082,14083,14084,14086,14088,14089,14090,14108,14111,14114,14116,14118,14125,14127,14129,14130,14133,14134,14135,14138,14140,14141,14146,14147,14157,14162,14163,14164,14166,14170,14173,14176,14177,14184,14185,14191,14201,14202,14208,14210,14216,14224,14242,14243,14250,14254,14610,14614,14646,14649,14655,14656,14659,14663,14667,14690,14717,14718,14719,14722,14723,14724,14725,14726,14728,14731,14735,14736,14738,14739,14740,14741,14744,14745,14750,14751,14752,14753,14754,14756,14757,14759,14760,14761,14762,14763,14765,14766,14767,14768,14769,14770,14772,14773,14774,14775,14776,14777,14779,14780,14781,14782,14783,14785,14786,14787,14788,14789,14790,14791,14792,14793,14794,14795,14796,14797,14798,14800,14801,14803,14805,14806,14807,14808,14809,14811,14812,14813,14814,14815,14816,14817,14818,14819,14820,14822,14823,14824,14825,14826,14827,14828,14829,14830,14831,14832,14833,14834,14835,14836,14837,14838,14839,14840,14841,14842,14843,14844,14845,14846,14847,14848,14849,14850,14851,14852,14853,14854,14855,14856,14857,14858,14859,14860,14861,14862,14863,14864,14865,14867,14868,14869,14871,14872,14897,14906,14912,14922,14927,14930,14947,14952,14953,14967,14972,14987,14990,15710,15711,15724,15736,16294,16352,16355,16363,16366,16370,16371,16373,16374,16375,16379,16381,16383,16386,16389,16395,16396,16399,16405,16449,16563,16613,16615,16617,16618,16619,16625,16626,16636,16644,16645,16647,16728,16774,16775,16776,16777,16887,16949,16996,17008,17014,17022,17067,17127,17146,17162,17169,17240,17425,17446,17451,17478,17479,17480,17482,17483,17600,17601,17602,17631,17656,17677,17689,17699,17700,17705,17718,17721,17722,17724,17731,17745,17747,17753,17757,17765,17771,17775,17776,17777,17784,17785,17786,17787,17790,17792,17793,17796,17801,17802,17804,17805,17807,17810,17812,17813,17814,17821,17822,17826,17829,17831,17832,17833,17924,17929,17931,17955,17956,17958,17963,17964,17965,17966,17967,17969,17971,17972,17973,17975,17978,17979,17980,17986,17989,18014,18030,18031,18034,18048,18054,18063,18074,18080,18890,18891,18892,18893,18894,18898,18899,18900,18901,18902,18903,18904,18905,18906,18908,18909,18910,18911,18912,18913,18914,18915,18916,18917,18918,18919,18920,18921,18943,18944,18949,18950,18952,18953,18957,18971,18974,18985,18986,18987,19009,19010,19015,19016,19020,19021,19035,19037,19038,19048,19049,19050,19051,19052,19054,19065,19067,19068,19073,19079,19080,19081,19083,19084,19105,19117,19124,19125,19130,19131,19132,19133,19134,19135,19136,19141,19149,19151,19156,19157,19159,19161,19163,19166,19167,19169,19170,19172,19173,19176,19177,19178,19179,19180,19183,19185,19186,19187,19189,19191,19193,19194,19200,19201,19203,19205,19206,19208,19209,19211,19212,19216,19217,19218,19221,19222,19223,19224,19225,19226,19227,19228,19229,19230,19231,19232,19233,19234,19235,19236,19237,19238,19239,19240,19241,19242,19243,19244,19245,19246,19247,19248,19254,19255,19257,19258,19259,19260,19261,19262,19263,19264,19265,19266,19267,19268,19269,19270,19271,19272,19273,19274,19275,19276,19277,19278,19279,19281,19282,19283,19284,19285,19286,19287,19288,19289,19290,19291,19292,19293,19294,19295,19296,19297,19298,19299,19300,19301,19302,19303,19304,19305,19306,19307,19308,19309,19310,19311,19312,19313,19314,19315,19316,19317,19318,19319,19320,19321,19322,19323,19324,19325,19326,19327,19328,19329,19330,19331,19332,19333,19334,19335,19337,19338,19339,19340,19341,19342,19343,19350,19353,19354,19355,19360,19361,19362,19363,19364,19365,19366,19367,19368,19369,19370,19371,19372,19373,19374,19375,19376,19377,19378,19379,19380,19381,19382,19383,19384,19385,19386,19387,19388,19389,19390,19391,19392,19393,19394,19395,19396,19397,19398,19399,19400,19401,19402,19403,19404,19405,19406,19407,19408,19409,19410,19411,19412,19413,19414,19420,19421,19422,19423,19424,19425,19426,19427,19428,19430,19431,19432,19433,19434,19435,19436,19438,19439,19441,19442,19443,19444,19445,19446,19447,19448,19450,19451,19452,19453,19457,19458,19459,19460,19461,19463,19464,19465,19466,19467,19469,19470,19471,19472,19473,19474,19478,19479,19480,19482,19483,19484,19485,19486,19487,19488,19489,19524,19525,19526,19527,19530,19531,19537,19538,19539,19542,19543,19544,19545,19547,19548,19549,19550,19560,19561,19562,19563,19564,19566,19567,19577,19578,19579,19580,19581,19582,19583,19584,19605,19606,19616,19619,19620,19621,19622,19623,19628,19629,19630,19640,19641,19642,19643,19644,19645,19647,19648,19654,19655,19656,19658,19659,19660,19665,19666,19667,19669,19673,19674,19675,19687,19688,19689,19690,19691,19692,19693,19704,19705,19706,19707,19708,19731,19734,19735,19737,19738,19741,19751,19754,19755,19757,19758,19760,19761,19767,19801,19802,19803,19804,19805,19806,19807,19808,19809,19815,19816,19817,19818,19820,19824,19833,19834,19835,19836,19837,19838,19840,19841,19842,19846,19847,19848,19849,19850,19851,19852,19853,19854,19855,19856,19857,19860,19861,19862,19864,19867,19868,19869,19870,19872,19873,19874,19875,19876,19877,19878,19879,19880,19881,19882,19883,19884,19885,19886,19887,19888,19889,19890,19891,19892,19893,19894,19895,19896,19897,19898,19899,19903,19904,19905,19906,19907,19908,19909,19910,19911,19912,19913,19914,19915,19917,19918,19919,19925,19926,19927,19928,19929,19930,19931,19932,19933,19934,19935,19936,19937,19938,19939,19941,19942,19944,19945,19946,19948,19958,19959,19960,19961,19964,19970,19971,19972,19981,19982,19983,19984,19985,19987,19988,19993,19995,19996,19997,20003,20005,20006,20008,20009,20010,20011,20012,20025,20026,20027,20028,20029,20030,20031,20032,20033,20035,20059,20064,20065,20067,20071,20085,20086,20087,20089,20090,20091,20107,20108,20109,20112,20113,20114,20115,20116,20117,20118,20119,20120,20121,20122,20123,20124,20125,20126,20127,20128,20129,20130,20131,20132,20133,20134,20136,20137,20140,20144,20145,20146,20147,20148,20149,20150,20151,20152,20155,20160,20163,20164,20165,20166,20167,20168,20169,20170,20171,20172,20177,20179,20180,20182,20183,20184,20185,20186,20187,20188,20189,20193,20200,20204,20205,20206,20209,20210,20211,20215,20220,20225,20226,20227,20228,20229,20230,20231,20233,20235,20236,20241,20242,20243,20247,20248,20249,20251,20252,20253,20254,20255,20257,20259,20260,20261,20270,20271,20272,20273,20274,20275,20276,20294,20310,20314,20315,20316,20317,20318,20319,20320,20321,20322,20323,20324,20325,20326,20327,20328,20329,20332,20333,20334,20335,20336,20337,20338,20339,20340,20342,20343,20349,20350,20351,20352,20353,20354,20355,20356,20357,20358,20359,20360,20361,20362,20363,20364,20366,20367,20368,20370,20371,20372,20373,20380,20381,20384,20390,20391,20604,20609,20610,20611,20614,20615,20616,20617,20618,20619,20620,20622,20623,20624,20625,20626,20627,20628,20655,20656,20657,20658,20659,20663,20670,20680,20684,20695,20705,20706,20707,20708,20709,20710,20711,20712,20713,20714,20715,20717,20718,20719,20721,20723,20724,20725,20726,20727,20728,20732,20733,20740,20741,20742,20744,20745,20746,20747,20749,20750,20751,20752,20753,20754,20755,20756,20757,20758,20759,20760,20761,20762,20763,20764,20765,20766,20767,20768,20769,20770,20772,20773,20774,20775,20777,20778,20780,20781,20784,20785,20786,20787,20788,20789,20790,20795,20796,20797,20798,20799,20800,20801,20802,20803,20806,20807,20808,20809,20811,20812,20823,20824,20826,20827,20828,20829,20830,20831,20833,20834,20835,20837,20838,20839,20840,20841,20842,20843,20844,20845,20846,20847,20848,20849,20850,20851,20862,20863,20864,20865,20866,20867,20868,20869,20871,20873,20875,20876,20877,20878,20879,20881,20882,20883,20884,20885,20886,20888,20889,20890,20891,20892,20893,20894,20895,20896,20899,20900,20901,20902,20906,20907,20908,20909,20910,20913,20914,20915,20916,20924,20925,20926,20927,20928,20929,20930,20932,20937,20939,20940,20941,20942,20943,20944,20945,20946,20947,20948,20949,20950,20952,20953,20954,20955,20962,20963,20964,20965,20966,20967,20968,20969,20971,20972,20973,20974,20975,20976,20980,20981,20982,20983,20984,20986,20989,20990,20991,20992,20993,20994,20995,20996,20997,21012,21013,21014,21015,21016,21017,21018,21019,21020,21024,21025,21026,21027,21028,21029,21030,21053,21054,21055,21056,21057,21058,21059,21060,21061,21062,21063,21064,21065,21066,21068,21069,21070,21071,21072,21073,21074,21075,21076,21081,21082,21083,21084,21085,21086,21087,21088,21089,21090,21091,21092,21094,21095,21096,21097,21098,21099,21100,21101,21102,21103,21104,21105,21106,21107,21110,21111,21112,21113,21120,21121,21122,21123,21124,21125,21126,21127,21128,21129,21141,21142,21143,21145,21146,21147,21148,21149,21159,21169,21170,21171,21172,21173,21174,21175,21177,21178,21179,21180,21181,21182,21184,21185,21186,21187,21188,21189,21190,21192,21194,21195,21196,21198,21199,21200,21201,21202,21204,21206,21207,21208,21209,21210,21211,21236,21237,21239,21241,21242,21243,21244,21245,21246,21247,21249,21250,21251,21252,21253,21254,21255,21256,21257,21258,21259,21260,21261,21279,21280,21281,21282,21283,21311,21312,21314,21315,21316,21317,21318,21319,21331,21332,21333,21334,21335,21336,21337,21338,21342,21343,21344,21362,21363,21365,21366,21368,21370,21372,21374,21375,22216,22217,22219,22220,22221,22222,22223,22224,22360,22361,22362,22404,22415,22454,22475,22480,22484,22487,22488,22652,22697,22791,22846,22880,22910,22964,23093,23125,23135,23154,23185,23233,23300,23301,23302,23303,23308,23316,23319,23321,23342,23344,23345,23347,23348,23354,23460,23461,23469,23483,23486,23503,23519,23520,23522,23524,23554,23555,23556,23583,23592,23593,23594,23596,23597,23598,23599,23600,23601,23602,23603,23604,23605,23615,23616,23618,23619,23624,23625,23626,23630,23637,23638,23640,23644,23649,23656,23657,23658,23659,23660,23664,23665,23668,23677,23681,23682,23683,23684,23685,23690,23691,23696,23697,23698,23700,23701,23702,23704,23705,23708,23709,23713,23714,23716,23717,23718,23719,23721,23722,23723,23724,23726,23728,23731,23732,23733,23734,23735,23736,23737,23741,23748,23749,23750,23751,23752,23753,23756,23757,23758,23760,23761,23762,23763,23764,23765,23766,23767,23768,23770,23771,23772,23773,23774,23775,23776,23777,23778,23779,23781,23782,23783,23785,23787,23796,23797,23799,23826,23827,23828,23829,23830,23833,23834,23835,23837,23838,23839,23840,23841,23842,23843,23845,23846,23848,23850,23852,23853,23854,23856,23857,23859,23860,23865,23866,23869,23870,23876,23878,23880,23881,23900,23901,23907,23909,23916,23919,23920,23921,23922,23923,23924,23925,23926,23927,23928,23929,23930,23931,23932,23933,23934,23935,23936,23937,23938,23940,23941,23942,23943,23949,23950,23951,23952,23953,23954,23958,23959,23960,23961,23962,23964,23965,23966,23967,23968,23969,23970,23971,23972,23974,23978,23979,23980,23981,23982,23983,23984,23988,23989,23990,23991,23992,23993,23996,23997,23998,23999,24000,24001,24012,24053,24054,24055,24056,24057,24058,24059,24060,24062,24063,24064,24065,24066,24067,24068,24069,24070,24071,24072,24073,24074,24075,24076,24077,24078,24079,24080,24081,24082,24083,24084,24085,24086,24102,24103,24104,24105,24106,24117,24125,24131,24132,24133,24134,24135,24136,24137,24138,24139,24140,24141,24142,24143,24144,24145,24146,24147,24148,24149,24150,24151,24152,24153,24154,24155,24156,24158,24159,24160,24161,24162,24163,24164,24166,24167,24168,24169,24170,24171,24172,24173,24174,24175,24176,24177,24178,24182,24183,24184,24185,24186,24188,24190,24192,24193,24194,24196,24197,24198,24199,24200,24201,24202,24203,24204,24205,24206,24207,24208,24210,24226,24227,24228,24229,24230,24231,24232,24233,24234,24235,24236,24237,24238,24239,24240,24241,24242,24243,24244,24245,24246,24247,24248,24249,24250,24251,24252,24253,24254,24255,24256,24257,24258,24259,24260,24261,24262,24263,24264,24265,24266,24267,24268,24269,24270,24271,24272,24273,24274,24275,24276,24277,24278,24279,24280,24281,24282,24283,24284,24285,24286,24287,24288,24289,24290,24291,24292,24293,24294,24295,24296,24297,24298,24299,24300,24301,24302,24303,24304,24305,24306,24310,24311,24312,24313) GROUP BY p.id_product ORDER BY cp.position asc LIMIT 3400,50
2533. AND c.nright <= '.(int)$parent->nright : 'c.id_category = '.(int)$id_parent).'
2534. AND c.active = 1
2535. AND pl.id_lang = '.(int)$cookie->id_lang.'
2536. AND p.id_product IN ('.implode(',', $product_id_list).')'
2537. .' GROUP BY p.id_product ORDER BY '.Tools::getProductsOrder('by', Tools::getValue('orderby'), true).' '.Tools::getProductsOrder('way', Tools::getValue('orderway')).
2538. ' LIMIT '.(((int)$this->page - 1) * $n.','.$n));
2539. }
2540.
2541. if (Tools::getProductsOrder('by', Tools::getValue('orderby'), true) == 'p.price')
2542. Tools::orderbyPrice($this->products, Tools::getProductsOrder('way', Tools::getValue('orderway')));
2543.
Argument [0] SELECT p.*, product_shop.*, product_shop.id_category_default, pl.*, i.id_image, il.legend, m.name manufacturer_name, DATEDIFF(product_shop.`date_add`, DATE_SUB(NOW(), INTERVAL 20 DAY)) > 0 AS new FROM `eh_category_product` cp LEFT JOIN eh_category c ON (c.id_category = cp.id_category) LEFT JOIN `eh_product` p ON p.`id_product` = cp.`id_product` INNER JOIN eh_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) LEFT JOIN eh_product_lang pl ON (pl.id_product = p.id_product) LEFT JOIN eh_image i ON (i.id_product = p.id_product AND i.cover = 1) LEFT JOIN eh_image_lang il ON (i.id_image = il.id_image AND il.id_lang = 7) LEFT JOIN eh_manufacturer m ON (m.id_manufacturer = p.id_manufacturer) WHERE product_shop.`active` = 1 AND c.nleft >= 5 AND c.nright <= 122 AND c.active = 1 AND pl.id_lang = 7 AND p.id_product IN (5662,5663,5664,5665,5666,5667,5668,5669,5670,5671,5672,5678,5679,5680,5682,5683,5684,5685,5686,5687,5688,5689,5690,5691,5692,5693,5694,5696,5698,5700,5701,5702,5703,5706,5707,5710,5711,5712,5713,5715,5716,5717,5718,5719,5720,5721,5722,5723,5724,5725,5727,5729,5730,5731,5733,5734,5742,5743,5744,5745,5746,5747,5748,5749,5750,5751,5752,5753,5754,5755,5756,5757,5758,5759,5760,5761,5762,5763,5764,5765,5766,5767,5768,5769,5770,5773,5774,5775,5776,5777,5778,5779,5780,5781,5782,5783,5784,5785,5786,5787,5788,5789,5790,5791,5792,5793,5794,5795,5796,5797,5798,5799,5800,5801,5803,5804,5805,5836,5863,5864,5865,6016,6017,6018,6019,6020,6021,6022,6023,6024,6025,6026,6027,6028,6029,6030,6031,6032,6033,6034,6035,6036,6037,6038,6039,6040,6041,6042,6043,6044,6047,6048,6049,6050,6051,6052,6053,6054,6055,6056,6057,6058,6059,6060,6061,6062,6063,6064,6065,6066,6067,6068,6069,6070,6071,6072,6073,6074,6075,6076,6077,6078,6079,6080,6081,6082,6083,6084,6085,6087,6088,6089,6090,6091,6092,6093,6094,6095,6096,6097,6098,6099,6100,6118,6119,6120,6121,6122,6123,6124,6125,6126,6127,6128,6129,6130,6131,6135,6136,6137,6138,6140,6141,6142,6143,6144,6145,6146,6147,6148,6149,6150,6151,6152,6153,6154,6155,6156,6157,6158,6159,6160,6161,6162,6163,6164,6165,6166,6167,6168,6169,6170,6171,6172,6173,6174,6175,6176,6177,6178,6179,6180,6181,6182,6183,6184,6185,6186,6187,6188,6189,6190,6191,6192,6193,6194,6195,6196,6197,6198,6199,6200,6201,6202,6203,6204,6205,6206,6207,6208,6209,6210,6211,6212,6213,6214,6215,6216,6217,6218,6219,6220,6221,6222,6223,6224,6225,6226,6227,6228,6229,6230,6231,6232,6233,6234,6235,6236,6237,6238,6239,6240,6241,6242,6243,6244,6245,6246,6247,6248,6249,6250,6251,6252,6253,6254,6255,6256,6257,6258,6259,6260,6261,6262,6263,6264,6265,6266,6267,6268,6269,6270,6271,6272,6273,6274,6275,6276,6277,6278,6279,6280,6283,6284,6285,6286,6287,6288,6289,6290,6291,6292,6293,6294,6295,6296,6297,6298,6299,6300,6301,6302,6303,6304,6305,6306,6307,6308,6309,6310,6311,6312,6313,6314,6315,6316,6317,6318,6319,6320,6321,6322,6324,6325,6326,6327,6328,6329,6330,6331,6332,6333,6334,6335,6336,6337,6338,6339,6340,6341,6342,6343,6344,6345,6346,6347,6348,6349,6350,6351,6352,6353,6354,6355,6356,6357,6358,6359,6360,6361,6362,6363,6364,6365,6366,6367,6368,6369,6370,6371,6372,6373,6374,6375,6376,6377,6378,6379,6380,6381,6382,6383,6384,6385,6386,6387,6388,6389,6390,6391,6392,6393,6394,6395,6396,6397,6398,6399,6400,6401,6402,6403,6404,6405,6406,6407,6408,6409,6410,6411,6412,6413,6414,6415,6416,6417,6418,6419,6420,6421,6422,6423,6424,6425,6426,6427,6428,6429,6430,6431,6432,6433,6434,6435,6436,6437,6438,6439,6440,6441,6442,6443,6444,6445,6446,6447,6448,6449,6450,6451,6452,6453,6454,6455,6456,6457,6458,6459,6460,6461,6462,6463,6464,6465,6466,6467,6468,6469,6470,6471,6472,6473,6474,6475,6476,6477,6478,6479,6480,6481,6482,6483,6484,6485,6486,6487,6488,6489,6490,6491,6492,6493,6494,6495,6496,6497,6498,6499,6500,6501,6502,6503,6504,6505,6506,6507,6508,6509,6510,6511,6512,6513,6514,6515,6516,6517,6518,6519,6520,6521,6529,6530,6531,6532,6533,6534,6535,6536,6537,6538,6540,6541,6542,6543,6544,6545,6546,6547,6548,6549,6550,6551,6552,6553,6554,6555,6556,6557,6558,6559,6560,6561,6562,6563,6564,6565,6566,6567,6568,6569,6570,6571,6572,6573,6574,6575,6576,6577,6578,6579,6580,6581,6582,6583,6584,6585,6586,6587,6588,6589,6590,6591,6592,6593,6594,6595,6596,6597,6598,6599,6600,6601,6602,6603,6604,6605,6606,6607,6608,6609,6610,6611,6612,6613,6614,6615,6616,6617,6618,6619,6620,6621,6622,6623,6624,6625,6626,6627,6628,6629,6630,6631,6632,6633,6634,6635,6636,6637,6638,6639,6640,6641,6642,6643,6644,6645,6646,6647,6648,6649,6650,6651,6652,6653,6654,6655,6656,6657,6658,6659,6660,6661,6662,6663,6664,6665,6666,6667,6668,6669,6670,6671,6672,6673,6674,6675,6676,6677,6678,6679,6680,6761,6777,6778,6785,6786,6787,6788,6789,6790,6791,6792,6794,6795,6796,6797,6798,6799,6800,6801,6802,6803,6804,6805,6806,6807,6808,6809,6810,6811,6812,6813,6814,6815,6816,6817,6818,6819,6820,6821,6822,6823,6824,6825,6826,6827,6828,6829,6830,6831,6832,6833,6834,6835,6836,6837,6838,6839,6840,6841,6842,6843,6844,6845,6846,6847,6848,6864,6865,7071,7072,7077,7078,7079,7080,7081,7082,7083,7084,7085,7086,7087,7088,7089,7090,7091,7092,7093,7094,7095,7096,7097,7099,7100,7108,7109,7110,7111,7115,7116,7117,7118,7119,7120,7121,7122,7123,7124,7125,7127,7128,7260,7262,7263,7264,7265,7266,7267,7268,7269,7270,7272,7273,7275,7277,7278,7279,7280,7281,7282,7283,7284,7285,7286,7287,7288,7289,7290,7291,7292,7293,7294,7295,7296,7297,7298,7299,7300,7301,7302,7303,7304,7305,7306,7307,7308,7309,7310,7311,7312,7313,7314,7315,7316,7317,7318,7319,7320,7321,7322,7323,7324,7325,7326,7327,7328,7329,7330,7331,7332,7333,7334,7335,7336,7337,7338,7339,7340,7341,7342,7343,7344,7345,7346,7347,7348,7349,7351,7352,7353,7378,7379,7381,7397,7408,7409,7410,7411,7412,7413,7414,7415,7416,7417,7418,7419,7420,7452,7467,7468,7469,7470,7471,7472,7473,7474,8445,8446,8447,8448,8474,8475,8476,8477,8478,8479,8480,8481,8482,8483,8711,8716,8717,8719,8720,8721,8722,8725,8726,8727,8728,8729,8730,8731,8732,8733,8734,8735,8736,8737,8738,8739,8742,8754,8755,8756,8757,8758,8759,8760,8761,8762,8763,8764,8765,8767,8768,8769,8770,8771,8772,8773,8774,8775,8776,8777,8778,8779,8781,8791,8870,8871,8872,8873,8874,8875,8876,8877,8878,8879,8880,8881,8882,8883,8884,8885,8886,8887,8888,8889,8890,8891,8892,8893,8894,8895,8896,8898,8899,8900,8901,8905,8906,8907,8908,8909,8915,8916,8917,8918,8919,8920,8921,8922,8923,8924,8925,8926,8927,8928,8929,8930,8931,8932,8933,8934,8935,8936,8947,8948,8949,8950,8951,9126,9128,9131,9132,9133,9134,9135,9136,9137,9138,9139,9140,9141,9142,9143,9144,9147,9148,9149,9150,9151,9152,9154,9155,9156,9157,9158,9160,9161,9162,9164,9165,9166,9171,9172,9173,9174,9175,9176,9177,9178,9179,9180,9181,9182,9183,9184,9185,9186,9189,9194,9196,9213,9214,9215,9219,9220,9268,9272,9276,9278,9279,9280,9281,9282,9283,9284,9285,9286,9287,9288,9289,9290,9291,9292,9293,9294,9295,9296,9297,9300,9301,9303,9304,9305,9306,9307,9308,9309,9310,9311,9312,9313,9314,9315,9316,9317,9318,9319,9320,9321,9322,9323,9324,9325,9326,9327,9328,9329,9330,9331,9333,9334,9335,9337,9338,9341,9343,9344,9345,9346,9347,9448,9449,9450,9451,9452,9453,9454,9479,9480,9481,9482,9483,9484,9485,9486,9487,9488,9489,9490,9491,9492,9495,9496,9497,9498,9499,9500,9502,9503,9504,9505,9506,9507,9509,9510,9511,9512,9513,9514,9515,9516,9518,9519,9520,9521,9522,9523,9526,9528,9556,9564,9567,9803,10274,10400,10460,10461,10462,10464,10465,10528,10529,10560,10851,11014,11015,11017,11018,11323,11324,11325,11326,11327,11328,11329,11331,11332,11334,11336,11337,11339,11340,11341,11342,11343,11344,11345,11346,11348,11349,11351,11352,11353,11354,11355,11356,11357,11360,11365,11366,11367,11368,11369,11371,11372,11373,11374,11375,11376,11377,11378,11379,11383,11652,11656,11658,11660,11661,11694,11695,11696,11697,11698,11700,11702,11709,11824,11825,12045,12049,12050,12059,12063,12067,12069,12078,12166,13210,13215,13231,13232,13236,13237,13240,13241,13246,13247,13248,13257,13268,13269,13270,13271,13272,13273,13274,13275,13278,13279,13280,13283,13284,13287,13290,13291,13298,13305,13306,13307,13308,13309,13318,13319,13320,13327,13329,13330,13331,13332,13333,13334,13337,13338,13339,13340,13341,13342,13355,13357,13358,13359,13360,13361,13370,13371,13378,13379,13380,13381,13390,13841,13842,13857,13872,13891,13895,13897,13900,13903,13905,13908,13911,13912,13917,13918,13921,13931,13935,13936,13937,13941,13955,13958,13963,13966,13967,13973,13974,13980,13981,13984,13990,13992,13996,13997,14001,14005,14007,14008,14019,14025,14026,14031,14036,14037,14038,14040,14044,14049,14050,14056,14059,14061,14062,14070,14073,14074,14075,14082,14083,14084,14086,14088,14089,14090,14108,14111,14114,14116,14118,14125,14127,14129,14130,14133,14134,14135,14138,14140,14141,14146,14147,14157,14162,14163,14164,14166,14170,14173,14176,14177,14184,14185,14191,14201,14202,14208,14210,14216,14224,14242,14243,14250,14254,14610,14614,14646,14649,14655,14656,14659,14663,14667,14690,14717,14718,14719,14722,14723,14724,14725,14726,14728,14731,14735,14736,14738,14739,14740,14741,14744,14745,14750,14751,14752,14753,14754,14756,14757,14759,14760,14761,14762,14763,14765,14766,14767,14768,14769,14770,14772,14773,14774,14775,14776,14777,14779,14780,14781,14782,14783,14785,14786,14787,14788,14789,14790,14791,14792,14793,14794,14795,14796,14797,14798,14800,14801,14803,14805,14806,14807,14808,14809,14811,14812,14813,14814,14815,14816,14817,14818,14819,14820,14822,14823,14824,14825,14826,14827,14828,14829,14830,14831,14832,14833,14834,14835,14836,14837,14838,14839,14840,14841,14842,14843,14844,14845,14846,14847,14848,14849,14850,14851,14852,14853,14854,14855,14856,14857,14858,14859,14860,14861,14862,14863,14864,14865,14867,14868,14869,14871,14872,14897,14906,14912,14922,14927,14930,14947,14952,14953,14967,14972,14987,14990,15710,15711,15724,15736,16294,16352,16355,16363,16366,16370,16371,16373,16374,16375,16379,16381,16383,16386,16389,16395,16396,16399,16405,16449,16563,16613,16615,16617,16618,16619,16625,16626,16636,16644,16645,16647,16728,16774,16775,16776,16777,16887,16949,16996,17008,17014,17022,17067,17127,17146,17162,17169,17240,17425,17446,17451,17478,17479,17480,17482,17483,17600,17601,17602,17631,17656,17677,17689,17699,17700,17705,17718,17721,17722,17724,17731,17745,17747,17753,17757,17765,17771,17775,17776,17777,17784,17785,17786,17787,17790,17792,17793,17796,17801,17802,17804,17805,17807,17810,17812,17813,17814,17821,17822,17826,17829,17831,17832,17833,17924,17929,17931,17955,17956,17958,17963,17964,17965,17966,17967,17969,17971,17972,17973,17975,17978,17979,17980,17986,17989,18014,18030,18031,18034,18048,18054,18063,18074,18080,18890,18891,18892,18893,18894,18898,18899,18900,18901,18902,18903,18904,18905,18906,18908,18909,18910,18911,18912,18913,18914,18915,18916,18917,18918,18919,18920,18921,18943,18944,18949,18950,18952,18953,18957,18971,18974,18985,18986,18987,19009,19010,19015,19016,19020,19021,19035,19037,19038,19048,19049,19050,19051,19052,19054,19065,19067,19068,19073,19079,19080,19081,19083,19084,19105,19117,19124,19125,19130,19131,19132,19133,19134,19135,19136,19141,19149,19151,19156,19157,19159,19161,19163,19166,19167,19169,19170,19172,19173,19176,19177,19178,19179,19180,19183,19185,19186,19187,19189,19191,19193,19194,19200,19201,19203,19205,19206,19208,19209,19211,19212,19216,19217,19218,19221,19222,19223,19224,19225,19226,19227,19228,19229,19230,19231,19232,19233,19234,19235,19236,19237,19238,19239,19240,19241,19242,19243,19244,19245,19246,19247,19248,19254,19255,19257,19258,19259,19260,19261,19262,19263,19264,19265,19266,19267,19268,19269,19270,19271,19272,19273,19274,19275,19276,19277,19278,19279,19281,19282,19283,19284,19285,19286,19287,19288,19289,19290,19291,19292,19293,19294,19295,19296,19297,19298,19299,19300,19301,19302,19303,19304,19305,19306,19307,19308,19309,19310,19311,19312,19313,19314,19315,19316,19317,19318,19319,19320,19321,19322,19323,19324,19325,19326,19327,19328,19329,19330,19331,19332,19333,19334,19335,19337,19338,19339,19340,19341,19342,19343,19350,19353,19354,19355,19360,19361,19362,19363,19364,19365,19366,19367,19368,19369,19370,19371,19372,19373,19374,19375,19376,19377,19378,19379,19380,19381,19382,19383,19384,19385,19386,19387,19388,19389,19390,19391,19392,19393,19394,19395,19396,19397,19398,19399,19400,19401,19402,19403,19404,19405,19406,19407,19408,19409,19410,19411,19412,19413,19414,19420,19421,19422,19423,19424,19425,19426,19427,19428,19430,19431,19432,19433,19434,19435,19436,19438,19439,19441,19442,19443,19444,19445,19446,19447,19448,19450,19451,19452,19453,19457,19458,19459,19460,19461,19463,19464,19465,19466,19467,19469,19470,19471,19472,19473,19474,19478,19479,19480,19482,19483,19484,19485,19486,19487,19488,19489,19524,19525,19526,19527,19530,19531,19537,19538,19539,19542,19543,19544,19545,19547,19548,19549,19550,19560,19561,19562,19563,19564,19566,19567,19577,19578,19579,19580,19581,19582,19583,19584,19605,19606,19616,19619,19620,19621,19622,19623,19628,19629,19630,19640,19641,19642,19643,19644,19645,19647,19648,19654,19655,19656,19658,19659,19660,19665,19666,19667,19669,19673,19674,19675,19687,19688,19689,19690,19691,19692,19693,19704,19705,19706,19707,19708,19731,19734,19735,19737,19738,19741,19751,19754,19755,19757,19758,19760,19761,19767,19801,19802,19803,19804,19805,19806,19807,19808,19809,19815,19816,19817,19818,19820,19824,19833,19834,19835,19836,19837,19838,19840,19841,19842,19846,19847,19848,19849,19850,19851,19852,19853,19854,19855,19856,19857,19860,19861,19862,19864,19867,19868,19869,19870,19872,19873,19874,19875,19876,19877,19878,19879,19880,19881,19882,19883,19884,19885,19886,19887,19888,19889,19890,19891,19892,19893,19894,19895,19896,19897,19898,19899,19903,19904,19905,19906,19907,19908,19909,19910,19911,19912,19913,19914,19915,19917,19918,19919,19925,19926,19927,19928,19929,19930,19931,19932,19933,19934,19935,19936,19937,19938,19939,19941,19942,19944,19945,19946,19948,19958,19959,19960,19961,19964,19970,19971,19972,19981,19982,19983,19984,19985,19987,19988,19993,19995,19996,19997,20003,20005,20006,20008,20009,20010,20011,20012,20025,20026,20027,20028,20029,20030,20031,20032,20033,20035,20059,20064,20065,20067,20071,20085,20086,20087,20089,20090,20091,20107,20108,20109,20112,20113,20114,20115,20116,20117,20118,20119,20120,20121,20122,20123,20124,20125,20126,20127,20128,20129,20130,20131,20132,20133,20134,20136,20137,20140,20144,20145,20146,20147,20148,20149,20150,20151,20152,20155,20160,20163,20164,20165,20166,20167,20168,20169,20170,20171,20172,20177,20179,20180,20182,20183,20184,20185,20186,20187,20188,20189,20193,20200,20204,20205,20206,20209,20210,20211,20215,20220,20225,20226,20227,20228,20229,20230,20231,20233,20235,20236,20241,20242,20243,20247,20248,20249,20251,20252,20253,20254,20255,20257,20259,20260,20261,20270,20271,20272,20273,20274,20275,20276,20294,20310,20314,20315,20316,20317,20318,20319,20320,20321,20322,20323,20324,20325,20326,20327,20328,20329,20332,20333,20334,20335,20336,20337,20338,20339,20340,20342,20343,20349,20350,20351,20352,20353,20354,20355,20356,20357,20358,20359,20360,20361,20362,20363,20364,20366,20367,20368,20370,20371,20372,20373,20380,20381,20384,20390,20391,20604,20609,20610,20611,20614,20615,20616,20617,20618,20619,20620,20622,20623,20624,20625,20626,20627,20628,20655,20656,20657,20658,20659,20663,20670,20680,20684,20695,20705,20706,20707,20708,20709,20710,20711,20712,20713,20714,20715,20717,20718,20719,20721,20723,20724,20725,20726,20727,20728,20732,20733,20740,20741,20742,20744,20745,20746,20747,20749,20750,20751,20752,20753,20754,20755,20756,20757,20758,20759,20760,20761,20762,20763,20764,20765,20766,20767,20768,20769,20770,20772,20773,20774,20775,20777,20778,20780,20781,20784,20785,20786,20787,20788,20789,20790,20795,20796,20797,20798,20799,20800,20801,20802,20803,20806,20807,20808,20809,20811,20812,20823,20824,20826,20827,20828,20829,20830,20831,20833,20834,20835,20837,20838,20839,20840,20841,20842,20843,20844,20845,20846,20847,20848,20849,20850,20851,20862,20863,20864,20865,20866,20867,20868,20869,20871,20873,20875,20876,20877,20878,20879,20881,20882,20883,20884,20885,20886,20888,20889,20890,20891,20892,20893,20894,20895,20896,20899,20900,20901,20902,20906,20907,20908,20909,20910,20913,20914,20915,20916,20924,20925,20926,20927,20928,20929,20930,20932,20937,20939,20940,20941,20942,20943,20944,20945,20946,20947,20948,20949,20950,20952,20953,20954,20955,20962,20963,20964,20965,20966,20967,20968,20969,20971,20972,20973,20974,20975,20976,20980,20981,20982,20983,20984,20986,20989,20990,20991,20992,20993,20994,20995,20996,20997,21012,21013,21014,21015,21016,21017,21018,21019,21020,21024,21025,21026,21027,21028,21029,21030,21053,21054,21055,21056,21057,21058,21059,21060,21061,21062,21063,21064,21065,21066,21068,21069,21070,21071,21072,21073,21074,21075,21076,21081,21082,21083,21084,21085,21086,21087,21088,21089,21090,21091,21092,21094,21095,21096,21097,21098,21099,21100,21101,21102,21103,21104,21105,21106,21107,21110,21111,21112,21113,21120,21121,21122,21123,21124,21125,21126,21127,21128,21129,21141,21142,21143,21145,21146,21147,21148,21149,21159,21169,21170,21171,21172,21173,21174,21175,21177,21178,21179,21180,21181,21182,21184,21185,21186,21187,21188,21189,21190,21192,21194,21195,21196,21198,21199,21200,21201,21202,21204,21206,21207,21208,21209,21210,21211,21236,21237,21239,21241,21242,21243,21244,21245,21246,21247,21249,21250,21251,21252,21253,21254,21255,21256,21257,21258,21259,21260,21261,21279,21280,21281,21282,21283,21311,21312,21314,21315,21316,21317,21318,21319,21331,21332,21333,21334,21335,21336,21337,21338,21342,21343,21344,21362,21363,21365,21366,21368,21370,21372,21374,21375,22216,22217,22219,22220,22221,22222,22223,22224,22360,22361,22362,22404,22415,22454,22475,22480,22484,22487,22488,22652,22697,22791,22846,22880,22910,22964,23093,23125,23135,23154,23185,23233,23300,23301,23302,23303,23308,23316,23319,23321,23342,23344,23345,23347,23348,23354,23460,23461,23469,23483,23486,23503,23519,23520,23522,23524,23554,23555,23556,23583,23592,23593,23594,23596,23597,23598,23599,23600,23601,23602,23603,23604,23605,23615,23616,23618,23619,23624,23625,23626,23630,23637,23638,23640,23644,23649,23656,23657,23658,23659,23660,23664,23665,23668,23677,23681,23682,23683,23684,23685,23690,23691,23696,23697,23698,23700,23701,23702,23704,23705,23708,23709,23713,23714,23716,23717,23718,23719,23721,23722,23723,23724,23726,23728,23731,23732,23733,23734,23735,23736,23737,23741,23748,23749,23750,23751,23752,23753,23756,23757,23758,23760,23761,23762,23763,23764,23765,23766,23767,23768,23770,23771,23772,23773,23774,23775,23776,23777,23778,23779,23781,23782,23783,23785,23787,23796,23797,23799,23826,23827,23828,23829,23830,23833,23834,23835,23837,23838,23839,23840,23841,23842,23843,23845,23846,23848,23850,23852,23853,23854,23856,23857,23859,23860,23865,23866,23869,23870,23876,23878,23880,23881,23900,23901,23907,23909,23916,23919,23920,23921,23922,23923,23924,23925,23926,23927,23928,23929,23930,23931,23932,23933,23934,23935,23936,23937,23938,23940,23941,23942,23943,23949,23950,23951,23952,23953,23954,23958,23959,23960,23961,23962,23964,23965,23966,23967,23968,23969,23970,23971,23972,23974,23978,23979,23980,23981,23982,23983,23984,23988,23989,23990,23991,23992,23993,23996,23997,23998,23999,24000,24001,24012,24053,24054,24055,24056,24057,24058,24059,24060,24062,24063,24064,24065,24066,24067,24068,24069,24070,24071,24072,24073,24074,24075,24076,24077,24078,24079,24080,24081,24082,24083,24084,24085,24086,24102,24103,24104,24105,24106,24117,24125,24131,24132,24133,24134,24135,24136,24137,24138,24139,24140,24141,24142,24143,24144,24145,24146,24147,24148,24149,24150,24151,24152,24153,24154,24155,24156,24158,24159,24160,24161,24162,24163,24164,24166,24167,24168,24169,24170,24171,24172,24173,24174,24175,24176,24177,24178,24182,24183,24184,24185,24186,24188,24190,24192,24193,24194,24196,24197,24198,24199,24200,24201,24202,24203,24204,24205,24206,24207,24208,24210,24226,24227,24228,24229,24230,24231,24232,24233,24234,24235,24236,24237,24238,24239,24240,24241,24242,24243,24244,24245,24246,24247,24248,24249,24250,24251,24252,24253,24254,24255,24256,24257,24258,24259,24260,24261,24262,24263,24264,24265,24266,24267,24268,24269,24270,24271,24272,24273,24274,24275,24276,24277,24278,24279,24280,24281,24282,24283,24284,24285,24286,24287,24288,24289,24290,24291,24292,24293,24294,24295,24296,24297,24298,24299,24300,24301,24302,24303,24304,24305,24306,24310,24311,24312,24313) GROUP BY p.id_product ORDER BY cp.position asc LIMIT 3400,50
3907.
3908. public function getProducts($selected_filters, &$products, &$nb_products, &$p, &$n, &$pages_nb, &$start, &$stop, &$range)
3909. {
3910. global $cookie;
3911.
3912. $products = $this->getProductByFilters($selected_filters);
3913. $products = Product::getProductsProperties((int)$cookie->id_lang, $products);
3914.
3915. $nb_products = $this->nbr_products;
3916. $range = 2; /* how many pages around page selected */
3917.
Argument [0] Array ( [category] => Array ( ) )
491. if (is_array($filter_block['title_values']))
492. foreach ($filter_block['title_values'] as $key => $val)
493. $title .= ' – '.$key.' '.implode('/', $val);
494.
495. $smarty->assign('categoryNameComplement', $title);
496. $this->getProducts($selected_filters, $params['catProducts'], $params['nbProducts'], $p, $n, $pages_nb, $start, $stop, $range);
497. // Need a nofollow on the pagination links?
498. $smarty->assign('no_follow', $filter_block['no_follow']);
499. }
500.
501. public function hookAfterSaveProduct($params)
Argument [0] Array ( [category] => Array ( ) ) Argument [1] Array ( ) Argument [2] Argument [3] Argument [4] Argument [5] Argument [6] Argument [7] Argument [8]
413.
414. // Call hook method
415. if ($hook_callable)
416. $display = $moduleInstance->{'hook'.$hook_name}($hook_args);
417. else if ($hook_retro_callable)
418. $display = $moduleInstance->{'hook'.$retro_hook_name}($hook_args);
419. // Live edit
420. if (!$array_return && $array['live_edit'] && Tools::isSubmit('live_edit') && Tools::getValue('ad') && Tools::getValue('liveToken') == Tools::getAdminToken('AdminModulesPositions'.(int)Tab::getIdFromClassName('AdminModulesPositions').(int)Tools::getValue('id_employee')))
421. {
422. $live_edit = true;
423. $output .= self::wrapLiveEdit($display, $moduleInstance, $array['id_hook']);
Argument [0] Array ( [nbProducts] => [catProducts] => Array ( ) [hookExecuted] => 1 [cookie] => Cookie Object ( [_content:protected] => Array ( [date_add] => 2024-05-04 03:46:28 [id_lang] => 7 [id_currency] => 1 ) [_name:protected] => ba0f167904639bd0df3ffc40aada7545 [_expire:protected] => 1716515188 [_domain:protected] => b2b.happypets.sk [_path:protected] => / [_cipherTool:protected] => Rijndael Object ( [_key:protected] => 5mnNYEony5k5jWYpfa21SFLFuVzdCXvE [_iv:protected] => ©&µüóÒÅídÊ ^¡U ) [_key:protected] => SoejH9LMG34kOKywJsviRNPQTaTDpDF9gcMPb4xr642auJ3mzWChQYWZ [_iv:protected] => dHfw87m5 [_modified:protected] => 1 [_allow_writing:protected] => 1 ) [cart] => Cart Object ( [id] => [id_shop_group] => 1 [id_shop] => 1 [id_address_delivery] => 0 [id_address_invoice] => 0 [id_currency] => 1 [id_customer] => [id_guest] => 0 [id_lang] => 7 [recyclable] => 1 [gift] => 0 [gift_message] => [date_add] => [secure_key] => [id_carrier] => 0 [date_upd] => [checkedTos] => [pictures] => [textFields] => [delivery_option] => [allow_seperated_package] => [_products:protected] => [_taxCalculationMethod:protected] => 0 [webserviceParameters:protected] => Array ( [fields] => Array ( [id_address_delivery] => Array ( [xlink_resource] => addresses ) [id_address_invoice] => Array ( [xlink_resource] => addresses ) [id_currency] => Array ( [xlink_resource] => currencies ) [id_customer] => Array ( [xlink_resource] => customers ) [id_guest] => Array ( [xlink_resource] => guests ) [id_lang] => Array ( [xlink_resource] => languages ) ) [associations] => Array ( [cart_rows] => Array ( [resource] => cart_row [virtual_entity] => 1 [fields] => Array ( [id_product] => Array ( [required] => 1 [xlink_resource] => products ) [id_product_attribute] => Array ( [required] => 1 [xlink_resource] => combinations ) [quantity] => Array ( [required] => 1 ) ) ) ) ) [id_shop_list] => [get_shop_from_context:protected] => 1 [table:protected] => cart [identifier:protected] => id_cart [fieldsRequired:protected] => Array ( [0] => id_currency [1] => id_lang ) [fieldsSize:protected] => Array ( [secure_key] => 32 ) [fieldsValidate:protected] => Array ( [id_shop_group] => isUnsignedId [id_shop] => isUnsignedId [id_address_delivery] => isUnsignedId [id_address_invoice] => isUnsignedId [id_carrier] => isUnsignedId [id_currency] => isUnsignedId [id_customer] => isUnsignedId [id_guest] => isUnsignedId [id_lang] => isUnsignedId [recyclable] => isBool [gift] => isBool [gift_message] => isMessage [allow_seperated_package] => isBool [date_add] => isDateFormat [date_upd] => isDateFormat ) [fieldsRequiredLang:protected] => Array ( ) [fieldsSizeLang:protected] => Array ( ) [fieldsValidateLang:protected] => Array ( ) [tables:protected] => Array ( ) [image_dir:protected] => [image_format:protected] => jpg [def:protected] => Array ( [table] => cart [primary] => id_cart [fields] => Array ( [id_shop_group] => Array ( [type] => 1 [validate] => isUnsignedId ) [id_shop] => Array ( [type] => 1 [validate] => isUnsignedId ) [id_address_delivery] => Array ( [type] => 1 [validate] => isUnsignedId ) [id_address_invoice] => Array ( [type] => 1 [validate] => isUnsignedId ) [id_carrier] => Array ( [type] => 1 [validate] => isUnsignedId ) [id_currency] => Array ( [type] => 1 [validate] => isUnsignedId [required] => 1 ) [id_customer] => Array ( [type] => 1 [validate] => isUnsignedId ) [id_guest] => Array ( [type] => 1 [validate] => isUnsignedId ) [id_lang] => Array ( [type] => 1 [validate] => isUnsignedId [required] => 1 ) [recyclable] => Array ( [type] => 2 [validate] => isBool ) [gift] => Array ( [type] => 2 [validate] => isBool ) [gift_message] => Array ( [type] => 3 [validate] => isMessage ) [delivery_option] => Array ( [type] => 3 ) [secure_key] => Array ( [type] => 3 [size] => 32 ) [allow_seperated_package] => Array ( [type] => 2 [validate] => isBool ) [date_add] => Array ( [type] => 5 [validate] => isDateFormat ) [date_upd] => Array ( [type] => 5 [validate] => isDateFormat ) ) [classname] => Cart ) [update_fields:protected] => ) [altern] => 1 )
179. $hookExecuted = false;
180. Hook::exec('actionProductListOverride', array(
181. 'nbProducts' => &$this->nbProducts,
182. 'catProducts' => &$this->cat_products,
183. 'hookExecuted' => &$hookExecuted,
184. ));
185.
186. // The hook was not executed, standard working
187. if (!$hookExecuted)
188. {
189. $this->context->smarty->assign('categoryNameComplement', '');
Argument [0] actionProductListOverride Argument [1] Array ( [nbProducts] => [catProducts] => Array ( ) [hookExecuted] => 1 )
107. $this->productSort(); // Product sort must be called before assignProductList()
108.
109. $this->assignScenes();
110. $this->assignSubcategories();
111. if ($this->category->id != 1)
112. $this->assignProductList();
113.
114. $this->context->smarty->assign(array(
115. 'category' => $this->category,
116. 'products' => (isset($this->cat_products) && $this->cat_products) ? $this->cat_products : null,
117. 'id_category' => (int)$this->category->id,
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.