Πίσω Παιδικά(σελ 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 (183,3917,203,214,221,287,288,310,311,314,317,318,320,321,326,327,347,349,350,352,358,363,364,365,366,375,376,405,407,413,420,452,482,483,485,525,528,548,566,567,651,660,661,705,714,719,724,737,757,762,765,769,785,786,815,816,822,826,881,892,906,916,917,926,942,953,961,973,989,990,1017,1025,1026,1034,1035,1040,1050,1056,1057,1058,1076,1093,1094,1095,1096,1105,1113,1114,1115,1124,1130,1131,1147,1163,1169,1170,1177,1188,1194,1195,1214,1287,1307,1313,1314,1321,1322,1333,1359,1382,1388,1400,1411,1418,1440,1441,1443,1445,1450,1474,1480,1490,1491,1512,1522,1530,1534,1543,1557,1576,1586,1597,1616,1633,1635,1636,1639,1643,1646,1663,1665,1669,1684,1694,1695,1703,1704,1722,1726,1727,1738,1751,1753,1755,1770,1775,1788,1789,1806,1831,1835,1837,1849,1855,1864,1871,1872,1873,1876,1881,1884,1888,1898,1910,1917,1927,1932,1935,1939,1940,1949,1950,1951,1954,1970,1976,1977,1990,2031,2032,2049,2050,2053,2066,2068,2074,2076,2077,2081,2082,2085,2086,2088,2095,2096,2098,2099,2100,2101,2112,2113,2122,2125,2130,2139,2159,2166,2168,2172,2180,2185,2202,2208,2211,2219,2224,2227,2237,2250,2252,2254,2256,2267,2269,2272,2273,2274,2277,2278,2286,2315,2328,2330,2331,2332,2336,2351,2352,2353,2357,2363,2365,2369,2384,2395,2404,2406,2409,2423,2425,2431,2450,2451,2452,2460,2464,2471,2474,2478,2486,2487,2488,2489,2493,2496,2500,2501,2507,2508,2513,2520,2527,2528,2533,2535,2543,2544,2547,2550,2552,2564,2565,2566,2567,2568,2570,2572,2573,2580,2584,2605,2607,2665,2682,2688,2689,2699,2704,2707,2737,2748,2751,2755,2759,2760,2767,2775,2785,2791,2793,2798,2799,2810,2844,2846,2849,2855,2856,2860,2872,2873,2875,2879,2888,2900,2908,2910,2917,2919,2927,2928,2929,2933,2948,2950,2954,2955,2960,2962,2972,2977,2982,2985,2986,3017,3024,3041,3055,3056,3057,3061,3063,3065,3069,3070,3071,3072,3073,3074,3077,3082,3088,3090,3108,3115,3128,3136,3139,3141,3142,3144,3151,3152,3153,3178,3180,3181,3182,3183,3194,3195,3196,3204,3205,3208,3218,3235,3252,3258,3260,3261,3275,3276,3283,3285,3291,3303,3304,3306,3314,3321,3323,3325,3336,3339,3343,3347,3352,3353,3511,3357,3359,3367,3372,3379,3388,3389,3392,3397,3407,3408,3409,3410,3415,3427,3429,3451,3453,3454,3464,3465,3480,3518,3519,3520,3524,3532,3543,3546,3559,3561,3562,3563,3564,3567,3573,3574,3576,3577,3578,3583,3584,3588,3590,3591,3594,3596,3597,3598,3599,3606,3613,3616,3618,3619,3634,3637,3655,3666,3683,3685,3703,3706,3708,3722,3747,3764,3773,3774,3775,3776,3814,3817,3818,3831,3833,3834,3835,3840,3842,3851,3852,3854,3855,3859,3861,3882,3885,3888,3891,3892,3893,3902,3907,3912,3921,3922,3924,3925,3926,3928,3929,3930,3934,3952,3965,3973,3974,3977,3998,4007,4008,4014,4019,4026,4034,4039,4041,4043,4044,4049,4050,4053,4060,4061,4067,4073,4077,4078,4081,4081) AND jos_vm_product.publish_up>='2018-10-16' order by publish_up desc