Πίσω Βιβλία(σελ 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 (144,178,199,200,361,378,384,385,408,409,410,414,423,431,448,473,474,529,563,589,608,640,712,718,720,738,779,781,847,863,864,889,909,922,923,936,937,969,970,981,982,995,1014,1033,1049,1063,1073,1110,1168,1189,1190,1202,1205,1270,1280,1301,1323,1325,1326,1335,1340,1341,1385,1396,1408,1417,1424,1425,1442,1487,1499,1529,1545,1553,1554,1562,1571,1580,1613,1617,1642,1648,1649,1651,1660,1661,1666,1674,1707,1711,1714,1717,1762,1774,1802,1813,1817,1818,1821,1823,1826,1836,1862,1880,1941,1971,1988,2000,2008,2020,2021,2024,2055,2064,2078,2080,2121,2124,2128,2131,2137,2173,2182,2187,2190,2214,2215,2218,2238,2243,2244,2294,2295,2311,2312,2314,2319,2327,2329,2349,2356,2378,2382,2387,2455,2466,2530,2545,2563,2624,2625,3649,2690,2712,2717,2734,2754,2790,2811,2816,2837,2847,2862,2864,2897,2961,2993,3006,3007,3037,3044,3054,3066,3086,3093,3099,3126,3133,3173,3177,3184,3210,3227,3233,3248,3257,3273,3274,3277,3278,3280,3281,3282,3296,3308,3317,3351,3369,3391,3393,3400,3428,3452,3458,3461,3487,3501,3523,3529,3548,3554,3556,3603,3621,3623,3656,3661,3663,3671,3672,3673,3674,3675,3676,3677,3687,3697,3700,3711,3726,3728,3730,3731,3744,3746,3751,3761,3762,3765,3779,3792,3794,3797,3802,3806,3808,3812,3830,3841,3843,3845,3847,3849,3866,3872,3901,3919,3940,3946,3947,3951,3962,3975,3982,3984,3986,3991,3994,4005,4016,4030,4036,4037,4038,4063,4072,4079,4080,4084,4084) AND jos_vm_product.publish_up>='2018-08-21' order by publish_up desc