SELECT DISTINCT p.name, p.id, i.base_filename, p.sale_price_inc_vat, pc.category FROM products p, images i, product_category pc WHERE pc.product = p.id && pc.category IN (,40,41,42,43,44,45,46,47,48,49,50,51,441,442,261,240,243,255,256,257,258,259,260,264,265,266,443,444,445,446,447,582,53,54,55,61,60,59,62,63,64,65,66,67,68,69,70,71,72,73,74,75,148,422,423,424,426,490,577,76,77,78,89,130,132,337,371,493,494,496,497,498,580,79,329,330,331,332,333,335,341,534,80,81,82,83,84,85,86,87,88,112,436,336,449,113,131,139,275,230,231,236,382,450,90,91,92,93,94,95,96,97,98,100,101,102,108,103,104,105,106,109,110,111,118,119,120,121,124,123,125,126,127,128,151,152,153,154,155,156,157,158,159,160,161,162,163,164,165,166,167,186,190,198,204,226,499,501,502,115,116,117,393,397,430,129,141,578,134,140,142,323,324,326,327,328,420,448,500,136,137,138,334,351,143,144,145,146,147,150,224,342,343,344,345,346,347,348,349,352,354,355,356,358,357,359,360,361,362,363,364,365,366,367,368,369,370,398,421,191,206,207,208,209,210,211,212,213,214,215,216,217,218,234,233,276,486,487,488,202,193,203,267,268,285,417,418,419,200,192,201,414,415,416,220,431,221,223,252,254,262,286,227,228,229,376,377,378,237,238,239,245,246,247,248,249,250,251,390,484,277,278,283,383,384,385,387,388,389,462,535,536,537,538,539,540,541,542,543,544,545,546,547,548,549,550,551,552,553,576,288,279,280,281,290,375,282,295,291,296,297,298,299,407,408,305,306,307,308,554,555,556,557,558,559,309,310,455,456,457,458,459,460,461,311,312,313,315,316,317,318,453,396,454,319,320,321,292,293,300,372,373,374,392,463,491,301,338,339,340,566,302,303,294,304,427,437,380,381,391,395,413,428,565,581,471,472,474,475,477,478,479,480,485,489,495,205,325,434,435,509,510,511,514,515,516,517,518,519,520,521,522,523,524,525,526,527,528,529,530,531,532,562,579,563,512,513,561,564,567,568,569,570,571,572,573,574,575,583) && p.primary_image = i.id GROUP BY p.name ORDER BY p.creation_date DESC LIMIT 4