SÉLECTIONNEZ ns_product_data.Formula_No, ns_formula_details.Product_Name, ns_product_data.Animal_Type, ns_product_data.Product_Type, Cendres, Calcium, Max_Fiber, Min_Fat, Min_Protein, Phosphore, Potassium, Sod... [VOIR LA REQUÊTE COMPLÈTE]

SELECT ns_product_data.Formula_No, ns_formula_details.Product_Name, ns_product_data.Animal_Type, ns_product_data.Product_Type, Ash, Calcium, Max_Fiber, Min_Fat, Min_Protein, Phosphorus, Potassium, Sodium, Kibble_Size FROM ns_product_data INNER JOIN ns_formula_details ON ns_formula_details.Formula_No = ns_product_data.Formula_No WHERE ns_product_data.Formula_No NOT IN ( SELECT DISTINCT Formula_No FROM ns_product_ingredients AS t1 INNER JOIN ( SELECT Formula_No AS t2_Formula_No, MAX(Cf_Part_No) AS Max_Cf_Part_No FROM ns_product_ingredients GROUP BY Formula_No) AS t2 ON t1.Formula_No = t2_Formula_No AND t1.Cf_Part_No = t2.Max_Cf_Part_No WHERE Ing_Class IN ('Agar Agar', 'Apple', 'Duck', 'Peanut', 'Trout') ) AND ns_product_data.Formula_No NOT LIKE '%FT' AND Ash IS NOT NULL AND Calcium IS NOT NULL AND Max_Fiber IS NOT NULL AND Min_Fat IS NOT NULL AND Min_Protein IS NOT NULL AND Phosphorus IS NOT NULL AND Potassium IS NOT NULL AND Sodium IS NOT NULL AND ns_product_data.Product_Name NOT LIKE '%Tuffy%' GROUP BY Formula_No ORDER BY Product_Name ASC

SÉLECTIONNEZ ns_product_data.Formula_No, ns_formula_details.Product_Name, ns_product_data.Animal_Type, ns_product_data.Product_Type, Cendres, Calcium, Max_Fiber, Min_Fat, Min_Protein, Phosphore, Potassium, Sod... [VOIR LA REQUÊTE COMPLÈTE]

SELECT ns_product_data.Formula_No, ns_formula_details.Product_Name, ns_product_data.Animal_Type, ns_product_data.Product_Type, Ash, Calcium, Max_Fiber, Min_Fat, Min_Protein, Phosphorus, Potassium, Sodium, Kibble_Size FROM ns_product_data INNER JOIN ns_formula_details ON ns_formula_details.Formula_No = ns_product_data.Formula_No WHERE ns_product_data.Formula_No NOT IN ( SELECT DISTINCT Formula_No FROM ns_product_ingredients AS t1 INNER JOIN ( SELECT Formula_No AS t2_Formula_No, MAX(Cf_Part_No) AS Max_Cf_Part_No FROM ns_product_ingredients GROUP BY Formula_No) AS t2 ON t1.Formula_No = t2_Formula_No AND t1.Cf_Part_No = t2.Max_Cf_Part_No WHERE Ing_Class IN ('Agar Agar', 'Apple', 'Duck', 'Peanut', 'Trout') ) AND ns_product_data.Formula_No NOT LIKE '%FT' AND Ash IS NOT NULL AND Calcium IS NOT NULL AND Max_Fiber IS NOT NULL AND Min_Fat IS NOT NULL AND Min_Protein IS NOT NULL AND Phosphorus IS NOT NULL AND Potassium IS NOT NULL AND Sodium IS NOT NULL AND ns_product_data.Product_Name NOT LIKE '%Tuffy%' GROUP BY Formula_No ORDER BY Product_Name ASC

SÉLECTIONNEZ DISTINCT ns_product_data.Formula_No, Cf_Part_No, ns_formula_details.Product_Name, ns_product_data.Animal_Type, ns_product_data.Product_Type, Cendres, Calcium, Max_Fibres, Min_Matières grasses, Min_Protéines, Phosphate... [VOIR LA REQUÊTE COMPLÈTE]

SELECT DISTINCT ns_product_data.Formula_No, Cf_Part_No, ns_formula_details.Product_Name, ns_product_data.Animal_Type, ns_product_data.Product_Type, Ash, Calcium, Max_Fiber, Min_Fat, Min_Protein, Phosphorus, Potassium, Sodium, Kibble_Size FROM ns_product_data INNER JOIN ns_formula_details ON formula_details.Formula_No = ns_product_data.Formula_No OÙ ns_product_data.Animal_Type = 'Dog' AND Grain_Free = 'Yes' AND Kibble_Size = 'Large Breed Adult' ET ns_product_data.Product_Type = 'Dry' AND Min_Protein <= 0.120000 AND Phosphorus <= 0.005000 AND Calcium >= 0,005000 ET Potassium <= 0.009000 AND ns_product_data.Formula_No NOT LIKE '%FT' AND Ash IS NOT NULL AND Calcium IS NOT NULL AND Max_Fiber IS NOT NULL AND Min_Fat IS NOT NULL AND Min_Protein IS NOT NULL AND Phosphorus IS NOT NULL AND Potassium IS NOT NULL AND Sodium IS NOT NULL AND ns_product_data.Product_Name NOT LIKE '%Tuffy%' AND ns_product_data.Product_Name NOT LIKE '%Supreme%' GROUP BY Formula_No ORDER BY Product_Name ASC

SÉLECTIONNEZ ns_product_data.Formula_No, ns_formula_details.Product_Name, ns_product_data.Animal_Type, ns_product_data.Product_Type, Cendres, Calcium, Max_Fiber, Min_Fat, Min_Protein, Phosphore, Potassium, Sod... [VOIR LA REQUÊTE COMPLÈTE]

SELECT ns_product_data.Formula_No, ns_formula_details.Product_Name, ns_product_data.Animal_Type, ns_product_data.Product_Type, Ash, Calcium, Max_Fiber, Min_Fat, Min_Protein, Phosphorus, Potassium, Sodium, Kibble_Size FROM ns_product_data INNER JOIN ns_formula_details ON ns_formula_details.Formula_No = ns_product_data.Formula_No WHERE ns_product_data.Formula_No NOT IN ( SELECT DISTINCT Formula_No FROM ns_product_ingredients AS t1 INNER JOIN ( SELECT Formula_No AS t2_Formula_No, MAX(Cf_Part_No) AS Max_Cf_Part_No FROM ns_product_ingredients GROUP BY Formula_No) AS t2 ON t1.Formula_No = t2_Formula_No AND t1.Cf_Part_No = t2.Max_Cf_Part_No WHERE Ing_Class IN ('Pork', 'Potato', 'Turkey', 'Wheat') ) AND ns_product_data.Animal_Type = 'Dog' AND Grain_Free = 'No' AND ns_product_data.Product_Type = 'Dry' AND ns_product_data.Formula_No NOT LIKE '%FT' AND Ash IS NOT NULL AND Calcium IS NOT NULL AND Max_Fiber IS NOT NULL AND Min_Fat IS NOT NULL AND Min_Protein IS NOT NULL AND Phosphorus IS NOT NULL AND Potassium IS NOT NULL AND Sodium IS NOT NULL AND ns_product_data.Product_Name NOT LIKE '%Tuffy%' GROUP BY Formula_No ORDER BY Product_Name ASC

SÉLECTIONNEZ ns_product_data.Formula_No, ns_formula_details.Product_Name, ns_product_data.Animal_Type, ns_product_data.Product_Type, Cendres, Calcium, Max_Fiber, Min_Fat, Min_Protein, Phosphore, Potassium, Sod... [VOIR LA REQUÊTE COMPLÈTE]

SELECT ns_product_data.Formula_No, ns_formula_details.Product_Name, ns_product_data.Animal_Type, ns_product_data.Product_Type, Ash, Calcium, Max_Fiber, Min_Fat, Min_Protein, Phosphorus, Potassium, Sodium, Kibble_Size FROM ns_product_data INNER JOIN ns_formula_details ON ns_formula_details.Formula_No = ns_product_data.Formula_No WHERE ns_product_data.Formula_No NOT IN ( SELECT DISTINCT Formula_No FROM ns_product_ingredients AS t1 INNER JOIN ( SELECT Formula_No AS t2_Formula_No, MAX(Cf_Part_No) AS Max_Cf_Part_No FROM ns_product_ingredients GROUP BY Formula_No) AS t2 ON t1.Formula_No = t2_Formula_No AND t1.Cf_Part_No = t2.Max_Cf_Part_No WHERE Ing_Class IN ('Pork', 'Potato', 'Turkey', 'Wheat') ) AND ns_product_data.Animal_Type = 'Dog' AND Grain_Free = 'No' AND ns_product_data.Product_Type = 'Dry' AND ns_product_data.Formula_No NOT LIKE '%FT' AND Ash IS NOT NULL AND Calcium IS NOT NULL AND Max_Fiber IS NOT NULL AND Min_Fat IS NOT NULL AND Min_Protein IS NOT NULL AND Phosphorus IS NOT NULL AND Potassium IS NOT NULL AND Sodium IS NOT NULL AND ns_product_data.Product_Name NOT LIKE '%Tuffy%' GROUP BY Formula_No ORDER BY Product_Name ASC

SÉLECTIONNEZ ns_product_data.Formula_No, ns_formula_details.Product_Name, ns_product_data.Animal_Type, ns_product_data.Product_Type, Cendres, Calcium, Max_Fiber, Min_Fat, Min_Protein, Phosphore, Potassium, Sod... [VOIR LA REQUÊTE COMPLÈTE]

SELECT ns_product_data.Formula_No, ns_formula_details.Product_Name, ns_product_data.Animal_Type, ns_product_data.Product_Type, Ash, Calcium, Max_Fiber, Min_Fat, Min_Protein, Phosphorus, Potassium, Sodium, Kibble_Size FROM ns_product_data INNER JOIN ns_formula_details ON ns_formula_details.Formula_No = ns_product_data.Formula_No WHERE ns_product_data.Formula_No NOT IN ( SELECT DISTINCT Formula_No FROM ns_product_ingredients AS t1 INNER JOIN ( SELECT Formula_No AS t2_Formula_No, MAX(Cf_Part_No) AS Max_Cf_Part_No FROM ns_product_ingredients GROUP BY Formula_No) AS t2 ON t1.Formula_No = t2_Formula_No AND t1.Cf_Part_No = t2.Max_Cf_Part_No WHERE Ing_Class IN ('Beef', 'Chickpeas', 'Kangaroo', 'Lettuce', 'Venison') ) AND ns_product_data.Animal_Type = 'Dog' AND Grain_Free = 'Yes' AND ns_product_data.Formula_No NOT LIKE '%FT' AND Ash IS NOT NULL AND Calcium IS NOT NULL AND Max_Fiber IS NOT NULL AND Min_Fat IS NOT NULL AND Min_Protein IS NOT NULL AND Phosphorus IS NOT NULL AND Potassium IS NOT NULL AND Sodium IS NOT NULL AND ns_product_data.Product_Name NOT LIKE '%Tuffy%' GROUP BY Formula_No ORDER BY Product_Name ASC

SÉLECTIONNEZ DISTINCT ns_product_data.Formula_No, Cf_Part_No, ns_formula_details.Product_Name, ns_product_data.Animal_Type, ns_product_data.Product_Type, Cendres, Calcium, Max_Fibres, Min_Matières grasses, Min_Protéines, Phosphate... [VOIR LA REQUÊTE COMPLÈTE]

SÉLECTIONNEZ DISTINCT ns_product_data.Formula_No, Cf_Part_No, ns_formula_details.Product_Name, ns_product_data.Animal_Type, ns_product_data.Product_Type, Cendres, Calcium, Max_Fibres, Min_Matières grasses, Min_Protéines, Phosphore, Potassium, Sodium, Kibble_Size FROM ns_product_data INNER JOIN ns_formula_details ON ns_formula_details.Formula_No = ns_product_data.Formula_No WHERE ns_product_data.Animal_Type = 'Chien' AND Grain_Free = 'Oui' AND Kibble_Size = 'Grande race adulte' AND ns_product_data.Product_Type = 'Sec' AND ns_product_data.Formula_No PAS COMME '%FT' ET Cendres N'EST PAS NULL ET Calcium N'EST PAS NULL ET Max_Fiber N'EST PAS NULL ET Min_Fat N'EST PAS NULL ET Min_Protein N'EST PAS NULL ET Phosphore N'EST PAS NULL ET Potassium N'EST PAS NULL ET Sodium N'EST PAS NULL ET ns_product_data.Product_Name N'AIME PAS '%Tuffy%' ET ns_product_data.Product_Name N'AIME PAS '%Supreme%' GROUP BY Formula_No ORDER BY Product_Name ASC

SÉLECTIONNEZ DISTINCT ns_product_data.Formula_No, Cf_Part_No, ns_formula_details.Product_Name, ns_product_data.Animal_Type, ns_product_data.Product_Type, Cendres, Calcium, Max_Fibres, Min_Matières grasses, Min_Protéines, Phosphate... [VOIR LA REQUÊTE COMPLÈTE]

SÉLECTIONNEZ DISTINCT ns_product_data.Formula_No, Cf_Part_No, ns_formula_details.Product_Name, ns_product_data.Animal_Type, ns_product_data.Product_Type, Ash, Calcium, Max_Fiber, Min_Fat, Min_Protein, Phosphore, Potassium, Sodium, Kibble_Size FROM ns_product_data INNER JOIN ns_formula_details ON ns_formula_details.Formula_No = ns_product_data.Formula_No WHERE ns_product_data.Animal_Type = 'Dog' AND ns_product_data.Formula_No PAS COMME '%FT' ET Ash N'EST PAS NULL ET Calcium N'EST PAS NULL ET Max_Fiber N'EST PAS NULL ET Min_Fat N'EST PAS NULL ET Min_Protein N'EST PAS NULL ET Phosphore N'EST PAS NULL ET Le potassium N'EST PAS NUL ET Le sodium N'EST PAS NUL ET ns_product_data.Product_Name N'EST PAS COMME '%Tuffy%' ET ns_product_data.Product_Name N'EST PAS COMME '%Supreme%' GROUP BY Formula_No ORDER BY Product_Name ASC

SÉLECTIONNEZ DISTINCT ns_product_data.Formula_No, Cf_Part_No, ns_formula_details.Product_Name, ns_product_data.Animal_Type, ns_product_data.Product_Type, Cendres, Calcium, Max_Fibres, Min_Matières grasses, Min_Protéines, Phosphate... [VOIR LA REQUÊTE COMPLÈTE]

SÉLECTIONNEZ DISTINCT ns_product_data.Formula_No, Cf_Part_No, ns_formula_details.Product_Name, ns_product_data.Animal_Type, ns_product_data.Product_Type, Ash, Calcium, Max_Fiber, Min_Fat, Min_Protein, Phosphore, Potassium, Sodium, Kibble_Size FROM ns_product_data INNER JOIN ns_formula_details ON ns_formula_details.Formula_No = ns_product_data.Formula_No WHERE ns_product_data.Animal_Type = 'Dog' AND Grain_Free = 'No' AND ns_product_data.Product_Type = 'Dry' AND ns_product_data.Formula_No PAS COMME '%FT' ET Ash N'EST PAS NULL ET Calcium N'EST PAS NULL ET Max_Fiber N'EST PAS NULL ET Min_Fat N'EST PAS NULL ET Min_Protein N'EST PAS NULL ET Phosphore N'EST PAS NULL ET Potassium N'EST PAS NULL ET Sodium N'EST PAS NULL ET ns_product_data.Product_Name N'EST PAS NULL ET ns_product_data.Product_Name N'EST PAS NULL ET ns_product_data.Product_Name N'EST PAS NULL ET ns_product_data.Product_Name N'EST PAS NULL ET GROUP BY Formula_No ORDER BY Product_Name ASC

SÉLECTIONNEZ DISTINCT ns_product_data.Formula_No, Cf_Part_No, ns_formula_details.Product_Name, ns_product_data.Animal_Type, ns_product_data.Product_Type, Cendres, Calcium, Max_Fibres, Min_Matières grasses, Min_Protéines, Phosphate... [VOIR LA REQUÊTE COMPLÈTE]

SELECT DISTINCT ns_product_data.Formula_No, Cf_Part_No, ns_formula_details.Product_Name, ns_product_data.Animal_Type, ns_product_data.Product_Type, Ash, Calcium, Max_Fiber, Min_Fat, Min_Protein, Phosphorus, Potassium, Sodium, Kibble_Size FROM ns_product_data INNER JOIN ns_formula_details ON ns _formula_details.Formula_No = ns_product_data.Formula_No OÙ ns_product_data.Animal_Type = 'Dog' ET Grain_Free = 'Yes' ET Kibble_Size = 'Senior' ET ns_product_data.Product_Type = 'Dry' ET ns_product_data.Formula_No PAS COMME '%FT' ET Ash N'EST PAS NULL ET Le calcium n'est pas NULL ET Max_Fiber EST NON NULL ET Min_Fat n'est pas NULL ET Min_Protein n'est pas NULL ET le phosphore n'est pas NULL ET le potassium n'est pas NULL ET le sodium n'est pas NULL ET ns_product_data.Product_Name PAS COMME '%Tuffy%' ET ns_product_data.Product_Name PAS COMME '%Supreme%' GROUP BY Formula_No ORDER BY Nom_produit ASC

SÉLECTIONNEZ DISTINCT ns_product_data.Formula_No, Cf_Part_No, ns_formula_details.Product_Name, ns_product_data.Animal_Type, ns_product_data.Product_Type, Cendres, Calcium, Max_Fibres, Min_Matières grasses, Min_Protéines, Phosphate... [VOIR LA REQUÊTE COMPLÈTE]

SÉLECTIONNEZ DISTINCT ns_product_data.Formula_No, Cf_Part_No, ns_formula_details.Product_Name, ns_product_data.Animal_Type, ns_product_data.Product_Type, Ash, Calcium, Max_Fiber, Min_Fat, Min_Protein, Phosphore, Potassium, Sodium, Kibble_Size FROM ns_product_data INNER JOIN ns_formula_details ON ns_formula_details.Formula_No = ns_product_data.Formula_No WHERE ns_product_data.Animal_Type = 'Dog' AND ns_product_data.Product_Type = 'Dry' AND ns_product_data.Formula_No PAS COMME '%FT' ET Ash N'EST PAS NULL ET Calcium N'EST PAS NULL ET Max_Fiber N'EST PAS NULL ET Min_Fat N'EST PAS NULL ET Min_Protein N'EST PAS NULL ET Phosphore N'EST PAS NULL ET Potassium N'EST PAS NULL ET Sodium N'EST PAS NULL ET ns_product_data.Product_Name N'EST PAS COMME '%Tuffy%' ET ns_product_data.Product_Name N'EST PAS COMME '%Supreme%' GROUP BY Formula_No ORDER BY Product_Name ASC

SÉLECTIONNEZ DISTINCT ns_product_data.Formula_No, Cf_Part_No, ns_formula_details.Product_Name, ns_product_data.Animal_Type, ns_product_data.Product_Type, Cendres, Calcium, Max_Fibres, Min_Matières grasses, Min_Protéines, Phosphate... [VOIR LA REQUÊTE COMPLÈTE]

SÉLECTIONNEZ DISTINCT ns_product_data.Formula_No, Cf_Part_No, ns_formula_details.Product_Name, ns_product_data.Animal_Type, ns_product_data.Product_Type, Ash, Calcium, Max_Fiber, Min_Fat, Min_Protein, Phosphore, Potassium, Sodium, Kibble_Size FROM ns_product_data INNER JOIN ns_formula_details ON ns_formula_details.Formula_No = ns_product_data.Formula_No WHERE ns_product_data.Product_Type = 'Cans' AND ns_product_data.Formula_No PAS COMME '%FT' ET Ash N'EST PAS NULL ET Calcium N'EST PAS NULL ET Max_Fiber N'EST PAS NULL ET Min_Fat N'EST PAS NULL ET Min_Protein N'EST PAS NULL ET Phosphore N'EST PAS NULL ET Potassium N'EST PAS NULL ET Sodium N'EST PAS NULL ET ns_product_data.Product_Name N'EST PAS COMME '%Tuffy%' ET ns_product_data.Product_Name N'EST PAS COMME '%Supreme%' GROUP BY Formula_No ORDER BY Product_Name ASC

SÉLECTIONNEZ ns_product_data.Formula_No, ns_formula_details.Product_Name, ns_product_data.Animal_Type, ns_product_data.Product_Type, Cendres, Calcium, Max_Fiber, Min_Fat, Min_Protein, Phosphore, Potassium, Sod... [VOIR LA REQUÊTE COMPLÈTE]

SELECT ns_product_data.Formula_No, ns_formula_details.Product_Name, ns_product_data.Animal_Type, ns_product_data.Product_Type, Ash, Calcium, Max_Fiber, Min_Fat, Min_Protein, Phosphorus, Potassium, Sodium, Kibble_Size FROM ns_product_data INNER JOIN ns_formula_details ON ns_formula_details.Formula_No = ns_product_data.Formula_No WHERE ns_product_data.Formula_No NOT IN ( SELECT DISTINCT Formula_No FROM ns_product_ingredients AS t1 INNER JOIN ( SELECT Formula_No AS t2_Formula_No, MAX(Cf_Part_No) AS Max_Cf_Part_No FROM ns_product_ingredients GROUP BY Formula_No) AS t2 ON t1.Formula_No = t2_Formula_No AND t1.Cf_Part_No = t2.Max_Cf_Part_No WHERE Ing_Class IN ('Beef', 'Bison', 'Blueberries', 'Chicken', 'Duck', 'Egg', 'Haddock', 'Herring', 'Kangaroo', 'Lamb', 'Lentils', 'Quail', 'Rabbit', 'Salmon', 'Sunflower', 'Sweet Potato', 'Trout', 'Tuna', 'Turkey', 'Venison') ) AND ns_product_data.Animal_Type = 'Dog' AND Grain_Free = 'No' AND ns_product_data.Product_Type = 'Dry' AND ns_product_data.Formula_No NOT LIKE '%FT' AND Ash IS NOT NULL AND Calcium IS NOT NULL AND Max_Fiber IS NOT NULL AND Min_Fat IS NOT NULL AND Min_Protein IS NOT NULL AND Phosphorus IS NOT NULL AND Potassium IS NOT NULL AND Sodium IS NOT NULL AND ns_product_data.Product_Name NOT LIKE '%Tuffy%' GROUP BY Formula_No ORDER BY Product_Name ASC

