Πίσω Ελευθ. χρόνου-Ψυχαγωγικά(σελ 1)Ευρετήριο
Select * from jos_vm_product left join jos_vm_product_category_xref on jos_vm_product_category_xref.product_id=jos_vm_product.product_id where jos_vm_product_category_xref.category_id in (132,139,172,177,189,204,230,289,308,312,319,344,345,368,379,380,406,429,432,438,439,449,462,463,464,465,466,467,468,469,470,471,531,532,559,560,561,582,583,584,585,610,630,631,632,633,634,635,664,665,666,667,681,682,689,690,691,692,695,728,729,739,740,741,742,760,763,788,789,793,794,799,800,801,803,804,805,819,820,821,831,850,855,890,891,904,905,911,912,913,914,924,925,940,941,972,998,999,1000,1024,1045,1065,1075,1084,1091,1092,1103,1104,1111,1112,1123,1129,1162,1191,1206,1212,1213,1217,1237,1238,1251,1271,1289,1302,1319,1320,1330,1337,1338,1342,1343,1344,1345,1350,1375,1376,1381,1398,1399,1439,1451,1467,1468,1473,1489,1496,1498,1505,1511,1521,1537,1555,1565,1566,1583,1585,1606,1620,1621,1623,1625,1631,1632,1638,1672,1677,1680,1681,1690,1692,1697,1701,1706,1708,1718,1720,1725,1729,1730,1741,1749,1756,1763,1768,1778,1798,1828,1838,1852,1856,1857,1858,1882,1915,1920,1933,1968,1987,1993,1997,2003,2007,2044,2062,2063,2111,2119,2129,2141,2155,2169,2170,2176,2179,2194,2196,2206,2216,2232,2239,2251,2258,2259,2265,2280,2281,2285,2288,2289,2290,2302,2305,2306,2313,2318,2322,2350,2391,2396,2399,2408,2413,2444,2457,2467,2468,2479,2484,2485,2494,2516,2518,2542,2546,2559,2560,2585,2586,2590,2596,2597,2600,2613,2622,2623,2630,2633,2639,2644,2654,2662,2676,2683,2702,2713,2718,2733,2736,2741,2743,2757,2763,2787,2788,2794,2805,2809,2820,2825,2826,2841,2842,2843,2853,2854,2871,2882,2884,2895,2896,2902,2978,2984,2988,2994,3010,3012,3013,3020,3021,3023,3031,3032,3035,3036,3040,3046,3051,3059,3087,3089,3091,3092,3094,3096,3097,3098,3110,3114,3116,3119,3132,3135,3147,3154,3160,3164,3174,3186,3198,3200,3216,3221,3254,3255,3256,3259,3267,3289,3311,3312,3313,3329,3330,3340,3350,3356,3360,3362,3384,3385,3386,3387,3395,3396,3399,3403,3416,3417,3467,3471,3472,3497,3525,3553,3628,3652,3932,3723,3729,3754,3763,3787,3811,3813,3816,3820,3825,3826,3839,3867,3874,3889,3895,3898,3903,3909,3945,3949,3953,3959,3960,3961,3970,3978,3981,3985,4002,4003,4006,4011,4023,4024,4025,4058,4066,4076,4086,4086) AND jos_vm_product.publish_up>='2018-06-23' order by publish_up desc