Jaeger Le Coultre

3065 Expression #1 of ORDER BY clause is not in SELECT list, references column 'etaswisswatch.f.featured_date_added' which is not in SELECT list; this is incompatible with DISTINCT
in:
[select distinct p.products_id, p.products_image, pd.products_name, p.master_categories_id from (zen_products p left join zen_featured f on p.products_id = f.products_id left join zen_products_description pd on p.products_id = pd.products_id) where p.products_id = f.products_id and p.products_id = pd.products_id and p.products_status = 1 and f.status = 1 and pd.language_id = '4' and p.products_id in (32680, 32899, 32900, 32901, 32902, 32903, 32904, 32905, 32906, 33042, 33043, 33044, 32681, 32688, 32837, 32838, 32839, 33168, 33169, 32682, 32908, 32909, 33112, 33157, 32683, 32689, 32684, 32810, 32811, 32812, 32813, 32814, 32815, 32816, 33145, 33146, 32685, 33041, 33153, 33154, 33155, 33156, 32686, 32702, 32703, 32704, 32705, 32706, 32707, 32708, 32709, 32687, 32714, 32715, 32716, 32717, 32718, 32719, 32720, 32721, 32722, 32723, 32991, 32690, 32869, 32870, 32871, 32872, 32873, 32874, 32875, 32876, 32877, 32878, 32879, 32880, 32881, 32882, 32883, 32884, 32885, 32886, 32887, 32888, 32889, 32890, 32891, 32892, 32893, 33019, 33020, 33021, 33022, 33023, 33024, 33025, 33026, 33027, 33028, 33029, 33030, 33031, 33032, 33033, 33034, 33035, 33036, 33037, 33038, 33095, 33096, 33097, 33098, 33099, 33100, 33101, 33102, 33103, 33104, 33105, 32691, 32692, 32693, 32694, 33079, 33080, 33081, 33082, 32695, 32696, 33083, 33084, 33085, 33086, 32697, 32698, 32699, 33087, 33088, 33089, 33144, 32700, 32701, 32710, 32711, 32712, 32713, 32724, 32725, 32726, 32727, 32728, 32729, 32730, 32731, 32732, 32733, 32734, 32735, 32736, 32737, 32738, 32739, 32740, 32741, 32742, 32743, 32744, 32745, 32746, 32747, 32748, 32749, 32750, 32751, 32752, 32753, 32754, 32755, 32756, 32757, 32758, 32759, 32760, 32992, 32993, 32994, 32995, 32761, 32762, 32763, 32764, 32765, 32766, 32767, 32768, 32769, 32770, 32771, 32772, 32773, 32774, 32775, 32776, 32777, 32778, 32779, 32780, 32781, 32782, 32996, 32997, 32783, 32784, 32785, 32786, 33090, 33091, 33166, 32787, 32788, 32998, 32999, 33092, 32789, 32790, 32791, 32792, 32793, 32794, 32795, 32796, 32797, 32798, 32799, 32800, 32801, 32802, 32803, 32804, 32805, 32806, 32807, 32808, 32809, 33000, 33001, 33002, 33003, 33004, 33005, 33006, 33007, 33008, 33009, 33010, 33011, 33012, 32817, 32818, 32819, 33013, 33014, 33015, 33016, 32820, 32821, 32822, 32823, 32824, 32825, 32826, 32827, 32828, 32829, 32830, 33017, 33147, 33148, 33149, 33150, 32831, 32832, 33093, 33094, 32833, 32834, 32835, 32836, 33167, 32840, 32841, 32842, 32843, 32844, 32845, 32846, 32847, 32848, 32849, 32850, 33018, 33151, 33152, 33170, 32851, 32852, 32853, 32854, 32855, 32856, 32857, 32858, 32859, 32860, 32861, 32862, 32863, 32864, 32865, 32866, 32867, 32868, 32894, 32895, 32896, 32897, 32898, 33039, 33040, 32907, 33045, 33046, 33047, 33048, 33049, 32910, 32911, 33116, 33117, 33118, 33119, 33120, 33121, 33158, 32912, 32913, 32914, 32915, 32916, 32917, 32918, 32919, 32920, 32921, 32922, 32923, 32924, 32925, 32926, 32927, 32928, 32929, 32930, 32931, 32932, 32933, 32934, 32935, 32936, 33052, 32937, 33053, 33133, 32938, 32939, 32940, 33060, 33061, 33160, 32941, 32942, 32943, 32944, 32945, 32946, 32947, 32948, 32949, 32950, 32951, 33062, 33134, 33135, 33136, 33137, 33138, 32952, 32953, 32954, 32955, 32956, 32957, 32958, 32959, 32960, 33063, 33064, 32961, 33161, 33162, 33163, 33164, 33165, 32962, 32963, 33139, 32964, 32965, 32966, 32967, 32968, 32969, 32970, 32971, 32972, 32973, 32974, 32975, 32976, 32977, 32978, 32979, 32980, 32981, 32982, 32983, 32984, 32985, 32986, 33065, 33066, 33067, 33068, 33069, 33070, 33071, 33072, 33073, 33074, 33075, 32987, 32988, 33076, 33077, 32989, 32990, 33050, 33109, 33110, 33111, 33051, 33131, 33132, 33054, 33055, 33056, 33057, 33058, 33059, 33078, 33140, 33141, 33142, 33143, 33106, 33107, 33108, 33113, 33114, 33115, 33122, 33123, 33124, 33125, 33126, 33127, 33128, 33129, 33130, 33159) order by f.featured_date_added DESC Limit 6]