SÉLECTIONNEZ DISTINCT ns_product_data.Formula_No, Cf_Part_No, ns_formula_details.Product_Name, ns_product_data.Animal_Type, ns_product_data.Product_Type, Cendres, Calcium, Max_Fibres, Min_Matières grasses, Min_Protéines, Phosphate... [VOIR LA REQUÊTE COMPLÈTE]

SELECT DISTINCT ns_product_data.Formula_No, Cf_Part_No, ns_formula_details.Product_Name, ns_product_data.Animal_Type, ns_product_data.Product_Type, Ash, Calcium, Max_Fiber, Min_Fat, Min_Protein, Phosphorus, Potassium, Sodium, Kibble_Size FROM ns_product_data INNER JOIN ns_formula_details ON ns_ formula_details.Formula_No = ns_product_data.Formula_No OÙ ns_product_data.Animal_Type = 'Cat' ET Grain_Free = 'Yes' ET ns_product_data.Formula_No PAS COMME '%FT' ET Ash N'EST PAS NULL ET Calcium N'EST PAS NULL ET Max_Fiber N'EST PAS NULL ET Min_Fat N'EST PAS NULL ET Min_Protein N'EST PAS NULL ET Phosphorus N'EST PAS NULL ET Le potassium n'est pas NULL ET Le sodium n'est pas NULL ET ns_product_data.Product_Name PAS COMME '%Tuffy%' ET ns_product_data.Product_Name PAS COMME '%Supreme%' GROUP BY Formula_No ORDER BY Product_Name ASC

SÉLECTIONNEZ DISTINCT ns_product_data.Formula_No, Cf_Part_No, ns_formula_details.Product_Name, ns_product_data.Animal_Type, ns_product_data.Product_Type, Cendres, Calcium, Max_Fibres, Min_Matières grasses, Min_Protéines, Phosphate... [VOIR LA REQUÊTE COMPLÈTE]

SÉLECTIONNEZ DISTINCT ns_product_data.Formula_No, Cf_Part_No, ns_formula_details.Product_Name, ns_product_data.Animal_Type, ns_product_data.Product_Type, Ash, Calcium, Max_Fiber, Min_Fat, Min_Protein, Phosphore, Potassium, Sodium, Kibble_Size FROM ns_product_data INNER JOIN ns_formula_details ON ns_formula_details.Formula_No = ns_product_data.Formula_No WHERE ns_product_data.Animal_Type = 'Cat' AND ns_product_data.Product_Type = 'Dry' AND ns_product_data.Formula_No PAS COMME '%FT' ET Ash N'EST PAS NULL ET Calcium N'EST PAS NULL ET Max_Fiber N'EST PAS NULL ET Min_Fat N'EST PAS NULL ET Min_Protein N'EST PAS NULL ET Phosphore N'EST PAS NULL ET Potassium N'EST PAS NULL ET Sodium N'EST PAS NULL ET ns_product_data.Product_Name N'EST PAS COMME '%Tuffy%' ET ns_product_data.Product_Name N'EST PAS COMME '%Supreme%' GROUP BY Formula_No ORDER BY Product_Name ASC

SÉLECTIONNEZ ns_product_data.Formula_No, ns_formula_details.Product_Name, ns_product_data.Animal_Type, ns_product_data.Product_Type, Cendres, Calcium, Max_Fiber, Min_Fat, Min_Protein, Phosphore, Potassium, Sod... [VOIR LA REQUÊTE COMPLÈTE]

SELECT ns_product_data.Formula_No, ns_formula_details.Product_Name, ns_product_data.Animal_Type, ns_product_data.Product_Type, Ash, Calcium, Max_Fiber, Min_Fat, Min_Protein, Phosphorus, Potassium, Sodium, Kibble_Size FROM ns_product_data INNER JOIN ns_formula_details ON ns_formula_details.Formula_No = ns_product_data.Formula_No WHERE ns_product_data.Formula_No NOT IN ( SELECT DISTINCT Formula_No FROM ns_product_ingredients AS t1 INNER JOIN ( SELECT Formula_No AS t2_Formula_No, MAX(Cf_Part_No) AS Max_Cf_Part_No FROM ns_product_ingredients GROUP BY Formula_No) AS t2 ON t1.Formula_No = t2_Formula_No AND t1.Cf_Part_No = t2.Max_Cf_Part_No WHERE Ing_Class IN ('Chicken', 'Turkey') ) AND ns_product_data.Animal_Type = 'Dog' AND ns_product_data.Product_Type = 'Dry' AND ns_product_data.Formula_No NOT LIKE '%FT' AND Ash IS NOT NULL AND Calcium IS NOT NULL AND Max_Fiber IS NOT NULL AND Min_Fat IS NOT NULL AND Min_Protein IS NOT NULL AND Phosphorus IS NOT NULL AND Potassium IS NOT NULL AND Sodium IS NOT NULL AND ns_product_data.Product_Name NOT LIKE '%Tuffy%' GROUP BY Formula_No ORDER BY Product_Name ASC

SÉLECTIONNEZ DISTINCT ns_product_data.Formula_No, Cf_Part_No, ns_formula_details.Product_Name, ns_product_data.Animal_Type, ns_product_data.Product_Type, Cendres, Calcium, Max_Fibres, Min_Matières grasses, Min_Protéines, Phosphate... [VOIR LA REQUÊTE COMPLÈTE]

SÉLECTIONNEZ DISTINCT ns_product_data.Formula_No, Cf_Part_No, ns_formula_details.Product_Name, ns_product_data.Animal_Type, ns_product_data.Product_Type, Ash, Calcium, Max_Fiber, Min_Fat, Min_Protein, Phosphore, Potassium, Sodium, Kibble_Size FROM ns_product_data INNER JOIN ns_formula_details ON ns_formula_details.Formula_No = ns_product_data.Formula_No WHERE ns_product_data.Animal_Type = 'Dog' AND Kibble_Size = 'Small Bites' AND ns_product_data.Product_Type = 'Dry' AND ns_product_data.Formula_No PAS COMME '%FT' ET Ash N'EST PAS NULL ET Calcium N'EST PAS NULL ET Max_Fiber N'EST PAS NULL ET Min_Fat N'EST PAS NULL ET Min_Protein N'EST PAS NULL ET Phosphore N'EST PAS NULL ET Potassium N'EST PAS NULL ET Sodium N'EST PAS NULL ET ns_product_data.Product_Name NE SEMBLE PAS À '%Tuffy%' ET ns_product_data.Product_Name NE SEMBLE PAS À '%Supreme%' GROUP BY Formula_No ORDER BY Product_Name ASC

SÉLECTIONNEZ ns_product_data.Formula_No, ns_formula_details.Product_Name, ns_product_data.Animal_Type, ns_product_data.Product_Type, Cendres, Calcium, Max_Fiber, Min_Fat, Min_Protein, Phosphore, Potassium, Sod... [VOIR LA REQUÊTE COMPLÈTE]

SELECT ns_product_data.Formula_No, ns_formula_details.Product_Name, ns_product_data.Animal_Type, ns_product_data.Product_Type, Ash, Calcium, Max_Fiber, Min_Fat, Min_Protein, Phosphorus, Potassium, Sodium, Kibble_Size FROM ns_product_data INNER JOIN ns_formula_details ON ns_formula_details.Formula_No = ns_product_data.Formula_No WHERE ns_product_data.Formula_No NOT IN ( SELECT DISTINCT Formula_No FROM ns_product_ingredients AS t1 INNER JOIN ( SELECT Formula_No AS t2_Formula_No, MAX(Cf_Part_No) AS Max_Cf_Part_No FROM ns_product_ingredients GROUP BY Formula_No) AS t2 ON t1.Formula_No = t2_Formula_No AND t1.Cf_Part_No = t2.Max_Cf_Part_No WHERE Ing_Class IN ('Chicken', 'Duck', 'Turkey') ) AND ns_product_data.Animal_Type = 'Dog' AND ns_product_data.Product_Type = 'Dry' AND ns_product_data.Formula_No NOT LIKE '%FT' AND Ash IS NOT NULL AND Calcium IS NOT NULL AND Max_Fiber IS NOT NULL AND Min_Fat IS NOT NULL AND Min_Protein IS NOT NULL AND Phosphorus IS NOT NULL AND Potassium IS NOT NULL AND Sodium IS NOT NULL AND ns_product_data.Product_Name NOT LIKE '%Tuffy%' GROUP BY Formula_No ORDER BY Product_Name ASC

SÉLECTIONNEZ DISTINCT ns_product_data.Formula_No, Cf_Part_No, ns_formula_details.Product_Name, ns_product_data.Animal_Type, ns_product_data.Product_Type, Cendres, Calcium, Max_Fibres, Min_Matières grasses, Min_Protéines, Phosphate... [VOIR LA REQUÊTE COMPLÈTE]

SÉLECTIONNEZ DISTINCT ns_product_data.Formula_No, Cf_Part_No, ns_formula_details.Product_Name, ns_product_data.Animal_Type, ns_product_data.Product_Type, Ash, Calcium, Max_Fiber, Min_Fat, Min_Protein, Phosphore, Potassium, Sodium, Kibble_Size FROM ns_product_data INNER JOIN ns_formula_details ON ns_formula_details.Formula_No = ns_product_data.Formula_No WHERE ns_product_data.Animal_Type = 'Dog' AND Grain_Free = 'No' AND ns_product_data.Product_Type = 'Dry' AND ns_product_data.Formula_No PAS COMME '%FT' ET Ash N'EST PAS NULL ET Calcium N'EST PAS NULL ET Max_Fiber N'EST PAS NULL ET Min_Fat N'EST PAS NULL ET Min_Protein N'EST PAS NULL ET Phosphore N'EST PAS NULL ET Potassium N'EST PAS NULL ET Sodium N'EST PAS NULL ET ns_product_data.Product_Name N'EST PAS NULL ET ns_product_data.Product_Name N'EST PAS NULL ET ns_product_data.Product_Name N'EST PAS NULL ET ns_product_data.Product_Name N'EST PAS NULL ET GROUP BY Formula_No ORDER BY Product_Name ASC

SÉLECTIONNEZ DISTINCT ns_product_data.Formula_No, Cf_Part_No, ns_formula_details.Product_Name, ns_product_data.Animal_Type, ns_product_data.Product_Type, Cendres, Calcium, Max_Fibres, Min_Matières grasses, Min_Protéines, Phosphate... [VOIR LA REQUÊTE COMPLÈTE]

SÉLECTIONNEZ DISTINCT ns_product_data.Formula_No, Cf_Part_No, ns_formula_details.Product_Name, ns_product_data.Animal_Type, ns_product_data.Product_Type, Ash, Calcium, Max_Fiber, Min_Fat, Min_Protein, Phosphore, Potassium, Sodium, Kibble_Size FROM ns_product_data INNER JOIN ns_formula_details ON ns_formula_details.Formula_No = ns_product_data.Formula_No WHERE ns_product_data.Animal_Type = 'Dog' AND Grain_Free = 'No' AND Kibble_Size = 'Senior' AND ns_product_data.Product_Type = 'Dry' AND ns_product_data.Formula_No PAS COMME '%FT' ET Ash N'EST PAS NULL ET Calcium N'EST PAS NULL ET Max_Fiber N'EST PAS NULL ET Min_Fat N'EST PAS NULL ET Min_Protein N'EST PAS NULL ET Phosphore N'EST PAS NULL ET Potassium N'EST PAS NULL ET Sodium N'EST PAS NULL ET ns_product_data.Product_Name N'EST PAS COMME '%Tuffy%' ET ns_product_data.Product_Name N'EST PAS COMME '%Supreme%' GROUP BY Formula_No ORDER BY Product_Name ASC

SÉLECTIONNEZ DISTINCT ns_product_data.Formula_No, Cf_Part_No, ns_formula_details.Product_Name, ns_product_data.Animal_Type, ns_product_data.Product_Type, Cendres, Calcium, Max_Fibres, Min_Matières grasses, Min_Protéines, Phosphate... [VOIR LA REQUÊTE COMPLÈTE]

SÉLECTIONNEZ DISTINCT ns_product_data.Formula_No, Cf_Part_No, ns_formula_details.Product_Name, ns_product_data.Animal_Type, ns_product_data.Product_Type, Ash, Calcium, Max_Fiber, Min_Fat, Min_Protein, Phosphore, Potassium, Sodium, Kibble_Size FROM ns_product_data INNER JOIN ns_formula_details ON ns_formula_details.Formula_No = ns_product_data.Formula_No WHERE ns_product_data.Animal_Type = 'Dog' AND Grain_Free = 'No' AND Kibble_Size = 'Senior' AND ns_product_data.Product_Type = 'Dry' AND ns_product_data.Formula_No PAS COMME '%FT' ET Ash N'EST PAS NULL ET Calcium N'EST PAS NULL ET Max_Fiber N'EST PAS NULL ET Min_Fat N'EST PAS NULL ET Min_Protein N'EST PAS NULL ET Phosphore N'EST PAS NULL ET Potassium N'EST PAS NULL ET Sodium N'EST PAS NULL ET ns_product_data.Product_Name N'EST PAS COMME '%Tuffy%' ET ns_product_data.Product_Name N'EST PAS COMME '%Supreme%' GROUP BY Formula_No ORDER BY Product_Name ASC

SÉLECTIONNEZ DISTINCT ns_product_data.Formula_No, Cf_Part_No, ns_formula_details.Product_Name, ns_product_data.Animal_Type, ns_product_data.Product_Type, Cendres, Calcium, Max_Fibres, Min_Matières grasses, Min_Protéines, Phosphate... [VOIR LA REQUÊTE COMPLÈTE]

SÉLECTIONNEZ DISTINCT ns_product_data.Formula_No, Cf_Part_No, ns_formula_details.Product_Name, ns_product_data.Animal_Type, ns_product_data.Product_Type, Ash, Calcium, Max_Fiber, Min_Fat, Min_Protein, Phosphore, Potassium, Sodium, Kibble_Size FROM ns_product_data INNER JOIN ns_formula_details ON ns_formula_details.Formula_No = ns_product_data.Formula_No WHERE ns_product_data.Animal_Type = 'Dog' AND Grain_Free = 'No' AND Kibble_Size = 'Senior' AND ns_product_data.Product_Type = 'Dry' AND ns_product_data.Formula_No PAS COMME '%FT' ET Ash N'EST PAS NULL ET Calcium N'EST PAS NULL ET Max_Fiber N'EST PAS NULL ET Min_Fat N'EST PAS NULL ET Min_Protein N'EST PAS NULL ET Phosphore N'EST PAS NULL ET Potassium N'EST PAS NULL ET Sodium N'EST PAS NULL ET ns_product_data.Product_Name N'EST PAS COMME '%Tuffy%' ET ns_product_data.Product_Name N'EST PAS COMME '%Supreme%' GROUP BY Formula_No ORDER BY Product_Name ASC

SÉLECTIONNEZ DISTINCT ns_product_data.Formula_No, Cf_Part_No, ns_formula_details.Product_Name, ns_product_data.Animal_Type, ns_product_data.Product_Type, Cendres, Calcium, Max_Fibres, Min_Matières grasses, Min_Protéines, Phosphate... [VOIR LA REQUÊTE COMPLÈTE]

SELECT DISTINCT ns_product_data.Formula_No, Cf_Part_No, ns_formula_details.Product_Name, ns_product_data.Animal_Type, ns_product_data.Product_Type, Ash, Calcium, Max_Fiber, Min_Fat, Min_Protein, Phosphorus, Potassium, Sodium, Kibble_Size FROM ns_product_data INNER JOIN ns_formula_details ON ns _formula_details.Formula_No = ns_product_data.Formula_No OÙ ns_product_data.Animal_Type = 'Dog' ET Grain_Free = 'Yes' ET Kibble_Size = 'Senior' ET ns_product_data.Product_Type = 'Dry' ET ns_product_data.Formula_No PAS COMME '%FT' ET Ash N'EST PAS NULL ET Le calcium n'est pas NULL ET Max_Fiber EST NON NULL ET Min_Fat n'est pas NULL ET Min_Protein n'est pas NULL ET le phosphore n'est pas NULL ET le potassium n'est pas NULL ET le sodium n'est pas NULL ET ns_product_data.Product_Name PAS COMME '%Tuffy%' ET ns_product_data.Product_Name PAS COMME '%Supreme%' GROUP BY Formula_No ORDER BY Nom_produit ASC

SÉLECTIONNEZ ns_product_data.Formula_No, ns_formula_details.Product_Name, ns_product_data.Animal_Type, ns_product_data.Product_Type, Cendres, Calcium, Max_Fiber, Min_Fat, Min_Protein, Phosphore, Potassium, Sod... [VOIR LA REQUÊTE COMPLÈTE]

SELECT ns_product_data.Formula_No, ns_formula_details.Product_Name, ns_product_data.Animal_Type, ns_product_data.Product_Type, Ash, Calcium, Max_Fiber, Min_Fat, Min_Protein, Phosphorus, Potassium, Sodium, Kibble_Size FROM ns_product_data INNER JOIN ns_formula_details ON ns_formula_details.Formula_No = ns_product_data.Formula_No WHERE ns_product_data.Formula_No NOT IN ( SELECT DISTINCT Formula_No FROM ns_product_ingredients AS t1 INNER JOIN ( SELECT Formula_No AS t2_Formula_No, MAX(Cf_Part_No) AS Max_Cf_Part_No FROM ns_product_ingredients GROUP BY Formula_No) AS t2 ON t1.Formula_No = t2_Formula_No AND t1.Cf_Part_No = t2.Max_Cf_Part_No WHERE Ing_Class IN ('Barley', 'Buckwheat', 'Canola Oil', 'Chicken', 'Corn', 'Oatmeal', 'Soy') ) AND ns_product_data.Animal_Type = 'Dog' AND Grain_Free = 'Yes' AND ns_product_data.Product_Type = 'Dry' AND ns_product_data.Formula_No NOT LIKE '%FT' AND Ash IS NOT NULL AND Calcium IS NOT NULL AND Max_Fiber IS NOT NULL AND Min_Fat IS NOT NULL AND Min_Protein IS NOT NULL AND Phosphorus IS NOT NULL AND Potassium IS NOT NULL AND Sodium IS NOT NULL AND ns_product_data.Product_Name NOT LIKE '%Tuffy%' GROUP BY Formula_No ORDER BY Product_Name ASC

SÉLECTIONNEZ ns_product_data.Formula_No, ns_formula_details.Product_Name, ns_product_data.Animal_Type, ns_product_data.Product_Type, Cendres, Calcium, Max_Fiber, Min_Fat, Min_Protein, Phosphore, Potassium, Sod... [VOIR LA REQUÊTE COMPLÈTE]

SELECT ns_product_data.Formula_No, ns_formula_details.Product_Name, ns_product_data.Animal_Type, ns_product_data.Product_Type, Ash, Calcium, Max_Fiber, Min_Fat, Min_Protein, Phosphorus, Potassium, Sodium, Kibble_Size FROM ns_product_data INNER JOIN ns_formula_details ON ns_formula_details.Formula_No = ns_product_data.Formula_No WHERE ns_product_data.Formula_No NOT IN ( SELECT DISTINCT Formula_No FROM ns_product_ingredients AS t1 INNER JOIN ( SELECT Formula_No AS t2_Formula_No, MAX(Cf_Part_No) AS Max_Cf_Part_No FROM ns_product_ingredients GROUP BY Formula_No) AS t2 ON t1.Formula_No = t2_Formula_No AND t1.Cf_Part_No = t2.Max_Cf_Part_No WHERE Ing_Class IN ('Barley', 'Buckwheat', 'Canola Oil', 'Chicken', 'Corn', 'Oatmeal', 'Soy') ) AND ns_product_data.Animal_Type = 'Dog' AND Grain_Free = 'Yes' AND ns_product_data.Product_Type = 'Dry' AND ns_product_data.Formula_No NOT LIKE '%FT' AND Ash IS NOT NULL AND Calcium IS NOT NULL AND Max_Fiber IS NOT NULL AND Min_Fat IS NOT NULL AND Min_Protein IS NOT NULL AND Phosphorus IS NOT NULL AND Potassium IS NOT NULL AND Sodium IS NOT NULL AND ns_product_data.Product_Name NOT LIKE '%Tuffy%' GROUP BY Formula_No ORDER BY Product_Name ASC

SÉLECTIONNEZ ns_product_data.Formula_No, ns_formula_details.Product_Name, ns_product_data.Animal_Type, ns_product_data.Product_Type, Cendres, Calcium, Max_Fiber, Min_Fat, Min_Protein, Phosphore, Potassium, Sod... [VOIR LA REQUÊTE COMPLÈTE]

