SET MELAMINA 3 PCS. (PLATO, CUENCO Y VASO) PEPPA PIG

SELECT SQL_NO_CACHE DISTINCT od.product_id, pl.name, pl.description_short, pl.link_rewrite, p.available_for_order, p.customizable, p.reference, p.id_category_default, i.id_image, product_shop.show_price,
cl.link_rewrite category, p.ean13, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity
FROM ps_order_detail od
LEFT JOIN ps_product p ON (p.id_product = od.product_id)
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) LEFT JOIN ps_stock_available stock
ON (stock.id_product = p.id_product AND stock.id_product_attribute = 0 AND stock.id_shop_group = 1  AND stock.id_shop = 0  )
LEFT JOIN ps_product_lang pl ON (pl.id_product = od.product_id AND pl.id_shop = 1 )
LEFT JOIN ps_category_lang cl ON (cl.id_category = product_shop.id_category_default AND cl.id_shop = 1 )
LEFT JOIN ps_image i ON (i.id_product = od.product_id)
LEFT JOIN `ps_category_product` cp ON (cp.`id_category` = product_shop.id_category_default
AND cp.id_product = product_shop.id_product)
LEFT JOIN `ps_category_group` cg ON (cp.`id_category` = cg.`id_category`)
WHERE od.id_order IN (95,262,437,556,748,767,769,781,789,840,844,845,846,851,877,878,881,886,888,890,892,897,911,916,931,934,943,951,952,956,963,964,965,969,982,983,991,993,995,1010,1049,1055,1057,1058,1064,1072,1074,1075,1078,1082,1083,1084,1085,1102,1107,1108,1121,1125,1127,1130,1134,1139,1141,1151,1157,1159,1166,1174,1185,1192,1193,1194,1195,1196,1198,1199,1200,1202,1206,1211,1232,1234,1238,1240,1245,1246,1249,1250,1251,1252,1255,1257,1260,1265,1266,1297,1299,1301,1302,1303,1304,1307,1312,1318,1319,1322,1327,1333,1335,1339,1356,1373,1383,1384,1408,1430,1433,1435,1436,1452,1455,1456,1475,1482,1487,1493,1494,1495,1513,1514,1516,1519,1524,1533,1536,1537,1538,1539,1541,1543,1550,1551,1552,1556,1558,1561,1562,1574,1585,1586,1590,1591,1593,1597,1601,1607,1609,1610,1616,1619,1624,1626,1633,1634,1646,1647,1648,1652,1653,1654,1655,1659,1660,1661,1664,1665,1666,1667,1668,1669,1672,1673,1674,1675,1676,1679,1680,1683,1687,1688,1692,1693,1694,1698,1699,1704,1711,1715,1722,1724,1738,1739,1741,1742,1743,1745,1746,1747,1748,1758,1760,1761,1766,1768,1779,1780,1785,1786,1792,1803,1807,1811,1812,1814,1815,1817,1820,1821,1832,1837,1871,1872,1901,2001,2004,2006,2007,2009,2022,2038,2041,2042,2043,2048,2050,2051,2053,2054,2056,2057,2058,2065,2068,2075,2082,2084,2087,2088,2105,2108,2116,2122,2129,2151,2155,2159,2160,2161,2163,2164,2165,2166,2167,2168,2169,2172,2173,2186,2187,2204,2205,2208,2209,2210,2212,2213,2214,2215,2218,2220,2221,2223,2224,2226,2231,2238,2251,2252,2254,2256,2257,2260,2261,2263,2266,2270,2271,2273,2281,2293,2307,2310,2313,2314,2315,2316,2318,2323,2328,2332,2333,2334,2335,2336,2337,2365,2376,2378,2385,2394,2395,2406,2413,2417,2419,2420,2424,2425,2428,2430,2444,2445,2457,2458,2466,2468,2471,2476,2479,2480,2483,2489,2511,2521,2523,2524,2538,2559,2561,2565,2572,2573,2574,2578,2584,2586,2605,2614,2616,2617,2624,2628,2634,2638,2642,2644,2652,2676,2684,2688,2689,2690,2691,2698,2713,2715,2719,2728,2731,2745,2746,2748,2750,2756,2759,2760,2761,2768,2773,2777,2780,2783,2800,2801,2804,2805,2806,2821,2822,2824,2825,2827,2845,2847,2848,2850,2859,2861,2862,2867,2869,2871,2873,2874,2876,2879,2881,2889,2890,2898,2911,2914,2929,2931,2935,2943,2945,2950,2951,2973,2974,2975,2976,2977,2978,2979,2990,2994,2997,2998,3002,3013,3014,3016,3017,3018,3019,3021,3023,3026,3031,3032,3033,3034,3040,3044,3046,3048,3063,3065,3089,3090,3093,3094,3095,3096,3107,3111,3112,3114,3123,3127,3128,3130,3141,3144,3145,3154,3166,3167,3182,3183,3185,3197,3205,3214,3223,3225,3231,3244,3246,3253,3255,3266,3305,3309,3310,3311,3313,3319,3320,3321,3323,3329,3334,3339,3343,3360,3365,3383,3384,3385,3387,3389,3393,3396,3399,3406,3421,3422,3423,3426,3440,3454,3466,3467,3468,3473,3475,3477,3492,3506,3509,3510,3511,3525,3541,3542,3544,3549,3550,3553,3554,3555,3556,3557,3578,3581,3592,3595,3596,3597,3601,3604,3614,3617,3646,3661,3665,3667,3668,3669,3671,3673,3675,3695,3697,3698,3700,3701,3705,3707,3726,3747,3751,3788,3794,3829,3830,3833,3836,3837,3838,3839,3840,3841,3842,3843,3852,3873,3884,3888,3905,3906,3908,3910,3917,3924,3939,3946,3962,3972,3973,3974,3975,3977,4000,4001,4012,4013,4024,4030,4077,4089,4091,4232,4363,4459,4466,4478,4498,4544,4549,4564,4648,4649,4650,4661,4662,4720,4722,4743,4744,4761,4765,4768,4769,4771,4784,4785,4794,4851,4869,4871,4875,4895,4897,4898,4901,4902,4907,4931,4963,5001,5019,5028,5043,5084,5085,5088,5103,5107,5111,5122,5142,5143,5148,5192,5224,5228,5230,5274,5282,5345,5346,5349,5376,5404,5415,5416,5502,5520,5521,5522,5539,5540,5590,5597,5640,5692,5732,5733,5765,5766,5873,5874,5875,5879,5908,5924,5960,5996,6009,6011,6018,6019,6022,6050,6054,6055,6083,6091,6107,6108,6110,6112,6128,6170,6181,6186,6189,6190,6200,6223,6224,6225,6244,6259,6262,6280,6281,6284,6286,6289,6296,6312,6313,6314,6318,6322,6323,6326,6327,6359,6380,6381,6382,6383,6386,6416,6426,6427,6438,6439,6440,6441,6442,6447,6449,6450,6452,6466,6475,6480,6484,6485,6490,6493,6495,6500,6501,6507,6520,6521,6522,6525,6527,6528,6536,6537,6547,6548,6553,6556,6565,6569,6570,6571,6578,6597,6598,6610,6618,6628,6639,6640,6651,6673,6675,6676,6677,6678,6695,6697,6727,6729,6734,6735,6736,6741,6743,6746,6749,6758,6766,6785,6786,6798,6812,6813,6829,6834,6835,6842,6844,6858,6861,6878,6887,6891,6895,6898,6899,6903,6906,6913,6918,6925,6926,6939,6946,6960,6961,6962,6964,6965,6971,6973,6987,6990,6998,6999,7000,7002,7009,7012,7043,7061,7069,7121,7123,7174,7246,7262,7263,7265,7275,7290,7311,7321,7323,7330,7333,7344,7348,7353,7354,7368,7370,7373,7387,7389,7390,7400,7402,7420,7421,7434,7459,7460,7461,7462,7486,7490,7496,7508,7509,7517,7529,7541,7543,7545,7550,7560,7575,7576,7582,7583,7584,7585,7586,7587,7592,7598,7600,7601,7603,7610,7620,7627,7628,7629,7632,7633,7637,7643,7647,7649,7659,7668,7670,7676,7687,7690,7708,7709,7712,7715,7716,7720,7733,7739,7742,7752,7756,7766,7767,7769,7770,7783,7785,7786,7787,7789,7792,7801,7811,7812,7817,7830,7836,7839,7841,7845,7849,7850,7852,7859,7860,7861,7864,7866,7867,7868,7871,7873,7874,7879,7881,7884,7886,7887,7890,7900,7901,7914,7915,7939,7940,7951,7959,7966,7967,7968,7982,7984,7985,7987,7991,7994,8000,8001,8007,8020,8022,8023,8027,8029,8035,8038,8039,8047,8054,8060,8062,8063,8064,8069,8071,8076,8077,8078,8079,8081,8082,8087,8088,8090,8106,8109,8110,8112,8113,8114,8118,8120,8121,8122,8123,8132,8133,8134,8139,8141,8143,8144,8145,8152,8158,8159,8160,8161,8162,8163,8167,8169,8170,8173,8174,8175,8176,8177,8184,8188,8191,8193,8194,8195,8196,8198,8199,8200,8203,8204,8208,8213,8219,8221,8225,8233,8234,8236,8237,8238,8240,8242,8244,8246,8247,8249,8262,8263,8264,8271,8272,8276,8278,8283,8284,8285,8288,8290,8293,8294,8295,8296,8297,8301,8305,8307,8314,8315,8319,8336,8337,8338,8339,8346,8347,8348,8349,8353,8354,8355,8357,8358,8368,8372,8384,8385,8388,8389,8390,8395,8396,8398,8399,8401,8402,8403,8404,8405,8406,8411,8413,8418,8420,8421,8423,8426,8427,8428,8432,8435,8444,8473,8486,8489,8493,8495,8505,8507,8512,8513,8517,8523,8541,8548,8549,8550,8552,8556,8557,8558,8559,8560,8562,8563,8564,8567,8569,8577,8580,8583,8588,8589,8602,8604,8611,8612,8613,8614,8615,8616,8617,8618,8621,8622,8623,8624,8625,8631,8634,8635,8637,8638,8639,8645,8648,8650,8651,8653,8658,8665,8667,8668,8677,8681,8683,8684,8685,8693,8700,8708,8709,8717,8718,8719,8720,8721,8722,8723,8724,8725,8726,8727,8728,8729,8730,8731,8732,8734,8735,8736,8738,8739,8741,8749,8751,8752,8754,8759,8760,8761,8762,8763,8764,8765,8767,8768,8769,8770,8771,8772,8773,8776,8782,8784,8785,8799,8800,8801,8802,8809,8813,8815,8816,8817,8818,8823,8831,8836,8838,8854,8856,8857,8858,8860,8861,8862,8863,8870,8873,8874,8875,8876,8877,8878,8879,8881,8887,8888,8889,8890,8891,8893,8894,8895,8896,8897,8898,8900,8901,8902,8903,8904,8905,8906,8908,8909,8910,8911,8913,8916,8922,8923,8928,8929,8932,8933,8940,8952,8953,8957,8965,8967,8968,8969,8970,8980,8982,8983,8984,8985,8986,8987,8989,8990,8991,8994,8995,8998,8999,9003,9004,9006,9009,9012,9013,9014,9015,9016,9017,9019,9020,9022,9023,9026,9027,9028,9030,9033,9037,9043,9049,9050,9053,9060,9076,9082,9083,9084,9085,9086,9087,9088,9089,9090,9091,9092,9094,9095,9097,9098,9099,9100,9101,9102,9103,9104,9105,9106,9107,9108,9112,9113,9114,9115,9117,9118,9119,9120,9121,9127,9128,9130,9131,9132,9137,9140,9177,9181,9184,9189,9191,9197,9203,9204,9205,9206,9208,9209,9210,9211,9212,9228,9232,9233,9234,9236,9239,9240,9241,9244,9246,9253,9264,9265,9266,9267,9268,9275,9279,9281,9295,9296,9299,9301,9302,9303,9305,9306,9307,9308,9309,9310,9316,9318,9319,9321,9322,9323,9324,9327,9329,9330,9331,9332,9333,9334,9335,9336,9338,9339,9340,9341,9351,9361,9362,9363,9364,9365,9366,9367,9372,9382,9383,9388,9389,9391,9393,9394,9395,9405,9409,9412,9413,9415,9416,9417,9432,9438,9443,9444,9446,9447,9448,9449,9450,9451,9453,9454,9456,9457,9460,9461,9462,9465,9466,9470,9482,9484,9494,9497,9504,9505,9514,9519,9520,9521,9522,9524,9527,9533,9534,9540,9541,9542,9545,9546,9549,9550,9551,9552,9555,9556,9557,9558,9559,9566,9567,9587,9592,9604,9605,9610,9612,9614,9618,9621,9622,9624,9626,9627,9628,9629,9630,9631,9632,9633,9634,9636,9637,9638,9653,9654,9655,9656,9657,9658,9659,9660,9661,9662,9663,9664,9665,9669,9670,9673,9679,9680,9682,9683,9684,9685,9686,9687,9689,9701,9703,9706,9715,9717,9718,9720,9721,9724,9725,9728,9736,9737,9738,9741,9742,9743,9744,9745,9746,9747,9748,9749,9750,9751,9752,9753,9754,9755,9757,9758,9760,9761,9762,9764,9765,9766,9768,9769,9770,9771,9773,9782,9783,9785,9786,9788,9790,9791,9792,9793,9799,9803,9805,9810,9811,9814,9842,9844,9845,9846,9849,9851,9852,9854,9863,9865,9879,9880,9882,9883,9884,9887,9888,9889,9890,9891,9892,9893,9898,9899,9901,9902,9908,9909,9911,9914,9917,9919,9920,9925,9926,9927,9936,9937,9962,9963,9973,9977,9980,9981,9982,9985,9986,9987,9988,9989,9990,9991,9992,9993,9994,9997,9999,10002,10004,10006,10007,10008,10010,10014,10015,10018,10021,10034,10035,10036,10037,10048,10052,10054,10059,10061,10064,10068,10069,10070,10071,10073,10075,10076,10079,10084,10089,10090,10091,10093,10094,10095,10097,10098,10105,10106,10108,10109,10112,10121,10122,10124,10125,10127,10139,10140,10141,10143,10145,10147,10149,10150,10151,10152,10153,10156,10157,10158,10159,10160,10161,10162,10163,10168,10169,10171,10173,10178,10179,10180,10183,10186,10187,10188,10189,10190,10191,10195,10198,10200,10210,10220,10225,10228,10230,10241,10242,10244,10245,10257,10258,10259,10260,10265,10266,10268,10271,10272,10275,10276,10277,10278,10279,10280,10282,10284,10285,10286,10287,10289,10290,10291,10292,10300,10303,10304,10308,10310,10311,10313,10314,10315,10320,10321,10324,10328,10330,10331,10332,10334,10339,10343,10344,10345,10346,10347,10350,10351,10352,10359,10360,10363,10364,10371,10372,10375,10376,10377,10379,10381,10382,10384,10386,10390,10391,10392,10394,10411,10427,10428,10450,10465,10471,10481,10509,10512,10513,10515,10519,10520,10533,10535,10540,10541,10545,10547,10550,10552,10557,10567,10570,10575,10577,10579,10580,10594,10601,10604,10611,10612,10615,10616,10619,10631,10634,10649,10650,10660,10662,10663,10665,10666,10667,10668,10669,10670,10671,10673,10676,10677,10678,10681,10685,10687,10688,10689,10690,10707,10713,10715,10716,10719,10721,10727,10730,10733,10734,10737,10739,10745,10748,10752,10753,10754,10756,10758,10760,10761,10767,10770,10775,10776,10779,10790,10797,10799,10806,10823,10828,10834,10835,10836,10837,10839,10841,10845,10847,10848,10853,10857,10858,10865,10866,10867,10868,10869,10870,10872,10873,10877,10879,10885,10887,10888,10891,10908,10909,10910,10913,10915,10916,10917,10919,10920,10923,10927,10928,10929,10932,10934,10937,10947,10948,10952,10957,10958,10966,10970,10971,10974,10976,10983,10986,10988,10989,10999,11002,11003,11019,11027,11028,11029,11031,11036,11044,11052,11055,11056,11057,11063,11065,11073,11086,11088,11091,11092,11094,11096,11097,11098,11103,11104,11105,11106,11107,11108,11109,11112,11114,11117,11122,11123,11125,11126,11127,11129,11131,11155,11176,11213,11237,11240,11245,11246,11248,11249,11254,11261,11265,11267,11273,11276,11277,11296,11355,11358,11360,11361,11362,11363,11364,11365,11366,11367,11370,11375,11376,11377,11379,11393,11401,11404,11406,11426,11470,11475,11476,11477,11480,11482,11483,11484,11485,11487,11488,11492,11494,11495,11497,11499,11509,11512,11513,11514,11517,11518,11519,11531,11566,11575,11596,11886,11994,11996,12043,12289,12434,12454,12462,12503,12679,12741,13531,13532,13547,13586,13597,13603,13604,13608,13611,13612,13613,13617,13618,13619,13620,13626,13628,13630,13638,13649,13650,13672,13674,13680,13683,13686,13688,13689,13695,13700,13705,13706,13708,13710,13731,13740,13747,13752,13758,13759,13760,13761,13764,13765,13774,13789,13792,13802,13804,13805,13806,13807,13809,13815,13835,13845,13847,13852,13859,13867,13868,13878,13879,13898,13905,13909,13910,13917,13921,13922,13923,13924,13925,13957,13958,13961,13962,13963,13964,13965,13966,13987,13988,13997,14000,14003,14006,14009,14010,14032,14037,14045,14052,14063,14075,14076,14090,14095,14101,14105,14113,14115,14119,14120,14123,14124,14135,14143,14153,14156,14157,14171,14172,14175,14178,14183,14185,14190,14200,14201,14215,14232,14233,14234,14241,14257,14261,14263,14264,14265,14266,14268,14274,14279,14281,14283,14290,14292,14293,14294,14296,14311,14313,14315,14317,14329,14330,14333,14335,14340,14345,14360,14366,14373,14385,14388,14393,14395,14397,14428,14429,14431,14435,14437,14439,14445,14446,14449,14452,14458,14463,14466,14474,14493,14498,14506,14515,14524,14535,14540,14546,14547,14549,14554,14572,14585,14590,14594,14604,14609,14614,14615,14616,14623,14628,14640,14645,14647,14648,14651,14664,14665,14669,14671,14674,14675,14676,14679,14698,14705,14706,14707,14708,14725,14727,14728,14729,14734,14738,14741,14752,14756,14758,14760,14762,14763,14767,14770,14776,14777,14786,14788,14793,14808,14831,14848,14850,14852,14853,14857,14858,14859,14860,14862,14864,14868,14869,14870,14871,14876,14883,14884,14885,14906,14907,14914,14919,14920,14931,14932,14934,14939,14949,14966,14969,14971,14976,14978,14979,14982,14983,14987,14988,14990,14993,14995,14996,14997,15001,15005,15008,15013,15037,15046,15048,15051,15052,15055,15056,15057,15059,15068,15075,15083,15084,15095,15098,15099,15100,15119,15121,15122,15137,15139,15140,15142,15143,15147,15148,15164,15171,15180,15181,15183,15190,15193,15201,15202,15203,15205,15208,15210,15211,15225,15233,15252,15254,15255,15259,15260,15263,15264,15265,15266,15267,15285,15291,15292,15301,15303,15310,15316,15319,15320,15322,15323,15324,15325,15328,15330,15331,15333,15336,15349,15351,15353,15354,15355,15356,15357,15384,15396,15398,15400,15401,15407,15408,15411,15414,15419,15423,15425,15436,15437,15440,15444,15460,15478,15485,15489,15490,15503,15508,15510,15511,15516,15518,15529,15532,15535,15537,15538,15576,15577,15579,15581,15582,15586,15589,15592,15593,15594,15595,15614,15616,15620,15631,15632,15639,15641,15642,15655,15656,15657,15658,15665,15667,15687,15688,15693,15698,15702,15706,15716,15738,15740,15753,15754,15761,15774,15776,15779,15782,15783,15785,15786,15787,15790,15795,15808,15809,15810,15812,15825,15837,15838,15839,15840,15841,15845,15860,15879,15881,15882,15884,15887,15894,15895,15901,15905,15910,15916,15927,15928,15929,15931,15933,15937,15938,15939,15945,15951,15967,15973,15977,15997,16017,16026,16031,16035,16044,16091,16109,16113,16115,16144,16171,16173,16175,16176,16185,16187,16195,16203,16213,16233,16243,16245,16246,16249,16266,16268,16294,16296,16299,16307,16310,16319,16320,16322,16323,16324,16329,16332,16335,16336,16343,16344,16345,16346,16347,16349,16350,16351,16352,16353,16355,16362,16383,16384,16398,16405,16421,16422,16423,16425,16426,16427,16428,16429,16455,16465,16473,16480,16482,16487,16492,16495,16497,16499,16518,16537,16543,16550,16551,16558,16562,16563,16564,16577,16585,16589,16590,16594,16598,16599,16605,16606,16607,16609,16611,16614,16629,16633,16636,16637,16639,16649,16660,16661,16671,16689,16690,16692,16695,16697,16698,16705,16714,16721,16723,16729,16741,16750,16751,16762,16775,16777,16779,16782,16787,16791,16795,16800,16802,16803,16805,16807,16811,16812,16814,16815,16818,16822,16825,16826,16846,16849,16851,16853,16857,16875,16878,16887,16888,16904,16912,16913,16923,16924,16931,16936,16938,16942,16943,16944,16958,16960,16962,16964,16966,16985,16987,16992,16998,17003,17008,17010,17014,17021,17038,17040,17050,17057,17059,17061,17063,17064,17070,17071,17077,17078,17084,17086,17087,17088,17090,17091,17092,17102,17109,17112,17119,17138,17156,17157,17159,17161,17166,17167,17168,17185,17186,17191,17194,17198,17204,17208,17209,17213,17229,17233,17244,17256,17260,17261,17269,17270,17282,17285,17287,17289,17291,17292,17299,17316,17317,17318,17325,17329,17334,17343,17344,17346,17349,17351,17362,17364,17367,17372,17392,17395,17401,17416,17419,17425,17426,17428,17432,17433,17434,17437,17439,17448,17449,17456,17466,17473,17480,17481,17490,17491,17494,17500,17501,17502,17505,17507,17511,17513,17525,17527,17528,17531,17532,17555,17556,17559,17562,17563,17564,17566,17569,17571,17573,17576,17585,17586,17589,17593,17597,17605,17612,17613,17634,17639,17641,17642,17643,17647,17648,17653,17655,17657,17658,17660,17661,17664,17669,17697,17706,17707,17708,17712,17714,17715,17717,17719,17723,17726,17728,17731,17732,17735,17741,17756,17761,17770,17771,17772,17774,17779,17787,17788,17792,17796,17798,17799,17800,17803,17811,17815,17817,17818,17824,17836,17838,17840,17841,17847,17851,17855,17856,17862,17863,17865,17866,17867,17870,17887,17891,17900,17903,17907,17911,17914,17920,17927,17929,17931,17932,17933,17935,17937,17938,17939,17942,17943,17945,17952,17957,17960,17961,17965,17966,17967,17968,17974,17976,17977,17980,17981,17983,17985,17986,17988,17989,17990,17992,17993,18001,18009,18016,18017,18018,18031,18037,18038,18039,18040,18041,18045,18048,18054,18055,18056,18059,18060,18061,18066,18069,18073,18074,18076,18077,18079,18084,18086,18087,18092,18097,18098,18103,18104,18107,18108,18110,18118,18121,18122,18128,18129,18130,18136,18139,18144,18145,18150,18161,18164,18168,18172,18174,18175,18176,18187,18197,18203,18204,18205,18206,18209,18212,18214,18215,18221,18234,18235,18236,18238,18239,18259,18265,18266,18267,18268,18271,18280,18282,18283,18284,18289,18290,18294,18299,18300,18301,18303,18307,18309,18310,18313,18317,18325,18334,18338,18339,18345,18346,18347,18352,18354,18355,18356,18357,18358,18360,18373,18386,18389,18390,18392,18393,18394,18397,18400,18402,18409,18413,18414,18419,18421,18422,18423,18425,18426,18430,18432,18433,18435,18444,18450,18451,18455,18458,18465,18466,18467,18470,18475,18477,18479,18481,18487,18488,18489,18494,18496,18502,18504,18505,18506,18516,18520,18522,18523,18528,18529,18530,18531,18535,18536,18547,18561,18567,18568,18569,18571,18576,18577,18578,18579,18580,18581,18582,18583,18584,18592,18595,18602,18603,18604,18608,18609,18610,18611,18612,18614,18615,18619,18621,18623,18628,18629,18632,18634,18635,18636,18640,18641,18643,18646,18648,18649,18650,18654,18655,18656,18657,18659,18664,18665,18666,18668,18669,18672,18673,18674,18675,18677,18689,18690,18693,18694,18698,18703,18705,18709,18710,18712,18714,18715,18716,18717,18721,18725,18731,18734,18735,18739,18744,18746,18756,18757,18758,18759,18760,18761,18762,18766,18771,18773,18777,18779,18781,18793,18796,18799,18801,18803,18804,18805,18816,18819,18820,18839,18842,18846,18859,18862,18871,18883,18892,18897,18898,18899,18900,18901,18910,18913,18920,18921,18924,18925,18950,18969,18990,18992,18993,18994,18995,18996,19003,19004,19007,19033,19036,19037,19039,19041,19055,19056,19057,19059,19064,19065,19069,19070,19071,19074,19094,19099,19109,19117,19119,19122,19124,19137,19141,19142,19144,19149,19150,19156,19163,19168,19169,19171,19180,19189,19210,19215,19216,19265,19269,19278,19288,19290,19295,19296,19305,19309,19310,19325,19326,19328,19330,19331,19333,19345,19346,19350,19352,19359,19382,19384,19392,19400,19407,19408,19410,19412,19414,19426,19429,19432,19438,19455,19456,19474,19485,19505,19506,19507,19511,19513,19521,19525,19539,19540,19542,19544,19545,19546,19547,19550,19574,19598,19599,19601,19603,19604,19606,19611,19613,19614,19623,19632,19633,19647,19652,19654,19655,19657,19660,19670,19686,19699,19700,19705,19707,19710,19711,19713,19714,19716,19718,19719,19723,19738,19743,19748,19749,19752,19755,19761,19764,19765,19774,19775,19777,19778,19781,19794,19797,19804,19805,19807,19811,19813,19818,19819,19832,19835,19842,19847,19853,19863,19864,19872,19879,19882,19885,19887,19888,19889,19896,19897,19900,19905,19917,19927,19934,19935,19937,19939,19951,19958,19959,19969,19971,19972,19984,19985,19988,19995,19997,20002,20007,20009,20016,20020,20031,20032,20034,20035,20044,20045,20051,20053,20054,20055,20056,20057,20058,20066,20075,20088,20093,20098,20103,20105,20120,20122,20123,20125,20127,20131,20135,20137,20142,20143,20157,20164,20171,20177,20200,20206,20216,20226,20230,20234,20235,20248,20261,20262,20264,20270,20280,20290,20299,20316,20320,20325,20344,20345,20351,20357,20358,20359,20360,20375,20383,20386,20388,20392,20403,20408,20417,20423,20425,20426,20434,20442,20447,20458,20465,20469,20474,20476,20477,20491,20500,20505,20525,20548,20564,20571,20580,20590,20591,20595,20601,20605,20607,20630,20635,20644,20645,20648,20656,20673,20674,20676,20683,20698,20703,20704,20708,20709,20710,20715,20742,20752,20782,20783,20789,20792,20796,20797,20809,20815,20817,20820,20828,20839,20849,20850,20854,20869,20871,20875,20876,20890,20891,20892,20893,20896,20916,20919,20950,20951,20957,20963,20964,20968,20993,21000,21004,21007,21009,21011,21016,21018,21027,21035,21049,21050,21055,21081,21090,21092,21102,21106,21113,21133,21142,21146,21147,21155,21159,21169,21171,21176,21185,21187,21201,21209,21211,21214,21226,21228,21230,21235,21239,21240,21259,21268,21273,21285,21292,21298,21306,21322,21336,21338,21340,21341,21344,21350,21351,21357,21359,21364,21367,21372,21374,21383,21384,21386,21387,21389,21390,21394,21399,21404,21406,21407,21413,21414,21415,21441,21445,21451,21453,21454,21455,21461,21465,21474,21499,21514,21527,21561,21577,21580,21607,21614,21615,21618,21628,21632,21633,21644,21661,21662,21664,21666,21667,21679,21690,21691,21716,21717,21722,21724,21728,21733,21734,21757,21774,21782,21784,21798,21807,21810,21811,21814,21818,21819,21856,21872,21876,21879,21880,21886,21896,21897,21900,21906,21926,21933,21939,21940,21943,21953,21974,21983,21993,21995,22005,22014,22025,22026,22031,22039,22044,22049,22053,22056,22057,22063,22064,22088,22092,22093,22098,22115,22119,22127,22137,22138,22148,22184,22187,22201,22207,22212,22223,22229,22232,22236,22248,22252,22256,22264,22265,22274,22282,22284,22308,22313,22315,22317,22322,22323,22325,22334,22339,22342,22347,22349,22363,22378,22381,22382,22391,22404,22405,22415,22435,22444,22467,22478,22479,22488,22490,22500,22513,22517,22539,22549,22551,22578,22585,22587,22588,22589,22608,22609,22615,22625,22628,22629,22638,22640,22641,22643,22647,22652,22667,22671,22707,22711,22726,22750,22762,22767,22768,22790,22801,22808,22819,22823,22846,22857,22860,22866,22872,22874,22881,22882,22886,22896,22905,22915,22918,22919,22947,22956,22964,22979,22991,22996,23016,23019,23032,23038,23039,23045,23051,23060,23077,23079,23080,23081,23084,23089,23094,23100,23153,23158,23162,23167,23168,23195,23202,23211,23250,23263,23280,23281,23293,23294,23307,23309,23312,23323,23334,23359,23369,23370,23388,23389,23392,23394,23404,23417,23436,23440,23453,23461,23471,23473,23475,23481,23484,23487,23505,23526,23527,23542,23559,23566,23586,23610,23611,23634,23637,23645,23704,23712,23719,23726,23727,23738,23739,23745,23755,23761,23763,23775,23780,23805,23814,23818,23820,23823,23826,23835,23836,23848,23851,23856,23857,23861,23862,23866,23869,23874,23884,23903,23912,23923,23924,23943,23947,23951,23955,23970,23980,23984,23986,23987,23998,24006,24007,24008,24012,24020,24022,24024,24030,24034,24051,24061,24063,24065,24069,24071,24072,24076,24078,24081,24087,24092,24094,24095,24105,24111,24113,24124,24126,24132,24140,24141,24142,24149,24156,24158,24164,24175,24206,24211,24234,24235,24247,24274,24276,24285,24290,24292,24294,24296,24299,24306,24309,24310,24317,24327,24330,24333,24338,24361,24363,24366,24368,24370,24380,24387,24403,24410,24442,24445,24453,24458,24459,24463,24465,24466,24467,24472,24475,24485,24490,24496,24503,24505,24506,24515,24516,24525,24530,24533,24534,24536,24544,24548,24551,24557,24558,24559,24566,24574,24585,24612,24619,24632,24647,24663,24664,24685,24692,24706,24715,24730,24731,24735,24750,24752,24764,24765,24769,24772,24782,24784,24791,24800,24809,24819,24835,24837,24852,24862,24865,24869,24875,24891,24905,24911,24914,24927,24931,24934,24967,24969,24971,24974,24982,24983,25001,25005,25011,25014,25016,25019,25024,25026,25029,25031,25037,25050,25052,25060,25070,25075,25080,25083,25119,25127,25128,25135,25144,25152,25153,25178,25182,25183,25185,25188,25207,25209,25220,25221,25235,25237,25239,25248,25252,25263,25270,25271,25278,25280,25284,25301,25313,25322,25330,25334,25339,25343,25346,25349,25356,25357,25358,25360,25364,25367,25371,25373,25392,25417,25428,25430,25432,25437,25448,25449,25454,25475,25487,25494,25501,25515,25520,25521,25528,25533,25544,25547,25548,25550,25582,25599,25609,25621,25622,25626,25628,25631,25645,25648,25649,25651,25688,25693,25694,25697,25707,25711,25717,25743,25747,25761,25766,25787,25792,25808,25816,25848,25858,25871,25875,25878,25889,25891,25899,25909,25922,25946,25962,25966,25967,25969,25978,25979,25998,26005,26007,26023,26032,26034,26042,26083,26088,26092,26108,26132,26140,26147,26160,26172,26175,26177,26402,26408,26424,26425,26429,26436,26447,26471,26473,26485,26497,26533,26537,26542,26546,26556,26559,26562,26581,26590,26598,26617,26637,26647,26651,26667,26679,26681,26687,26705,26710,26720,26742,26746,26750,26751,26754,26755,26762,26767,26768,26784,26787,26795,26798,26800,26815,26824,26826,26837,26841,26842,26845,26877,26879,26919,26960,26967,26970,26983,26991,27026,27048,27049,27050,27052,27054,27074,27080,27081,27082,27116,27119,27123,27138,27141,27144,27168,27175,27179,27191,27194,27210,27213,27237,27238,27274,27304,27308,27321,27333,27342,27349,27353,27359,27368,27387,27388,27396,27435,27437,27453,27455,27470,27499,27506,27556,27583,27587,27667,27701,27706,27729,27737,27738,27760,27763,27779,27807,27845,27857,27863,27865,27866,27867,27874,27894,27955,27965,28030,28090,28093,28099,28135,28167,28195,28197,28215,28218,28225,28254,28266,28292,28301,28312,28336,28344,28382,28430,28436,28445,28455,28463,28476,28501,28503,28509,28522,28530,28544,28559,28560,28561,28592,28593,28625,28646,28651,28749,28779,28785,28793,28813,28832,28857,28879,28882,28883,28913,28921,28930,28936,28937,28944,28947,28962,28965,29007,29019,29021,29048,29053,29076,29087,29095,29097,29110,29132,29148,29157,29158,29160,29161,29173,29188,29209,29222,29245,29260,29272,29275,29288,29302,29327,29330,29331,29333,29352,29380,29384,29395,29396,29398,29400,29418,29430,29467,29471,29474,29476,29485,29504,29516,29539,29566,29568,29575,29602,29623,29632,29637,29648,29652,29699,29712,29733,29761,29770,29774,29781,29783,29785,29796,29800,29812,29817,29856,29885,29886,29890,29896,29913,29914,29915,29928,29931,29940,29942,29949,29989,29996,30001,30011,30012,30020,30035,30045,30061,30070,30076,30097,30108,30113,30119,30125,30132,30134,30150,30180,30182,30204,30213,30218,30220,30237,30264,30267,30292,30294,30308,30310,30311,30321,30338,30356,30367,30369,30379,30381,30400,30406,30428,30430,30450,30462,30485,30505,30507,30550,30564,30604,30611,30617,30621,30624,30631,30634,30651,30661,30677,30681,30688,30723,30726,30727,30734,30740,30741,30758,30759,30764,30768,30772,30780,30788,30790,30800,30832,30838,30845,30855,30870,30889,30899,30916,30919,30940,30953,30956,30975,30981,30983,30984,30990,30991,31010,31016,31019,31024,31025,31033,31037,31048,31050,31080,31094,31102,31104,31106,31122,31131,31136,31138,31145,31166,31167,31184,31188,31190,31195,31199,31212,31225,31257,31280,31289,31305,31329,31350,31352,31360,31393,31405,31407,31415,31416,31417,31435,31448,31450,31453,31462,31471,31473,31474,31477,31481,31497,31520,31534,31537,31538,31539,31543,31565,31566,31573,31576,31582,31590,31591,31595,31628,31652,31667,31684,31686,31687,31693,31713,31727,31734,31754,31756,31780,31784,31792,31795,31805,31813,31824,31830,31850,31863,31866,31867,31883,31893,31907,31908,31931,31960,31963,31970,31975,31994,31998,32022,32030,32040,32042,32045,32048,32050,32054,32062,32076,32080,32088,32091,32092,32102,32104,32111,32112,32120,32138,32139,32143,32144,32149,32161,32162,32164,32180,32181,32192,32194,32197,32198,32199,32202,32213,32216,32219,32228,32231,32233,32237,32239,32241,32245,32272,32282,32294,32300,32311,32321,32330,32346,32352,32359,32381,32382,32383,32412,32426,32431,32435,32448,32459,32460,32477,32481,32499,32515,32524,32528,32530,32534,32535,32543,32548,32550,32557,32559,32577,32582,32583,32585,32587,32588,32596,32597,32600,32619,32620,32621,32622,32638,32641,32645,32646,32654,32661,32666,32669,32672,32676,32700,32701,32709,32710,32719,32751,32754,32765,32767,32803,32807,32808,32820,32824,32831,32834,32850,32857,32861,32864,32866,32868,32871,32876,32885,32886,32906,32916,32944,32950,32963,32967,32969,32971,32989,32991,32992,32994,32998,33001,33008,33014,33016,33017,33018,33024,33034,33036,33039,33043,33047,33064,33068,33070,33072,33082,33085,33093,33109,33123,33124,33131,33133,33137,33140,33169,33195,33199,33206,33207,33214,33217,33252,33253,33256,33259,33264,33267,33269,33297,33327,33351,33356,33357,33364,33371,33374,33375,33386,33389,33408,33411,33416,33426,33435,33439,33445,33448,33460,33462,33464,33473,33499,33524,33528,33530,33538,33568,33576,33585,33586,33597,33602,33611,33619,33624,33647,33666,33671,33683,33700,33709,33739,33742,33747,33780,33783,33788,33795,33797,33805,33809,33826,33857,33859,33871,33872,33873,33880,33883,33884,33887,33902,33909,33910,33921,33929,33941,33945,33949,33955,33963,33970,33976,33986,33995,34009,34011,34012,34019,34021,34023,34024,34025,34030,34033,34037,34050,34051,34065,34078,34091,34093,34094,34096,34101,34102,34103,34106,34111,34115,34116,34118,34138,34142,34147,34159,34162,34164,34165,34167,34169,34178,34180,34185,34186,34198,34217,34232,34237,34262,34268,34271,34280,34285,34290,34294,34301,34306,34357,34365,34373,34386,34387,34393,34408,34413,34418,34426,34432,34454,34455,34465,34474,34475,34490,34500,34504,34527,34534,34550,34553,34566,34570,34575,34579,34583,34585,34589,34599,34611,34613,34614,34615,34620,34625,34630,34646,34667,34670,34671,34684,34693,34699,34707,34715,34724,34731,34734,34736,34749,34755,34767,34787,34789,34793,34797,34801,34805,34812,34821,34828,34838,34840,34843,34857,34859,34861,34868,34875,34882,34885,34892,34895,34898,34899,34904,34908,34909,34913,34914,34921,34924,34925,34933,34939,34942,34966,34978,34985,34988,34991,34993,35006,35014,35018,35041,35042,35044,35054,35062,35076,35081,35096,35097,35102,35106,35117,35120,35134,35138,35159,35191,35194,35204,35205,35226,35237,35238,35255,35276,35280,35284,35285,35286,35287,35288,35289,35298,35303,35311,35327,35328,35329,35331,35335,35344,35352,35368,35408,35411,35414,35421,35422,35428,35431,35433,35434,35437,35438,35446,35447,35457,35464,35465,35466,35471,35484,35493,35496,35504,35519,35526,35548,35573,35576,35580,35583,35585,35595,35596,35610,35627,35631,35636,35641,35643,35650,35663,35666,35667,35670,35677,35682,35684,35687,35696,35710,35711,35718,35722,35731,35736,35740,35742,35743,35747,35753,35757,35764,35766,35767,35771,35776,35779,35782,35783,35784,35786,35802,35814,35815,35844,35869,35888,35903,35905,35906,35913,35916,35918,35936,35937,35944,35948,35954,35955,35957,35961,35962,35963,35970,35972,35974,35975,35976,35989,35996,36017,36024,36037,36038,36039,36044,36047,36050,36053,36070,36075,36096,36100,36107,36112,36114,36125,36136,36138,36139,36150,36157,36179,36188,36191,36195,36196,36197,36200,36208,36220,36221,36222,36224,36248,36320,36328,36363,36377,36396,36398,36412,36422,36424,36458,36475,36491,36502,36545,36577,36597,36611,36622,36647,36685,36693,36704,36785,36815,36933,36957,36997,37021,37024,37050,37278,37357,37412,37415,37513,37539,37573,37602,37616,37639,37687,37739,37931,37962,37970,38004,38063,38071,38086,38113,38126,38142,38148,38154,38169,38194,38213,38216,38218,38219,38231,38252,38256,38257,38261,38317,38364,38370,38372,38376,38409,38413,38450,38451,38475,38518,38544,38545,38589,38598,38602,38613,38638,38693,38723,38727,38729,38741,38757,38776,38785,38796,38797,38825,38853,38889,38912,38923,38930,38946,38959,38970,38985,39002,39023,39051,39054,39060,39100,39127,39132,39151,39160,39168,39187,39192,39194,39203,39209,39211,39229,39248,39252,39262,39264,39273,39279,39299,39300,39321,39332,39336,39338,39350,39374,39393,39425,39442,39456,39457,39464,39473,39496,39505,39507,39508,39510,39541,39542,39563,39573,39590,39609,39610,39613,39616,39624,39627,39630,39635,39641,39645,39648,39650,39651,39653,39717,39723,39726,39742,39749,39768,39773,39778,39790,39797,39807,39816,39819,39824,39829,39830,39833,39839,39840,39841,39852,39872,39880,39915,39924,39929,39933,39941,39945,39953,39962,39964,39975,39977,39988,40009,40031,40038,40053,40065,40069,40084,40122,40138,40139,40168,40169,40172,40175,40180,40185,40190,40191,40201,40215,40216,40219,40241,40253,40280,40285,40315,40362,40381,40393,40490,40515,40520,40521,40537,40546,40563,40568,40579,40583,40585,40653,40689,40712,40755,40759,40779,40785,40791,40812,40823,40832,40854,40879,40883,40900,40951,40952,40954,40958,40960,40993,41002,41010,41013,41015,41030,41038,41046,41057,41105,41113,41139,41150,41173,41197,41220,41242,41247,41258,41277,41286,41319,41333,41343,41351,41362,41369,41377,41393,41399,41423,41425,41437,41446,41452,41514,41536,41542,41564,41610,41654,41658,41666,41676,41694,41717,41738,41763,41778,41804,41811,41823,41869,41877,41878,41888,41892,41897,41913,41935,41941,41953,41985,41988,42042,42051,42093,42095,42099,42100,42103,42105,42107,42115,42130,42167,42168,42173,42188,42196,42207,42209,42212,42267,42277,42280,42290,42295,42315,42317,42335,42339,42340,42348,42355,42373,42379,42433,42467,42484,42486,42488,42491,42492,42494,42495,42510,42514,42516,42520,42526,42531,42551,42567,42569,42572,42573,42574,42580,42582,42588,42590,42591,42593,42598,42605,42617,42618,42620,42629,42635,42660,42676,42687,42690,42692,42699,42702,42710,42714,42737,42748,42776,42779,42783,42784,42785,42787,42837,42841,42848,42854,42858,42863,42867,42885,42897,42956,42989,42991,43010,43016,43021,43029,43030,43039,43040,43042,43047,43050,43058,43059,43062,43063,43065,43066,43067,43069,43070,43071,43078,43083,43086,43087,43112,43117,43126,43131,43137,43139,43140,43158,43167,43168,43175,43176,43181,43185,43186,43202,43206,43214,43216,43219,43220,43232,43233,43235,43236,43239,43240,43242,43243,43257,43289,43314,43320,43349,43356,43359,43367,43370,43399,43409,43424,43430,43438,43445,43446,43466,43478,43483,43484,43499,43511,43512,43524,43535,43548,43551,43557,43561,43568,43580,43594,43595,43601,43634,43635,43688,43689,43690,43694,43724,43734,43738,43752,43795,43803,43814,43818,43822,43831,43843,43850,43873,43875,43881,43887,43903,43918,43953,43985,43996,43999,44014,44037,44044,44052,44104,44116,44118,44133,44162,44174,44177,44218,44226,44227,44228,44238,44249,44302,44319,44332,44335,44340,44343,44373,44390,44409,44410,44418,44424,44439,44506,44511,44541,44551,44567,44587,44590,44599,44611,44628,44630,44649,44657,44664,44679,44688,44693,44694,44713,44728,44736,44744,44746,44752,44768,44780,44785,44801,44810,44822,44838,44840,44845,44846,44863,44874,44875,44877,44882,44898,44907,44912,44915,44934,44935,44945,44966,44968,44972,44981,44998,45006,45042,45046,45056,45057,45058,45077,45082,45094,45131,45134,45142,45144,45151,45162,45175,45181,45191,45192,45206,45209,45225,45242,45245,45250,45255,45261,45267,45268,45270,45271,45276,45279,45283,45286,45290,45295,45301,45305,45323,45344,45345,45366,45373,45378,45388,45390,45412,45425,45429,45436,45442,45443,45449,45450,45455,45462,45466,45476,45497,45500,45507,45510,45513,45518,45531,45535,45542,45546,45558,45569,45571,45573,45574,45584,45587,45597,45612,45642,45653,45668,45680,45687,45688,45696,45714,45719,45720,45730,45737,45742,45745,45753,45755,45763,45780,45787,45789,45801,45802,45804,45807,45809,45817,45826,45837,45844,45851,45857,45864,45873,45875,45893,45895,45908,45912,45914,45924,45927,45939,45940,45944,45947,45948,45957,45958,45980,45981,45985,45988,45989,45992,45994,45995,45996,46000,46004,46012,46019,46028,46037,46041,46049,46052,46059,46063,46067,46069,46079,46080,46082,46088,46095,46097,46098,46099,46115,46117,46131,46133,46137,46142,46163,46169,46170,46172,46183,46188,46191,46193,46194,46195,46226,46262,46269,46287,46292,46295,46297,46333,46349,46368,46382,46384,46418,46423,46424,46435,46441,46448,46449,46453,46479,46505,46514,46524,46525,46536,46579,46582,46597,46610,46619,46629,46644,46659,46668,46688,46695,46698,46709,46715,46716,46743,46752,46761,46764,46771,46780,46781,46813,46819,46822,46847,46855,46875,46882,46884,46887,46890,46892,46903,46919,46930,46947,46952,46956,46959,46962,46966,46975,46983,46993,47019,47024,47027,47032,47036,47037,47050,47064,47103,47110,47114,47126,47129,47136,47149,47176,47177,47179,47192,47211,47225,47227,47251,47254,47255,47262,47278,47281,47292,47303,47316,47328,47331,47337,47351,47356,47394,47407,47432,47434,47435,47445,47446,47451,47454,47471,47474,47478,47484,47490,47495,47503,47510,47518,47527,47536,47567,47580,47585,47592,47610,47616,47633,47634,47643,47657,47662,47668,47672,47677,47704,47707,47713,47730,47735,47755,47757,47770,47779,47829,47836,47844,47860,47878,47888,47914,47927,47935,47956,47958,47971,47987,47990,47992,48003,48005,48029,48042,48043,48047,48048,48050,48062,48065,48074,48084,48094,48128,48139,48142,48143,48145,48148,48180,48209,48214,48239,48304,48334,48346,48349,48350,48356,48360,48371,48378,48380,48382,48395,48406,48422,48429,48464,48494,48499,48503,48505,48513,48532,48533,48535,48558,48562,48563,48573,48578,48586,48594,48603,48615,48622,48636,48637,48640,48642,48652,48663,48669,48677,48691,48698,48708,48715,48737,48741,48760,48765,48776,48784,48789,48797,48808,48819,48823,48827,48828,48830,48842,48857,48864,48896,48897,48899,48900,48901,48916,48918,48925,48927,48929,48944,48948,48953,48958,48962,48964,48967,48970,48978,48981,48982,48998,49010,49031,49033,49039,49047,49048,49053,49058,49066,49068,49071,49082,49090,49097,49105,49110,49117,49128,49130,49131,49148,49149,49152,49155,49166,49181,49184,49193,49196,49205,49219,49228,49229,49231,49239,49248,49249,49251,49255,49256,49271,49277,49281,49287,49299,49311,49317,49318,49328,49333,49335,49346,49349,49350,49356,49377,49380,49385,49387,49393,49396,49400,49405,49408,49410,49411,49419,49436,49438,49440,49443,49459,49464,49465,49467,49483,49496,49505,49513,49516,49517,49520,49521,49523,49528,49534,49560,49582,49592,49595,49616,49620,49626,49631,49659,49661,49664,49697,49708,49711,49718,49720,49721,49722,49723,49726,49733,49738,49739,49742,49750,49766,49768,49772,49773,49775,49779,49795,49797,49801,49803,49804,49813,49815,49824,49825,49827,49838,49845,49846,49878,49879,49887,49889,49890,49891,49905,49907,49908,49909,49915,49917,49919,49924,49926,49932,49936,49948,49952,49953,49961,49962,49968,49972,49973,49976,49989,49990,49996,49997,49998,50010,50014,50017,50022,50023,50024,50026,50029,50032,50033,50036,50040,50049,50056,50069,50073,50076,50092,50094,50114,50115,50122,50139,50140,50144,50164,50175,50182,50186,50187,50197,50198,50199,50201,50205,50208,50214,50216,50218,50219,50220,50241,50242,50243,50245,50246,50251,50257,50259,50260,50261,50262,50264,50267,50284,50288,50290,50295,50296,50298,50300,50301,50302,50305,50322,50336,50344,50346,50349,50350,50353,50356,50359,50361,50363,50364,50367,50369,50370,50372,50374,50376,50379,50380,50381,50382,50402,50406,50409,50417,50420,50422,50424,50432,50442,50450,50453,50455,50464,50465,50470,50471,50474,50487,50490,50491,50497,50503,50504,50505,50506,50513,50520,50522,50524,50525,50533,50536,50537,50539,50540,50549,50554,50560,50561,50563,50572,50573,50575,50579,50613,50616,50617,50623,50635,50636,50646,50652,50657,50667,50668,50669,50678,50686,50698,50708,50712,50713,50720,50722,50728,50730,50731,50733,50766,50837,50849,50850,50871,50887,50898,50924,51026,51027,51041,51061,51075,51101,51125,51136,51140,51160,51162,51232,51260,51304,51373,51422,51438,51439,51450,51454,51458,51462,51465,51562,51578,51579,51619,51736,51778,51818,51830,51877,51891,51934,51938,52050,52052,52121,52227,52266,52328,52416,52448,52478,52638,52641,52689,52690,52713,52719,52760,52818,52820,52831,52832,52833,52836,52860,52861,52892,52943,52972,53007,53041,53068,53079,53080,53087,53092,53093,53094,53097,53105,53119,53138,53144,53147,53165,53170,53180,53198,53218,53268,53324,53337,53353,53354,53364,53379,53406,53426,53439,53482,53483,53500,53541,53582,53593,53600,53602,53624,53626,53627,53628,53630,53633,53635,53641,53642,53647,53650,53662,53664,53667,53670,53678,53723,53733,53735,53736,53737,53755,53758,53759,53796,53813,53822,53824,53834,53857,53906,53911,53912,53926,53927,53936,53940,53947,53955,53974,53977,53987,53991,53994,54074,54075,54079,54085,54096,54100,54105,54110,54112,54123,54141,54142,54158,54167,54175,54179,54188,54193,54213,54221,54227,54244,54267,54272,54275,54276,54279,54281,54292,54304,54308,54339,54342,54346,54349,54371,54372,54377,54380,54382,54383,54386,54387,54402,54410,54412,54417,54418,54420,54435,54436,54455,54486,54487,54548,54556,54557,54558,54559,54560,54571,54581,54588,54590,54607,54615,54617,54623,54653,54659,54675,54684,54693,54701,54717,54726,54727,54769,54796,54797,54800,54801,54802,54808,54816,54822,54824,54825,54829,54837,54854,54855,54856,54860,54864,54877,54879,54880,54894,54900,54906,54911,54916,54918,54922,54923,54933,54944,54952,54964,54969,54972,54978,54996,54997,54998,55006,55007,55008,55031,55037,55040,55047,55058,55088,55108,55144,55146,55147,55148,55149,55162,55164,55165,55184,55186,55205,55211,55220,55237,55246,55247,55249,55250,55251,55253,55254,55271,55287,55293,55312,55313,55388,55390,55404,55414,55457,55458,55464,55467,55469,55470,55471,55473,55475,55477,55482,55490,55491,55492,55493,55495,55535,55540,55545,55546,55547,55548,55549,55550,55557,55558,55570,55591,55592,55604,55607,55608,55611,55614,55616,55618,55619,55620,55621,55622,55625,55626,55627,55628,55630,55631,55632,55633,55634,55636,55653,55657,55658,55659,55662,55664,55687,55705,55725,55739,55740,55744,55745,55746,55753,55757,55760,55791,55799,55805,55837,55838,55839,55843,55844,55845,55853,55854,55855,55885,55893,55897,55898,55901,55902,55903,55905,55909,55910,55912,55913,55915,55930,55933,55943,55945,55946,55952,55955,55982,55999,56018,56020,56024,56031,56038,56043,56046,56099,56136,56157,56168,56169,56176,56177,56182,56185,56188,56189,56191,56192,56195,56234,56236,56237,56261,56268,56292,56305,56319,56342,56378,56382,56391,56394,56457,56513,56538,56545,56552,56584,56585,56589,56692,56695,56707,56847,56849,56860,56870,56878,56879,56883,56908,56929,56930,56939,56960,56985,57001,57004,57005,57006,57007,57008,57010,57018,57066,57071,57083,57085,57086,57088,57092,57094,57100,57107,57117,57128,57145,57159,57161,57185,57202,57209,57214,57218,57222,57223,57225,57249,57251,57259,57264,57272,57282,57287,57288,57289,57305,57306,57317,57319,57353,57356,57358,57361,57374,57380,57391,57395,57402,57411,57414,57416,57418,57420,57422,57425,57433,57445,57446,57451,57466,57467,57468,57470,57471,57473,57477,57479,57480,57481,57491,57495,57497,57498,57499,57521,57522,57523,57524,57528,57529,57530,57539,57540,57548,57558,57563,57566,57583,57585,57595,57598,57606,57608,57615,57628,57629,57636,57643,57646,57649,57669,57680,57683,57688,57691,57696,57702,57704,57714,57717,57734,57741,57742,57743,57745,57753,57755,57761,57768,57772,57787,57792,57810,57812,57819,57821,57831,57836,57843,57850,57853,57856,57860,57861,57873,57874,57879,57893,57896,57899,57905,57908,57910,57915,57927,57928,57931,57938,57942,57943,57944,57946,57947,57948,57949,57951,57970,57974,57975,57985,57991,57995,58006,58023,58029,58030,58068,58070,58072,58085,58087,58088,58098,58104,58114,58122,58125,58130,58131,58132,58143,58178,58180,58191,58195,58200,58201,58203,58235,58237,58264,58276,58281,58283,58285,58289,58305,58326,58328,58334,58335,58336,58340,58347,58348,58375,58385,58386,58422,58424,58427,58440,58446,58460,58461,58472,58477,58480,58506,58509,58521,58528,58532,58534,58541,58546,58548,58561,58577,58581,58594,58597,58598,58608,58609,58617,58624,58629,58648,58650,58655,58656,58658,58661,58671,58672,58676,58684,58700,58719,58720,58721,58739,58741,58751,58756,58758,58776,58779,58783,58795,58800,58802,58803,58818,58820,58821,58833,58834,58844,58847,58855,58858,58859,58868,58873,58877,58881,58882,58913,58919,58921,58940,58945,58954,58964,58968,58972,58983,58984,58989,58994,59006,59008,59009,59014,59024,59034,59041,59050,59060,59074,59087,59088,59090,59096,59099,59101,59103,59104,59109,59111,59112,59118,59132,59135,59137,59138,59140,59141,59150,59153,59158,59162,59168,59169,59170,59172,59176,59188,59198,59203,59208,59217,59223,59224,59229,59230,59239,59245,59251,59255,59257,59260,59263,59266,59267,59269,59280,59281,59282,59287,59289,59292,59303,59309,59310,59311,59315,59324,59325,59336,59342,59347,59349,59353,59354,59358,59365,59369,59375,59377,59404,59407,59409,59413,59421,59422,59426,59427,59430,59439,59440,59443,59445,59453,59462,59463,59465,59474,59475,59493,59495,59505,59527,59533,59552,59560,59588,59592,59596,59599,59602,59605,59608,59609,59610,59612,59613,59616,59617,59618,59622,59628,59629,59631,59635,59636,59637,59639,59662,59668,59674,59683,59690,59691,59694,59709,59720,59734,59740,59743,59747,59748,59749,59750,59767,59773,59774,59777,59778,59782,59784,59789,59790,59792,59798,59809,59812,59822,59823,59824,59827,59831,59834,59835,59850,59852,59853,59857,59860,59864,59876,59884,59885,59889,59894,59899,59905,59909,59916,59922,59927,59930,59950,59956,59959,59960,59976,59983,59984,59986,59991,59992,60002,60005,60006,60009,60014,60015,60016,60017,60019,60029,60033,60035,60036,60037,60038,60039,60040,60042,60043,60049,60050,60056,60059,60060,60067,60076,60078,60081,60111,60112,60125,60127,60130,60133,60169,60184,60193,60194,60198,60216,60217,60232,60233,60239,60240,60246,60248,60251,60257,60258,60261,60269,60274,60285,60290,60292,60299,60304,60370,60371,60378,60399,60412,60432,60434,60437,60450,60451,60461,60495,60838,60936,60985,61006,61040,61246,61306,61643,61793,61797,61800,61802,61803,61810,61815,61821,61827,61831,61843,61844,61853,61854,61867,61873,61880,61938,61940,61941,61951,61955,61960,61964,61969,61978,61980,62001,62008,62014,62016,62020,62022,62050,62060,62063,62074,62077,62081,62082,62084,62092,62093,62095,62119,62128,62131,62136,62141,62166,62181,62191,62207,62237,62239,62240,62250,62260,62281,62287,62294,62295,62296,62308,62309,62312,62332,62336,62348,62352,62358,62367,62391,62417,62433,62454,62557,62562,62567,62568,62570,62573,62579,62583,62594,62599,62601,62603,62613,62615,62616,62815,62822,62823,62824,62828,62829,62830,62831,62832,62833,62844,62850,62886,62891,62892,62893,62911,62912,62913,62924,62937,62938,62963,62967,62968,62973,62980,63004,63005,63006,63017,63019,63020,63021,63022,63023,63024,63025,63026,63028,63029,63039,63045,63046,63047,63048,63049,63050,63051,63052,63053,63054,63055,63056,63057,63058,63064,63075,63100,63124,63129,63131,63132,63144,63146,63149,63157,63159,63164,63186,63210,63221,63222,63234,63235,63236,63245,63246,63247,63251,63252,63255,63266,63267,63275,63304,63306,63317,63318,63328,63330,63342,63350,63355,63359,63377,63397,63408,63410,63412,63440,63444,63454,63455,63461,63462,63470,63473,63486,63500,63501,63502,63504,63518,63529,63531,63541,63543,63545,63546,63548,63549,63551,63552,63555,63566,63603,63606,63630,63640,63652,63664,63667,63671,63672,63676,63679,63681,63682,63685,63686,63687,63697,63698,63699,63720,63721,63723,63734,63745,63752,63754,63756,63766,63768,63780,63783,63788,63795,63797,63798,63800,63807,63809,63833,63843,63845,63850,63852,63878,63882,63885,63890,63892,63916,63929,63930,63933,63936,63937,63938,63948,63951,63955,63956,63999,64000,64001,64008,64009,64055,64056,64060,64061,64065,64066,64069,64070,64072,64079,64082,64085,64086,64098,64100,64104,64110,64117,64118,64119,64121,64126,64128,64133,64134,64140,64146,64149,64156,64157,64192,64208,64209,64210,64218,64233,64247,64253,64255,64265,64272,64280,64287,64305,64309,64316,64318,64324,64326,64327,64328,64335,64336,64338,64379,64381,64390,64398,64404,64410,64411,64413,64432,64443,64469,64471,64474,64476,64477,64478,64479,64483,64488,64493,64498,64499,64500,64505,64512,64521,64523,64524,64525,64528,64534,64535,64536,64545,64550,64551,64559,64564,64569,64570,64598,64600,64611,64615,64616,64626,64627,64667,64680,64691,64692,64698,64702,64703,64706,64707,64709,64716,64720,64732,64740,64742,64743,64745,64746,64750,64759,64761,64767,64768,64769,64771,64802,64804,64806,64820,64821,64825,64852,64857,64858,64859,64861,64862,64864,64867,64889,64891,64892,64903,64907,64916,64919,64934,64936,64942,64946,64951,64962,64969,64974,64978,64981,64984,64986,64987,64989,64992,64996,64997,65003,65013,65014,65026,65043,65045,65055,65063,65075,65076,65077,65078,65084,65086,65087,65095,65117,65118,65119,65120,65121,65122,65123,65124,65125,65133,65140,65142,65143,65144,65145,65185,65187,65202,65203,65220,65231,65245,65259,65264,65271,65273,65280,65287,65288,65291,65296,65327,65331,65361,65365,65369,65370,65371,65372,65379,65385,65391,65392,65393,65400,65401,65402,65403,65405,65407,65409,65410,65411,65412,65417,65422,65427,65430,65436,65450,65459,65463,65475,65478,65481,65482,65485,65486,65488,65493,65499,65500,65501,65502,65504,65505,65514,65534,65546,65551,65554,65560,65561,65570,65578,65580,65602,65604,65611,65612,65614,65619,65623,65624,65637,65654,65673,65674,65675,65681,65682,65684,65693,65695,65697,65699,65701,65702,65705,65707,65714,65716,65718,65734,65738,65756,65757,65760,65773,65776,65778,65779,65781,65783,65786,65793,65795,65796,65797,65798,65803,65807,65809,65816,65832,65835,65843,65844,65847,65849,65850,65852,65856,65863,65865,65897,65898,65916,65930,65932,65933,65935,65936,65937,65943,65945,65947,65948,65952,65955,65957,65964,65976,65977,65979,65982,65987,65988,65996,65998,66010,66012,66013,66018,66020,66021,66028,66032,66037,66038,66042,66043,66044,66045,66057,66060,66064,66068,66070,66071,66074,66075,66077,66078,66097,66104,66105,66124,66125,66132,66137,66143,66149,66150,66151,66159,66166,66167,66173,66176,66177,66179,66182,66185,66204,66210,66217,66219,66236,66237,66238,66240,66243,66244,66246,66254,66256,66272,66273,66290,66295,66304,66305,66306,66308,66311,66315,66317,66319,66351,66357,66358,66359,66361,66364,66365,66366,66369,66379,66380,66381,66382,66394,66395,66402,66409,66417,66421,66427,66428,66429,66433,66442,66445,66454,66459,66464,66466,66468,66469,66485,66489,66505,66506,66511,66524,66538,66542,66563,66564,66582,66587,66588,66590,66605,66610,66621,66623,66624,66632,66634,66640,66641,66643,66664,66668,66670,66671,66674,66686,66714,66716,66717,66721,66726,66738,66740,66744,66746,66749,66750,66756,66757,66760,66764,66765,66767,66799,66803,66814,66815,66816,66820,66843,66846,66849,66860,66866,66875,66884,66885,66892,66893,66895,66897,66902,66903,66906,66910,66912,66913,66914,66920,66932,66934,66936,66937,66942,66951,66978,66980,66983,66990,67025,67034,67052,67055,67070,67071,67072,67074,67077,67080,67086,67088,67090,67091,67134,67139,67147,67149,67158,67162,67164,67165,67167,67168,67170,67189,67210,67214,67220,67231,67234,67235,67238,67244,67255,67259,67262,67263,67264,67266,67269,67271,67272,67274,67289,67301,67306,67316,67318,67348,67350,67359,67368,67373,67376,67377,67380,67381,67382,67394,67405,67407,67409,67413,67414,67415,67416,67417,67424,67441,67445,67446,67459,67471,67479,67480,67485,67502,67517,67524,67527,67529,67530,67532,67533,67540,67552,67554,67557,67558,67562,67564,67568,67569,67570,67573,67587,67594,67596,67597,67599,67609,67610,67616,67620,67623,67633,67634,67635,67636,67639,67642,67643,67649,67661,67664,67665,67666,67673,67675,67676,67684,67690,67693,67696,67697,67700,67701,67702,67708,67709,67711,67712,67716,67719,67720,67722,67723,67724,67726,67728,67735,67739,67740,67745,67749,67753,67768,67786,67787,67824,67832,67834,67838,67841,67842,67843,67844,67845,67851,67852,67854,67855,67858,67859,67870,67871,67876,67891,67899,67901,67905,67907,67914,67917,67923,67924,67926,67935,67939,67941,67959,67961,67967,67968,67969,67974,67975,67976,67981,67984,67989,67994,67995,68019,68023,68035,68040,68041,68050,68067,68069,68075,68078,68082,68083,68089,68100,68105,68122,68123,68127,68137,68138,68140,68146,68148,68158,68167,68179,68183,68184,68188,68191,68193,68199,68205,68215,68221,68226,68240,68247,68248,68249,68251,68253,68254,68270,68273,68275,68276,68290,68291,68310,68332,68339,68346,68356,68358,68360,68361,68362,68364,68368,68377,68378,68379,68382,68383,68389,68401,68406,68407,68408,68416,68425,68427,68430,68450,68451,68452,68454,68455,68457,68458,68460,68461,68463,68465,68466,68467,68474,68475,68477,68479,68489,68497,68503,68504,68506,68510,68516,68518,68523,68526,68530,68535,68536,68537,68538,68541,68545,68546,68548,68554,68565,68566,68567,68579,68581,68582,68583,68585,68587,68588,68590,68591,68602,68617,68618,68619,68620,68622,68626,68627,68628,68633,68641,68645,68646,68649,68651,68652,68654,68660,68665,68666,68668,68669,68677,68685,68687,68690,68692,68693,68698,68702,68709,68710,68721,68722,68725,68727,68732,68738,68743,68745,68750,68754,68755,68757,68760,68762,68798,68800,68801,68807,68808,68809,68826,68847,68849,68850,68854,68855,68858,68859,68874,68877,68882,68883,68887,68888,68889,68891,68896,68899,68914,68915,68916,68938,68939,68940,68951,68953,68957,68958,68966,68967,68968,68970,68971,68975,68977,68978,68979,68993,69002,69009,69014,69015,69028,69031,69033,69035,69038,69047,69048,69074,69106,69154,69165,69229,69314,69330,69398,69405,69679,69684,69791,69822,69825,69826,69854,69932,69933,69934,69967,69981,70053,70059,70081,70141,70157,70168,70207,70283,70303,70328,70491,70778,71807,71814,71830,71853,71854,72203,77355,77400,79271,79421,79841,79866,80032,80070,80129,80149,80155,80156,80170,80240,80243,80268,80373,80377,80379,80429,80467,80526,80793,81076,81241,81304,81391,81769,81773,81810,81925,81957,82119,82275,82373,82415,82458,82531,82582,82583,82584,82601,82882,82884,82939,82948,82970,83031,83051,83062,83069,83070,83098,83102,83105,83135,83138,83159,83172,83182,83203,83217,83237,83254,83261,83285,83290,83323,83324,83326,83346,83364,83385,83396,83403,83411,83415,83422,83424,83435,83457,83487,83499,83524,83525,83527,83540,83541,83542,83566,83591,83592,83605,83625,83650,83655,83685,83760,83795,83810,83845,83850,83854,83862,83869,83923,83935,83962,83971,84060,84083,84084,84093,84113,84120,84137,84148,84157,84163,84171,84172,84185,84202,84225,84233,84246,84282,84288,84289,84356,84364,84375,84378,84402,84430,84463,84485,84511,84575,84599,84630,84643,84661,84708,84790,84796,84829,84867,84971,85060,85078,85112,85290,85291,85318,85359,85426,85486,85519,85547,85579,85623,85754,85766,85788,85823,85824,85825,85914,85917,85925,85939,86016,86017,86019,86020,86033,86063,86064,86076,86095,86118,86120,86126,86133,86145,86161,86181,86191,86192,86194,86203,86204,86205,86206,86207,86218,86242,86255,86256,86264,86276,86279,86282,86288,86290,86308,86312,86313,86328,86329,86331,86332,86344,86357,86367,86377,86427,86469,86472,86491,86494,86495,86496,86497,86498,86521,86525,86526,86527,86532,86533,86593,86617,86620,86631,86664,86667,86678,86684,86689,86690,86692,86693,86694,86695,86704,86709,86715,86721,86741,86754,86763,86764,86799,86819,86826,86834,86847,86890,86892,86893,86895,86897,86898,86913,86920,86931,86934,86949,86958,86964,86965,86978,86996,87001,87043,87049,87063,87070,87080,87082,87106,87124,87133,87135,87136,87137,87138,87140,87145,87152,87169,87173,87234,87236,87237,87239,87260,87265,87266,87267,87268,87269,87270,87271,87278,87279,87280,87286,87300,87312,87313,87314,87320,87321,87323,87326,87345,87410,87416,87474,87480,87493,87508,87518,87519,87520,87521,87522,87533,87554,87556,87605,87647,87654,87664,87668,87671,87673,87675,87680,87681,87705,87712,87744,87752,87754,87755,87781,87782,87783,87784,87785,87786,87787,87795,87836,87861,87863,87874,87881,87897,87899,87900,87907,87908,87920,87922,87925,87926,87927,87933,87934,87935,87944,87978,87980,87983,87984,87986,87996,87997,87998,88000,88002,88004,88008,88010,88035,88039,88041,88043,88054,88067,88106,88124,88151,88154,88156)
AND pl.id_lang = 1
AND cl.id_lang = 1
AND od.product_id NOT IN (1995)
AND i.cover = 1
AND product_shop.active = 1
AND cg.`id_group` =1
ORDER BY RAND()
LIMIT 8

