| 60293 |
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, Phosp... [SEE FULL QUERY]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.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 |
Animal_Type = Dog
Grain_Free = No
|
|
|
2026-04-02 01:29:36 |
| 60292 |
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, Phosp... [SEE FULL QUERY]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 Kibble_Size = 'Large Breed 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 |
Animal_Type = Dog
Grain_Free = No
Kibble_Size = Large Breed Adult
Product_Type = Dry
|
|
|
2026-04-01 22:58:28 |
| 60291 |
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, Phosp... [SEE FULL QUERY]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 Kibble_Size = 'Large Breed 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 |
Animal_Type = Dog
Grain_Free = No
Kibble_Size = Large Breed Adult
Product_Type = Dry
|
|
|
2026-04-01 22:58:18 |
| 60290 |
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, Phosp... [SEE FULL QUERY]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 Kibble_Size = 'Puppy' 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 |
Animal_Type = Dog
Grain_Free = No
Kibble_Size = Puppy
Product_Type = Dry
|
|
|
2026-04-01 22:57:28 |
| 60289 |
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, Phosp... [SEE FULL QUERY]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 ns_product_data.Product_Type = 'Dry' AND Min_Fat >= 0.080000 AND Min_Fat <= 0.100000
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 |
Animal_Type = Dog
Product_Type = Dry
|
Min_Fat >= 0.080000
Min_Fat <= 0.100000
|
|
2026-04-01 22:52:26 |
| 60288 |
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, Phosp... [SEE FULL QUERY]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 = 'Standard Adult' AND ns_product_data.Product_Type = 'Dry' AND Min_Fat <= 0.100000
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 |
Animal_Type = Dog
Kibble_Size = Standard Adult
Product_Type = Dry
|
Min_Fat <= 0.100000
|
|
2026-04-01 22:20:03 |
| 60287 |
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, Phosp... [SEE FULL QUERY]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 (ns_product_data.Product_Type = 'Treats' OR ns_product_data.Product_Type = 'Other') AND Min_Fat >= 0.050000 AND Min_Fat <= 0.100000
AND ns_product_data.Formula_No NOT LIKE '%FT'
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 |
Animal_Type = Dog
Product_Type = Treats OR ns_product_data.Product_Type = Other)
|
Min_Fat >= 0.050000
Min_Fat <= 0.100000
|
|
2026-04-01 22:14:15 |
| 60286 |
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, Phosp... [SEE FULL QUERY]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 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 |
Animal_Type = Dog
Product_Type = Dry
|
|
|
2026-04-01 21:58:11 |
| 60285 |
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, Phosp... [SEE FULL QUERY]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 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 |
Animal_Type = Dog
Grain_Free = No
Product_Type = Dry
|
|
|
2026-04-01 20:38:27 |
| 60284 |
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, Phosp... [SEE FULL QUERY]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 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 |
Animal_Type = Cat
Product_Type = Dry
|
|
|
2026-04-01 20:24:04 |
| 60283 |
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, Phosp... [SEE FULL QUERY]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 = '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 |
Animal_Type = Dog
Grain_Free = Yes
Kibble_Size = Standard Adult
Product_Type = Dry
|
|
|
2026-04-01 20:06:01 |
| 60282 |
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, Phosp... [SEE FULL QUERY]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 = '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 |
Animal_Type = Dog
Grain_Free = Yes
Kibble_Size = Standard Adult
Product_Type = Dry
|
|
|
2026-04-01 20:05:56 |
| 60281 |
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, Phosp... [SEE FULL QUERY]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 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 |
Animal_Type = Dog
Grain_Free = No
Product_Type = Dry
|
|
|
2026-04-01 19:35:55 |
| 60280 |
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, Sod... [SEE FULL QUERY]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 ('Beets', 'Venison')
)
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 |
Animal_Type = Dog
Product_Type = Dry
|
|
|
2026-04-01 19:14:54 |
| 60279 |
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, Phosp... [SEE FULL QUERY]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 = 'Large Breed Adult' AND ns_product_data.Product_Type = 'Dry' AND Min_Protein <= 0.120000 AND Phosphorus <= 0.005000 AND Calcium >= 0.005000 AND 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 |
Animal_Type = Dog
Grain_Free = Yes
Kibble_Size = Large Breed Adult
Product_Type = Dry
|
Min_Protein <= 0.120000
Phosphorus <= 0.005000
Calcium >= 0.005000
Potassium <= 0.009000
|
|
2026-04-01 19:11:38 |
| 60278 |
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, Phosp... [SEE FULL QUERY]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 Kibble_Size = 'Large Breed 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 |
Animal_Type = Dog
Grain_Free = No
Kibble_Size = Large Breed Adult
Product_Type = Dry
|
|
|
2026-04-01 18:43:41 |
| 60277 |
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, Phosp... [SEE FULL QUERY]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 Grain_Free = 'Yes' AND ns_product_data.Product_Type = 'Cans' AND Phosphorus <= 0.005000
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 |
Animal_Type = Cat
Grain_Free = Yes
Product_Type = Cans
|
Phosphorus <= 0.005000
|
|
2026-04-01 18:34:38 |
| 60276 |
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, Sod... [SEE FULL QUERY]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 |
Animal_Type = Dog
Grain_Free = No
Product_Type = Dry
|
|
|
2026-04-01 17:29:12 |
| 60275 |
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, Phosp... [SEE FULL QUERY]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 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 |
Animal_Type = Dog
Grain_Free = No
Kibble_Size = Standard Adult
Product_Type = Dry
|
|
|
2026-04-01 17:12:52 |
| 60274 |
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, Sod... [SEE FULL QUERY]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 ('Apricots', 'Peas', 'Spinach', '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 |
Animal_Type = Dog
Product_Type = Dry
|
|
|
2026-04-01 17:07:47 |
| 60273 |
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, Sod... [SEE FULL QUERY]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 ('Apricots', 'Barley', 'Beef', 'Potato', 'Turkey')
)
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 |
|
|
|
2026-04-01 16:51:41 |
| 60272 |
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, Sod... [SEE FULL QUERY]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', 'Coconut', 'Soy', 'Watercress', 'Yucca')
)
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 |
Animal_Type = Dog
Product_Type = Dry
|
|
|
2026-04-01 16:50:56 |
| 60271 |
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, Phosp... [SEE FULL QUERY]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 Kibble_Size = 'Small Bites' 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 |
Animal_Type = Dog
Grain_Free = No
Kibble_Size = Small Bites
Product_Type = Dry
|
|
|
2026-04-01 16:13:21 |
| 60270 |
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, Sod... [SEE FULL QUERY]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 |
Animal_Type = Dog
Grain_Free = No
Product_Type = Dry
|
|
|
2026-04-01 16:00:58 |
| 60269 |
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, Phosp... [SEE FULL QUERY]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 Kibble_Size = 'Large Breed 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 |
Animal_Type = Dog
Grain_Free = No
Kibble_Size = Large Breed Adult
Product_Type = Dry
|
|
|
2026-04-01 15:34:14 |
| 60268 |
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, Phosp... [SEE FULL QUERY]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 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 |
Animal_Type = Dog
Grain_Free = No
Kibble_Size = Standard Adult
Product_Type = Dry
|
|
|
2026-04-01 14:27:18 |
| 60267 |
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, Phosp... [SEE FULL QUERY]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 = 'Puppy' 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 |
Animal_Type = Dog
Kibble_Size = Puppy
Product_Type = Dry
|
|
|
2026-04-01 14:17:14 |
| 60266 |
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, Phosp... [SEE FULL QUERY]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 = 'Puppy' 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 |
Animal_Type = Dog
Kibble_Size = Puppy
Product_Type = Dry
|
|
|
2026-04-01 14:14:26 |
| 60265 |
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, Sod... [SEE FULL QUERY]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', 'Lamb')
)
AND ns_product_data.Animal_Type = 'Dog' AND Grain_Free = 'No'
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 |
Animal_Type = Dog
Grain_Free = No
|
|
|
2026-04-01 13:28:26 |
| 60264 |
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, Phosp... [SEE FULL QUERY]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.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 |
Animal_Type = Dog
Grain_Free = No
|
|
|
2026-04-01 13:28:06 |
| 60263 |
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, Sod... [SEE FULL QUERY]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 |
Animal_Type = Dog
Grain_Free = No
Product_Type = Dry
|
|
|
2026-04-01 13:22:26 |
| 60262 |
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, Phosp... [SEE FULL QUERY]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 Kibble_Size = 'Large Breed 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 |
Animal_Type = Dog
Grain_Free = No
Kibble_Size = Large Breed Adult
Product_Type = Dry
|
|
|
2026-04-01 12:26:30 |
| 60261 |
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, Phosp... [SEE FULL QUERY]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 = 'Large Breed 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 |
Animal_Type = Dog
Grain_Free = Yes
Kibble_Size = Large Breed Adult
Product_Type = Dry
|
|
|
2026-04-01 12:25:34 |
| 60260 |
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, Phosp... [SEE FULL QUERY]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
AND 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 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, Cf_Part_No DESC |
Animal_Type = Dog
Grain_Free = No
Kibble_Size = Puppy
Product_Type = Dry
|
|
|
2026-04-01 11:47:58 |
| 60259 |
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, Phosp... [SEE FULL QUERY]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 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 |
Animal_Type = Dog
Grain_Free = No
Kibble_Size = Standard Adult
Product_Type = Dry
|
|
|
2026-04-01 11:47:05 |
| 60257 |
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, Phosp... [SEE FULL QUERY]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 Grain_Free = 'No' AND Kibble_Size = 'Senior' 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 |
Grain_Free = No
Kibble_Size = Senior
Product_Type = Dry
|
|
|
2026-04-01 11:46:59 |
| 60258 |
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, Phosp... [SEE FULL QUERY]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 = 'Puppy'
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 |
Animal_Type = Dog
Grain_Free = Yes
Kibble_Size = Puppy
|
|
|
2026-04-01 11:46:59 |
| 60256 |
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, Phosp... [SEE FULL QUERY]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 = 'Puppy' AND (ns_product_data.Product_Type = 'Treats' OR ns_product_data.Product_Type = 'Other')
AND ns_product_data.Formula_No NOT LIKE '%FT'
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 |
Animal_Type = Dog
Kibble_Size = Puppy
Product_Type = Treats OR ns_product_data.Product_Type = Other)
|
|
|
2026-04-01 11:46:59 |
| 60255 |
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, Phosp... [SEE FULL QUERY]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 Grain_Free = 'No' AND Kibble_Size = 'Large Breed 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 |
Grain_Free = No
Kibble_Size = Large Breed Adult
Product_Type = Dry
|
|
|
2026-04-01 11:46:58 |
| 60253 |
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, Phosp... [SEE FULL QUERY]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 = '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 |
Animal_Type = Dog
Grain_Free = No
Product_Type = Cans
|
|
|
2026-04-01 11:46:56 |
| 60254 |
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, Phosp... [SEE FULL QUERY]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 Kibble_Size = 'Small Bites'
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 |
Animal_Type = Dog
Grain_Free = No
Kibble_Size = Small Bites
|
|
|
2026-04-01 11:46:56 |
| 60252 |
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, Phosp... [SEE FULL QUERY]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 = 'Puppy'
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 |
Animal_Type = Dog
Grain_Free = Yes
Kibble_Size = Puppy
|
|
|
2026-04-01 11:46:55 |
| 60251 |
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, Phosp... [SEE FULL QUERY]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 Grain_Free = 'No' AND Kibble_Size = 'Senior' 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 |
Grain_Free = No
Kibble_Size = Senior
Product_Type = Dry
|
|
|
2026-04-01 11:46:53 |
| 60249 |
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, Phosp... [SEE FULL QUERY]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 Grain_Free = 'No' AND Kibble_Size = 'Large Breed 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 |
Grain_Free = No
Kibble_Size = Large Breed Adult
Product_Type = Dry
|
|
|
2026-04-01 11:46:52 |
| 60250 |
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, Phosp... [SEE FULL QUERY]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 = 'Puppy' AND (ns_product_data.Product_Type = 'Treats' OR ns_product_data.Product_Type = 'Other')
AND ns_product_data.Formula_No NOT LIKE '%FT'
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 |
Animal_Type = Dog
Kibble_Size = Puppy
Product_Type = Treats OR ns_product_data.Product_Type = Other)
|
|
|
2026-04-01 11:46:52 |
| 60246 |
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, Phosp... [SEE FULL QUERY]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 = '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 |
Animal_Type = Dog
Grain_Free = No
Product_Type = Cans
|
|
|
2026-04-01 11:46:50 |
| 60247 |
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, Phosp... [SEE FULL QUERY]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 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 |
Animal_Type = Dog
Grain_Free = No
Kibble_Size = Standard Adult
Product_Type = Dry
|
|
|
2026-04-01 11:46:50 |
| 60248 |
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, Phosp... [SEE FULL QUERY]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 Kibble_Size = 'Small Bites'
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 |
Animal_Type = Dog
Grain_Free = No
Kibble_Size = Small Bites
|
|
|
2026-04-01 11:46:50 |
| 60245 |
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, Phosp... [SEE FULL QUERY]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 = 'Puppy'
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 |
Animal_Type = Dog
Grain_Free = Yes
Kibble_Size = Puppy
|
|
|
2026-04-01 11:46:48 |
| 60244 |
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, Phosp... [SEE FULL QUERY]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 Kibble_Size = 'Senior' 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 |
Animal_Type = Dog
Grain_Free = No
Kibble_Size = Senior
Product_Type = Dry
|
|
|
2026-04-01 11:46:47 |
| 60243 |
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, Phosp... [SEE FULL QUERY]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 Kibble_Size = 'Large Breed 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 |
Animal_Type = Dog
Grain_Free = No
Kibble_Size = Large Breed Adult
Product_Type = Dry
|
|
|
2026-04-01 11:46:45 |
| 60241 |
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, Phosp... [SEE FULL QUERY]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 Kibble_Size = 'Small Bites' 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 |
Animal_Type = Dog
Grain_Free = No
Kibble_Size = Small Bites
Product_Type = Dry
|
|
|
2026-04-01 11:46:45 |
| 60242 |
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, Phosp... [SEE FULL QUERY]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 Kibble_Size = 'Puppy' AND (ns_product_data.Product_Type = 'Treats' OR ns_product_data.Product_Type = 'Other')
AND ns_product_data.Formula_No NOT LIKE '%FT'
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 |
Animal_Type = Dog
Grain_Free = No
Kibble_Size = Puppy
Product_Type = Treats OR ns_product_data.Product_Type = Other)
|
|
|
2026-04-01 11:46:45 |
| 60240 |
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, Phosp... [SEE FULL QUERY]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 Kibble_Size = 'Puppy' 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 |
Animal_Type = Dog
Grain_Free = No
Kibble_Size = Puppy
Product_Type = Cans
|
|
|
2026-04-01 11:46:44 |
| 60239 |
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, Phosp... [SEE FULL QUERY]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 = 'Puppy' 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 |
Animal_Type = Dog
Grain_Free = Yes
Kibble_Size = Puppy
Product_Type = Dry
|
|
|
2026-04-01 11:46:43 |
| 60238 |
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, Phosp... [SEE FULL QUERY]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
AND ns_product_data.Animal_Type = 'Cat' AND Grain_Free = 'Yes' AND Kibble_Size = 'Senior' 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, Cf_Part_No DESC |
Animal_Type = Cat
Grain_Free = Yes
Kibble_Size = Senior
Product_Type = Treats OR ns_product_data.Product_Type = Other)
|
|
|
2026-04-01 11:46:39 |
| 60237 |
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, Phosp... [SEE FULL QUERY]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
AND ns_product_data.Animal_Type = 'Cat' AND Grain_Free = 'Yes' AND Kibble_Size = 'Senior' 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, Cf_Part_No DESC |
Animal_Type = Cat
Grain_Free = Yes
Kibble_Size = Senior
Product_Type = Treats OR ns_product_data.Product_Type = Other)
|
|
|
2026-04-01 11:46:36 |
| 60236 |
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, Phosp... [SEE FULL QUERY]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
AND ns_product_data.Animal_Type = 'Cat' AND Grain_Free = 'Yes' AND Kibble_Size = 'Senior' 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, Cf_Part_No DESC |
Animal_Type = Cat
Grain_Free = Yes
Kibble_Size = Senior
Product_Type = Treats OR ns_product_data.Product_Type = Other)
|
|
|
2026-04-01 11:46:34 |
| 60235 |
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, Phosp... [SEE FULL QUERY]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
AND ns_product_data.Animal_Type = 'Cat' AND Grain_Free = 'Yes' AND Kibble_Size = 'Senior' 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, Cf_Part_No DESC |
Animal_Type = Cat
Grain_Free = Yes
Kibble_Size = Senior
Product_Type = Treats OR ns_product_data.Product_Type = Other)
|
|
|
2026-04-01 11:46:30 |
| 60234 |
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, Phosp... [SEE FULL QUERY]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
AND ns_product_data.Animal_Type = 'Cat' AND Grain_Free = 'Yes' AND Kibble_Size = 'Senior' 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, Cf_Part_No DESC |
Animal_Type = Cat
Grain_Free = Yes
Kibble_Size = Senior
Product_Type = Treats OR ns_product_data.Product_Type = Other)
|
|
|
2026-04-01 11:46:20 |
| 60233 |
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, Phosp... [SEE FULL QUERY]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 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 |
Animal_Type = Dog
Grain_Free = No
Kibble_Size = Standard Adult
Product_Type = Dry
|
|
|
2026-04-01 11:46:16 |
| 60232 |
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, Phosp... [SEE FULL QUERY]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 Kibble_Size = 'Senior' 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 |
Animal_Type = Dog
Grain_Free = No
Kibble_Size = Senior
Product_Type = Dry
|
|
|
2026-04-01 11:46:14 |
| 60231 |
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, Phosp... [SEE FULL QUERY]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 Kibble_Size = 'Puppy' AND (ns_product_data.Product_Type = 'Treats' OR ns_product_data.Product_Type = 'Other')
AND ns_product_data.Formula_No NOT LIKE '%FT'
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 |
Animal_Type = Dog
Grain_Free = No
Kibble_Size = Puppy
Product_Type = Treats OR ns_product_data.Product_Type = Other)
|
|
|
2026-04-01 11:46:12 |
| 60230 |
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, Phosp... [SEE FULL QUERY]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 Kibble_Size = 'Large Breed 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 |
Animal_Type = Dog
Grain_Free = No
Kibble_Size = Large Breed Adult
Product_Type = Dry
|
|
|
2026-04-01 11:46:09 |
| 60229 |
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, Phosp... [SEE FULL QUERY]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 Kibble_Size = 'Small Bites' 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 |
Animal_Type = Dog
Grain_Free = No
Kibble_Size = Small Bites
Product_Type = Dry
|
|
|
2026-04-01 11:46:03 |
| 60228 |
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, Phosp... [SEE FULL QUERY]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
AND ns_product_data.Animal_Type = 'Cat' AND Grain_Free = 'Yes' AND Kibble_Size = 'Senior' 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, Cf_Part_No DESC |
Animal_Type = Cat
Grain_Free = Yes
Kibble_Size = Senior
Product_Type = Treats OR ns_product_data.Product_Type = Other)
|
|
|
2026-04-01 11:46:01 |
| 60227 |
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, Phosp... [SEE FULL QUERY]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 Kibble_Size = 'Puppy' 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 |
Animal_Type = Dog
Grain_Free = No
Kibble_Size = Puppy
Product_Type = Cans
|
|
|
2026-04-01 11:45:55 |
| 60226 |
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, Phosp... [SEE FULL QUERY]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 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 |
Animal_Type = Dog
Grain_Free = No
Kibble_Size = Standard Adult
Product_Type = Dry
|
|
|
2026-04-01 11:45:47 |
| 60225 |
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, Phosp... [SEE FULL QUERY]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 = 'Puppy' 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 |
Animal_Type = Dog
Grain_Free = Yes
Kibble_Size = Puppy
Product_Type = Dry
|
|
|
2026-04-01 11:45:42 |
| 60224 |
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, Phosp... [SEE FULL QUERY]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 Kibble_Size = 'Senior' 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 |
Animal_Type = Dog
Grain_Free = No
Kibble_Size = Senior
Product_Type = Dry
|
|
|
2026-04-01 11:45:39 |
| 60223 |
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, Phosp... [SEE FULL QUERY]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 Kibble_Size = 'Puppy' AND (ns_product_data.Product_Type = 'Treats' OR ns_product_data.Product_Type = 'Other')
AND ns_product_data.Formula_No NOT LIKE '%FT'
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 |
Animal_Type = Dog
Grain_Free = No
Kibble_Size = Puppy
Product_Type = Treats OR ns_product_data.Product_Type = Other)
|
|
|
2026-04-01 11:45:38 |
| 60222 |
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, Phosp... [SEE FULL QUERY]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 Kibble_Size = 'Large Breed 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 |
Animal_Type = Dog
Grain_Free = No
Kibble_Size = Large Breed Adult
Product_Type = Dry
|
|
|
2026-04-01 11:45:35 |
| 60221 |
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, Phosp... [SEE FULL QUERY]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 Kibble_Size = 'Small Bites' 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 |
Animal_Type = Dog
Grain_Free = No
Kibble_Size = Small Bites
Product_Type = Dry
|
|
|
2026-04-01 11:45:28 |
| 60220 |
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, Phosp... [SEE FULL QUERY]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
AND ns_product_data.Animal_Type = 'Cat' AND Grain_Free = 'Yes' AND Kibble_Size = 'Senior' 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, Cf_Part_No DESC |
Animal_Type = Cat
Grain_Free = Yes
Kibble_Size = Senior
Product_Type = Treats OR ns_product_data.Product_Type = Other)
|
|
|
2026-04-01 11:45:26 |
| 60219 |
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, Phosp... [SEE FULL QUERY]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 Kibble_Size = 'Puppy' 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 |
Animal_Type = Dog
Grain_Free = No
Kibble_Size = Puppy
Product_Type = Cans
|
|
|
2026-04-01 11:45:19 |
| 60218 |
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, Phosp... [SEE FULL QUERY]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 Grain_Free = 'No' 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 |
Grain_Free = No
Kibble_Size = Standard Adult
Product_Type = Dry
|
|
|
2026-04-01 11:45:15 |
| 60217 |
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, Phosp... [SEE FULL QUERY]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 Grain_Free = 'No' 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 |
Grain_Free = No
Kibble_Size = Standard Adult
Product_Type = Dry
|
|
|
2026-04-01 11:45:13 |
| 60216 |
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, Phosp... [SEE FULL QUERY]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 Grain_Free = 'No' 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 |
Grain_Free = No
Kibble_Size = Standard Adult
Product_Type = Dry
|
|
|
2026-04-01 11:45:11 |
| 60214 |
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, Phosp... [SEE FULL QUERY]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 = 'Puppy' 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 |
Animal_Type = Dog
Grain_Free = Yes
Kibble_Size = Puppy
Product_Type = Dry
|
|
|
2026-04-01 11:45:09 |
| 60215 |
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, Phosp... [SEE FULL QUERY]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 Grain_Free = 'No' 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 |
Grain_Free = No
Kibble_Size = Standard Adult
Product_Type = Dry
|
|
|
2026-04-01 11:45:09 |
| 60213 |
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, Phosp... [SEE FULL QUERY]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 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 |
Animal_Type = Dog
Grain_Free = No
Kibble_Size = Standard Adult
Product_Type = Dry
|
|
|
2026-04-01 11:45:07 |
| 60212 |
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, Phosp... [SEE FULL QUERY]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
AND ns_product_data.Animal_Type = 'Cat' AND Kibble_Size = 'Senior' 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, Cf_Part_No DESC |
Animal_Type = Cat
Kibble_Size = Senior
Product_Type = Treats OR ns_product_data.Product_Type = Other)
|
|
|
2026-04-01 11:44:54 |
| 60211 |
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, Phosp... [SEE FULL QUERY]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
AND ns_product_data.Animal_Type = 'Cat' AND Grain_Free = 'Yes' AND Kibble_Size = 'Senior' 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, Cf_Part_No DESC |
Animal_Type = Cat
Grain_Free = Yes
Kibble_Size = Senior
Product_Type = Treats OR ns_product_data.Product_Type = Other)
|
|
|
2026-04-01 11:44:49 |
| 60210 |
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, Phosp... [SEE FULL QUERY]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 = '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 |
Animal_Type = Dog
Kibble_Size = Standard Adult
Product_Type = Dry
|
|
|
2026-04-01 11:43:52 |
| 60209 |
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, Phosp... [SEE FULL QUERY]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 = 'Small Bites' 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 |
Animal_Type = Dog
Kibble_Size = Small Bites
Product_Type = Dry
|
|
|
2026-04-01 11:42:27 |
| 60208 |
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, Phosp... [SEE FULL QUERY]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 = '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 |
Animal_Type = Dog
Grain_Free = No
Product_Type = Cans
|
|
|
2026-04-01 11:37:02 |
| 60207 |
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, Phosp... [SEE FULL QUERY]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
AND ns_product_data.Animal_Type = 'Cat' AND Grain_Free = 'Yes' AND Kibble_Size = 'Senior' 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, Cf_Part_No DESC |
Animal_Type = Cat
Grain_Free = Yes
Kibble_Size = Senior
Product_Type = Treats OR ns_product_data.Product_Type = Other)
|
|
|
2026-04-01 11:36:04 |
| 60206 |
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, Phosp... [SEE FULL QUERY]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
AND ns_product_data.Animal_Type = 'Cat' AND Grain_Free = 'Yes' AND Kibble_Size = 'Senior' 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, Cf_Part_No DESC |
Animal_Type = Cat
Grain_Free = Yes
Kibble_Size = Senior
Product_Type = Treats OR ns_product_data.Product_Type = Other)
|
|
|
2026-04-01 11:36:02 |
| 60205 |
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, Phosp... [SEE FULL QUERY]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 = '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 |
Animal_Type = Dog
Grain_Free = No
Product_Type = Cans
|
|
|
2026-04-01 11:35:31 |
| 60204 |
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, Phosp... [SEE FULL QUERY]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 = '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 |
Animal_Type = Dog
Grain_Free = No
Product_Type = Cans
|
|
|
2026-04-01 11:35:30 |
| 60203 |
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, Phosp... [SEE FULL QUERY]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 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 |
Animal_Type = Dog
Grain_Free = No
Product_Type = Dry
|
|
|
2026-04-01 11:22:40 |
| 60202 |
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, Phosp... [SEE FULL QUERY]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 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 |
Animal_Type = Dog
Grain_Free = No
Product_Type = Dry
|
|
|
2026-04-01 11:22:23 |
| 60201 |
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, Phosp... [SEE FULL QUERY]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 ns_product_data.Product_Type = 'Dry' AND Min_Protein >= 0.180000 AND Min_Protein <= 0.240000
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 |
Animal_Type = Dog
Product_Type = Dry
|
Min_Protein >= 0.180000
Min_Protein <= 0.240000
|
|
2026-04-01 10:58:07 |
| 60200 |
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, Phosp... [SEE FULL QUERY]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 = 'Puppy' AND ns_product_data.Product_Type = 'Dry' AND Min_Protein >= 0.200000 AND Min_Protein <= 0.220000
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 |
Animal_Type = Dog
Kibble_Size = Puppy
Product_Type = Dry
|
Min_Protein >= 0.200000
Min_Protein <= 0.220000
|
|
2026-04-01 10:57:42 |
| 60199 |
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, Phosp... [SEE FULL QUERY]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 ns_product_data.Product_Type = 'Dry' AND Min_Protein >= 0.200000 AND Min_Protein <= 0.220000
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 |
Animal_Type = Dog
Product_Type = Dry
|
Min_Protein >= 0.200000
Min_Protein <= 0.220000
|
|
2026-04-01 10:55:43 |
| 60198 |
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, Phosp... [SEE FULL QUERY]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 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 |
Animal_Type = Dog
Product_Type = Dry
|
|
|
2026-04-01 10:55:18 |
| 60197 |
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, Sod... [SEE FULL QUERY]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 |
Animal_Type = Dog
Grain_Free = Yes
|
|
|
2026-04-01 10:50:14 |
| 60196 |
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, Phosp... [SEE FULL QUERY]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 = 'Puppy'
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 |
Animal_Type = Dog
Grain_Free = Yes
Kibble_Size = Puppy
|
|
|
2026-04-01 10:27:20 |
| 60195 |
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, Sod... [SEE FULL QUERY]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 |
|
|
|
2026-04-01 08:54:40 |
| 60194 |
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, Sod... [SEE FULL QUERY]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 |
|
|
|
2026-04-01 08:54:39 |
EN 
ES 
FR