SELECT ns_product_data.Formula_No, ns_formula_details.Product_Name, ns_product_data.Animal_Type, ns_product_data.Product_Type, Ash, Calcium, Max_Fiber, Min_Fat, Min_Protein, Phosphorus, Potassium, Sodium, Kibble_Size FROM ns_product_data INNER JOIN ns_formula_details ON ns_formula_details.Formula_No = ns_product_data.Formula_No WHERE ns_product_data.Formula_No NOT IN ( SELECT DISTINCT Formula_No FROM ns_product_ingredients AS t1 INNER JOIN ( SELECT Formula_No AS t2_Formula_No, MAX(Cf_Part_No) AS Max_Cf_Part_No FROM ns_product_ingredients GROUP BY Formula_No) AS t2 ON t1.Formula_No = t2_Formula_No AND t1.Cf_Part_No = t2.Max_Cf_Part_No WHERE Ing_Class IN ('Beef', 'Bison', 'Blueberries', 'Chicken', 'Duck', 'Egg', 'Haddock', 'Herring', 'Kangaroo', 'Lamb', 'Lentils', 'Quail', 'Rabbit', 'Salmon', 'Sunflower', 'Sweet Potato', 'Trout', 'Tuna', 'Turkey', 'Venison') ) AND ns_product_data.Animal_Type = 'Dog' AND Grain_Free = 'No' AND ns_product_data.Product_Type = 'Dry' AND ns_product_data.Formula_No NOT LIKE '%FT' AND Ash IS NOT NULL AND Calcium IS NOT NULL AND Max_Fiber IS NOT NULL AND Min_Fat IS NOT NULL AND Min_Protein IS NOT NULL AND Phosphorus IS NOT NULL AND Potassium IS NOT NULL AND Sodium IS NOT NULL AND ns_product_data.Product_Name NOT LIKE '%Tuffy%' GROUP BY Formula_No ORDER BY Product_Name ASC

SÉLECTIONNEZ DISTINCT ns_product_data.Formula_No, Cf_Part_No, ns_formula_details.Product_Name, ns_product_data.Animal_Type, ns_product_data.Product_Type, Cendres, Calcium, Max_Fibres, Min_Matières grasses, Min_Protéines, Phosphate... [VOIR LA REQUÊTE COMPLÈTE]

SÉLECTIONNEZ DISTINCT ns_product_data.Formula_No, Cf_Part_No, ns_formula_details.Product_Name, ns_product_data.Animal_Type, ns_product_data.Product_Type, Ash, Calcium, Max_Fiber, Min_Fat, Min_Protein, Phosphore, Potassium, Sodium, Kibble_Size FROM ns_product_data INNER JOIN ns_formula_details ON ns_formula_details.Formula_No = ns_product_data.Formula_No WHERE ns_product_data.Animal_Type = 'Dog' AND ns_product_data.Product_Type = 'Dry' AND ns_product_data.Formula_No PAS COMME '%FT' ET Ash N'EST PAS NULL ET Calcium N'EST PAS NULL ET Max_Fiber N'EST PAS NULL ET Min_Fat N'EST PAS NULL ET Min_Protein N'EST PAS NULL ET Phosphore N'EST PAS NULL ET Potassium N'EST PAS NULL ET Sodium N'EST PAS NULL ET ns_product_data.Product_Name N'EST PAS COMME '%Tuffy%' ET ns_product_data.Product_Name N'EST PAS COMME '%Supreme%' GROUP BY Formula_No ORDER BY Product_Name ASC

SÉLECTIONNEZ DISTINCT ns_product_data.Formula_No, Cf_Part_No, ns_formula_details.Product_Name, ns_product_data.Animal_Type, ns_product_data.Product_Type, Cendres, Calcium, Max_Fibres, Min_Matières grasses, Min_Protéines, Phosphate... [VOIR LA REQUÊTE COMPLÈTE]

SELECT DISTINCT ns_product_data.Formula_No, Cf_Part_No, ns_formula_details.Product_Name, ns_product_data.Animal_Type, ns_product_data.Product_Type, Ash, Calcium, Max_Fiber, Min_Fat, Min_Protein, Phosphorus, Potassium, Sodium, Kibble_Size FROM ns_product_data INNER JOIN ns_formula_details ON ns_ formula_details.Formula_No = ns_product_data.Formula_No OÙ ns_product_data.Animal_Type = 'Dog' ET Grain_Free = 'Yes' ET Kibble_Size = 'Element' ET ns_product_data.Product_Type = 'Dry' ET ns_product_data.Formula_No PAS COMME '%FT' ET Ash N'EST PAS NULL ET Le calcium n'est pas NULL ET Max_Fiber EST NON NULL ET Min_Fat n'est pas NULL ET Min_Protein n'est pas NULL ET le phosphore n'est pas NULL ET le potassium n'est pas NULL ET le sodium n'est pas NULL ET ns_product_data.Product_Name PAS COMME '%Tuffy%' ET ns_product_data.Product_Name PAS COMME '%Supreme%' GROUP BY Formula_No ORDER BY Nom_produit ASC

SÉLECTIONNEZ DISTINCT ns_product_data.Formula_No, Cf_Part_No, ns_formula_details.Product_Name, ns_product_data.Animal_Type, ns_product_data.Product_Type, Cendres, Calcium, Max_Fibres, Min_Matières grasses, Min_Protéines, Phosphate... [VOIR LA REQUÊTE COMPLÈTE]

SELECT DISTINCT ns_product_data.Formula_No, Cf_Part_No, ns_formula_details.Product_Name, ns_product_data.Animal_Type, ns_product_data.Product_Type, Ash, Calcium, Max_Fiber, Min_Fat, Min_Protein, Phosphorus, Potassium, Sodium, Kibble_Size FROM ns_product_data INNER JOIN ns_formula_details ON ns _formula_details.Formula_No = ns_product_data.Formula_No OÙ ns_product_data.Animal_Type = 'Dog' ET Grain_Free = 'Yes' ET Kibble_Size = 'Senior' ET ns_product_data.Product_Type = 'Dry' ET ns_product_data.Formula_No PAS COMME '%FT' ET Ash N'EST PAS NULL ET Le calcium n'est pas NULL ET Max_Fiber EST NON NULL ET Min_Fat n'est pas NULL ET Min_Protein n'est pas NULL ET le phosphore n'est pas NULL ET le potassium n'est pas NULL ET le sodium n'est pas NULL ET ns_product_data.Product_Name PAS COMME '%Tuffy%' ET ns_product_data.Product_Name PAS COMME '%Supreme%' GROUP BY Formula_No ORDER BY Nom_produit ASC

SÉLECTIONNEZ DISTINCT ns_product_data.Formula_No, Cf_Part_No, ns_formula_details.Product_Name, ns_product_data.Animal_Type, ns_product_data.Product_Type, Cendres, Calcium, Max_Fibres, Min_Matières grasses, Min_Protéines, Phosphate... [VOIR LA REQUÊTE COMPLÈTE]

SÉLECTIONNEZ DISTINCT ns_product_data.Formula_No, Cf_Part_No, ns_formula_details.Product_Name, ns_product_data.Animal_Type, ns_product_data.Product_Type, Cendres, Calcium, Max_Fibres, Min_Matières grasses, Min_Protéines, Phosphore, Potassium, Sodium, Kibble_Size FROM ns_product_data INNER JOIN ns_formula_details ON ns_formula_details.Formula_No = ns_product_data.Formula_No WHERE ns_product_data.Animal_Type = 'Chien' AND Grain_Free = 'Oui' AND Kibble_Size = 'Adulte standard' AND ns_product_data.Product_Type = 'Sec' AND ns_product_data.Formula_No PAS COMME '%FT' ET Cendres N'EST PAS NULL ET Calcium N'EST PAS NULL ET Max_Fiber N'EST PAS NULL ET Min_Fat N'EST PAS NULL ET Min_Protein N'EST PAS NULL ET Phosphore N'EST PAS NULL ET Potassium N'EST PAS NULL ET Sodium N'EST PAS NULL ET ns_product_data.Product_Name N'AIME PAS '%Tuffy%' ET ns_product_data.Product_Name N'AIME PAS '%Supreme%' GROUP BY Formula_No ORDER BY Product_Name ASC

SÉLECTIONNEZ DISTINCT ns_product_data.Formula_No, Cf_Part_No, ns_formula_details.Product_Name, ns_product_data.Animal_Type, ns_product_data.Product_Type, Cendres, Calcium, Max_Fibres, Min_Matières grasses, Min_Protéines, Phosphate... [VOIR LA REQUÊTE COMPLÈTE]

SÉLECTIONNEZ DISTINCT ns_product_data.Formula_No, Cf_Part_No, ns_formula_details.Product_Name, ns_product_data.Animal_Type, ns_product_data.Product_Type, Ash, Calcium, Max_Fiber, Min_Fat, Min_Protein, Phosphore, Potassium, Sodium, Kibble_Size FROM ns_product_data INNER JOIN ns_formula_details ON ns_formula_details.Formula_No = ns_product_data.Formula_No WHERE ns_product_data.Animal_Type = 'Dog' AND Grain_Free = 'No' AND Kibble_Size = 'Small Bites' AND ns_product_data.Product_Type = 'Dry' AND ns_product_data.Formula_No PAS COMME '%FT' ET Ash N'EST PAS NULL ET Calcium N'EST PAS NULL ET Max_Fiber N'EST PAS NULL ET Min_Fat N'EST PAS NULL ET Min_Protein N'EST PAS NULL ET Phosphore N'EST PAS NULL ET Potassium N'EST PAS NULL ET Sodium N'EST PAS NULL ET ns_product_data.Product_Name NE SEMBLE PAS À '%Tuffy%' ET ns_product_data.Product_Name NE SEMBLE PAS À '%Supreme%' GROUP BY Formula_No ORDER BY Product_Name ASC

SÉLECTIONNEZ DISTINCT ns_product_data.Formula_No, Cf_Part_No, ns_formula_details.Product_Name, ns_product_data.Animal_Type, ns_product_data.Product_Type, Cendres, Calcium, Max_Fibres, Min_Matières grasses, Min_Protéines, Phosphate... [VOIR LA REQUÊTE COMPLÈTE]

SÉLECTIONNEZ DISTINCT ns_product_data.Formula_No, Cf_Part_No, ns_formula_details.Product_Name, ns_product_data.Animal_Type, ns_product_data.Product_Type, Cendres, Calcium, Max_Fibres, Min_Matières grasses, Min_Protéines, Phosphore, Potassium, Sodium, Kibble_Size FROM ns_product_data INNER JOIN ns_formula_details ON ns_formula_details.Formula_No = ns_product_data.Formula_No WHERE ns_product_data.Animal_Type = 'Chien' AND Grain_Free = 'Non' AND Kibble_Size = 'Adulte standard' AND ns_product_data.Product_Type = 'Sec' AND ns_product_data.Formula_No PAS COMME '%FT' ET Cendres N'EST PAS NULL ET Calcium N'EST PAS NULL ET Max_Fiber N'EST PAS NULL ET Min_Fat N'EST PAS NULL ET Min_Protein N'EST PAS NULL ET Phosphore N'EST PAS NULL ET Potassium N'EST PAS NULL ET Sodium N'EST PAS NULL ET ns_product_data.Product_Name N'AIME PAS '%Tuffy%' ET ns_product_data.Product_Name N'AIME PAS '%Supreme%' GROUP BY Formula_No ORDER BY Product_Name ASC

SÉLECTIONNEZ DISTINCT ns_product_data.Formula_No, Cf_Part_No, ns_formula_details.Product_Name, ns_product_data.Animal_Type, ns_product_data.Product_Type, Cendres, Calcium, Max_Fibres, Min_Matières grasses, Min_Protéines, Phosphate... [VOIR LA REQUÊTE COMPLÈTE]

SÉLECTIONNEZ DISTINCT ns_product_data.Formula_No, Cf_Part_No, ns_formula_details.Product_Name, ns_product_data.Animal_Type, ns_product_data.Product_Type, Ash, Calcium, Max_Fiber, Min_Fat, Min_Protein, Phosphore, Potassium, Sodium, Kibble_Size FROM ns_product_data INNER JOIN ns_formula_details ON ns_formula_details.Formula_No = ns_product_data.Formula_No WHERE ns_product_data.Animal_Type = 'Dog' AND Grain_Free = 'No' AND Kibble_Size = 'Senior' AND ns_product_data.Product_Type = 'Dry' AND ns_product_data.Formula_No PAS COMME '%FT' ET Ash N'EST PAS NULL ET Calcium N'EST PAS NULL ET Max_Fiber N'EST PAS NULL ET Min_Fat N'EST PAS NULL ET Min_Protein N'EST PAS NULL ET Phosphore N'EST PAS NULL ET Potassium N'EST PAS NULL ET Sodium N'EST PAS NULL ET ns_product_data.Product_Name N'EST PAS COMME '%Tuffy%' ET ns_product_data.Product_Name N'EST PAS COMME '%Supreme%' GROUP BY Formula_No ORDER BY Product_Name ASC

SÉLECTIONNEZ DISTINCT ns_product_data.Formula_No, Cf_Part_No, ns_formula_details.Product_Name, ns_product_data.Animal_Type, ns_product_data.Product_Type, Cendres, Calcium, Max_Fibres, Min_Matières grasses, Min_Protéines, Phosphate... [VOIR LA REQUÊTE COMPLÈTE]

SÉLECTIONNEZ DISTINCT ns_product_data.Formula_No, Cf_Part_No, ns_formula_details.Product_Name, ns_product_data.Animal_Type, ns_product_data.Product_Type, Cendres, Calcium, Max_Fibres, Min_Matières grasses, Min_Protéines, Phosphore, Potassium, Sodium, Kibble_Size FROM ns_product_data INNER JOIN ns_formula_details ON ns_formula_details.Formula_No = ns_product_data.Formula_No WHERE ns_product_data.Animal_Type = 'Chien' AND Grain_Free = 'Non' AND Kibble_Size = 'Adulte standard' AND ns_product_data.Product_Type = 'Sec' AND ns_product_data.Formula_No PAS COMME '%FT' ET Cendres N'EST PAS NULL ET Calcium N'EST PAS NULL ET Max_Fiber N'EST PAS NULL ET Min_Fat N'EST PAS NULL ET Min_Protein N'EST PAS NULL ET Phosphore N'EST PAS NULL ET Potassium N'EST PAS NULL ET Sodium N'EST PAS NULL ET ns_product_data.Product_Name N'AIME PAS '%Tuffy%' ET ns_product_data.Product_Name N'AIME PAS '%Supreme%' GROUP BY Formula_No ORDER BY Product_Name ASC

SÉLECTIONNEZ ns_product_data.Formula_No, ns_formula_details.Product_Name, ns_product_data.Animal_Type, ns_product_data.Product_Type, Cendres, Calcium, Max_Fiber, Min_Fat, Min_Protein, Phosphore, Potassium, Sod... [VOIR LA REQUÊTE COMPLÈTE]

SELECT ns_product_data.Formula_No, ns_formula_details.Product_Name, ns_product_data.Animal_Type, ns_product_data.Product_Type, Ash, Calcium, Max_Fiber, Min_Fat, Min_Protein, Phosphorus, Potassium, Sodium, Kibble_Size FROM ns_product_data INNER JOIN ns_formula_details ON ns_formula_details.Formula_No = ns_product_data.Formula_No WHERE ns_product_data.Formula_No NOT IN ( SELECT DISTINCT Formula_No FROM ns_product_ingredients AS t1 INNER JOIN ( SELECT Formula_No AS t2_Formula_No, MAX(Cf_Part_No) AS Max_Cf_Part_No FROM ns_product_ingredients GROUP BY Formula_No) AS t2 ON t1.Formula_No = t2_Formula_No AND t1.Cf_Part_No = t2.Max_Cf_Part_No WHERE Ing_Class IN ('Beef', 'Bison', 'Blueberries', 'Chicken', 'Duck', 'Egg', 'Haddock', 'Herring', 'Kangaroo', 'Lamb', 'Lentils', 'Quail', 'Rabbit', 'Salmon', 'Sunflower', 'Sweet Potato', 'Trout', 'Tuna', 'Turkey', 'Venison') ) AND ns_product_data.Animal_Type = 'Dog' AND Grain_Free = 'No' AND ns_product_data.Product_Type = 'Dry' AND ns_product_data.Formula_No NOT LIKE '%FT' AND Ash IS NOT NULL AND Calcium IS NOT NULL AND Max_Fiber IS NOT NULL AND Min_Fat IS NOT NULL AND Min_Protein IS NOT NULL AND Phosphorus IS NOT NULL AND Potassium IS NOT NULL AND Sodium IS NOT NULL AND ns_product_data.Product_Name NOT LIKE '%Tuffy%' GROUP BY Formula_No ORDER BY Product_Name ASC

SÉLECTIONNEZ ns_product_data.Formula_No, ns_formula_details.Product_Name, ns_product_data.Animal_Type, ns_product_data.Product_Type, Cendres, Calcium, Max_Fiber, Min_Fat, Min_Protein, Phosphore, Potassium, Sod... [VOIR LA REQUÊTE COMPLÈTE]

SELECT ns_product_data.Formula_No, ns_formula_details.Product_Name, ns_product_data.Animal_Type, ns_product_data.Product_Type, Ash, Calcium, Max_Fiber, Min_Fat, Min_Protein, Phosphorus, Potassium, Sodium, Kibble_Size FROM ns_product_data INNER JOIN ns_formula_details ON ns_formula_details.Formula_No = ns_product_data.Formula_No WHERE ns_product_data.Formula_No NOT IN ( SELECT DISTINCT Formula_No FROM ns_product_ingredients AS t1 INNER JOIN ( SELECT Formula_No AS t2_Formula_No, MAX(Cf_Part_No) AS Max_Cf_Part_No FROM ns_product_ingredients GROUP BY Formula_No) AS t2 ON t1.Formula_No = t2_Formula_No AND t1.Cf_Part_No = t2.Max_Cf_Part_No WHERE Ing_Class IN ('Beef', 'Bison', 'Blueberries', 'Chicken', 'Duck', 'Egg', 'Haddock', 'Herring', 'Kangaroo', 'Lamb', 'Lentils', 'Quail', 'Rabbit', 'Salmon', 'Sunflower', 'Sweet Potato', 'Trout', 'Tuna', 'Turkey', 'Venison') ) AND ns_product_data.Animal_Type = 'Dog' AND Grain_Free = 'No' AND ns_product_data.Product_Type = 'Dry' AND ns_product_data.Formula_No NOT LIKE '%FT' AND Ash IS NOT NULL AND Calcium IS NOT NULL AND Max_Fiber IS NOT NULL AND Min_Fat IS NOT NULL AND Min_Protein IS NOT NULL AND Phosphorus IS NOT NULL AND Potassium IS NOT NULL AND Sodium IS NOT NULL AND ns_product_data.Product_Name NOT LIKE '%Tuffy%' GROUP BY Formula_No ORDER BY Product_Name ASC

SÉLECTIONNEZ ns_product_data.Formula_No, ns_formula_details.Product_Name, ns_product_data.Animal_Type, ns_product_data.Product_Type, Cendres, Calcium, Max_Fiber, Min_Fat, Min_Protein, Phosphore, Potassium, Sod... [VOIR LA REQUÊTE COMPLÈTE]

SELECT ns_product_data.Formula_No, ns_formula_details.Product_Name, ns_product_data.Animal_Type, ns_product_data.Product_Type, Ash, Calcium, Max_Fiber, Min_Fat, Min_Protein, Phosphorus, Potassium, Sodium, Kibble_Size FROM ns_product_data INNER JOIN ns_formula_details ON ns_formula_details.Formula_No = ns_product_data.Formula_No WHERE ns_product_data.Formula_No NOT IN ( SELECT DISTINCT Formula_No FROM ns_product_ingredients AS t1 INNER JOIN ( SELECT Formula_No AS t2_Formula_No, MAX(Cf_Part_No) AS Max_Cf_Part_No FROM ns_product_ingredients GROUP BY Formula_No) AS t2 ON t1.Formula_No = t2_Formula_No AND t1.Cf_Part_No = t2.Max_Cf_Part_No WHERE Ing_Class IN ('Cherries', 'Chicory Root', 'Garlic', 'Kangaroo', 'Salmon') ) AND ns_product_data.Animal_Type = 'Dog' AND Grain_Free = 'No' AND ns_product_data.Product_Type = 'Dry' AND ns_product_data.Formula_No NOT LIKE '%FT' AND Ash IS NOT NULL AND Calcium IS NOT NULL AND Max_Fiber IS NOT NULL AND Min_Fat IS NOT NULL AND Min_Protein IS NOT NULL AND Phosphorus IS NOT NULL AND Potassium IS NOT NULL AND Sodium IS NOT NULL AND ns_product_data.Product_Name NOT LIKE '%Tuffy%' GROUP BY Formula_No ORDER BY Product_Name ASC

SÉLECTIONNEZ DISTINCT ns_product_data.Formula_No, Cf_Part_No, ns_formula_details.Product_Name, ns_product_data.Animal_Type, ns_product_data.Product_Type, Cendres, Calcium, Max_Fibres, Min_Matières grasses, Min_Protéines, Phosphate... [VOIR LA REQUÊTE COMPLÈTE]