SELECT SQL_NO_CACHE o.id_order
FROM ps_orders o
LEFT JOIN ps_order_detail od ON (od.id_order = o.id_order)
WHERE o.valid = 1 AND od.product_id IN (1995)

SELECT SQL_NO_CACHE COUNT(DISTINCT `id_product`) FROM `ps_specific_price` WHERE `id_product` != 0 LIMIT 1

SELECT SQL_NO_CACHE p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) AS quantity, pl.`description`, pl.`description_short`, pl.`available_now`,
pl.`available_later`, pl.`link_rewrite`, pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, image_shop.`id_image` id_image,
il.`legend` as legend, m.`name` AS manufacturer_name, cl.`name` AS category_default,
DATEDIFF(product_shop.`date_add`, DATE_SUB("2026-01-03 00:00:00",
INTERVAL 70 DAY)) > 0 AS new, product_shop.price AS orderprice
FROM `ps_category_product` cp
LEFT JOIN `ps_product` p
ON p.`id_product` = cp.`id_product`
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
LEFT JOIN ps_stock_available stock
ON (stock.id_product = p.id_product AND stock.id_product_attribute = 0 AND stock.id_shop_group = 1  AND stock.id_shop = 0  )
LEFT JOIN `ps_category_lang` cl
ON (product_shop.`id_category_default` = cl.`id_category`
AND cl.`id_lang` = 1 AND cl.id_shop = 1 )
LEFT JOIN `ps_product_lang` pl
ON (p.`id_product` = pl.`id_product`
AND pl.`id_lang` = 1 AND pl.id_shop = 1 )
LEFT JOIN `ps_image_shop` image_shop
ON (image_shop.`id_product` = p.`id_product` AND image_shop.cover=1 AND image_shop.id_shop=1)
LEFT JOIN `ps_image_lang` il
ON (image_shop.`id_image` = il.`id_image`
AND il.`id_lang` = 1)
LEFT JOIN `ps_manufacturer` m
ON m.`id_manufacturer` = p.`id_manufacturer`
WHERE product_shop.`id_shop` = 1
AND cp.`id_category` = 37 AND product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog") ORDER BY cp.`position` ASC
LIMIT 0,100

