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 = '1' and p.products_id in (31990, 32014, 32023, 32026, 32136, 32137, 32138, 32139, 32140, 32141, 32142, 32143, 32144, 32145, 32243, 32473, 32474, 32475, 32476, 32477, 32478, 32479, 32480, 32481, 31991, 31997, 32003, 32007, 32028, 32068, 32265, 32266, 32267, 32268, 32269, 32270, 32271, 32272, 32273, 31992, 32134, 32135, 32314, 32315, 32316, 32317, 32318, 32319, 32320, 31993, 32033, 32213, 32214, 32215, 32297, 32298, 32299, 32300, 32301, 32302, 32303, 32304, 32305, 32306, 32307, 37991, 37992, 37993, 37994, 31994, 32010, 32054, 32055, 32056, 32057, 32058, 32059, 32060, 32061, 32062, 32063, 32064, 32065, 32066, 32250, 32251, 32252, 32253, 32254, 32255, 32256, 32257, 32258, 32259, 32260, 32445, 32446, 31995, 32008, 32034, 32035, 32036, 32037, 32038, 32039, 32040, 32041, 32042, 32043, 32044, 32045, 32046, 32047, 32048, 32049, 32050, 32051, 32244, 32245, 32246, 32247, 32432, 32433, 32434, 32435, 32436, 32437, 31996, 32012, 32013, 32022, 31998, 32195, 32196, 32372, 32373, 32374, 32375, 32376, 31999, 32000, 32001, 32101, 32102, 32293, 32294, 32295, 32002, 32261, 32262, 32004, 32017, 32032, 32108, 32109, 32110, 32111, 32112, 32113, 32114, 32115, 32116, 32117, 32118, 32119, 32120, 32121, 32122, 32123, 32124, 32125, 32126, 32127, 32128, 32129, 32130, 32131, 32132, 32133, 32431, 32451, 32452, 32453, 32454, 32455, 32456, 32457, 32458, 32459, 32460, 32461, 32462, 32463, 32464, 32465, 32466, 32467, 32468, 32469, 32470, 32471, 32472, 32005, 32006, 32020, 32069, 32070, 32071, 32072, 32274, 32275, 32276, 32277, 32278, 32279, 32009, 32019, 32025, 32030, 32103, 32104, 32105, 32106, 32107, 32296, 32311, 32312, 32313, 32011, 32015, 32197, 32198, 32199, 32200, 32201, 32202, 32377, 32378, 32379, 32380, 32381, 32382, 32383, 32384, 32385, 32016, 32018, 32189, 32190, 32191, 32192, 32193, 32194, 32241, 32242, 32492, 32493, 32494, 32495, 32496, 32021, 32174, 32175, 32176, 32177, 32178, 32179, 32180, 32181, 32182, 32349, 32350, 32351, 32352, 32353, 32354, 32355, 32356, 32357, 32358, 32024, 32216, 32217, 32309, 32310, 32389, 32390, 32391, 32392, 32393, 32394, 32395, 32027, 32031, 32094, 32095, 32096, 32097, 32098, 32099, 32100, 32292, 32447, 32448, 32449, 32450, 32029, 32156, 32157, 32158, 32159, 32160, 32331, 32332, 32333, 32334, 32335, 32052, 32053, 32248, 32249, 32438, 32439, 32440, 32441, 32442, 32443, 32444, 32067, 32073, 32074, 32075, 32076, 32077, 32078, 32079, 32080, 32081, 32082, 32280, 32281, 32282, 32283, 32284, 32285, 32083, 32084, 32286, 32287, 32288, 32289, 32290, 32085, 32086, 32087, 32088, 32089, 32090, 32091, 32092, 32093, 32291, 32146, 32147, 32148, 32149, 32150, 32151, 32152, 32153, 32154, 32155, 32321, 32322, 32323, 32324, 32325, 32326, 32327, 32328, 32329, 32330, 32482, 32483, 32484, 32161, 32162, 32163, 32164, 32336, 32337, 32338, 32339, 32340, 32341, 32485, 32486, 32165, 32166, 32167, 32168, 32169, 32170, 32171, 32172, 32173, 32342, 32343, 32344, 32345, 32346, 32347, 32348, 32487, 32488, 32489, 32490, 32491, 32183, 32184, 32359, 32360, 32361, 32362, 32363, 32364, 32365, 32366, 32185, 32186, 32187, 32188, 32367, 32368, 32369, 32370, 32371, 32497, 32203, 32204, 32205, 32206, 32207, 32208, 32209, 32210, 32211, 32212, 32386, 32218, 32219, 32220, 32221, 32396, 32397, 32398, 32399, 32400, 32401, 32402, 32222, 32410, 32411, 32412, 32413, 32414, 32415, 32416, 32417, 32223, 32224, 32225, 32418, 32419, 32420, 32421, 32422, 32226, 32227, 32228, 32229, 32230, 32231, 32232, 32233, 32234, 32235, 32236, 32237, 32238, 32239, 32240, 32263, 32264, 32308, 32387, 32388, 32403, 32404, 32405, 32406, 32407, 32408, 32409, 32423, 32424, 32425, 32426, 32427, 32428, 32429, 32430) order by f.featured_date_added DESC Limit 6]