SÉLECTIONNEZ DISTINCT ns_product_data.Formula_No, Cf_Part_No, ns_formula_details.Product_Name, ns_product_data.Animal_Type, ns_product_data.Product_Type, Cendres, Calcium, Max_Fibres, Min_Matières grasses, Min_Protéines, Phosphore, Potassium, Sodium, Kibble_Size FROM ns_product_data INNER JOIN ns_formula_details ON ns_formula_details.Formula_No = ns_product_data.Formula_No WHERE ns_product_data.Animal_Type = 'Chien' AND Grain_Free = 'Non' AND Kibble_Size = 'Adulte standard' AND ns_product_data.Product_Type = 'Sec' AND ns_product_data.Formula_No PAS COMME '%FT' ET Cendres N'EST PAS NULL ET Calcium N'EST PAS NULL ET Max_Fiber N'EST PAS NULL ET Min_Fat N'EST PAS NULL ET Min_Protein N'EST PAS NULL ET Phosphore N'EST PAS NULL ET Potassium N'EST PAS NULL ET Sodium N'EST PAS NULL ET ns_product_data.Product_Name N'AIME PAS '%Tuffy%' ET ns_product_data.Product_Name N'AIME PAS '%Supreme%' GROUP BY Formula_No ORDER BY Product_Name ASC

SÉLECTIONNEZ DISTINCT ns_product_data.Formula_No, Cf_Part_No, ns_formula_details.Product_Name, ns_product_data.Animal_Type, ns_product_data.Product_Type, Cendres, Calcium, Max_Fibres, Min_Matières grasses, Min_Protéines, Phosphate... [VOIR LA REQUÊTE COMPLÈTE]

SÉLECTIONNEZ DISTINCT ns_product_data.Formula_No, Cf_Part_No, ns_formula_details.Product_Name, ns_product_data.Animal_Type, ns_product_data.Product_Type, Ash, Calcium, Max_Fiber, Min_Fat, Min_Protein, Phosphore, Potassium, Sodium, Kibble_Size FROM ns_product_data INNER JOIN ns_formula_details ON ns_formula_details.Formula_No = ns_product_data.Formula_No WHERE ns_product_data.Animal_Type = 'Dog' AND Grain_Free = 'No' AND Kibble_Size = 'Puppy' AND ns_product_data.Product_Type = 'Dry' AND ns_product_data.Formula_No PAS COMME '%FT' ET Ash N'EST PAS NULL ET Calcium N'EST PAS NULL ET Max_Fiber N'EST PAS NULL ET Min_Fat N'EST PAS NULL ET Min_Protein N'EST PAS NULL ET Phosphore N'EST PAS NULL ET Potassium N'EST PAS NULL ET Sodium N'EST PAS NULL ET ns_product_data.Product_Name N'EST PAS COMME '%Tuffy%' ET ns_product_data.Product_Name N'EST PAS COMME '%Supreme%' GROUP BY Formula_No ORDER BY Product_Name ASC

SÉLECTIONNEZ DISTINCT ns_product_data.Formula_No, Cf_Part_No, ns_formula_details.Product_Name, ns_product_data.Animal_Type, ns_product_data.Product_Type, Cendres, Calcium, Max_Fibres, Min_Matières grasses, Min_Protéines, Phosphate... [VOIR LA REQUÊTE COMPLÈTE]

SELECT DISTINCT ns_product_data.Formula_No, Cf_Part_No, ns_formula_details.Product_Name, ns_product_data.Animal_Type, ns_product_data.Product_Type, Ash, Calcium, Max_Fiber, Min_Fat, Min_Protein, Phosphorus, Potassium, Sodium, Kibble_Size FROM ns_product_data INNER JOIN ns_formula_details ON ns_formula_details.Formula_No = ns_product_data.Formula_No WHERE ns_product_data.Animal_Type = 'Dog' AND Grain_Free = 'Yes' AND Kibble_Size = 'Senior' AND ns_product_data.Product_Type = 'Cans' AND ns_product_data.Formula_No NOT LIKE '%FT' AND Ash IS NOT NULL AND Calcium IS NOT NULL AND Max_Fiber IS NOT NULL AND Min_Fat IS NOT NULL AND Min_Protein IS NOT NULL AND Phosphorus IS NOT NULL AND Potassium IS NOT NULL AND Sodium IS NOT NULL AND ns_product_data.Product_Name NOT LIKE '%Tuffy%' AND ns_product_data.Product_Name NOT LIKE '%Supreme%' GROUP BY Formula_No ORDER BY Product_Name ASC

SÉLECTIONNEZ DISTINCT ns_product_data.Formula_No, Cf_Part_No, ns_formula_details.Product_Name, ns_product_data.Animal_Type, ns_product_data.Product_Type, Cendres, Calcium, Max_Fibres, Min_Matières grasses, Min_Protéines, Phosphate... [VOIR LA REQUÊTE COMPLÈTE]

SELECT DISTINCT ns_product_data.Formula_No, Cf_Part_No, ns_formula_details.Product_Name, ns_product_data.Animal_Type, ns_product_data.Product_Type, Ash, Calcium, Max_Fiber, Min_Fat, Min_Protein, Phosphorus, Potassium, Sodium, Kibble_Size FROM ns_product_data INNER JOIN ns_formula_details ON ns_ formula_details.Formula_No = ns_product_data.Formula_No OÙ ns_product_data.Animal_Type = 'Dog' ET Kibble_Size = 'Senior' ET ns_product_data.Product_Type = 'Cans' ET ns_product_data.Formula_No PAS COMME '%FT' ET Ash N'EST PAS NULL ET Le Calcium N'EST PAS NULL ET Max_Fiber N'EST PAS NULL ET Min_Fat N'EST PAS NULL NULL ET Min_Protein N'EST PAS NULL ET Le phosphore n'est pas NULL ET Le potassium n'est pas NULL ET Le sodium n'est pas NULL ET ns_product_data.Product_Name PAS COMME '%Tuffy%' ET ns_product_data.Product_Name PAS COMME '%Supreme%' GROUP BY Formula_No ORDER BY Product_Name ASC

SÉLECTIONNEZ ns_product_data.Formula_No, ns_formula_details.Product_Name, ns_product_data.Animal_Type, ns_product_data.Product_Type, Cendres, Calcium, Max_Fiber, Min_Fat, Min_Protein, Phosphore, Potassium, Sod... [VOIR LA REQUÊTE COMPLÈTE]

SELECT ns_product_data.Formula_No, ns_formula_details.Product_Name, ns_product_data.Animal_Type, ns_product_data.Product_Type, Ash, Calcium, Max_Fiber, Min_Fat, Min_Protein, Phosphorus, Potassium, Sodium, Kibble_Size FROM ns_product_data INNER JOIN ns_formula_details ON ns_formula_details.Formula_No = ns_product_data.Formula_No WHERE ns_product_data.Formula_No NOT IN ( SELECT DISTINCT Formula_No FROM ns_product_ingredients AS t1 INNER JOIN ( SELECT Formula_No AS t2_Formula_No, MAX(Cf_Part_No) AS Max_Cf_Part_No FROM ns_product_ingredients GROUP BY Formula_No) AS t2 ON t1.Formula_No = t2_Formula_No AND t1.Cf_Part_No = t2.Max_Cf_Part_No WHERE Ing_Class IN ('Chicken', 'Corn', 'Potato', 'Sweet Potato', 'Wheat') ) AND ns_product_data.Animal_Type = 'Dog' AND ns_product_data.Product_Type = 'Dry' AND ns_product_data.Formula_No NOT LIKE '%FT' AND Ash IS NOT NULL AND Calcium IS NOT NULL AND Max_Fiber IS NOT NULL AND Min_Fat IS NOT NULL AND Min_Protein IS NOT NULL AND Phosphorus IS NOT NULL AND Potassium IS NOT NULL AND Sodium IS NOT NULL AND ns_product_data.Product_Name NOT LIKE '%Tuffy%' GROUP BY Formula_No ORDER BY Product_Name ASC

SÉLECTIONNEZ ns_product_data.Formula_No, ns_formula_details.Product_Name, ns_product_data.Animal_Type, ns_product_data.Product_Type, Cendres, Calcium, Max_Fiber, Min_Fat, Min_Protein, Phosphore, Potassium, Sod... [VOIR LA REQUÊTE COMPLÈTE]

SELECT ns_product_data.Formula_No, ns_formula_details.Product_Name, ns_product_data.Animal_Type, ns_product_data.Product_Type, Ash, Calcium, Max_Fiber, Min_Fat, Min_Protein, Phosphorus, Potassium, Sodium, Kibble_Size FROM ns_product_data INNER JOIN ns_formula_details ON ns_formula_details.Formula_No = ns_product_data.Formula_No WHERE ns_product_data.Formula_No NOT IN ( SELECT DISTINCT Formula_No FROM ns_product_ingredients AS t1 INNER JOIN ( SELECT Formula_No AS t2_Formula_No, MAX(Cf_Part_No) AS Max_Cf_Part_No FROM ns_product_ingredients GROUP BY Formula_No) AS t2 ON t1.Formula_No = t2_Formula_No AND t1.Cf_Part_No = t2.Max_Cf_Part_No WHERE Ing_Class IN ('Chicken', 'Corn', 'Potato', 'Sunflower', 'Sweet Potato', 'Wheat') ) AND ns_product_data.Animal_Type = 'Dog' AND ns_product_data.Product_Type = 'Dry' AND ns_product_data.Formula_No NOT LIKE '%FT' AND Ash IS NOT NULL AND Calcium IS NOT NULL AND Max_Fiber IS NOT NULL AND Min_Fat IS NOT NULL AND Min_Protein IS NOT NULL AND Phosphorus IS NOT NULL AND Potassium IS NOT NULL AND Sodium IS NOT NULL AND ns_product_data.Product_Name NOT LIKE '%Tuffy%' GROUP BY Formula_No ORDER BY Product_Name ASC

SÉLECTIONNEZ ns_product_data.Formula_No, ns_formula_details.Product_Name, ns_product_data.Animal_Type, ns_product_data.Product_Type, Cendres, Calcium, Max_Fiber, Min_Fat, Min_Protein, Phosphore, Potassium, Sod... [VOIR LA REQUÊTE COMPLÈTE]

SELECT ns_product_data.Formula_No, ns_formula_details.Product_Name, ns_product_data.Animal_Type, ns_product_data.Product_Type, Ash, Calcium, Max_Fiber, Min_Fat, Min_Protein, Phosphorus, Potassium, Sodium, Kibble_Size FROM ns_product_data INNER JOIN ns_formula_details ON ns_formula_details.Formula_No = ns_product_data.Formula_No WHERE ns_product_data.Formula_No NOT IN ( SELECT DISTINCT Formula_No FROM ns_product_ingredients AS t1 INNER JOIN ( SELECT Formula_No AS t2_Formula_No, MAX(Cf_Part_No) AS Max_Cf_Part_No FROM ns_product_ingredients GROUP BY Formula_No) AS t2 ON t1.Formula_No = t2_Formula_No AND t1.Cf_Part_No = t2.Max_Cf_Part_No WHERE Ing_Class IN ('Chicken', 'Corn', 'Potato', 'Sunflower', 'Sweet Potato', 'Wheat') ) AND ns_product_data.Animal_Type = 'Dog' AND ns_product_data.Formula_No NOT LIKE '%FT' AND Ash IS NOT NULL AND Calcium IS NOT NULL AND Max_Fiber IS NOT NULL AND Min_Fat IS NOT NULL AND Min_Protein IS NOT NULL AND Phosphorus IS NOT NULL AND Potassium IS NOT NULL AND Sodium IS NOT NULL AND ns_product_data.Product_Name NOT LIKE '%Tuffy%' GROUP BY Formula_No ORDER BY Product_Name ASC

SÉLECTIONNEZ DISTINCT ns_product_data.Formula_No, Cf_Part_No, ns_formula_details.Product_Name, ns_product_data.Animal_Type, ns_product_data.Product_Type, Cendres, Calcium, Max_Fibres, Min_Matières grasses, Min_Protéines, Phosphate... [VOIR LA REQUÊTE COMPLÈTE]

SELECT DISTINCT ns_product_data.Formula_No, Cf_Part_No, ns_formula_details.Product_Name, ns_product_data.Animal_Type, ns_product_data.Product_Type, Ash, Calcium, Max_Fiber, Min_Fat, Min_Protein, Phosphorus, Potassium, Sodium, Kibble_Size FROM ns_product_data INNER JOIN ns_formula_details ON ns_formula_details.Formula_No = ns_product_data.Formula_No WHERE ns_product_data.Animal_Type = 'Dog' AND Grain_Free = 'No' AND ns_product_data.Product_Type = 'Dry' AND Min_Protein >= 0.110000 AND ns_product_data.Formula_No NOT LIKE '%FT' AND Ash IS NOT NULL AND Calcium IS NOT NULL AND Max_Fiber IS NOT NULL AND Min_Fat IS NOT NULL AND Min_Protein IS NOT NULL AND Phosphorus IS NOT NULL AND Potassium IS NOT NULL AND Sodium IS NOT NULL AND ns_product_data.Product_Name NOT LIKE '%Tuffy%' AND ns_product_data.Product_Name NOT LIKE '%Supreme%' GROUP BY Formula_No ORDER BY Product_Name ASC

SÉLECTIONNEZ ns_product_data.Formula_No, ns_formula_details.Product_Name, ns_product_data.Animal_Type, ns_product_data.Product_Type, Cendres, Calcium, Max_Fiber, Min_Fat, Min_Protein, Phosphore, Potassium, Sod... [VOIR LA REQUÊTE COMPLÈTE]

SELECT ns_product_data.Formula_No, ns_formula_details.Product_Name, ns_product_data.Animal_Type, ns_product_data.Product_Type, Ash, Calcium, Max_Fiber, Min_Fat, Min_Protein, Phosphorus, Potassium, Sodium, Kibble_Size FROM ns_product_data INNER JOIN ns_formula_details ON ns_formula_details.Formula_No = ns_product_data.Formula_No WHERE ns_product_data.Formula_No NOT IN ( SELECT DISTINCT Formula_No FROM ns_product_ingredients AS t1 INNER JOIN ( SELECT Formula_No AS t2_Formula_No, MAX(Cf_Part_No) AS Max_Cf_Part_No FROM ns_product_ingredients GROUP BY Formula_No) AS t2 ON t1.Formula_No = t2_Formula_No AND t1.Cf_Part_No = t2.Max_Cf_Part_No WHERE Ing_Class IN ('Beef', 'Bison', 'Blueberries', 'Chicken', 'Duck', 'Egg', 'Haddock', 'Herring', 'Kangaroo', 'Lamb', 'Lentils', 'Quail', 'Rabbit', 'Salmon', 'Sunflower', 'Sweet Potato', 'Trout', 'Tuna', 'Turkey', 'Venison') ) AND ns_product_data.Animal_Type = 'Dog' AND Grain_Free = 'No' AND ns_product_data.Product_Type = 'Dry' AND ns_product_data.Formula_No NOT LIKE '%FT' AND Ash IS NOT NULL AND Calcium IS NOT NULL AND Max_Fiber IS NOT NULL AND Min_Fat IS NOT NULL AND Min_Protein IS NOT NULL AND Phosphorus IS NOT NULL AND Potassium IS NOT NULL AND Sodium IS NOT NULL AND ns_product_data.Product_Name NOT LIKE '%Tuffy%' GROUP BY Formula_No ORDER BY Product_Name ASC

SÉLECTIONNEZ ns_product_data.Formula_No, ns_formula_details.Product_Name, ns_product_data.Animal_Type, ns_product_data.Product_Type, Cendres, Calcium, Max_Fiber, Min_Fat, Min_Protein, Phosphore, Potassium, Sod... [VOIR LA REQUÊTE COMPLÈTE]

SELECT ns_product_data.Formula_No, ns_formula_details.Product_Name, ns_product_data.Animal_Type, ns_product_data.Product_Type, Ash, Calcium, Max_Fiber, Min_Fat, Min_Protein, Phosphorus, Potassium, Sodium, Kibble_Size FROM ns_product_data INNER JOIN ns_formula_details ON ns_formula_details.Formula_No = ns_product_data.Formula_No WHERE ns_product_data.Formula_No NOT IN ( SELECT DISTINCT Formula_No FROM ns_product_ingredients AS t1 INNER JOIN ( SELECT Formula_No AS t2_Formula_No, MAX(Cf_Part_No) AS Max_Cf_Part_No FROM ns_product_ingredients GROUP BY Formula_No) AS t2 ON t1.Formula_No = t2_Formula_No AND t1.Cf_Part_No = t2.Max_Cf_Part_No WHERE Ing_Class IN ('Blueberries', 'Herring', 'Lentils', 'Rabbit', 'Sunflower', 'Sweet Potato') ) AND ns_product_data.Animal_Type = 'Dog' AND Grain_Free = 'No' AND ns_product_data.Product_Type = 'Dry' AND ns_product_data.Formula_No NOT LIKE '%FT' AND Ash IS NOT NULL AND Calcium IS NOT NULL AND Max_Fiber IS NOT NULL AND Min_Fat IS NOT NULL AND Min_Protein IS NOT NULL AND Phosphorus IS NOT NULL AND Potassium IS NOT NULL AND Sodium IS NOT NULL AND ns_product_data.Product_Name NOT LIKE '%Tuffy%' GROUP BY Formula_No ORDER BY Product_Name ASC

SÉLECTIONNEZ DISTINCT ns_product_data.Formula_No, Cf_Part_No, ns_formula_details.Product_Name, ns_product_data.Animal_Type, ns_product_data.Product_Type, Cendres, Calcium, Max_Fibres, Min_Matières grasses, Min_Protéines, Phosphate... [VOIR LA REQUÊTE COMPLÈTE]

SELECT DISTINCT ns_product_data.Formula_No, Cf_Part_No, ns_formula_details.Product_Name, ns_product_data.Animal_Type, ns_product_data.Product_Type, Ash, Calcium, Max_Fiber, Min_Fat, Min_Protein, Phosphorus, Potassium, Sodium, Kibble_Size FROM ns_product_data INNER JOIN ns_formula_details ON ns_formula_details.Formula_No = ns_product_data.Formula_No WHERE ns_product_data.Animal_Type = 'Cat' AND ns_product_data.Product_Type = 'Cans' AND Phosphorus <= 0.008000 AND ns_product_data.Formula_No NOT LIKE '%FT' AND Ash IS NOT NULL AND Calcium IS NOT NULL AND Max_Fiber IS NOT NULL AND Min_Fat IS NOT NULL AND Min_Protein IS NOT NULL AND Phosphorus IS NOT NULL AND Potassium IS NOT NULL AND Sodium IS NOT NULL AND ns_product_data.Product_Name NOT LIKE '%Tuffy%' AND ns_product_data.Product_Name NOT LIKE '%Supreme%' GROUP BY Formula_No ORDER BY Product_Name ASC

SÉLECTIONNEZ DISTINCT ns_product_data.Formula_No, Cf_Part_No, ns_formula_details.Product_Name, ns_product_data.Animal_Type, ns_product_data.Product_Type, Cendres, Calcium, Max_Fibres, Min_Matières grasses, Min_Protéines, Phosphate... [VOIR LA REQUÊTE COMPLÈTE]

SÉLECTIONNEZ DISTINCT ns_product_data.Formula_No, Cf_Part_No, ns_formula_details.Product_Name, ns_product_data.Animal_Type, ns_product_data.Product_Type, Ash, Calcium, Max_Fiber, Min_Fat, Min_Protein, Phosphore, Potassium, Sodium, Kibble_Size FROM ns_product_data INNER JOIN ns_formula_details ON ns_formula_details.Formula_No = ns_product_data.Formula_No WHERE ns_product_data.Animal_Type = 'Dog' AND Grain_Free = 'No' AND ns_product_data.Product_Type = 'Dry' AND ns_product_data.Formula_No PAS COMME '%FT' ET Ash N'EST PAS NULL ET Calcium N'EST PAS NULL ET Max_Fiber N'EST PAS NULL ET Min_Fat N'EST PAS NULL ET Min_Protein N'EST PAS NULL ET Phosphore N'EST PAS NULL ET Potassium N'EST PAS NULL ET Sodium N'EST PAS NULL ET ns_product_data.Product_Name N'EST PAS NULL ET ns_product_data.Product_Name N'EST PAS NULL ET ns_product_data.Product_Name N'EST PAS NULL ET ns_product_data.Product_Name N'EST PAS NULL ET GROUP BY Formula_No ORDER BY Product_Name ASC

SÉLECTIONNEZ ns_product_data.Formula_No, ns_formula_details.Product_Name, ns_product_data.Animal_Type, ns_product_data.Product_Type, Cendres, Calcium, Max_Fiber, Min_Fat, Min_Protein, Phosphore, Potassium, Sod... [VOIR LA REQUÊTE COMPLÈTE]

SELECT ns_product_data.Formula_No, ns_formula_details.Product_Name, ns_product_data.Animal_Type, ns_product_data.Product_Type, Ash, Calcium, Max_Fiber, Min_Fat, Min_Protein, Phosphorus, Potassium, Sodium, Kibble_Size FROM ns_product_data INNER JOIN ns_formula_details ON ns_formula_details.Formula_No = ns_product_data.Formula_No WHERE ns_product_data.Formula_No NOT IN ( SELECT DISTINCT Formula_No FROM ns_product_ingredients AS t1 INNER JOIN ( SELECT Formula_No AS t2_Formula_No, MAX(Cf_Part_No) AS Max_Cf_Part_No FROM ns_product_ingredients GROUP BY Formula_No) AS t2 ON t1.Formula_No = t2_Formula_No AND t1.Cf_Part_No = t2.Max_Cf_Part_No WHERE Ing_Class IN ('Brewers Yeast', 'Chicken', 'Cod', 'Fish', 'Lamb', 'Peanut', 'Pork', 'Potato', 'Salmon', 'Sunflower', 'Sweet Potato', 'Tomato Pomace', 'Wheat') ) AND ns_product_data.Animal_Type = 'Dog' AND ns_product_data.Product_Type = 'Cans' AND ns_product_data.Formula_No NOT LIKE '%FT' AND Ash IS NOT NULL AND Calcium IS NOT NULL AND Max_Fiber IS NOT NULL AND Min_Fat IS NOT NULL AND Min_Protein IS NOT NULL AND Phosphorus IS NOT NULL AND Potassium IS NOT NULL AND Sodium IS NOT NULL AND ns_product_data.Product_Name NOT LIKE '%Tuffy%' GROUP BY Formula_No ORDER BY Product_Name ASC