SELECT SQL_NO_CACHE h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module, h.`live_edit`
FROM `ps_module` m
INNER JOIN ps_module_shop module_shop
ON (module_shop.id_module = m.id_module AND module_shop.id_shop = 1 AND module_shop.enable_device & 1)
INNER JOIN `ps_module_shop` ms ON ms.`id_module` = m.`id_module`
INNER JOIN `ps_hook_module` hm ON hm.`id_module` = m.`id_module`
INNER JOIN `ps_hook` h ON hm.`id_hook` = h.`id_hook`
LEFT JOIN `ps_module_group` `mg` ON mg.`id_module` = m.`id_module`
WHERE (h.name != "displayPayment") AND (hm.id_shop = 1) AND (mg.id_shop = 1 AND  mg.`id_group` IN (1))
GROUP BY hm.id_hook, hm.id_module
ORDER BY hm.`position`

SELECT SQL_NO_CACHE c.`name`, cl.`id_lang`, IF(cl.`id_lang` IS NULL, c.`value`, cl.`value`) AS value, c.id_shop_group, c.id_shop
FROM `ps_configuration` c
LEFT JOIN `ps_configuration_lang` cl ON (c.`id_configuration` = cl.`id_configuration`)

SELECT SQL_NO_CACHE h.id_hook, h.name as h_name, title, description, h.position, live_edit, hm.position as hm_position, m.id_module, m.name, active
FROM `ps_hook_module` hm
STRAIGHT_JOIN `ps_hook` h ON (h.id_hook = hm.id_hook AND hm.id_shop = 1)
STRAIGHT_JOIN `ps_module` as m ON (m.id_module = hm.id_module)
ORDER BY hm.position

