SELECT id_objects, objects_shop_allocation.id, entryDate, classification FROM objects_shop_allocation, objects WHERE objects_shop_allocation.start < '1792045401' AND objects_shop_allocation.end > '1792045401' AND objects.id = objects_shop_allocation.id_objects AND objects_shop_allocation.id_objects IN (77,78,82,221,395,397,399,402,408,409,410,412,424,425,426,428,432,433,434,436,438,439,440,441,442,443,444,445,446,452,453,458,460,463,464,465,467,468,469,470,471,475,477,478,479,480,482,483,484,485,490,491,494,495,496,497,500,504,506,507,514,515,516,518,520,521,524,525,530,540,546,547,548,553,566,568,570,576,584,589,590,593,597,598,599,601,627,636,639,640,643,645,646,647,649,650,651,656,662,666,669,670,671,672,673,674,692,694,695,696,697,700,701,707,718,719,720,725,726,728,729,730,731,732,735,751,753,754,758,760,761,762,763,764,765,766,767,771,776,786,788,793,799,806,809,815,818,824,826,828,829,831,841,848,849,852,859,870,873,874,878,880,883,885,886,888,890,891,895,900,901,912,921,925,928,932,933,936,937,941,942,944,954,956,959,960,964,971,980,983,985,991,996,1001,1009,1011,1026,1027,1036,1037,1039,1051,1053,1054,1055,1056,1057,1060,1062,1071,1073,1075,1080,1084,1087,1088,1090,1099,1101,1103,1104,1107,1109,1112,1120,1137,1145,1163,1164,1167,1174,1175,1182,1185,1189,1194,1195,1197,1203,1205,1206,1207,1208,1209,1212,1214,1217,1229,1241,1243,1246,1249,1257,1259,1260,1266,1269,1274,1280,1282,1283,1284,1285,1286,1291,1292,1295,1296,1297,1298,1300,1306,1323,1324,1329,1331,1333,1337,1348,1354,1357,1359,1362,1371,1372,1374,1376,1378,1382,1387,1388,1391,1392,1396,1397,1399,1402,1403,1404,1406,1407,1409,1431,1436,1437,1438,1439,1441,1446,1448,1449,1452,1453,1455,1456,1460,1461,1464,1465,1470,1472,1473,1474,1475,1479,1482,1483,1484,1492,1493,1498,1503,1504,1505,1506,1508,1509,1510,1516,1522,1530,1531,1535,1536,1540,1541,1543,1551,1553,1554,1557,1558,1572,1573,1574,1575,1576,1577,1580,1583,1587,1589,1596,1602,1604,1605,1609,1619,1621,1635,1647,1653,1656,1658,1684,1696,1703,1705,1709,1710,1717,1719,1720,1721,1737,1739,1740,1741,1742,1743,1744,1758,1759,1765,1767,1770,1776,1777,1779,1780,1782,1785,1791,1810,1811,1812,1813,1822,1828,1829,1830,1831,1834,1837,1846,1847,1848,1849,1854,1868,1869,1873,1880,1881,1882,1883,1884,1893,1896,1897,1912,1925,1928,1933,1934,1936,1937,1938,1939,1943,1950,1959,1966,1973,1982,1985,1986,1988,1998,1999,2001,2002,2006,2011,2013,2014,2040,2041,2042,2043,2044,2045,2047,2052,2053,2054,2056,2057,2060,2064,2069,2080,2083,2085,2086,2089,2094,2105,2110,2133,2135,2136,2137,2138,2142,2143,2144,2145,2155,2156,2157,2172,2197,2212,2215,2218,2230,2234,2238,2241,2242,2247,2248,2249,2250,2252,2253,2255,2256,2259,2262,2263,2265,2266,2272,2285,2286,2287,2288,2293,2294,2303,2312,2313,2315,2317,2321,2330,2334,2335,2342,2355,2356,2358,2361,2362,2363,2367,2370,2376,2379,2388,2390,2392,2393,2394,2395,2400,2426,2427,2429,2432,2434,2435,2446,2449,2454,2456,2458,2465,2485,2486,2491,2492,2506,2507,2517,2520,2521,2522,2523,2524,2525,2558,2566,2571,2585,2587,2592,2593,2594,2605,2622,2647,2657,2658,2668,2671,2688,2689,2690,2703,2732,2743,2744,2745,2746,2747,2748,2749,2750,2751,2752,2753,2763,2766,2767,2771,2772,2774,2779,2786,2803,2805,2807,2809,2819,2823,2825,2827,2828,2831,2832,2837,2842,2845,2846,2849,2850,2854,2860,2862,2870,2897,2898,2914,2915,2916,2922,2935,2936,2941,2942,2964,2973,2974,2975,2977,2988,2995,2997,3032,3048,3060,3074,3103,3104,3105,3126,3128,3129,3131,3142,3143,3205,3211,3212,3214,3215,3216,3253,3260,3261,3270,3303,3335,3344,3345,3347,3348,3349,3350,3359,3365,3366,3367,3368,3381,3384,3390,3392,3396,3403,3406,3408,3412,3424,3429,3439,3442,3453,3454,3455,3457,3480,3504,3506,3509,3510,3513,3514,3515,3516,3517,3518,3522,3523,3536,3541,3543,3554,3565,3567,3580,3585,3599,3610,3618,3626,3627,3628,3629,3630,3633,3634,3640,3641,3642,3645,3648,3652,3653,3657,3658,3681,3683,3691,3696,3697,3698,3699,3700,3715,3736,3739,3740,3742,3749,3750,3767,3774,3787,3791,3801,3807,3813,3819,3824,3835,3840,3843,3847,3848,3858,3861,3867,3870,3877,3880,3885,3893,3901,3912,3914,3920,3922,3924,3925,3928,3929,3933,3941,3945,3947,3948,3950,3954,3955,3958,3959,3961,3962,3963,3964,3965,3967,3972,3973,3975,3978,3979,3997,3998,3999,4000,4001,4002,4010,4026,4047,4059,4060,4089,4093,4146,4157,4166,4195,4200,4201,4208,4209,4211,4266,4283,4286,4287,4293,4294,4304,4324,4334,4359,4364,4383,4386,4396,4399,4402,4494,4521,4531,4532,4536,4537,4550,4551,4552,4571,4589,4590,4614,4618,4619,4643,4657,4659,4661,4662,4663,4670,4672,4673,4674,4675,4676,4677,4682,4685,4692,4701,4705,4740,4747,4748,4749,4755,4765,4767,4781,4784,4793,4794,4801,4802,4814,4828,4829,4835,4846,4847,4848,4849,4851,4852,4854,4856,4857,4862,4864,4869,4870,4872,4873,4875,4887,4890,4894,4898,4899,4902,4904,4906,4911,4913,4934,4935,4938,4957,4977,4978,4986,4987,4988,4989,4990,4991,4992,4995,4998,5001,5002,5003,5004,5005,5007,5008,5009,5013,5018,5031,5039,5041,5047,5052,5075,5079,5096,5097,5100,5106,5110,5117,5127,5136,5138,5139,5145,5149,5152,5153,5154,5157,5158,5160,5162,5166,5176,5178,5183,5189,5193,5204,5206,5210,5218,5219,5220,5221,5222,5223,5224,5235,5244,5249,5251,5256,5258,5268,5269,5279,5283,5284,5285,5286,5287,5292,5293,5294,5296,5304,5305,5307,5312,5313,5316,5320,5332,5334,5335,5336,5343,5344,5346,5354,5358,5360,5365,5366,5367,5370,5371,5374,5375,5377,5381,5385,5388,5398,5403,5405,5413,5414,5418,5425,5433,5435,5436,5447,5448,5450,5453,5476,5495,5498,5499,5510,5521,5522,5527,5528,5530,5532,5537,5538,5551,5552,5555,5557,5559,5562,5571,5574,5583,5584,5589,5592,5597,5602,5606,5607,5611,5619,5623,5625,5626,5633,5638,5641,5642,5643,5644,5656,5661,5673,5678,5681,5690,5691,5695,5696,5699,5708,5711,5712,5721,5729,5731,5737,5749,5753,5757,5766,5773,5790,5800,5832,5842,5845,5875,5881,5884,5921,5933,5934,5943,6018,6022,6026,6030,6043,6111,6118,6119,6120,6121,6122,6127,6129,6136,6140,6142,6149,6176,6179,6180,6181,6182,6183,6206,6211,6216,6218,6221,6222,6223,6236,6241,6247,6251,6254,6269,6279,6280,6296,6310,6311,6337,6338,6339,6340,6346,6355,6357,6358,6359,6366,6367,6376,6383,6386,6399,6401,6402,6414,6422,6439,6455,6462,6469,6470,6477,6483,6486,6487,6491,6492,6494,6495,6496,6497,6498,6500,6514,6516,6520,6521,6523,6527,6529,6533,6534,6540,6541,6545,6547,6555,6565,6575,6579,6583,6586,6599,6603,6605,6606,6610,6616,6617,6620,6621,6622,6623,6624,6635,6637,6639,6640,6641,6642,6647,6648,6651,6652,6653,6654,6660,6661,6663,6664,6665,6666,6668,6669,6670,6671,6673,6674,6675,6684,6685,6686,6687,6688,6689,6690,6691,6692,6693,6694,6696,6697,6698,6699,6700,6701,6702,6703,6704,6705,6712,6714,6715,6716,6717,6718,6719,6720,6721,6722,6723,6725,6730,6731,6732,6733,6735,6742,6743,6744,6746,6747,6748,6750,6751,6752,6753,6754,6755,6756,6757,6758,6759,6760,6763,6764,6765,6766,6767,6769,6772,6773,6774,6775,6776,6777,6779,6780,6781,6782,6783,6788,6789,6790,6791,6792,6793,6794,6796,6798,6799,6800,6801,6803,6804,6805,6806,6807,6808,6810,6811,6812,6813,6815,6816,6819,6820,6821,6822,6823,6824,6825,6831,6832,6840,6841,6842,6843,6844,6846,6848,6849,6850,6851,6852,6853,6858,6859,6860,6864,6865,6869,6870,6872,6876,6878,6879,6880,6881,6882,6883,6884,6885,6886,6889,6890,6892,6893,6894,6895,6897,6898,6899,6901,6902,6904,6905,6906,6907,6908,6910,6911,6914,6917,6918,6919,6920,6922,6924,6926,6928,6929,6930,6931,6932,6934,6936,6937,6938,6939,6941,6942,6943,6944,6946,6947,6948,6949,6950,6953,6956,6957,6958,6959,6960,6961,6962,6963,6964,6966,6967,6968,6969,6970,6972,6973,6978,6985,6986,6987,6993,7000,7003,7004,7007,7008,7009,7010,7011,7012,7013,7014,7016,7017,7018,7019,7020,7021,7022,7026,7029,7035,7036,7037,7038,7039,7040,7042,7043,7046,7047,7048,7053,7054,7055,7056,7057,7059,7060,7063,7065,7069,7070,7071,7072,7075,7076,7086,7096,7098,7104,7109,7113,7114,7115,7122,7123,7127,7129,7132,7133,7134,7136,7137,7143,7145,7147,7148,7149,7150,7166,7169,7175,7185,7186,7189,7191,7194,7195,7204,7206,7212,7219,7220,7224,7225,7229,7236,7242,7246,7247,7274,7275,7276,7277,7278,7281,7282,7283,7284,7287,7288,7289,7292,7294,7296,7298,7300,7301,7302,7304,7306,7307,7317,7318,7319,7320,7321,7323,7325,7328,7329,7333,7338,7339,7341,7355,7365,7371,7372,7374,7375,7376,7377,7378,7379,7380,7385,7386,7388,7389,7390,7393,7394,7395,7396,7397,7398,7399,7400,7402,7403,7404,7407,7415,7416,7418,7419,7420,7421,7422,7425,7426,7427,7436,7441,7442,7443,7444,7454,7462,7467,7468,7477,7478,7479,7482,7494,7495,7496,7497,7498,7502,7503,7504,7513,7514,7526,7535,7536,7537,7539,7544,7545,7546,7547,7550,7554,7556,7566,7567,7568,7569,7570,7572,7573,7588,7590,7596,7603,7609,7610,7616,7618,7620,7621,7622,7623,7624,7625,7627,7632,7636,7638,7645,7646,7647,7650,7651,7654,7655,7656,7661,7662,7664,7665,7666,7667,7674,7678,7679,7685,7708,7709,7717,7723,7728,7730,7734,7736,7737,7739,7744,7745,7749,7750,7752,7753,7754,7755,7757,7760,7761,7768,7773,7777,7779,7784,7785,7788,7794,7801,7802,7810,7813,7821,7822,7823,7827,7828,7829,7833,7834,7836,7837,7838,7842,7844,7846,7849,7850,7851,7852,7853,7854,7856,7857,7859,7860,7866,7868,7869,7870,7871,7873,7874,7875,7905,7908,7911,7914,7915,7916,7920,7927,7928,7930,7931,7934,7935,7936,7937,7938,7939,7940,7942,7943,7944,7945,7946,7947,7948,7953,7954,7956,7958,7960,7961,7969,7971,7974,7978,7979,7981,7982,7984,7988,7992,7993,7994,7995,7996,7997,7998,8000,8001,8002,8004,8005,8008,8011,8012,8013,8015,8016,8017,8018,8019,8020,8028,8032,8034,8035,8036,8038,8042,8043,8048,8049,8050,8054,8055,8056,8057,8061,8062,8068,8071,8072,8085,8086,8108,8110,8111,8112,8115,8119,8120,8122,8134,8135,8140,8145,8149,8150,8152,8157,8159,8160,8161,8162,8163,8164,8165,8166,8167,8172,8173,8174,8175,8176,8180,8186,8188,8189,8190,8201,8204,8220,8221,8222,8224,8225,8226,8241,8242,8243,8244,8246,8247,8248,8250,8254,8255,8256,8258,8259,8260,8262,8264,8265,8266,8267,8275,8279,8280,8281,8282,8327,8338,8339,8340,8342,8343,8351,8352,8369,8384,8385,8391,8392,8403,8404,8405,8432,8433,8434,8435,8436,8446,8448,8449,8450,8454,8455,8459,8460,8461,8462,8463,8464,8465,8485,8496,8497,8498,8499,8502,8508,8509,8510,8511,8512,8522,8523,8545,8559,8560,8561,8568,8569,8571,8572,8574,8575,8576,8585,8595,8598,8608,8609,8610,8614,8615,8623,8629,8630,8631,8632,8644,8645,8647,8658,8661,8662,8663,8664,8665,8685,8686,8693,8694,8695,8709,8715,8716,8717,8730,8742,8743,8749,8752,8756,8774,8775,8781,8786,8787,8788,8789,8790,8791,8792,8793,8805,8806,8808,8809,8810,8811,8825,8826,8839,8840,8851,8852,8853,8854,8861,8868,8869,8873,8874,8881,8888,8890,8891,8892,8893,8894,8895,8896,8897,8899,8909,8913,8915,8930,8932,8936,8937,8938,8943,8965,8966,8967,8970,8978,8979,8980,8981,8982,8983,8984,8985,8986,8987,9012,9013,9021,9026,9027,9028,9039,9040,9052,9054,9056,9075,9076,9091,9092,9093,9094,9095,9097,9099,9105,9106,9108,9109,9114,9116,9117,9118,9119,9125,9131,9132,9133,9134,9135,9136,9137,9185,9186,9187,9188,9191,9192,9204,9213,9215,9216,9217,9223,9226,9232,9233,9236,9237,9242,9248,9250,9251,9252,9293,9304,9329,9330,9333,9340,9355,9356,9357,9359,9360,9387,9390,9394,9396,9401,9403,9405,9411,9412,9418,9445,9448,9449,9450,9451,9457,9471,9475,9476,9477,9484,9504,9508,9514,9515,9518,9522,9525,9526,9527,9528,9538,9551,9552,9554,9555,9559,9560,9571,9584,9588,9593,9625,9637,9642,9662,9663,9664,9673,9676,9677,9689,9692,9693,9712,9714,9715,9716,9717,9720,9721,9728,9731,9732,9738,9739,9740,9741,9742,9743,9744,9745,9746,9747,9748,9751,9752,9753,9755,9756,9762,9763,9768,9769,9774,9777,9780,9792,9793,9797,9798,9807,9811,9812,9813,9814,9816,9817,9818,9819,9820,9821,9822,9823,9824,9825,9828,9829,9831,9832,9833,9834,9835,9843,9844,9849,9850,9851,9852,9853,9854,9860,9861,9862,9863,9868,9872,9877,9880,9882,9884,9885,9886,9889,9894,9896,9898,9899,9900,9911,9924,9930,9931,9936,9945,9950,9962,9963,9964,9969,9975,9976,9977,9999,10005,10006,10026,10052,10056,10061,10064,10070,10071,10072,10075,10077,10084,10085,10087,10089,10090,10091,10092,10093,10097,10098,10099,10100,10102,10103,10104,10105,10106,10107,10108,10109,10110,10111,10112,10113,10114,10121,10127,10134,10138,10145,10146,10154,10156,10158,10167,10168,10170,10171,10172,10173,10181,10182,10192,10198,10199,10200,10201,10202,10205,10206,10207,10208,10210,10211,10212,10213,10214,10222,10230,10236,10237,10241,10243,10244,10245,10246,10250,10254,10258,10266,10267,10272,10274,10279,10281,10283,10284,10285,10286,10287,10288,10290,10291,10292,10293,10294,10295,10296,10298,10299,10301,10302,10304,10307,10308,10309,10314,10315,10319,10323,10324,10328) AND objects_shop_allocation.id_shop IN (1) GROUP BY objects_shop_allocation.id_objects ORDER BY entryDate DESC LIMIT 0,20