SÉLECTIONNEZ ns_product_data.Formula_No, ns_formula_details.Product_Name, ns_product_data.Animal_Type, ns_product_data.Product_Type, Cendres, Calcium, Max_Fiber, Min_Fat, Min_Protein, Phosphore, Potassium, Sod... [VOIR LA REQUÊTE COMPLÈTE]

SELECT ns_product_data.Formula_No, ns_formula_details.Product_Name, ns_product_data.Animal_Type, ns_product_data.Product_Type, Ash, Calcium, Max_Fiber, Min_Fat, Min_Protein, Phosphorus, Potassium, Sodium, Kibble_Size FROM ns_product_data INNER JOIN ns_formula_details ON ns_formula_details.Formula_No = ns_product_data.Formula_No WHERE ns_product_data.Formula_No NOT IN ( SELECT DISTINCT Formula_No FROM ns_product_ingredients AS t1 INNER JOIN ( SELECT Formula_No AS t2_Formula_No, MAX(Cf_Part_No) AS Max_Cf_Part_No FROM ns_product_ingredients GROUP BY Formula_No) AS t2 ON t1.Formula_No = t2_Formula_No AND t1.Cf_Part_No = t2.Max_Cf_Part_No WHERE Ing_Class IN ('Brewers Yeast', 'Chicken', 'Cod', 'Fish', 'Lamb', 'Peanut', 'Pork', 'Potato', 'Salmon', 'Sweet Potato', 'Tomato Pomace', 'Wheat') ) AND ns_product_data.Animal_Type = 'Dog' AND ns_product_data.Product_Type = 'Cans' AND ns_product_data.Formula_No NOT LIKE '%FT' AND Ash IS NOT NULL AND Calcium IS NOT NULL AND Max_Fiber IS NOT NULL AND Min_Fat IS NOT NULL AND Min_Protein IS NOT NULL AND Phosphorus IS NOT NULL AND Potassium IS NOT NULL AND Sodium IS NOT NULL AND ns_product_data.Product_Name NOT LIKE '%Tuffy%' GROUP BY Formula_No ORDER BY Product_Name ASC

SÉLECTIONNEZ ns_product_data.Formula_No, ns_formula_details.Product_Name, ns_product_data.Animal_Type, ns_product_data.Product_Type, Cendres, Calcium, Max_Fiber, Min_Fat, Min_Protein, Phosphore, Potassium, Sod... [VOIR LA REQUÊTE COMPLÈTE]

SELECT ns_product_data.Formula_No, ns_formula_details.Product_Name, ns_product_data.Animal_Type, ns_product_data.Product_Type, Ash, Calcium, Max_Fiber, Min_Fat, Min_Protein, Phosphorus, Potassium, Sodium, Kibble_Size FROM ns_product_data INNER JOIN ns_formula_details ON ns_formula_details.Formula_No = ns_product_data.Formula_No WHERE ns_product_data.Formula_No NOT IN ( SELECT DISTINCT Formula_No FROM ns_product_ingredients AS t1 INNER JOIN ( SELECT Formula_No AS t2_Formula_No, MAX(Cf_Part_No) AS Max_Cf_Part_No FROM ns_product_ingredients GROUP BY Formula_No) AS t2 ON t1.Formula_No = t2_Formula_No AND t1.Cf_Part_No = t2.Max_Cf_Part_No WHERE Ing_Class IN ('Brewers Yeast', 'Chicken', 'Cod', 'Fish', 'Lamb', 'Peanut', 'Pork', 'Potato', 'Salmon', 'Sweet Potato', 'Tomato Pomace', 'Wheat') ) AND ns_product_data.Animal_Type = 'Dog' AND ns_product_data.Product_Type = 'Dry' AND ns_product_data.Formula_No NOT LIKE '%FT' AND Ash IS NOT NULL AND Calcium IS NOT NULL AND Max_Fiber IS NOT NULL AND Min_Fat IS NOT NULL AND Min_Protein IS NOT NULL AND Phosphorus IS NOT NULL AND Potassium IS NOT NULL AND Sodium IS NOT NULL AND ns_product_data.Product_Name NOT LIKE '%Tuffy%' GROUP BY Formula_No ORDER BY Product_Name ASC

SÉLECTIONNEZ ns_product_data.Formula_No, ns_formula_details.Product_Name, ns_product_data.Animal_Type, ns_product_data.Product_Type, Cendres, Calcium, Max_Fiber, Min_Fat, Min_Protein, Phosphore, Potassium, Sod... [VOIR LA REQUÊTE COMPLÈTE]

SELECT ns_product_data.Formula_No, ns_formula_details.Product_Name, ns_product_data.Animal_Type, ns_product_data.Product_Type, Ash, Calcium, Max_Fiber, Min_Fat, Min_Protein, Phosphorus, Potassium, Sodium, Kibble_Size FROM ns_product_data INNER JOIN ns_formula_details ON ns_formula_details.Formula_No = ns_product_data.Formula_No WHERE ns_product_data.Formula_No NOT IN ( SELECT DISTINCT Formula_No FROM ns_product_ingredients AS t1 INNER JOIN ( SELECT Formula_No AS t2_Formula_No, MAX(Cf_Part_No) AS Max_Cf_Part_No FROM ns_product_ingredients GROUP BY Formula_No) AS t2 ON t1.Formula_No = t2_Formula_No AND t1.Cf_Part_No = t2.Max_Cf_Part_No WHERE Ing_Class IN ('Brewers Yeast', 'Chicken', 'Cod', 'Lamb', 'Peanut', 'Pork', 'Potato', 'Salmon', 'Sweet Potato', 'Tomato Pomace', 'Wheat') ) AND ns_product_data.Animal_Type = 'Dog' AND ns_product_data.Product_Type = 'Dry' AND ns_product_data.Formula_No NOT LIKE '%FT' AND Ash IS NOT NULL AND Calcium IS NOT NULL AND Max_Fiber IS NOT NULL AND Min_Fat IS NOT NULL AND Min_Protein IS NOT NULL AND Phosphorus IS NOT NULL AND Potassium IS NOT NULL AND Sodium IS NOT NULL AND ns_product_data.Product_Name NOT LIKE '%Tuffy%' GROUP BY Formula_No ORDER BY Product_Name ASC

SÉLECTIONNEZ ns_product_data.Formula_No, ns_formula_details.Product_Name, ns_product_data.Animal_Type, ns_product_data.Product_Type, Cendres, Calcium, Max_Fiber, Min_Fat, Min_Protein, Phosphore, Potassium, Sod... [VOIR LA REQUÊTE COMPLÈTE]

SELECT ns_product_data.Formula_No, ns_formula_details.Product_Name, ns_product_data.Animal_Type, ns_product_data.Product_Type, Ash, Calcium, Max_Fiber, Min_Fat, Min_Protein, Phosphorus, Potassium, Sodium, Kibble_Size FROM ns_product_data INNER JOIN ns_formula_details ON ns_formula_details.Formula_No = ns_product_data.Formula_No WHERE ns_product_data.Formula_No NOT IN ( SELECT DISTINCT Formula_No FROM ns_product_ingredients AS t1 INNER JOIN ( SELECT Formula_No AS t2_Formula_No, MAX(Cf_Part_No) AS Max_Cf_Part_No FROM ns_product_ingredients GROUP BY Formula_No) AS t2 ON t1.Formula_No = t2_Formula_No AND t1.Cf_Part_No = t2.Max_Cf_Part_No WHERE Ing_Class IN ('Brewers Yeast', 'Chicken', 'Cod', 'Lamb', 'Peanut', 'Pork', 'Potato', 'Salmon', 'Sweet Potato', 'Tomato Pomace', 'Wheat') ) AND ns_product_data.Animal_Type = 'Dog' AND ns_product_data.Formula_No NOT LIKE '%FT' AND Ash IS NOT NULL AND Calcium IS NOT NULL AND Max_Fiber IS NOT NULL AND Min_Fat IS NOT NULL AND Min_Protein IS NOT NULL AND Phosphorus IS NOT NULL AND Potassium IS NOT NULL AND Sodium IS NOT NULL AND ns_product_data.Product_Name NOT LIKE '%Tuffy%' GROUP BY Formula_No ORDER BY Product_Name ASC

SÉLECTIONNEZ DISTINCT ns_product_data.Formula_No, Cf_Part_No, ns_formula_details.Product_Name, ns_product_data.Animal_Type, ns_product_data.Product_Type, Cendres, Calcium, Max_Fibres, Min_Matières grasses, Min_Protéines, Phosphate... [VOIR LA REQUÊTE COMPLÈTE]

SELECT DISTINCT ns_product_data.Formula_No, Cf_Part_No, ns_formula_details.Product_Name, ns_product_data.Animal_Type, ns_product_data.Product_Type, Ash, Calcium, Max_Fiber, Min_Fat, Min_Protein, Phosphorus, Potassium, Sodium, Kibble_Size FROM ns_product_data INNER JOIN ns_formula_details ON ns_formula_details.Formula_No = ns_product_data.Formula_No WHERE ns_product_data.Animal_Type = 'Cat' AND ns_product_data.Product_Type = 'Dry' AND Phosphorus >= 0.010000 AND Calcium >= 0.010000 AND Potassium >= 0.010000 AND Sodium >= 0.010000 AND ns_product_data.Formula_No NOT LIKE '%FT' AND Ash IS NOT NULL AND Calcium IS NOT NULL AND Max_Fiber IS NOT NULL AND Min_Fat IS NOT NULL AND Min_Protein IS NOT NULL AND Phosphorus IS NOT NULL AND Potassium IS NOT NULL AND Sodium IS NOT NULL AND ns_product_data.Product_Name NOT LIKE '%Tuffy%' AND ns_product_data.Product_Name NOT LIKE '%Supreme%' GROUP BY Formula_No ORDER BY Product_Name ASC

SÉLECTIONNEZ DISTINCT ns_product_data.Formula_No, Cf_Part_No, ns_formula_details.Product_Name, ns_product_data.Animal_Type, ns_product_data.Product_Type, Cendres, Calcium, Max_Fibres, Min_Matières grasses, Min_Protéines, Phosphate... [VOIR LA REQUÊTE COMPLÈTE]

SELECT DISTINCT ns_product_data.Formula_No, Cf_Part_No, ns_formula_details.Product_Name, ns_product_data.Animal_Type, ns_product_data.Product_Type, Ash, Calcium, Max_Fiber, Min_Fat, Min_Protein, Phosphorus, Potassium, Sodium, Kibble_Size FROM ns_product_data INNER JOIN ns_formula_details ON ns_formula_details.Formula_No = ns_product_data.Formula_No WHERE ns_product_data.Animal_Type = 'Cat' AND ns_product_data.Product_Type = 'Dry' AND Phosphorus >= 0.012000 AND Calcium >= 0.012000 AND Potassium >= 0.010000 AND Sodium >= 0.013000 AND ns_product_data.Formula_No NOT LIKE '%FT' AND Ash IS NOT NULL AND Calcium IS NOT NULL AND Max_Fiber IS NOT NULL AND Min_Fat IS NOT NULL AND Min_Protein IS NOT NULL AND Phosphorus IS NOT NULL AND Potassium IS NOT NULL AND Sodium IS NOT NULL AND ns_product_data.Product_Name NOT LIKE '%Tuffy%' AND ns_product_data.Product_Name NOT LIKE '%Supreme%' GROUP BY Formula_No ORDER BY Product_Name ASC

SÉLECTIONNEZ DISTINCT ns_product_data.Formula_No, Cf_Part_No, ns_formula_details.Product_Name, ns_product_data.Animal_Type, ns_product_data.Product_Type, Cendres, Calcium, Max_Fibres, Min_Matières grasses, Min_Protéines, Phosphate... [VOIR LA REQUÊTE COMPLÈTE]

SÉLECTIONNEZ DISTINCT ns_product_data.Formula_No, Cf_Part_No, ns_formula_details.Product_Name, ns_product_data.Animal_Type, ns_product_data.Product_Type, Ash, Calcium, Max_Fiber, Min_Fat, Min_Protein, Phosphore, Potassium, Sodium, Kibble_Size FROM ns_product_data INNER JOIN ns_formula_details ON ns_formula_details.Formula_No = ns_product_data.Formula_No WHERE ns_product_data.Animal_Type = 'Cat' AND ns_product_data.Product_Type = 'Dry' AND ns_product_data.Formula_No PAS COMME '%FT' ET Ash N'EST PAS NULL ET Calcium N'EST PAS NULL ET Max_Fiber N'EST PAS NULL ET Min_Fat N'EST PAS NULL ET Min_Protein N'EST PAS NULL ET Phosphore N'EST PAS NULL ET Potassium N'EST PAS NULL ET Sodium N'EST PAS NULL ET ns_product_data.Product_Name N'EST PAS COMME '%Tuffy%' ET ns_product_data.Product_Name N'EST PAS COMME '%Supreme%' GROUP BY Formula_No ORDER BY Product_Name ASC

SÉLECTIONNEZ DISTINCT ns_product_data.Formula_No, Cf_Part_No, ns_formula_details.Product_Name, ns_product_data.Animal_Type, ns_product_data.Product_Type, Cendres, Calcium, Max_Fibres, Min_Matières grasses, Min_Protéines, Phosphate... [VOIR LA REQUÊTE COMPLÈTE]

SELECT DISTINCT ns_product_data.Formula_No, Cf_Part_No, ns_formula_details.Product_Name, ns_product_data.Animal_Type, ns_product_data.Product_Type, Ash, Calcium, Max_Fiber, Min_Fat, Min_Protein, Phosphorus, Potassium, Sodium, Kibble_Size FROM ns_product_data INNER JOIN ns_formula_details ON ns_formula_details.Formula_No = ns_product_data.Formula_No WHERE ns_product_data.Animal_Type = 'Cat' AND Kibble_Size = 'Standard Adult' AND ns_product_data.Product_Type = 'Dry' AND ns_product_data.Formula_No NOT LIKE '%FT' AND Ash IS NOT NULL AND Calcium IS NOT NULL AND Max_Fiber IS NOT NULL AND Min_Fat IS NOT NULL AND Min_Protein IS NOT NULL AND Phosphorus IS NOT NULL AND Potassium IS NOT NULL AND Sodium IS NOT NULL AND ns_product_data.Product_Name NOT LIKE '%Tuffy%' AND ns_product_data.Product_Name NOT LIKE '%Supreme%' GROUP BY Formula_No ORDER BY Product_Name ASC

SÉLECTIONNEZ DISTINCT ns_product_data.Formula_No, Cf_Part_No, ns_formula_details.Product_Name, ns_product_data.Animal_Type, ns_product_data.Product_Type, Cendres, Calcium, Max_Fibres, Min_Matières grasses, Min_Protéines, Phosphate... [VOIR LA REQUÊTE COMPLÈTE]

SELECT DISTINCT ns_product_data.Formula_No, Cf_Part_No, ns_formula_details.Product_Name, ns_product_data.Animal_Type, ns_product_data.Product_Type, Ash, Calcium, Max_Fiber, Min_Fat, Min_Protein, Phosphorus, Potassium, Sodium, Kibble_Size FROM ns_product_data INNER JOIN ns_formula_details ON ns_ formula_details.Formula_No = ns_product_data.Formula_No OÙ ns_product_data.Animal_Type = 'Cat' ET Kibble_Size = 'Senior' ET ns_product_data.Product_Type = 'Dry' ET ns_product_data.Formula_No PAS COMME '%FT' ET Ash N'EST PAS NULL ET Le calcium n'est pas NULL ET Max_Fiber N'EST PAS NULL ET Min_Fat N'EST PAS NULL NULL ET Min_Protein N'EST PAS NULL ET Le phosphore n'est pas NULL ET Le potassium n'est pas NULL ET Le sodium n'est pas NULL ET ns_product_data.Product_Name PAS COMME '%Tuffy%' ET ns_product_data.Product_Name PAS COMME '%Supreme%' GROUP BY Formula_No ORDER BY Product_Name ASC

SÉLECTIONNEZ DISTINCT ns_product_data.Formula_No, Cf_Part_No, ns_formula_details.Product_Name, ns_product_data.Animal_Type, ns_product_data.Product_Type, Cendres, Calcium, Max_Fibres, Min_Matières grasses, Min_Protéines, Phosphate... [VOIR LA REQUÊTE COMPLÈTE]

SÉLECTIONNEZ DISTINCT ns_product_data.Formula_No, Cf_Part_No, ns_formula_details.Product_Name, ns_product_data.Animal_Type, ns_product_data.Product_Type, Ash, Calcium, Max_Fiber, Min_Fat, Min_Protein, Phosphore, Potassium, Sodium, Kibble_Size FROM ns_product_data INNER JOIN ns_formula_details ON ns_formula_details.Formula_No = ns_product_data.Formula_No WHERE ns_product_data.Animal_Type = 'Cat' AND ns_product_data.Product_Type = 'Dry' AND ns_product_data.Formula_No PAS COMME '%FT' ET Ash N'EST PAS NULL ET Calcium N'EST PAS NULL ET Max_Fiber N'EST PAS NULL ET Min_Fat N'EST PAS NULL ET Min_Protein N'EST PAS NULL ET Phosphore N'EST PAS NULL ET Potassium N'EST PAS NULL ET Sodium N'EST PAS NULL ET ns_product_data.Product_Name N'EST PAS COMME '%Tuffy%' ET ns_product_data.Product_Name N'EST PAS COMME '%Supreme%' GROUP BY Formula_No ORDER BY Product_Name ASC

SÉLECTIONNEZ DISTINCT ns_product_data.Formula_No, Cf_Part_No, ns_formula_details.Product_Name, ns_product_data.Animal_Type, ns_product_data.Product_Type, Cendres, Calcium, Max_Fibres, Min_Matières grasses, Min_Protéines, Phosphate... [VOIR LA REQUÊTE COMPLÈTE]

SÉLECTIONNEZ DISTINCT ns_product_data.Formula_No, Cf_Part_No, ns_formula_details.Product_Name, ns_product_data.Animal_Type, ns_product_data.Product_Type, Ash, Calcium, Max_Fiber, Min_Fat, Min_Protein, Phosphore, Potassium, Sodium, Kibble_Size FROM ns_product_data INNER JOIN ns_formula_details ON ns_formula_details.Formula_No = ns_product_data.Formula_No WHERE ns_product_data.Animal_Type = 'Dog' AND Grain_Free = 'Yes' AND Kibble_Size = 'Puppy' AND ns_product_data.Product_Type = 'Dry' AND ns_product_data.Formula_No PAS COMME '%FT' ET Ash N'EST PAS NULL ET Calcium N'EST PAS NULL ET Max_Fiber N'EST PAS NULL ET Min_Fat N'EST PAS NULL ET Min_Protein N'EST PAS NULL ET Phosphore N'EST PAS NULL ET Potassium N'EST PAS NULL ET Sodium N'EST PAS NULL ET ns_product_data.Product_Name N'EST PAS COMME '%Tuffy%' ET ns_product_data.Product_Name N'EST PAS COMME '%Supreme%' GROUP BY Formula_No ORDER BY Product_Name ASC

SÉLECTIONNEZ ns_product_data.Formula_No, ns_formula_details.Product_Name, ns_product_data.Animal_Type, ns_product_data.Product_Type, Cendres, Calcium, Max_Fiber, Min_Fat, Min_Protein, Phosphore, Potassium, Sod... [VOIR LA REQUÊTE COMPLÈTE]

SELECT ns_product_data.Formula_No, ns_formula_details.Product_Name, ns_product_data.Animal_Type, ns_product_data.Product_Type, Ash, Calcium, Max_Fiber, Min_Fat, Min_Protein, Phosphorus, Potassium, Sodium, Kibble_Size FROM ns_product_data INNER JOIN ns_formula_details ON ns_formula_details.Formula_No = ns_product_data.Formula_No WHERE ns_product_data.Formula_No NOT IN ( SELECT DISTINCT Formula_No FROM ns_product_ingredients AS t1 INNER JOIN ( SELECT Formula_No AS t2_Formula_No, MAX(Cf_Part_No) AS Max_Cf_Part_No FROM ns_product_ingredients GROUP BY Formula_No) AS t2 ON t1.Formula_No = t2_Formula_No AND t1.Cf_Part_No = t2.Max_Cf_Part_No WHERE Ing_Class IN ('Beef', 'Canola Oil', 'Chicken', 'Corn', 'Garlic', 'Palm Oil', 'Pork') ) AND ns_product_data.Animal_Type = 'Dog' AND ns_product_data.Product_Type = 'Dry' AND ns_product_data.Formula_No NOT LIKE '%FT' AND Ash IS NOT NULL AND Calcium IS NOT NULL AND Max_Fiber IS NOT NULL AND Min_Fat IS NOT NULL AND Min_Protein IS NOT NULL AND Phosphorus IS NOT NULL AND Potassium IS NOT NULL AND Sodium IS NOT NULL AND ns_product_data.Product_Name NOT LIKE '%Tuffy%' GROUP BY Formula_No ORDER BY Product_Name ASC

SÉLECTIONNEZ DISTINCT ns_product_data.Formula_No, Cf_Part_No, ns_formula_details.Product_Name, ns_product_data.Animal_Type, ns_product_data.Product_Type, Cendres, Calcium, Max_Fibres, Min_Matières grasses, Min_Protéines, Phosphate... [VOIR LA REQUÊTE COMPLÈTE]