SELECT SQL_NO_CACHE DISTINCT c.id_parent, c.id_category, cl.name, cl.description, cl.link_rewrite
FROM `ps_category` c
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.`id_lang` = 1 AND cl.id_shop = 1 )
LEFT JOIN `ps_category_group` cg ON (cg.`id_category` = c.`id_category`)
WHERE (c.`active` = 1 OR c.`id_category` = 1)
AND `level_depth` <= 4
AND cg.`id_group` IN (1)
ORDER BY `level_depth` ASC, category_shop.`position` ASC

SELECT SQL_NO_CACHE cl.*,c.*, cl.`name` country, z.`name` zone
FROM `ps_country` c  INNER JOIN ps_country_shop country_shop
ON (country_shop.id_country = c.id_country AND country_shop.id_shop = 1)
LEFT JOIN `ps_country_lang` cl ON (c.`id_country` = cl.`id_country` AND cl.`id_lang` = 1)
LEFT JOIN `ps_zone` z ON (z.`id_zone` = c.`id_zone`)
WHERE 1
ORDER BY cl.name ASC

SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `ps_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 1 
LEFT JOIN `ps_category_group` cg ON c.`id_category` = cg.`id_category`
RIGHT JOIN `ps_category` c2 ON c2.`id_category` = 94 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 1
AND c.`active` = 1
AND cg.`id_group` IN (1)
GROUP BY c.`id_category`
ORDER BY c.`level_depth` ASC, cl.`name` ASC

SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `ps_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 1 
LEFT JOIN `ps_category_group` cg ON c.`id_category` = cg.`id_category`
RIGHT JOIN `ps_category` c2 ON c2.`id_category` = 28 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 1
AND c.`active` = 1
AND cg.`id_group` IN (1)
GROUP BY c.`id_category`
ORDER BY c.`level_depth` ASC, cl.`name` ASC

SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `ps_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 1 
LEFT JOIN `ps_category_group` cg ON c.`id_category` = cg.`id_category`
RIGHT JOIN `ps_category` c2 ON c2.`id_category` = 96 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 1
AND c.`active` = 1
AND cg.`id_group` IN (1)
GROUP BY c.`id_category`
ORDER BY c.`level_depth` ASC, cl.`name` ASC

SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `ps_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 1 
LEFT JOIN `ps_category_group` cg ON c.`id_category` = cg.`id_category`
RIGHT JOIN `ps_category` c2 ON c2.`id_category` = 17 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 1
AND c.`active` = 1
AND cg.`id_group` IN (1)
GROUP BY c.`id_category`
ORDER BY c.`level_depth` ASC, cl.`name` ASC

SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `ps_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 1 
LEFT JOIN `ps_category_group` cg ON c.`id_category` = cg.`id_category`
RIGHT JOIN `ps_category` c2 ON c2.`id_category` = 74 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 1
AND c.`active` = 1
AND cg.`id_group` IN (1)
GROUP BY c.`id_category`
ORDER BY c.`level_depth` ASC, cl.`name` ASC

SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `ps_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 1 
LEFT JOIN `ps_category_group` cg ON c.`id_category` = cg.`id_category`
RIGHT JOIN `ps_category` c2 ON c2.`id_category` = 95 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 1
AND c.`active` = 1
AND cg.`id_group` IN (1)
GROUP BY c.`id_category`
ORDER BY c.`level_depth` ASC, cl.`name` ASC

SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `ps_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 1 
LEFT JOIN `ps_category_group` cg ON c.`id_category` = cg.`id_category`
RIGHT JOIN `ps_category` c2 ON c2.`id_category` = 93 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 1
AND c.`active` = 1
AND cg.`id_group` IN (1)
GROUP BY c.`id_category`
ORDER BY c.`level_depth` ASC, cl.`name` ASC

SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `ps_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 1 
LEFT JOIN `ps_category_group` cg ON c.`id_category` = cg.`id_category`
RIGHT JOIN `ps_category` c2 ON c2.`id_category` = 30 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 1
AND c.`active` = 1
AND cg.`id_group` IN (1)
GROUP BY c.`id_category`
ORDER BY c.`level_depth` ASC, cl.`name` ASC

SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `ps_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 1 
LEFT JOIN `ps_category_group` cg ON c.`id_category` = cg.`id_category`
RIGHT JOIN `ps_category` c2 ON c2.`id_category` = 31 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 1
AND c.`active` = 1
AND cg.`id_group` IN (1)
GROUP BY c.`id_category`
ORDER BY c.`level_depth` ASC, cl.`name` ASC

SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `ps_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 1 
LEFT JOIN `ps_category_group` cg ON c.`id_category` = cg.`id_category`
RIGHT JOIN `ps_category` c2 ON c2.`id_category` = 65 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 1
AND c.`active` = 1
AND cg.`id_group` IN (1)
GROUP BY c.`id_category`
ORDER BY c.`level_depth` ASC, cl.`name` ASC

SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 6, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 6) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 5430) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2026-01-03 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2026-01-03 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1

SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `ps_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 1 
LEFT JOIN `ps_category_group` cg ON c.`id_category` = cg.`id_category`
RIGHT JOIN `ps_category` c2 ON c2.`id_category` = 58 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 1
AND c.`active` = 1
AND cg.`id_group` IN (1)
GROUP BY c.`id_category`
ORDER BY c.`level_depth` ASC, cl.`name` ASC

SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 6, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 6) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 4720) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2026-01-03 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2026-01-03 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1

SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 6, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 6) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 5378) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2026-01-03 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2026-01-03 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1

SELECT SQL_NO_CACHE m.`id_module`, m.`name`, (
SELECT id_module
FROM `ps_module_shop` ms
WHERE m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
LIMIT 1
) as mshop
FROM `ps_module` m

SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `ps_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 1 
LEFT JOIN `ps_category_group` cg ON c.`id_category` = cg.`id_category`
RIGHT JOIN `ps_category` c2 ON c2.`id_category` = 81 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 1
AND c.`active` = 1
AND cg.`id_group` IN (1)
GROUP BY c.`id_category`
ORDER BY c.`level_depth` ASC, cl.`name` ASC

SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 6, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 6) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 5164) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2026-01-03 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2026-01-03 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1

SELECT SQL_NO_CACHE id_category, id_parent, level_depth, name, is_root_category, active FROM ps_category LEFT JOIN ps_category_lang AS cl USING (id_category) LEFT JOIN ps_category_shop AS cs USING (id_category) WHERE cs.id_shop = 1 AND cl.id_lang = 1 ORDER BY `ps_category`.`id_parent` ASC, `ps_category`.`id_category` ASC

SELECT SQL_NO_CACHE DISTINCT a.*, cl.`name` AS country, s.name AS state, s.iso_code AS state_iso
FROM `ps_address` a
LEFT JOIN `ps_country` c ON (a.`id_country` = c.`id_country`)
LEFT JOIN `ps_country_lang` cl ON (c.`id_country` = cl.`id_country`)
LEFT JOIN `ps_state` s ON (s.`id_state` = a.`id_state`)
WHERE `id_lang` = 1 AND `id_customer` = 0 AND a.`deleted` = 0

SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 6, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 6) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 4475) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2026-01-03 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2026-01-03 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1

SELECT SQL_NO_CACHE m.`id_module`, m.`name`, (
SELECT id_module
FROM `ps_module_shop` ms
WHERE m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
LIMIT 1
) as mshop
FROM `ps_module` m

SELECT SQL_NO_CACHE m.`id_module`, m.`name`, (
SELECT id_module
FROM `ps_module_shop` ms
WHERE m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
LIMIT 1
) as mshop
FROM `ps_module` m

SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 6, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 6) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 5413) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2026-01-03 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2026-01-03 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1

SELECT SQL_NO_CACHE m.`id_module`, m.`name`, (
SELECT id_module
FROM `ps_module_shop` ms
WHERE m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
LIMIT 1
) as mshop
FROM `ps_module` m

SELECT SQL_NO_CACHE `id_hook`, `name`
FROM `ps_hook`
UNION
SELECT `id_hook`, ha.`alias` as name
FROM `ps_hook_alias` ha
INNER JOIN `ps_hook` h ON ha.name = h.name

SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 6, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 6) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 4711) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2026-01-03 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2026-01-03 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1

SELECT SQL_NO_CACHE DISTINCT c.id_consulta, c.*, r.respuesta FROM ps_lgconsultas c LEFT JOIN ps_lgconsultas_respuestas r ON c.id_consulta=r.id_consulta WHERE c.id_producto=1995  AND c.active=1 ORDER BY c.date_add DESC

SELECT SQL_NO_CACHE m.`id_module`, m.`name`, (
SELECT id_module
FROM `ps_module_shop` ms
WHERE m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
LIMIT 1
) as mshop
FROM `ps_module` m

SELECT SQL_NO_CACHE tr.*
FROM `ps_tax_rule` tr
JOIN `ps_tax_rules_group` trg ON (tr.`id_tax_rules_group` = trg.`id_tax_rules_group`)
WHERE trg.`active` = 1
AND tr.`id_country` = 6
AND tr.`id_tax_rules_group` = 24
AND tr.`id_state` IN (0, 0)
AND ('0' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to`
OR (tr.`zipcode_to` = 0 AND tr.`zipcode_from` IN(0, '0')))
ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC

SELECT SQL_NO_CACHE 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`, pl.`available_now`, pl.`available_later`,
image_shop.`id_image` id_image, il.`legend`, m.`name` as manufacturer_name, cl.`name` AS category_default, IFNULL(product_attribute_shop.id_product_attribute, 0) id_product_attribute,
DATEDIFF(
p.`date_add`,
DATE_SUB(
"2026-01-03 00:00:00",
INTERVAL 70 DAY
)
) > 0 AS new
FROM `ps_accessory`
LEFT JOIN `ps_product` p ON p.`id_product` = `id_product_2`
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_product_attribute_shop` product_attribute_shop
ON (p.`id_product` = product_attribute_shop.`id_product` AND product_attribute_shop.`default_on` = 1 AND product_attribute_shop.id_shop=1)
LEFT JOIN `ps_product_lang` pl ON (
p.`id_product` = pl.`id_product`
AND pl.`id_lang` = 1 AND pl.id_shop = 1 
)
LEFT JOIN `ps_category_lang` cl ON (
product_shop.`id_category_default` = cl.`id_category`
AND cl.`id_lang` = 1 AND cl.id_shop = 1 
)
LEFT JOIN `ps_image_shop` image_shop
ON (image_shop.`id_product` = p.`id_product` AND image_shop.cover=1 AND image_shop.id_shop=1)
LEFT JOIN `ps_image_lang` il ON (image_shop.`id_image` = il.`id_image` AND il.`id_lang` = 1)
LEFT JOIN `ps_manufacturer` m ON (p.`id_manufacturer`= m.`id_manufacturer`)
LEFT JOIN ps_stock_available stock
ON (stock.id_product = p.id_product AND stock.id_product_attribute = 0 AND stock.id_shop_group = 1  AND stock.id_shop = 0  )
WHERE `id_product_1` = 1995 AND product_shop.`active` = 1 AND product_shop.`visibility` != 'none'
GROUP BY product_shop.id_product

SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 6, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 6) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 1995) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2026-01-03 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2026-01-03 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1

SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 6, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 6) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 5494) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2026-01-03 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2026-01-03 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1

SELECT SQL_NO_CACHE DISTINCT c.id_consulta, c.*, r.respuesta FROM ps_lgconsultas c LEFT JOIN ps_lgconsultas_respuestas r ON c.id_consulta=r.id_consulta WHERE c.id_producto=1995  AND c.active=1 ORDER BY c.date_add DESC

SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 6, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 6) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 6804) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2026-01-03 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2026-01-03 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1

SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 6, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 6) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 7439) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2026-01-03 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2026-01-03 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1

SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 6, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 6) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 4746) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2026-01-03 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2026-01-03 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1

SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 6, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 6) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 265) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2026-01-03 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2026-01-03 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1

SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 6, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 6) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 6903) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2026-01-03 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2026-01-03 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1

SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 6, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 6) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 5467) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2026-01-03 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2026-01-03 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1

SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 6, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 6) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 5474) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2026-01-03 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2026-01-03 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1

SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 6, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 6) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 6871) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2026-01-03 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2026-01-03 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1

SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 6, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 6) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 7224) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2026-01-03 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2026-01-03 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1

SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 6, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 6) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 7339) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2026-01-03 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2026-01-03 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1

SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 6, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 6) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 4979) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2026-01-03 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2026-01-03 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1

SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 6, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 6) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 5127) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2026-01-03 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2026-01-03 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1

SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 6, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 6) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 5890) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2026-01-03 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2026-01-03 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1

SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 6, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 6) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 5135) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2026-01-03 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2026-01-03 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1

SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 6, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 6) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 7489) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2026-01-03 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2026-01-03 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1

SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 6, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 6) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 6830) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2026-01-03 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2026-01-03 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1

SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 6, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 6) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 5442) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2026-01-03 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2026-01-03 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1

SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 6, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 6) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 7538) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2026-01-03 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2026-01-03 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1

SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 6, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 6) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 5301) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2026-01-03 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2026-01-03 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1

SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 6, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 6) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 2112) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2026-01-03 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2026-01-03 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1

SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 6, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 6) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 7539) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2026-01-03 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2026-01-03 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1

SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 6, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 6) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 7524) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2026-01-03 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2026-01-03 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1

SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 6, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 6) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 5503) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2026-01-03 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2026-01-03 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1

SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 6, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 6) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 6621) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2026-01-03 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2026-01-03 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1

SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 6, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 6) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 5220) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2026-01-03 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2026-01-03 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1

SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 6, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 6) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 4875) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2026-01-03 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2026-01-03 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1

SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 6, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 6) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 5064) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2026-01-03 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2026-01-03 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1

SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 6, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 6) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 5256) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2026-01-03 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2026-01-03 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1

SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 6, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 6) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 5881) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2026-01-03 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2026-01-03 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1

SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 6, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 6) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 4848) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2026-01-03 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2026-01-03 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1

SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 6, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 6) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 5194) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2026-01-03 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2026-01-03 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1

SELECT SQL_NO_CACHE *,
( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 6, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 6) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 1995) AND `id_customer` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2026-01-03 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2026-01-03 00:00:00' <= `to`)
ORDER BY `from_quantity` ASC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC

SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 6, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 6) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 5088) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2026-01-03 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2026-01-03 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1

SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 6, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 6) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 6622) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2026-01-03 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2026-01-03 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1

SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 6, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 6) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 5228) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2026-01-03 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2026-01-03 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1

SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 6, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 6) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 6533) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2026-01-03 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2026-01-03 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1

SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 6, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 6) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 4960) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2026-01-03 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2026-01-03 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1

SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 6, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 6) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 4989) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2026-01-03 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2026-01-03 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1

SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 6, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 6) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 5886) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2026-01-03 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2026-01-03 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1

SELECT SQL_NO_CACHE m.page, ml.url_rewrite, ml.id_lang
FROM `ps_meta` m
LEFT JOIN `ps_meta_lang` ml ON (m.id_meta = ml.id_meta AND ml.id_shop = 1 )
ORDER BY LENGTH(ml.url_rewrite) DESC

SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 6, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 6) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 6049) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2026-01-03 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2026-01-03 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1

SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 6, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 6) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 4998) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2026-01-03 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2026-01-03 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1

SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 6, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 6) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 5042) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2026-01-03 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2026-01-03 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1

SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 6, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 6) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 5866) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2026-01-03 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2026-01-03 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1

SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 6, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 6) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 5771) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2026-01-03 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2026-01-03 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1

SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 6, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 6) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 4732) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2026-01-03 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2026-01-03 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1

SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 6, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 6) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 5911) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2026-01-03 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2026-01-03 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1

SELECT SQL_NO_CACHE DISTINCT c.id_consulta, c.*, r.respuesta FROM ps_lgconsultas c LEFT JOIN ps_lgconsultas_respuestas r ON c.id_consulta=r.id_consulta WHERE c.id_producto=1995  AND c.active=1 ORDER BY c.date_add DESC

SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 6, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 6) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 6575) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2026-01-03 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2026-01-03 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1

SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 6, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 6) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 2879) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2026-01-03 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2026-01-03 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1

SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 6, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 6) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 4926) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2026-01-03 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2026-01-03 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1

SELECT SQL_NO_CACHE * FROM `ps_state` ORDER BY `name` ASC

SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 6, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 6) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 4081) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2026-01-03 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2026-01-03 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1

SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 6, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 6) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 5882) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2026-01-03 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2026-01-03 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1

SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 6, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 6) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 5265) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2026-01-03 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2026-01-03 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1

SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 6, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 6) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 4075) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2026-01-03 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2026-01-03 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1

SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 6, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 6) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 6743) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2026-01-03 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2026-01-03 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1

SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 6, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 6) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 6733) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2026-01-03 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2026-01-03 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1

SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 6, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 6) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 5339) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2026-01-03 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2026-01-03 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1

SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 6, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 6) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 6554) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2026-01-03 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2026-01-03 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1

SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 6, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 6) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 292) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2026-01-03 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2026-01-03 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1

SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 6, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 6) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 3478) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2026-01-03 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2026-01-03 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1

SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 6, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 6) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 4082) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2026-01-03 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2026-01-03 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1

SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 6, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 6) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 2954) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2026-01-03 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2026-01-03 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1

SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 6, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 6) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 1404) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2026-01-03 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2026-01-03 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1

SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 6, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 6) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 6578) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2026-01-03 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2026-01-03 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1

SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 6, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 6) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 4083) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2026-01-03 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2026-01-03 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1

SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 6, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 6) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 6065) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2026-01-03 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2026-01-03 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1

SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 6, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 6) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 6571) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2026-01-03 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2026-01-03 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1

SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 6, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 6) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 6094) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2026-01-03 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2026-01-03 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1

SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 6, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 6) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 2149) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2026-01-03 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2026-01-03 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1

SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 6, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 6) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 1337) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2026-01-03 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2026-01-03 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1

SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 6, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 6) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 5895) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2026-01-03 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2026-01-03 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1

SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 6, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 6) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 5422) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2026-01-03 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2026-01-03 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1

SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 6, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 6) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 6577) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2026-01-03 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2026-01-03 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1

SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 6, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 6) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 5524) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2026-01-03 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2026-01-03 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1

SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 6, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 6) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 1745) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2026-01-03 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2026-01-03 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1

SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 6, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 6) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 6095) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2026-01-03 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2026-01-03 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1

SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 6, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 6) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 5173) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2026-01-03 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2026-01-03 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1

SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 6, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 6) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 6576) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2026-01-03 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2026-01-03 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1

SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 6, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 6) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 2157) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2026-01-03 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2026-01-03 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1

SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 6, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 6) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 3403) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2026-01-03 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2026-01-03 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1

SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 6, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 6) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 5386) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2026-01-03 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2026-01-03 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1

SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 6, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 6) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 6076) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2026-01-03 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2026-01-03 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1

SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 6, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 6) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 5512) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2026-01-03 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2026-01-03 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1

SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 6, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 6) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 4076) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2026-01-03 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2026-01-03 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1

SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 6, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 6) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 6594) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2026-01-03 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2026-01-03 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1

SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 6, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 6) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 316) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2026-01-03 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2026-01-03 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1

SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 6, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 6) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 5894) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2026-01-03 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2026-01-03 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1

SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 6, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 6) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 853) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2026-01-03 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2026-01-03 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1

SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 6, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 6) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 1746) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2026-01-03 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2026-01-03 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1

SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 6, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 6) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 759) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2026-01-03 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2026-01-03 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1