SÉLECTIONNEZ DISTINCT ns_product_data.Formula_No, Cf_Part_No, ns_formula_details.Product_Name, ns_product_data.Animal_Type, ns_product_data.Product_Type, Ash, Calcium, Max_Fiber, Min_Fat, Min_Protein, Phosphore, Potassium, Sodium, Kibble_Size FROM ns_product_data INNER JOIN ns_formula_details ON ns_formula_details.Formula_No = ns_product_data.Formula_No WHERE ns_product_data.Animal_Type = 'Dog' AND Kibble_Size = 'Large Breed Adult' AND ns_product_data.Product_Type = 'Dry' AND ns_product_data.Formula_No PAS COMME '%FT' ET Ash N'EST PAS NULL ET Calcium N'EST PAS NULL ET Max_Fiber N'EST PAS NULL ET Min_Fat N'EST PAS NUL ET Min_Protein N'EST PAS NUL ET Phosphore N'EST PAS NUL ET Potassium N'EST PAS NUL ET Sodium N'EST PAS NUL ET ns_product_data.Product_Name N'AIME PAS '%Tuffy%' ET ns_product_data.Product_Name N'AIME PAS '%Supreme%' GROUP BY Formula_No ORDER BY Product_Name ASC

SÉLECTIONNEZ ns_product_data.Formula_No, ns_formula_details.Product_Name, ns_product_data.Animal_Type, ns_product_data.Product_Type, Cendres, Calcium, Max_Fiber, Min_Fat, Min_Protein, Phosphore, Potassium, Sod... [VOIR LA REQUÊTE COMPLÈTE]

SELECT ns_product_data.Formula_No, ns_formula_details.Product_Name, ns_product_data.Animal_Type, ns_product_data.Product_Type, Ash, Calcium, Max_Fiber, Min_Fat, Min_Protein, Phosphorus, Potassium, Sodium, Kibble_Size FROM ns_product_data INNER JOIN ns_formula_details ON ns_formula_details.Formula_No = ns_product_data.Formula_No WHERE ns_product_data.Formula_No NOT IN ( SELECT DISTINCT Formula_No FROM ns_product_ingredients AS t1 INNER JOIN ( SELECT Formula_No AS t2_Formula_No, MAX(Cf_Part_No) AS Max_Cf_Part_No FROM ns_product_ingredients GROUP BY Formula_No) AS t2 ON t1.Formula_No = t2_Formula_No AND t1.Cf_Part_No = t2.Max_Cf_Part_No WHERE Ing_Class IN ('Beef', 'Canola Oil', 'Chicken', 'Corn', 'Garlic', 'Palm Oil', 'Pork', 'Sorghum', 'Tapioca') ) AND ns_product_data.Animal_Type = 'Dog' AND ns_product_data.Product_Type = 'Dry' AND ns_product_data.Formula_No NOT LIKE '%FT' AND Ash IS NOT NULL AND Calcium IS NOT NULL AND Max_Fiber IS NOT NULL AND Min_Fat IS NOT NULL AND Min_Protein IS NOT NULL AND Phosphorus IS NOT NULL AND Potassium IS NOT NULL AND Sodium IS NOT NULL AND ns_product_data.Product_Name NOT LIKE '%Tuffy%' GROUP BY Formula_No ORDER BY Product_Name ASC

SÉLECTIONNEZ ns_product_data.Formula_No, ns_formula_details.Product_Name, ns_product_data.Animal_Type, ns_product_data.Product_Type, Cendres, Calcium, Max_Fiber, Min_Fat, Min_Protein, Phosphore, Potassium, Sod... [VOIR LA REQUÊTE COMPLÈTE]

SELECT ns_product_data.Formula_No, ns_formula_details.Product_Name, ns_product_data.Animal_Type, ns_product_data.Product_Type, Ash, Calcium, Max_Fiber, Min_Fat, Min_Protein, Phosphorus, Potassium, Sodium, Kibble_Size FROM ns_product_data INNER JOIN ns_formula_details ON ns_formula_details.Formula_No = ns_product_data.Formula_No WHERE ns_product_data.Formula_No NOT IN ( SELECT DISTINCT Formula_No FROM ns_product_ingredients AS t1 INNER JOIN ( SELECT Formula_No AS t2_Formula_No, MAX(Cf_Part_No) AS Max_Cf_Part_No FROM ns_product_ingredients GROUP BY Formula_No) AS t2 ON t1.Formula_No = t2_Formula_No AND t1.Cf_Part_No = t2.Max_Cf_Part_No WHERE Ing_Class IN ('Canola Oil', 'Chicken', 'Egg', 'Palm Oil', 'Potato', 'Soy') ) AND ns_product_data.Animal_Type = 'Dog' AND ns_product_data.Product_Type = 'Dry' AND ns_product_data.Formula_No NOT LIKE '%FT' AND Ash IS NOT NULL AND Calcium IS NOT NULL AND Max_Fiber IS NOT NULL AND Min_Fat IS NOT NULL AND Min_Protein IS NOT NULL AND Phosphorus IS NOT NULL AND Potassium IS NOT NULL AND Sodium IS NOT NULL AND ns_product_data.Product_Name NOT LIKE '%Tuffy%' GROUP BY Formula_No ORDER BY Product_Name ASC

SÉLECTIONNEZ ns_product_data.Formula_No, ns_formula_details.Product_Name, ns_product_data.Animal_Type, ns_product_data.Product_Type, Cendres, Calcium, Max_Fiber, Min_Fat, Min_Protein, Phosphore, Potassium, Sod... [VOIR LA REQUÊTE COMPLÈTE]

SELECT ns_product_data.Formula_No, ns_formula_details.Product_Name, ns_product_data.Animal_Type, ns_product_data.Product_Type, Ash, Calcium, Max_Fiber, Min_Fat, Min_Protein, Phosphorus, Potassium, Sodium, Kibble_Size FROM ns_product_data INNER JOIN ns_formula_details ON ns_formula_details.Formula_No = ns_product_data.Formula_No WHERE ns_product_data.Formula_No NOT IN ( SELECT DISTINCT Formula_No FROM ns_product_ingredients AS t1 INNER JOIN ( SELECT Formula_No AS t2_Formula_No, MAX(Cf_Part_No) AS Max_Cf_Part_No FROM ns_product_ingredients GROUP BY Formula_No) AS t2 ON t1.Formula_No = t2_Formula_No AND t1.Cf_Part_No = t2.Max_Cf_Part_No WHERE Ing_Class IN ('Canola Oil', 'Chicken', 'Egg', 'Palm Oil', 'Potato', 'Soy') ) AND ns_product_data.Animal_Type = 'Dog' AND (ns_product_data.Product_Type = 'Treats' OR ns_product_data.Product_Type = 'Other') AND ns_product_data.Formula_No NOT LIKE '%FT' AND Ash IS NOT NULL AND Calcium IS NOT NULL AND Max_Fiber IS NOT NULL AND Min_Fat IS NOT NULL AND Min_Protein IS NOT NULL AND Phosphorus IS NOT NULL AND Potassium IS NOT NULL AND Sodium IS NOT NULL AND ns_product_data.Product_Name NOT LIKE '%Tuffy%' GROUP BY Formula_No ORDER BY Product_Name ASC

SÉLECTIONNEZ DISTINCT ns_product_data.Formula_No, Cf_Part_No, ns_formula_details.Product_Name, ns_product_data.Animal_Type, ns_product_data.Product_Type, Cendres, Calcium, Max_Fibres, Min_Matières grasses, Min_Protéines, Phosphate... [VOIR LA REQUÊTE COMPLÈTE]

SELECT DISTINCT ns_product_data.Formula_No, Cf_Part_No, ns_formula_details.Product_Name, ns_product_data.Animal_Type, ns_product_data.Product_Type, Ash, Calcium, Max_Fiber, Min_Fat, Min_Protein, Phosphorus, Potassium, Sodium, Kibble_Size FROM ns_product_data INNER JOIN ns_formula_details ON ns_formula_details.Formula_No = ns_product_data.Formula_No WHERE ns_product_data.Animal_Type = 'Dog' AND Grain_Free = 'Yes' AND ns_product_data.Product_Type = 'Dry' AND Min_Protein >= 0.250000 AND Min_Fat >= 0.150000 AND ns_product_data.Formula_No NOT LIKE '%FT' AND Ash IS NOT NULL AND Calcium IS NOT NULL AND Max_Fiber IS NOT NULL AND Min_Fat IS NOT NULL AND Min_Protein IS NOT NULL AND Phosphorus IS NOT NULL AND Potassium IS NOT NULL AND Sodium IS NOT NULL AND ns_product_data.Product_Name NOT LIKE '%Tuffy%' AND ns_product_data.Product_Name NOT LIKE '%Supreme%' GROUP BY Formula_No ORDER BY Product_Name ASC

SÉLECTIONNEZ DISTINCT ns_product_data.Formula_No, Cf_Part_No, ns_formula_details.Product_Name, ns_product_data.Animal_Type, ns_product_data.Product_Type, Cendres, Calcium, Max_Fibres, Min_Matières grasses, Min_Protéines, Phosphate... [VOIR LA REQUÊTE COMPLÈTE]

SELECT DISTINCT ns_product_data.Formula_No, Cf_Part_No, ns_formula_details.Product_Name, ns_product_data.Animal_Type, ns_product_data.Product_Type, Ash, Calcium, Max_Fiber, Min_Fat, Min_Protein, Phosphorus, Potassium, Sodium, Kibble_Size FROM ns_product_data INNER JOIN ns_formula_details ON formula_details.Formula_No = ns_product_data.Formula_No OÙ ns_product_data.Animal_Type = 'Dog' ET ns_product_data.Product_Type = 'Dry' ET Min_Protein >= 0,250000 ET Min_Fat >= 0,150000 ET ns_product_data.Formula_No PAS COMME '%FT' ET Ash N'EST PAS NULL ET Le calcium n'est pas NULL ET Max_Fiber N'EST PAS NULL ET Min_Fat N'EST PAS NULL ET Min_Protein N'EST PAS NULL ET Le phosphore n'est pas NULL ET Le potassium n'est pas NULL ET Le sodium n'est pas NULL ET ns_product_data.Product_Name PAS COMME '%Tuffy%' ET ns_product_data.Product_Name PAS COMME '%Supreme%' GROUP BY Formula_No ORDER BY Product_Name ASC

SÉLECTIONNEZ DISTINCT ns_product_data.Formula_No, Cf_Part_No, ns_formula_details.Product_Name, ns_product_data.Animal_Type, ns_product_data.Product_Type, Cendres, Calcium, Max_Fibres, Min_Matières grasses, Min_Protéines, Phosphate... [VOIR LA REQUÊTE COMPLÈTE]

SELECT DISTINCT ns_product_data.Formula_No, Cf_Part_No, ns_formula_details.Product_Name, ns_product_data.Animal_Type, ns_product_data.Product_Type, Ash, Calcium, Max_Fiber, Min_Fat, Min_Protein, Phosphorus, Potassium, Sodium, Kibble_Size FROM ns_product_data INNER JOIN ns_formula_details ON ns_formula_details.Formula_No = ns_product_data.Formula_No WHERE ns_product_data.Animal_Type = 'Dog' AND Kibble_Size = 'Large Breed Adult' AND ns_product_data.Product_Type = 'Dry' AND Min_Protein >= 0.250000 AND Min_Fat >= 0.150000 AND ns_product_data.Formula_No NOT LIKE '%FT' AND Ash IS NOT NULL AND Calcium IS NOT NULL AND Max_Fiber IS NOT NULL AND Min_Fat IS NOT NULL AND Min_Protein IS NOT NULL AND Phosphorus IS NOT NULL AND Potassium IS NOT NULL AND Sodium IS NOT NULL AND ns_product_data.Product_Name NOT LIKE '%Tuffy%' AND ns_product_data.Product_Name NOT LIKE '%Supreme%' GROUP BY Formula_No ORDER BY Product_Name ASC

SÉLECTIONNEZ DISTINCT ns_product_data.Formula_No, Cf_Part_No, ns_formula_details.Product_Name, ns_product_data.Animal_Type, ns_product_data.Product_Type, Cendres, Calcium, Max_Fibres, Min_Matières grasses, Min_Protéines, Phosphate... [VOIR LA REQUÊTE COMPLÈTE]

SELECT DISTINCT ns_product_data.Formula_No, Cf_Part_No, ns_formula_details.Product_Name, ns_product_data.Animal_Type, ns_product_data.Product_Type, Ash, Calcium, Max_Fiber, Min_Fat, Min_Protein, Phosphorus, Potassium, Sodium, Kibble_Size FROM ns_product_data INNER JOIN ns_formula_details ON formula_details.Formula_No = ns_product_data.Formula_No OÙ ns_product_data.Animal_Type = 'Dog' ET ns_product_data.Product_Type = 'Dry' ET Min_Protein >= 0,250000 ET Min_Fat >= 0,150000 ET ns_product_data.Formula_No PAS COMME '%FT' ET Ash N'EST PAS NULL ET Le calcium n'est pas NULL ET Max_Fiber N'EST PAS NULL ET Min_Fat N'EST PAS NULL ET Min_Protein N'EST PAS NULL ET Le phosphore n'est pas NULL ET Le potassium n'est pas NULL ET Le sodium n'est pas NULL ET ns_product_data.Product_Name PAS COMME '%Tuffy%' ET ns_product_data.Product_Name PAS COMME '%Supreme%' GROUP BY Formula_No ORDER BY Product_Name ASC

SÉLECTIONNEZ ns_product_data.Formula_No, ns_formula_details.Product_Name, ns_product_data.Animal_Type, ns_product_data.Product_Type, Cendres, Calcium, Max_Fiber, Min_Fat, Min_Protein, Phosphore, Potassium, Sod... [VOIR LA REQUÊTE COMPLÈTE]

SELECT ns_product_data.Formula_No, ns_formula_details.Product_Name, ns_product_data.Animal_Type, ns_product_data.Product_Type, Ash, Calcium, Max_Fiber, Min_Fat, Min_Protein, Phosphorus, Potassium, Sodium, Kibble_Size FROM ns_product_data INNER JOIN ns_formula_details ON ns_formula_details.Formula_No = ns_product_data.Formula_No WHERE ns_product_data.Formula_No NOT IN ( SELECT DISTINCT Formula_No FROM ns_product_ingredients AS t1 INNER JOIN ( SELECT Formula_No AS t2_Formula_No, MAX(Cf_Part_No) AS Max_Cf_Part_No FROM ns_product_ingredients GROUP BY Formula_No) AS t2 ON t1.Formula_No = t2_Formula_No AND t1.Cf_Part_No = t2.Max_Cf_Part_No WHERE Ing_Class IN ('Beef', 'Brewers Yeast', 'Canola Oil', 'Chicken', 'Corn', 'Garlic', 'Hydrolyzed Yeast', 'Palm Oil', 'Pork', 'Sorghum', 'Tapioca') ) AND ns_product_data.Animal_Type = 'Dog' AND ns_product_data.Product_Type = 'Dry' AND ns_product_data.Formula_No NOT LIKE '%FT' AND Ash IS NOT NULL AND Calcium IS NOT NULL AND Max_Fiber IS NOT NULL AND Min_Fat IS NOT NULL AND Min_Protein IS NOT NULL AND Phosphorus IS NOT NULL AND Potassium IS NOT NULL AND Sodium IS NOT NULL AND ns_product_data.Product_Name NOT LIKE '%Tuffy%' GROUP BY Formula_No ORDER BY Product_Name ASC

SÉLECTIONNEZ ns_product_data.Formula_No, ns_formula_details.Product_Name, ns_product_data.Animal_Type, ns_product_data.Product_Type, Cendres, Calcium, Max_Fiber, Min_Fat, Min_Protein, Phosphore, Potassium, Sod... [VOIR LA REQUÊTE COMPLÈTE]

SELECT ns_product_data.Formula_No, ns_formula_details.Product_Name, ns_product_data.Animal_Type, ns_product_data.Product_Type, Ash, Calcium, Max_Fiber, Min_Fat, Min_Protein, Phosphorus, Potassium, Sodium, Kibble_Size FROM ns_product_data INNER JOIN ns_formula_details ON ns_formula_details.Formula_No = ns_product_data.Formula_No WHERE ns_product_data.Formula_No NOT IN ( SELECT DISTINCT Formula_No FROM ns_product_ingredients AS t1 INNER JOIN ( SELECT Formula_No AS t2_Formula_No, MAX(Cf_Part_No) AS Max_Cf_Part_No FROM ns_product_ingredients GROUP BY Formula_No) AS t2 ON t1.Formula_No = t2_Formula_No AND t1.Cf_Part_No = t2.Max_Cf_Part_No WHERE Ing_Class IN ('Brewers Yeast', 'Canola Oil', 'Chicken', 'Corn', 'Garlic', 'Hydrolyzed Yeast', 'Palm Oil', 'Pork', 'Sorghum', 'Tapioca') ) AND ns_product_data.Animal_Type = 'Dog' AND ns_product_data.Product_Type = 'Dry' AND ns_product_data.Formula_No NOT LIKE '%FT' AND Ash IS NOT NULL AND Calcium IS NOT NULL AND Max_Fiber IS NOT NULL AND Min_Fat IS NOT NULL AND Min_Protein IS NOT NULL AND Phosphorus IS NOT NULL AND Potassium IS NOT NULL AND Sodium IS NOT NULL AND ns_product_data.Product_Name NOT LIKE '%Tuffy%' GROUP BY Formula_No ORDER BY Product_Name ASC

SÉLECTIONNEZ DISTINCT ns_product_data.Formula_No, Cf_Part_No, ns_formula_details.Product_Name, ns_product_data.Animal_Type, ns_product_data.Product_Type, Cendres, Calcium, Max_Fibres, Min_Matières grasses, Min_Protéines, Phosphate... [VOIR LA REQUÊTE COMPLÈTE]

SÉLECTIONNEZ DISTINCT ns_product_data.Formula_No, Cf_Part_No, ns_formula_details.Product_Name, ns_product_data.Animal_Type, ns_product_data.Product_Type, Ash, Calcium, Max_Fiber, Min_Fat, Min_Protein, Phosphore, Potassium, Sodium, Kibble_Size FROM ns_product_data INNER JOIN ns_formula_details ON ns_formula_details.Formula_No = ns_product_data.Formula_No WHERE ns_product_data.Animal_Type = 'Dog' AND Grain_Free = 'No' AND ns_product_data.Product_Type = 'Dry' AND ns_product_data.Formula_No PAS COMME '%FT' ET Ash N'EST PAS NULL ET Calcium N'EST PAS NULL ET Max_Fiber N'EST PAS NULL ET Min_Fat N'EST PAS NULL ET Min_Protein N'EST PAS NULL ET Phosphore N'EST PAS NULL ET Potassium N'EST PAS NULL ET Sodium N'EST PAS NULL ET ns_product_data.Product_Name N'EST PAS NULL ET ns_product_data.Product_Name N'EST PAS NULL ET ns_product_data.Product_Name N'EST PAS NULL ET ns_product_data.Product_Name N'EST PAS NULL ET GROUP BY Formula_No ORDER BY Product_Name ASC

SÉLECTIONNEZ ns_product_data.Formula_No, ns_formula_details.Product_Name, ns_product_data.Animal_Type, ns_product_data.Product_Type, Cendres, Calcium, Max_Fiber, Min_Fat, Min_Protein, Phosphore, Potassium, Sod... [VOIR LA REQUÊTE COMPLÈTE]

SELECT ns_product_data.Formula_No, ns_formula_details.Product_Name, ns_product_data.Animal_Type, ns_product_data.Product_Type, Ash, Calcium, Max_Fiber, Min_Fat, Min_Protein, Phosphorus, Potassium, Sodium, Kibble_Size FROM ns_product_data INNER JOIN ns_formula_details ON ns_formula_details.Formula_No = ns_product_data.Formula_No WHERE ns_product_data.Formula_No NOT IN ( SELECT DISTINCT Formula_No FROM ns_product_ingredients AS t1 INNER JOIN ( SELECT Formula_No AS t2_Formula_No, MAX(Cf_Part_No) AS Max_Cf_Part_No FROM ns_product_ingredients GROUP BY Formula_No) AS t2 ON t1.Formula_No = t2_Formula_No AND t1.Cf_Part_No = t2.Max_Cf_Part_No WHERE Ing_Class IN ('Chicken') ) AND ns_product_data.Animal_Type = 'Dog' AND ns_product_data.Product_Type = 'Dry' AND ns_product_data.Formula_No NOT LIKE '%FT' AND Ash IS NOT NULL AND Calcium IS NOT NULL AND Max_Fiber IS NOT NULL AND Min_Fat IS NOT NULL AND Min_Protein IS NOT NULL AND Phosphorus IS NOT NULL AND Potassium IS NOT NULL AND Sodium IS NOT NULL AND ns_product_data.Product_Name NOT LIKE '%Tuffy%' GROUP BY Formula_No ORDER BY Product_Name ASC

SÉLECTIONNEZ DISTINCT ns_product_data.Formula_No, Cf_Part_No, ns_formula_details.Product_Name, ns_product_data.Animal_Type, ns_product_data.Product_Type, Cendres, Calcium, Max_Fibres, Min_Matières grasses, Min_Protéines, Phosphate... [VOIR LA REQUÊTE COMPLÈTE]

SELECT DISTINCT ns_product_data.Formula_No, Cf_Part_No, ns_formula_details.Product_Name, ns_product_data.Animal_Type, ns_product_data.Product_Type, Ash, Calcium, Max_Fiber, Min_Fat, Min_Protein, Phosphorus, Potassium, Sodium, Kibble_Size FROM ns_product_data INNER JOIN ns_formula_details ON formula_details.Formula_No = ns_product_data.Formula_No OÙ ns_product_data.Animal_Type = 'Cat' ET Grain_Free = 'Yes' ET ns_product_data.Product_Type = 'Dry' ET ns_product_data.Formula_No PAS COMME '%FT' ET Ash N'EST PAS NULL ET Le calcium n'est pas NULL ET Max_Fiber N'EST PAS NULL ET Min_Fat N'EST PAS NULL NULL ET Min_Protein N'EST PAS NULL ET Le phosphore n'est pas NULL ET Le potassium n'est pas NULL ET Le sodium n'est pas NULL ET ns_product_data.Product_Name PAS COMME '%Tuffy%' ET ns_product_data.Product_Name PAS COMME '%Supreme%' GROUP BY Formula_No ORDER BY Product_Name ASC

SÉLECTIONNEZ ns_product_data.Formula_No, ns_formula_details.Product_Name, ns_product_data.Animal_Type, ns_product_data.Product_Type, Cendres, Calcium, Max_Fiber, Min_Fat, Min_Protein, Phosphore, Potassium, Sod... [VOIR LA REQUÊTE COMPLÈTE]

SELECT ns_product_data.Formula_No, ns_formula_details.Product_Name, ns_product_data.Animal_Type, ns_product_data.Product_Type, Ash, Calcium, Max_Fiber, Min_Fat, Min_Protein, Phosphorus, Potassium, Sodium, Kibble_Size FROM ns_product_data INNER JOIN ns_formula_details ON ns_formula_details.Formula_No = ns_product_data.Formula_No WHERE ns_product_data.Formula_No NOT IN ( SELECT DISTINCT Formula_No FROM ns_product_ingredients AS t1 INNER JOIN ( SELECT Formula_No AS t2_Formula_No, MAX(Cf_Part_No) AS Max_Cf_Part_No FROM ns_product_ingredients GROUP BY Formula_No) AS t2 ON t1.Formula_No = t2_Formula_No AND t1.Cf_Part_No = t2.Max_Cf_Part_No WHERE Ing_Class IN ('Beef', 'Chicken') ) AND ns_product_data.Animal_Type = 'Dog' AND Grain_Free = 'Yes' AND ns_product_data.Product_Type = 'Dry' AND ns_product_data.Formula_No NOT LIKE '%FT' AND Ash IS NOT NULL AND Calcium IS NOT NULL AND Max_Fiber IS NOT NULL AND Min_Fat IS NOT NULL AND Min_Protein IS NOT NULL AND Phosphorus IS NOT NULL AND Potassium IS NOT NULL AND Sodium IS NOT NULL AND ns_product_data.Product_Name NOT LIKE '%Tuffy%' GROUP BY Formula_No ORDER BY Product_Name ASC

SÉLECTIONNEZ ns_product_data.Formula_No, ns_formula_details.Product_Name, ns_product_data.Animal_Type, ns_product_data.Product_Type, Cendres, Calcium, Max_Fiber, Min_Fat, Min_Protein, Phosphore, Potassium, Sod... [VOIR LA REQUÊTE COMPLÈTE]

SELECT ns_product_data.Formula_No, ns_formula_details.Product_Name, ns_product_data.Animal_Type, ns_product_data.Product_Type, Ash, Calcium, Max_Fiber, Min_Fat, Min_Protein, Phosphorus, Potassium, Sodium, Kibble_Size FROM ns_product_data INNER JOIN ns_formula_details ON ns_formula_details.Formula_No = ns_product_data.Formula_No WHERE ns_product_data.Formula_No NOT IN ( SELECT DISTINCT Formula_No FROM ns_product_ingredients AS t1 INNER JOIN ( SELECT Formula_No AS t2_Formula_No, MAX(Cf_Part_No) AS Max_Cf_Part_No FROM ns_product_ingredients GROUP BY Formula_No) AS t2 ON t1.Formula_No = t2_Formula_No AND t1.Cf_Part_No = t2.Max_Cf_Part_No WHERE Ing_Class IN ('Chicken', 'Peas', 'Soy') ) AND ns_product_data.Animal_Type = 'Dog' AND Grain_Free = 'No' AND ns_product_data.Product_Type = 'Dry' AND ns_product_data.Formula_No NOT LIKE '%FT' AND Ash IS NOT NULL AND Calcium IS NOT NULL AND Max_Fiber IS NOT NULL AND Min_Fat IS NOT NULL AND Min_Protein IS NOT NULL AND Phosphorus IS NOT NULL AND Potassium IS NOT NULL AND Sodium IS NOT NULL AND ns_product_data.Product_Name NOT LIKE '%Tuffy%' GROUP BY Formula_No ORDER BY Product_Name ASC

SÉLECTIONNEZ DISTINCT ns_product_data.Formula_No, Cf_Part_No, ns_formula_details.Product_Name, ns_product_data.Animal_Type, ns_product_data.Product_Type, Cendres, Calcium, Max_Fibres, Min_Matières grasses, Min_Protéines, Phosphate... [VOIR LA REQUÊTE COMPLÈTE]

SÉLECTIONNEZ DISTINCT ns_product_data.Formula_No, Cf_Part_No, ns_formula_details.Product_Name, ns_product_data.Animal_Type, ns_product_data.Product_Type, Cendres, Calcium, Max_Fibres, Min_Matières grasses, Min_Protéines, Phosphore, Potassium, Sodium, Kibble_Size FROM ns_product_data INNER JOIN ns_formula_details ON ns_formula_details.Formula_No = ns_product_data.Formula_No WHERE ns_product_data.Animal_Type = 'Chien' AND Grain_Free = 'Non' AND Kibble_Size = 'Adulte standard' AND ns_product_data.Product_Type = 'Sec' AND ns_product_data.Formula_No PAS COMME '%FT' ET Cendres N'EST PAS NULL ET Calcium N'EST PAS NULL ET Max_Fiber N'EST PAS NULL ET Min_Fat N'EST PAS NULL ET Min_Protein N'EST PAS NULL ET Phosphore N'EST PAS NULL ET Potassium N'EST PAS NULL ET Sodium N'EST PAS NULL ET ns_product_data.Product_Name N'AIME PAS '%Tuffy%' ET ns_product_data.Product_Name N'AIME PAS '%Supreme%' GROUP BY Formula_No ORDER BY Product_Name ASC

SÉLECTIONNEZ DISTINCT ns_product_data.Formula_No, Cf_Part_No, ns_formula_details.Product_Name, ns_product_data.Animal_Type, ns_product_data.Product_Type, Cendres, Calcium, Max_Fibres, Min_Matières grasses, Min_Protéines, Phosphate... [VOIR LA REQUÊTE COMPLÈTE]

SELECT DISTINCT ns_product_data.Formula_No, Cf_Part_No, ns_formula_details.Product_Name, ns_product_data.Animal_Type, ns_product_data.Product_Type, Ash, Calcium, Max_Fiber, Min_Fat, Min_Protein, Phosphorus, Potassium, Sodium, Kibble_Size FROM ns_product_data INNER JOIN ns_formula_details ON ns_ formula_details.Formula_No = ns_product_data.Formula_No OÙ ns_product_data.Animal_Type = 'Cat' ET ns_product_data.Product_Type = 'Dry' ET Phosphore <= 0.017000 AND ns_product_data.Formula_No NOT LIKE '%FT' AND Ash IS NOT NULL AND Calcium IS NOT NULL AND Max_Fiber IS NOT NULL AND Min_Fat IS NOT NULL AND Min_Protein IS NOT NULL AND Phosphorus IS NOT NULL AND Potassium IS NOT NULL AND Sodium IS NOT NULL AND ns_product_data.Product_Name NOT LIKE '%Tuffy%' AND ns_product_data.Product_Name NOT LIKE '%Supreme%' GROUP BY Formula_No ORDER BY Product_Name ASC

SÉLECTIONNEZ DISTINCT ns_product_data.Formula_No, Cf_Part_No, ns_formula_details.Product_Name, ns_product_data.Animal_Type, ns_product_data.Product_Type, Cendres, Calcium, Max_Fibres, Min_Matières grasses, Min_Protéines, Phosphate... [VOIR LA REQUÊTE COMPLÈTE]

SELECT DISTINCT ns_product_data.Formula_No, Cf_Part_No, ns_formula_details.Product_Name, ns_product_data.Animal_Type, ns_product_data.Product_Type, Ash, Calcium, Max_Fiber, Min_Fat, Min_Protein, Phosphorus, Potassium, Sodium, Kibble_Size FROM ns_product_data INNER JOIN ns_formula_details ON ns_ formula_details.Formula_No = ns_product_data.Formula_No OÙ ns_product_data.Animal_Type = 'Cat' ET ns_product_data.Product_Type = 'Dry' ET Phosphore <= 0.010000 AND ns_product_data.Formula_No NOT LIKE '%FT' AND Ash IS NOT NULL AND Calcium IS NOT NULL AND Max_Fiber IS NOT NULL AND Min_Fat IS NOT NULL AND Min_Protein IS NOT NULL AND Phosphorus IS NOT NULL AND Potassium IS NOT NULL AND Sodium IS NOT NULL AND ns_product_data.Product_Name NOT LIKE '%Tuffy%' AND ns_product_data.Product_Name NOT LIKE '%Supreme%' GROUP BY Formula_No ORDER BY Product_Name ASC

SÉLECTIONNEZ DISTINCT ns_product_data.Formula_No, Cf_Part_No, ns_formula_details.Product_Name, ns_product_data.Animal_Type, ns_product_data.Product_Type, Cendres, Calcium, Max_Fibres, Min_Matières grasses, Min_Protéines, Phosphate... [VOIR LA REQUÊTE COMPLÈTE]

SELECT DISTINCT ns_product_data.Formula_No, Cf_Part_No, ns_formula_details.Product_Name, ns_product_data.Animal_Type, ns_product_data.Product_Type, Ash, Calcium, Max_Fiber, Min_Fat, Min_Protein, Phosphorus, Potassium, Sodium, Kibble_Size FROM ns_product_data INNER JOIN ns_formula_details ON ns_formula_details.Formula_No = ns_product_data.Formula_No WHERE ns_product_data.Animal_Type = 'Cat' AND ns_product_data.Product_Type = 'Dry' AND Potassium <= 0.010000 AND ns_product_data.Formula_No NOT LIKE '%FT' AND Ash IS NOT NULL AND Calcium IS NOT NULL AND Max_Fiber IS NOT NULL AND Min_Fat IS NOT NULL AND Min_Protein IS NOT NULL AND Phosphorus IS NOT NULL AND Potassium IS NOT NULL AND Sodium IS NOT NULL AND ns_product_data.Product_Name NOT LIKE '%Tuffy%' AND ns_product_data.Product_Name NOT LIKE '%Supreme%' GROUP BY Formula_No ORDER BY Product_Name ASC

SÉLECTIONNEZ DISTINCT ns_product_data.Formula_No, Cf_Part_No, ns_formula_details.Product_Name, ns_product_data.Animal_Type, ns_product_data.Product_Type, Cendres, Calcium, Max_Fibres, Min_Matières grasses, Min_Protéines, Phosphate... [VOIR LA REQUÊTE COMPLÈTE]

SÉLECTIONNEZ DISTINCT ns_product_data.Formula_No, Cf_Part_No, ns_formula_details.Product_Name, ns_product_data.Animal_Type, ns_product_data.Product_Type, Ash, Calcium, Max_Fiber, Min_Fat, Min_Protein, Phosphore, Potassium, Sodium, Kibble_Size FROM ns_product_data INNER JOIN ns_formula_details ON ns_formula_details.Formula_No = ns_product_data.Formula_No WHERE ns_product_data.Animal_Type = 'Dog' AND ns_product_data.Product_Type = 'Dry' AND ns_product_data.Formula_No PAS COMME '%FT' ET Ash N'EST PAS NULL ET Calcium N'EST PAS NULL ET Max_Fiber N'EST PAS NULL ET Min_Fat N'EST PAS NULL ET Min_Protein N'EST PAS NULL ET Phosphore N'EST PAS NULL ET Potassium N'EST PAS NULL ET Sodium N'EST PAS NULL ET ns_product_data.Product_Name N'EST PAS COMME '%Tuffy%' ET ns_product_data.Product_Name N'EST PAS COMME '%Supreme%' GROUP BY Formula_No ORDER BY Product_Name ASC

SÉLECTIONNEZ DISTINCT ns_product_data.Formula_No, Cf_Part_No, ns_formula_details.Product_Name, ns_product_data.Animal_Type, ns_product_data.Product_Type, Cendres, Calcium, Max_Fibres, Min_Matières grasses, Min_Protéines, Phosphate... [VOIR LA REQUÊTE COMPLÈTE]

SELECT DISTINCT ns_product_data.Formula_No, Cf_Part_No, ns_formula_details.Product_Name, ns_product_data.Animal_Type, ns_product_data.Product_Type, Ash, Calcium, Max_Fiber, Min_Fat, Min_Protein, Phosphorus, Potassium, Sodium, Kibble_Size FROM ns_product_data INNER JOIN ns_formula_details ON ns_ formula_details.Formula_No = ns_product_data.Formula_No OÙ ns_product_data.Animal_Type = 'Dog' ET Grain_Free = 'Non' ET ns_product_data.Product_Type = 'Dry' ET Min_Protein >= 0,260000 ET Min_Protein <= 0.360000 AND ns_product_data.Formula_No NOT LIKE '%FT' AND Ash IS NOT NULL AND Calcium IS NOT NULL AND Max_Fiber IS NOT NULL AND Min_Fat IS NOT NULL AND Min_Protein IS NOT NULL AND Phosphorus IS NOT NULL AND Potassium IS NOT NULL AND Sodium IS NOT NULL AND ns_product_data.Product_Name NOT LIKE '%Tuffy%' AND ns_product_data.Product_Name NOT LIKE '%Supreme%' GROUP BY Formula_No ORDER BY Product_Name ASC

SÉLECTIONNEZ ns_product_data.Formula_No, ns_formula_details.Product_Name, ns_product_data.Animal_Type, ns_product_data.Product_Type, Cendres, Calcium, Max_Fiber, Min_Fat, Min_Protein, Phosphore, Potassium, Sod... [VOIR LA REQUÊTE COMPLÈTE]

SELECT ns_product_data.Formula_No, ns_formula_details.Product_Name, ns_product_data.Animal_Type, ns_product_data.Product_Type, Ash, Calcium, Max_Fiber, Min_Fat, Min_Protein, Phosphorus, Potassium, Sodium, Kibble_Size FROM ns_product_data INNER JOIN ns_formula_details ON ns_formula_details.Formula_No = ns_product_data.Formula_No WHERE ns_product_data.Formula_No NOT IN ( SELECT DISTINCT Formula_No FROM ns_product_ingredients AS t1 INNER JOIN ( SELECT Formula_No AS t2_Formula_No, MAX(Cf_Part_No) AS Max_Cf_Part_No FROM ns_product_ingredients GROUP BY Formula_No) AS t2 ON t1.Formula_No = t2_Formula_No AND t1.Cf_Part_No = t2.Max_Cf_Part_No WHERE Ing_Class IN ('Catfish', 'Chicken', 'Cod', 'Fish', 'Haddock', 'Herring', 'Menhaden Fish', 'Redfish', 'Salmon', 'Spelt', 'Trout', 'Whitefish') ) AND ns_product_data.Animal_Type = 'Dog' AND Grain_Free = 'No' AND ns_product_data.Product_Type = 'Cans' AND ns_product_data.Formula_No NOT LIKE '%FT' AND Ash IS NOT NULL AND Calcium IS NOT NULL AND Max_Fiber IS NOT NULL AND Min_Fat IS NOT NULL AND Min_Protein IS NOT NULL AND Phosphorus IS NOT NULL AND Potassium IS NOT NULL AND Sodium IS NOT NULL AND ns_product_data.Product_Name NOT LIKE '%Tuffy%' GROUP BY Formula_No ORDER BY Product_Name ASC

SÉLECTIONNEZ ns_product_data.Formula_No, ns_formula_details.Product_Name, ns_product_data.Animal_Type, ns_product_data.Product_Type, Cendres, Calcium, Max_Fiber, Min_Fat, Min_Protein, Phosphore, Potassium, Sod... [VOIR LA REQUÊTE COMPLÈTE]

SELECT ns_product_data.Formula_No, ns_formula_details.Product_Name, ns_product_data.Animal_Type, ns_product_data.Product_Type, Ash, Calcium, Max_Fiber, Min_Fat, Min_Protein, Phosphorus, Potassium, Sodium, Kibble_Size FROM ns_product_data INNER JOIN ns_formula_details ON ns_formula_details.Formula_No = ns_product_data.Formula_No WHERE ns_product_data.Formula_No NOT IN ( SELECT DISTINCT Formula_No FROM ns_product_ingredients AS t1 INNER JOIN ( SELECT Formula_No AS t2_Formula_No, MAX(Cf_Part_No) AS Max_Cf_Part_No FROM ns_product_ingredients GROUP BY Formula_No) AS t2 ON t1.Formula_No = t2_Formula_No AND t1.Cf_Part_No = t2.Max_Cf_Part_No WHERE Ing_Class IN ('Catfish', 'Chicken', 'Cod', 'Fish', 'Haddock', 'Herring', 'Menhaden Fish', 'Redfish', 'Salmon', 'Spelt', 'Trout', 'Whitefish') ) AND ns_product_data.Animal_Type = 'Dog' AND Grain_Free = 'No' AND ns_product_data.Product_Type = 'Dry' AND ns_product_data.Formula_No NOT LIKE '%FT' AND Ash IS NOT NULL AND Calcium IS NOT NULL AND Max_Fiber IS NOT NULL AND Min_Fat IS NOT NULL AND Min_Protein IS NOT NULL AND Phosphorus IS NOT NULL AND Potassium IS NOT NULL AND Sodium IS NOT NULL AND ns_product_data.Product_Name NOT LIKE '%Tuffy%' GROUP BY Formula_No ORDER BY Product_Name ASC

SÉLECTIONNEZ ns_product_data.Formula_No, ns_formula_details.Product_Name, ns_product_data.Animal_Type, ns_product_data.Product_Type, Cendres, Calcium, Max_Fiber, Min_Fat, Min_Protein, Phosphore, Potassium, Sod... [VOIR LA REQUÊTE COMPLÈTE]

SELECT ns_product_data.Formula_No, ns_formula_details.Product_Name, ns_product_data.Animal_Type, ns_product_data.Product_Type, Ash, Calcium, Max_Fiber, Min_Fat, Min_Protein, Phosphorus, Potassium, Sodium, Kibble_Size FROM ns_product_data INNER JOIN ns_formula_details ON ns_formula_details.Formula_No = ns_product_data.Formula_No WHERE ns_product_data.Formula_No NOT IN ( SELECT DISTINCT Formula_No FROM ns_product_ingredients AS t1 INNER JOIN ( SELECT Formula_No AS t2_Formula_No, MAX(Cf_Part_No) AS Max_Cf_Part_No FROM ns_product_ingredients GROUP BY Formula_No) AS t2 ON t1.Formula_No = t2_Formula_No AND t1.Cf_Part_No = t2.Max_Cf_Part_No WHERE Ing_Class IN ('Chicken', 'Fish') ) AND ns_product_data.Animal_Type = 'Dog' AND Grain_Free = 'No' AND ns_product_data.Product_Type = 'Dry' AND ns_product_data.Formula_No NOT LIKE '%FT' AND Ash IS NOT NULL AND Calcium IS NOT NULL AND Max_Fiber IS NOT NULL AND Min_Fat IS NOT NULL AND Min_Protein IS NOT NULL AND Phosphorus IS NOT NULL AND Potassium IS NOT NULL AND Sodium IS NOT NULL AND ns_product_data.Product_Name NOT LIKE '%Tuffy%' GROUP BY Formula_No ORDER BY Product_Name ASC

SÉLECTIONNEZ DISTINCT ns_product_data.Formula_No, Cf_Part_No, ns_formula_details.Product_Name, ns_product_data.Animal_Type, ns_product_data.Product_Type, Cendres, Calcium, Max_Fibres, Min_Matières grasses, Min_Protéines, Phosphate... [VOIR LA REQUÊTE COMPLÈTE]

SÉLECTIONNEZ DISTINCT ns_product_data.Formula_No, Cf_Part_No, ns_formula_details.Product_Name, ns_product_data.Animal_Type, ns_product_data.Product_Type, Ash, Calcium, Max_Fiber, Min_Fat, Min_Protein, Phosphore, Potassium, Sodium, Kibble_Size FROM ns_product_data INNER JOIN ns_formula_details ON ns_formula_details.Formula_No = ns_product_data.Formula_No WHERE ns_product_data.Animal_Type = 'Dog' AND Grain_Free = 'No' AND ns_product_data.Product_Type = 'Dry' AND ns_product_data.Formula_No PAS COMME '%FT' ET Ash N'EST PAS NULL ET Calcium N'EST PAS NULL ET Max_Fiber N'EST PAS NULL ET Min_Fat N'EST PAS NULL ET Min_Protein N'EST PAS NULL ET Phosphore N'EST PAS NULL ET Potassium N'EST PAS NULL ET Sodium N'EST PAS NULL ET ns_product_data.Product_Name N'EST PAS NULL ET ns_product_data.Product_Name N'EST PAS NULL ET ns_product_data.Product_Name N'EST PAS NULL ET ns_product_data.Product_Name N'EST PAS NULL ET GROUP BY Formula_No ORDER BY Product_Name ASC

SÉLECTIONNEZ DISTINCT ns_product_data.Formula_No, Cf_Part_No, ns_formula_details.Product_Name, ns_product_data.Animal_Type, ns_product_data.Product_Type, Cendres, Calcium, Max_Fibres, Min_Matières grasses, Min_Protéines, Phosphate... [VOIR LA REQUÊTE COMPLÈTE]

SÉLECTIONNEZ DISTINCT ns_product_data.Formula_No, Cf_Part_No, ns_formula_details.Product_Name, ns_product_data.Animal_Type, ns_product_data.Product_Type, Ash, Calcium, Max_Fiber, Min_Fat, Min_Protein, Phosphore, Potassium, Sodium, Kibble_Size FROM ns_product_data INNER JOIN ns_formula_details ON ns_formula_details.Formula_No = ns_product_data.Formula_No WHERE ns_product_data.Animal_Type = 'Cat' AND ns_product_data.Product_Type = 'Dry' AND ns_product_data.Formula_No PAS COMME '%FT' ET Ash N'EST PAS NULL ET Calcium N'EST PAS NULL ET Max_Fiber N'EST PAS NULL ET Min_Fat N'EST PAS NULL ET Min_Protein N'EST PAS NULL ET Phosphore N'EST PAS NULL ET Potassium N'EST PAS NULL ET Sodium N'EST PAS NULL ET ns_product_data.Product_Name N'EST PAS COMME '%Tuffy%' ET ns_product_data.Product_Name N'EST PAS COMME '%Supreme%' GROUP BY Formula_No ORDER BY Product_Name ASC

SÉLECTIONNEZ DISTINCT ns_product_data.Formula_No, Cf_Part_No, ns_formula_details.Product_Name, ns_product_data.Animal_Type, ns_product_data.Product_Type, Cendres, Calcium, Max_Fibres, Min_Matières grasses, Min_Protéines, Phosphate... [VOIR LA REQUÊTE COMPLÈTE]

SÉLECTIONNEZ DISTINCT ns_product_data.Formula_No, Cf_Part_No, ns_formula_details.Product_Name, ns_product_data.Animal_Type, ns_product_data.Product_Type, Ash, Calcium, Max_Fiber, Min_Fat, Min_Protein, Phosphore, Potassium, Sodium, Kibble_Size FROM ns_product_data INNER JOIN ns_formula_details ON ns_formula_details.Formula_No = ns_product_data.Formula_No WHERE ns_product_data.Animal_Type = 'Cat' AND ns_product_data.Product_Type = 'Dry' AND ns_product_data.Formula_No PAS COMME '%FT' ET Ash N'EST PAS NULL ET Calcium N'EST PAS NULL ET Max_Fiber N'EST PAS NULL ET Min_Fat N'EST PAS NULL ET Min_Protein N'EST PAS NULL ET Phosphore N'EST PAS NULL ET Potassium N'EST PAS NULL ET Sodium N'EST PAS NULL ET ns_product_data.Product_Name N'EST PAS COMME '%Tuffy%' ET ns_product_data.Product_Name N'EST PAS COMME '%Supreme%' GROUP BY Formula_No ORDER BY Product_Name ASC

SÉLECTIONNEZ DISTINCT ns_product_data.Formula_No, Cf_Part_No, ns_formula_details.Product_Name, ns_product_data.Animal_Type, ns_product_data.Product_Type, Cendres, Calcium, Max_Fibres, Min_Matières grasses, Min_Protéines, Phosphate... [VOIR LA REQUÊTE COMPLÈTE]

SÉLECTIONNEZ DISTINCT ns_product_data.Formula_No, Cf_Part_No, ns_formula_details.Product_Name, ns_product_data.Animal_Type, ns_product_data.Product_Type, Ash, Calcium, Max_Fiber, Min_Fat, Min_Protein, Phosphore, Potassium, Sodium, Kibble_Size FROM ns_product_data INNER JOIN ns_formula_details ON ns_formula_details.Formula_No = ns_product_data.Formula_No WHERE ns_product_data.Animal_Type = 'Cat' AND ns_product_data.Product_Type = 'Dry' AND ns_product_data.Formula_No PAS COMME '%FT' ET Ash N'EST PAS NULL ET Calcium N'EST PAS NULL ET Max_Fiber N'EST PAS NULL ET Min_Fat N'EST PAS NULL ET Min_Protein N'EST PAS NULL ET Phosphore N'EST PAS NULL ET Potassium N'EST PAS NULL ET Sodium N'EST PAS NULL ET ns_product_data.Product_Name N'EST PAS COMME '%Tuffy%' ET ns_product_data.Product_Name N'EST PAS COMME '%Supreme%' GROUP BY Formula_No ORDER BY Product_Name ASC

SÉLECTIONNEZ DISTINCT ns_product_data.Formula_No, Cf_Part_No, ns_formula_details.Product_Name, ns_product_data.Animal_Type, ns_product_data.Product_Type, Cendres, Calcium, Max_Fibres, Min_Matières grasses, Min_Protéines, Phosphate... [VOIR LA REQUÊTE COMPLÈTE]

SÉLECTIONNEZ DISTINCT ns_product_data.Formula_No, Cf_Part_No, ns_formula_details.Product_Name, ns_product_data.Animal_Type, ns_product_data.Product_Type, Ash, Calcium, Max_Fiber, Min_Fat, Min_Protein, Phosphore, Potassium, Sodium, Kibble_Size FROM ns_product_data INNER JOIN ns_formula_details ON ns_formula_details.Formula_No = ns_product_data.Formula_No WHERE ns_product_data.Animal_Type = 'Dog' AND Grain_Free = 'No' AND Kibble_Size = 'Puppy' AND ns_product_data.Product_Type = 'Dry' AND ns_product_data.Formula_No PAS COMME '%FT' ET Ash N'EST PAS NULL ET Calcium N'EST PAS NULL ET Max_Fiber N'EST PAS NULL ET Min_Fat N'EST PAS NULL ET Min_Protein N'EST PAS NULL ET Phosphore N'EST PAS NULL ET Potassium N'EST PAS NULL ET Sodium N'EST PAS NULL ET ns_product_data.Product_Name N'EST PAS COMME '%Tuffy%' ET ns_product_data.Product_Name N'EST PAS COMME '%Supreme%' GROUP BY Formula_No ORDER BY Product_Name ASC

SÉLECTIONNEZ DISTINCT ns_product_data.Formula_No, Cf_Part_No, ns_formula_details.Product_Name, ns_product_data.Animal_Type, ns_product_data.Product_Type, Cendres, Calcium, Max_Fibres, Min_Matières grasses, Min_Protéines, Phosphate... [VOIR LA REQUÊTE COMPLÈTE]

SÉLECTIONNEZ DISTINCT ns_product_data.Formula_No, Cf_Part_No, ns_formula_details.Product_Name, ns_product_data.Animal_Type, ns_product_data.Product_Type, Ash, Calcium, Max_Fiber, Min_Fat, Min_Protein, Phosphore, Potassium, Sodium, Kibble_Size FROM ns_product_data INNER JOIN ns_formula_details ON ns_formula_details.Formula_No = ns_product_data.Formula_No WHERE ns_product_data.Animal_Type = 'Dog' AND Grain_Free = 'No' AND ns_product_data.Product_Type = 'Dry' AND ns_product_data.Formula_No PAS COMME '%FT' ET Ash N'EST PAS NULL ET Calcium N'EST PAS NULL ET Max_Fiber N'EST PAS NULL ET Min_Fat N'EST PAS NULL ET Min_Protein N'EST PAS NULL ET Phosphore N'EST PAS NULL ET Potassium N'EST PAS NULL ET Sodium N'EST PAS NULL ET ns_product_data.Product_Name N'EST PAS NULL ET ns_product_data.Product_Name N'EST PAS NULL ET ns_product_data.Product_Name N'EST PAS NULL ET ns_product_data.Product_Name N'EST PAS NULL ET GROUP BY Formula_No ORDER BY Product_Name ASC

SÉLECTIONNEZ ns_product_data.Formula_No, ns_formula_details.Product_Name, ns_product_data.Animal_Type, ns_product_data.Product_Type, Cendres, Calcium, Max_Fiber, Min_Fat, Min_Protein, Phosphore, Potassium, Sod... [VOIR LA REQUÊTE COMPLÈTE]

SELECT ns_product_data.Formula_No, ns_formula_details.Product_Name, ns_product_data.Animal_Type, ns_product_data.Product_Type, Ash, Calcium, Max_Fiber, Min_Fat, Min_Protein, Phosphorus, Potassium, Sodium, Kibble_Size FROM ns_product_data INNER JOIN ns_formula_details ON ns_formula_details.Formula_No = ns_product_data.Formula_No WHERE ns_product_data.Formula_No NOT IN ( SELECT DISTINCT Formula_No FROM ns_product_ingredients AS t1 INNER JOIN ( SELECT Formula_No AS t2_Formula_No, MAX(Cf_Part_No) AS Max_Cf_Part_No FROM ns_product_ingredients GROUP BY Formula_No) AS t2 ON t1.Formula_No = t2_Formula_No AND t1.Cf_Part_No = t2.Max_Cf_Part_No WHERE Ing_Class IN ('Barley', 'Wheat') ) AND ns_product_data.Animal_Type = 'Dog' AND Kibble_Size = 'Standard Adult' AND ns_product_data.Product_Type = 'Dry' AND ns_product_data.Formula_No NOT LIKE '%FT' AND Ash IS NOT NULL AND Calcium IS NOT NULL AND Max_Fiber IS NOT NULL AND Min_Fat IS NOT NULL AND Min_Protein IS NOT NULL AND Phosphorus IS NOT NULL AND Potassium IS NOT NULL AND Sodium IS NOT NULL AND ns_product_data.Product_Name NOT LIKE '%Tuffy%' GROUP BY Formula_No ORDER BY Product_Name ASC

SÉLECTIONNEZ ns_product_data.Formula_No, ns_formula_details.Product_Name, ns_product_data.Animal_Type, ns_product_data.Product_Type, Cendres, Calcium, Max_Fiber, Min_Fat, Min_Protein, Phosphore, Potassium, Sod... [VOIR LA REQUÊTE COMPLÈTE]

SELECT ns_product_data.Formula_No, ns_formula_details.Product_Name, ns_product_data.Animal_Type, ns_product_data.Product_Type, Ash, Calcium, Max_Fiber, Min_Fat, Min_Protein, Phosphorus, Potassium, Sodium, Kibble_Size FROM ns_product_data INNER JOIN ns_formula_details ON ns_formula_details.Formula_No = ns_product_data.Formula_No WHERE ns_product_data.Formula_No NOT IN ( SELECT DISTINCT Formula_No FROM ns_product_ingredients AS t1 INNER JOIN ( SELECT Formula_No AS t2_Formula_No, MAX(Cf_Part_No) AS Max_Cf_Part_No FROM ns_product_ingredients GROUP BY Formula_No) AS t2 ON t1.Formula_No = t2_Formula_No AND t1.Cf_Part_No = t2.Max_Cf_Part_No WHERE Ing_Class IN ('Barley', 'Soy', 'Tomato Pomace', 'Wheat') ) AND ns_product_data.Animal_Type = 'Dog' AND Kibble_Size = 'Standard Adult' AND ns_product_data.Product_Type = 'Dry' AND ns_product_data.Formula_No NOT LIKE '%FT' AND Ash IS NOT NULL AND Calcium IS NOT NULL AND Max_Fiber IS NOT NULL AND Min_Fat IS NOT NULL AND Min_Protein IS NOT NULL AND Phosphorus IS NOT NULL AND Potassium IS NOT NULL AND Sodium IS NOT NULL AND ns_product_data.Product_Name NOT LIKE '%Tuffy%' GROUP BY Formula_No ORDER BY Product_Name ASC

SÉLECTIONNEZ ns_product_data.Formula_No, ns_formula_details.Product_Name, ns_product_data.Animal_Type, ns_product_data.Product_Type, Cendres, Calcium, Max_Fiber, Min_Fat, Min_Protein, Phosphore, Potassium, Sod... [VOIR LA REQUÊTE COMPLÈTE]

SELECT ns_product_data.Formula_No, ns_formula_details.Product_Name, ns_product_data.Animal_Type, ns_product_data.Product_Type, Ash, Calcium, Max_Fiber, Min_Fat, Min_Protein, Phosphorus, Potassium, Sodium, Kibble_Size FROM ns_product_data INNER JOIN ns_formula_details ON ns_formula_details.Formula_No = ns_product_data.Formula_No WHERE ns_product_data.Formula_No NOT IN ( SELECT DISTINCT Formula_No FROM ns_product_ingredients AS t1 INNER JOIN ( SELECT Formula_No AS t2_Formula_No, MAX(Cf_Part_No) AS Max_Cf_Part_No FROM ns_product_ingredients GROUP BY Formula_No) AS t2 ON t1.Formula_No = t2_Formula_No AND t1.Cf_Part_No = t2.Max_Cf_Part_No WHERE Ing_Class IN ('Pork', 'Potato', 'Pumpkin', 'Soy', 'Wheat') ) AND ns_product_data.Animal_Type = 'Dog' AND Kibble_Size = 'Standard Adult' AND ns_product_data.Product_Type = 'Dry' AND ns_product_data.Formula_No NOT LIKE '%FT' AND Ash IS NOT NULL AND Calcium IS NOT NULL AND Max_Fiber IS NOT NULL AND Min_Fat IS NOT NULL AND Min_Protein IS NOT NULL AND Phosphorus IS NOT NULL AND Potassium IS NOT NULL AND Sodium IS NOT NULL AND ns_product_data.Product_Name NOT LIKE '%Tuffy%' GROUP BY Formula_No ORDER BY Product_Name ASC

SÉLECTIONNEZ DISTINCT ns_product_data.Formula_No, Cf_Part_No, ns_formula_details.Product_Name, ns_product_data.Animal_Type, ns_product_data.Product_Type, Cendres, Calcium, Max_Fibres, Min_Matières grasses, Min_Protéines, Phosphate... [VOIR LA REQUÊTE COMPLÈTE]

SÉLECTIONNEZ DISTINCT ns_product_data.Formula_No, Cf_Part_No, ns_formula_details.Product_Name, ns_product_data.Animal_Type, ns_product_data.Product_Type, Ash, Calcium, Max_Fiber, Min_Fat, Min_Protein, Phosphore, Potassium, Sodium, Kibble_Size FROM ns_product_data INNER JOIN ns_formula_details ON ns_formula_details.Formula_No = ns_product_data.Formula_No WHERE ns_product_data.Animal_Type = 'Dog' AND Grain_Free = 'No' AND Kibble_Size = 'Puppy' AND ns_product_data.Product_Type = 'Dry' AND ns_product_data.Formula_No PAS COMME '%FT' ET Ash N'EST PAS NULL ET Calcium N'EST PAS NULL ET Max_Fiber N'EST PAS NULL ET Min_Fat N'EST PAS NULL ET Min_Protein N'EST PAS NULL ET Phosphore N'EST PAS NULL ET Potassium N'EST PAS NULL ET Sodium N'EST PAS NULL ET ns_product_data.Product_Name N'EST PAS COMME '%Tuffy%' ET ns_product_data.Product_Name N'EST PAS COMME '%Supreme%' GROUP BY Formula_No ORDER BY Product_Name ASC

SÉLECTIONNEZ DISTINCT ns_product_data.Formula_No, Cf_Part_No, ns_formula_details.Product_Name, ns_product_data.Animal_Type, ns_product_data.Product_Type, Cendres, Calcium, Max_Fibres, Min_Matières grasses, Min_Protéines, Phosphate... [VOIR LA REQUÊTE COMPLÈTE]

SÉLECTIONNEZ DISTINCT ns_product_data.Formula_No, Cf_Part_No, ns_formula_details.Product_Name, ns_product_data.Animal_Type, ns_product_data.Product_Type, Cendres, Calcium, Max_Fibres, Min_Matières grasses, Min_Protéines, Phosphore, Potassium, Sodium, Kibble_Size FROM ns_product_data INNER JOIN ns_formula_details ON ns_formula_details.Formula_No = ns_product_data.Formula_No WHERE ns_product_data.Animal_Type = 'Chien' AND Grain_Free = 'Non' AND Kibble_Size = 'Adulte standard' AND ns_product_data.Product_Type = 'Sec' AND ns_product_data.Formula_No PAS COMME '%FT' ET Cendres N'EST PAS NULL ET Calcium N'EST PAS NULL ET Max_Fiber N'EST PAS NULL ET Min_Fat N'EST PAS NULL ET Min_Protein N'EST PAS NULL ET Phosphore N'EST PAS NULL ET Potassium N'EST PAS NULL ET Sodium N'EST PAS NULL ET ns_product_data.Product_Name N'AIME PAS '%Tuffy%' ET ns_product_data.Product_Name N'AIME PAS '%Supreme%' GROUP BY Formula_No ORDER BY Product_Name ASC

SÉLECTIONNEZ DISTINCT ns_product_data.Formula_No, Cf_Part_No, ns_formula_details.Product_Name, ns_product_data.Animal_Type, ns_product_data.Product_Type, Cendres, Calcium, Max_Fibres, Min_Matières grasses, Min_Protéines, Phosphate... [VOIR LA REQUÊTE COMPLÈTE]

SÉLECTIONNEZ DISTINCT ns_product_data.Formula_No, Cf_Part_No, ns_formula_details.Product_Name, ns_product_data.Animal_Type, ns_product_data.Product_Type, Ash, Calcium, Max_Fiber, Min_Fat, Min_Protein, Phosphore, Potassium, Sodium, Kibble_Size FROM ns_product_data INNER JOIN ns_formula_details ON ns_formula_details.Formula_No = ns_product_data.Formula_No WHERE ns_product_data.Animal_Type = 'Dog' AND Grain_Free = 'No' AND ns_product_data.Product_Type = 'Dry' AND ns_product_data.Formula_No PAS COMME '%FT' ET Ash N'EST PAS NULL ET Calcium N'EST PAS NULL ET Max_Fiber N'EST PAS NULL ET Min_Fat N'EST PAS NULL ET Min_Protein N'EST PAS NULL ET Phosphore N'EST PAS NULL ET Potassium N'EST PAS NULL ET Sodium N'EST PAS NULL ET ns_product_data.Product_Name N'EST PAS NULL ET ns_product_data.Product_Name N'EST PAS NULL ET ns_product_data.Product_Name N'EST PAS NULL ET ns_product_data.Product_Name N'EST PAS NULL ET GROUP BY Formula_No ORDER BY Product_Name ASC

SÉLECTIONNEZ DISTINCT ns_product_data.Formula_No, Cf_Part_No, ns_formula_details.Product_Name, ns_product_data.Animal_Type, ns_product_data.Product_Type, Cendres, Calcium, Max_Fibres, Min_Matières grasses, Min_Protéines, Phosphate... [VOIR LA REQUÊTE COMPLÈTE]

SÉLECTIONNEZ DISTINCT ns_product_data.Formula_No, Cf_Part_No, ns_formula_details.Product_Name, ns_product_data.Animal_Type, ns_product_data.Product_Type, Ash, Calcium, Max_Fiber, Min_Fat, Min_Protein, Phosphore, Potassium, Sodium, Kibble_Size FROM ns_product_data INNER JOIN ns_formula_details ON ns_formula_details.Formula_No = ns_product_data.Formula_No WHERE ns_product_data.Animal_Type = 'Dog' AND Grain_Free = 'No' AND ns_product_data.Product_Type = 'Dry' AND ns_product_data.Formula_No PAS COMME '%FT' ET Ash N'EST PAS NULL ET Calcium N'EST PAS NULL ET Max_Fiber N'EST PAS NULL ET Min_Fat N'EST PAS NULL ET Min_Protein N'EST PAS NULL ET Phosphore N'EST PAS NULL ET Potassium N'EST PAS NULL ET Sodium N'EST PAS NULL ET ns_product_data.Product_Name N'EST PAS NULL ET ns_product_data.Product_Name N'EST PAS NULL ET ns_product_data.Product_Name N'EST PAS NULL ET ns_product_data.Product_Name N'EST PAS NULL ET GROUP BY Formula_No ORDER BY Product_Name ASC

SÉLECTIONNEZ DISTINCT ns_product_data.Formula_No, Cf_Part_No, ns_formula_details.Product_Name, ns_product_data.Animal_Type, ns_product_data.Product_Type, Cendres, Calcium, Max_Fibres, Min_Matières grasses, Min_Protéines, Phosphate... [VOIR LA REQUÊTE COMPLÈTE]

SÉLECTIONNEZ DISTINCT ns_product_data.Formula_No, Cf_Part_No, ns_formula_details.Product_Name, ns_product_data.Animal_Type, ns_product_data.Product_Type, Ash, Calcium, Max_Fiber, Min_Fat, Min_Protein, Phosphore, Potassium, Sodium, Kibble_Size FROM ns_product_data INNER JOIN ns_formula_details ON ns_formula_details.Formula_No = ns_product_data.Formula_No WHERE ns_product_data.Animal_Type = 'Cat' AND Grain_Free = 'No' AND ns_product_data.Product_Type = 'Dry' AND ns_product_data.Formula_No PAS COMME '%FT' ET Ash N'EST PAS NULL ET Calcium N'EST PAS NULL ET Max_Fiber N'EST PAS NULL ET Min_Fat N'EST PAS NULL ET Min_Protein N'EST PAS NULL ET Phosphore N'EST PAS NULL ET Potassium N'EST PAS NULL ET Sodium N'EST PAS NULL ET ns_product_data.Product_Name N'EST PAS COMME '%Tuffy%' ET ns_product_data.Product_Name N'EST PAS COMME '%Supreme%' GROUP BY Formula_No ORDER BY Product_Name ASC