| 31651 |
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 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
Product_Type = Dry
|
|
|
2024-12-14 16:09:10 |
| 31650 |
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 = '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 = Yes
Kibble_Size = Small Bites
Product_Type = Dry
|
|
|
2024-12-14 15:30:23 |
| 31649 |
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
WHERE Ing_Class IN ('Chicken', 'Turkey')
ORDER BY Product_Name)
AND 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%'
GROUP BY Formula_No
ORDER BY Product_Name ASC |
Animal_Type = Dog
Grain_Free = No
Kibble_Size = Small Bites
Product_Type = Dry
|
|
Chicken, Turkey |
2024-12-14 15:18:58 |
| 31648 |
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
|
|
|
2024-12-14 15:18:01 |
| 31647 |
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.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
|
|
|
2024-12-14 14:51:06 |
| 31646 |
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 ns_product_data.Product_Type = 'Dry' AND Phosphorus <= 0.010000
AND ns_product_data.Formula_No NOT LIKE '%FT'
AND Ash IS NOT NULL
AND Calcium IS NOT NULL
AND Max_Fiber IS NOT NULL
AND Min_Fat IS NOT NULL
AND Min_Protein IS NOT NULL
AND Phosphorus IS NOT NULL
AND Potassium IS NOT NULL
AND Sodium IS NOT NULL
AND ns_product_data.Product_Name NOT LIKE '%Tuffy%'
AND ns_product_data.Product_Name NOT LIKE '%Supreme%'
GROUP BY Formula_No
ORDER BY Product_Name ASC |
Animal_Type = Dog
Grain_Free = Yes
Product_Type = Dry
|
Phosphorus <= 0.010000
|
|
2024-12-14 14:30:23 |
| 31645 |
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 ns_product_data.Product_Type = 'Dry' AND Phosphorus <= 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
Product_Type = Dry
|
Phosphorus <= 0.009000
|
|
2024-12-14 14:30:13 |
| 31644 |
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 ns_product_data.Product_Type = 'Dry' AND Phosphorus <= 0.010000
AND ns_product_data.Formula_No NOT LIKE '%FT'
AND Ash IS NOT NULL
AND Calcium IS NOT NULL
AND Max_Fiber IS NOT NULL
AND Min_Fat IS NOT NULL
AND Min_Protein IS NOT NULL
AND Phosphorus IS NOT NULL
AND Potassium IS NOT NULL
AND Sodium IS NOT NULL
AND ns_product_data.Product_Name NOT LIKE '%Tuffy%'
AND ns_product_data.Product_Name NOT LIKE '%Supreme%'
GROUP BY Formula_No
ORDER BY Product_Name ASC |
Animal_Type = Dog
Grain_Free = Yes
Product_Type = Dry
|
Phosphorus <= 0.010000
|
|
2024-12-14 14:29:57 |
| 31643 |
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 ns_product_data.Product_Type = 'Dry' 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 = Dog
Grain_Free = Yes
Product_Type = Dry
|
Phosphorus <= 0.005000
|
|
2024-12-14 14:29:46 |
| 31642 |
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 ns_product_data.Product_Type = 'Dry' AND Phosphorus <= 0.004000
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
Product_Type = Dry
|
Phosphorus <= 0.004000
|
|
2024-12-14 14:29:29 |
| 31641 |
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
|
|
|
2024-12-14 13:45:23 |
| 31640 |
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
|
|
|
2024-12-14 13:41:59 |
| 31639 |
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.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
|
|
|
2024-12-14 13:38:15 |
| 31638 |
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
|
|
|
2024-12-14 13:37:58 |
| 31637 |
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.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
|
|
|
2024-12-14 13:37:37 |
| 31636 |
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.050000 AND Min_Fat <= 0.120000
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.050000
Min_Fat <= 0.120000
|
|
2024-12-14 12:46:36 |
| 31635 |
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
|
|
|
2024-12-14 12:39:48 |
| 31634 |
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
WHERE Ing_Class IN ('Chicken')
ORDER BY Product_Name)
AND ns_product_data.Animal_Type = 'Dog' AND Grain_Free = 'Yes' AND ns_product_data.Product_Type = 'Dry'
AND ns_product_data.Formula_No NOT LIKE '%FT'
AND Ash IS NOT NULL
AND Calcium IS NOT NULL
AND Max_Fiber IS NOT NULL
AND Min_Fat IS NOT NULL
AND Min_Protein IS NOT NULL
AND Phosphorus IS NOT NULL
AND Potassium IS NOT NULL
AND Sodium IS NOT NULL
AND ns_product_data.Product_Name NOT LIKE '%Tuffy%'
GROUP BY Formula_No
ORDER BY Product_Name ASC |
Animal_Type = Dog
Grain_Free = Yes
Product_Type = Dry
|
|
Chicken |
2024-12-14 11:58:27 |
| 31633 |
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 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
Product_Type = Dry
|
|
|
2024-12-14 11:07:14 |
| 31632 |
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
WHERE Ing_Class IN ('Corn', 'Lamb', 'Pork', 'Rice', 'Sweet Potato', 'Wheat')
ORDER BY Product_Name)
AND 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%'
GROUP BY Formula_No
ORDER BY Product_Name ASC |
Animal_Type = Dog
Grain_Free = Yes
Kibble_Size = Large Breed Adult
Product_Type = Dry
|
|
Corn, Lamb, Pork, Rice, Sweet Potato, Wheat |
2024-12-14 10:52:50 |
| 31631 |
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
|
|
|
2024-12-14 10:51:18 |
| 31630 |
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
WHERE Ing_Class IN ('Chicken', 'Lamb', 'Salmon')
ORDER BY Product_Name)
AND ns_product_data.Animal_Type = 'Dog' AND Kibble_Size = 'Standard Adult' AND ns_product_data.Product_Type = 'Dry'
AND ns_product_data.Formula_No NOT LIKE '%FT'
AND Ash IS NOT NULL
AND Calcium IS NOT NULL
AND Max_Fiber IS NOT NULL
AND Min_Fat IS NOT NULL
AND Min_Protein IS NOT NULL
AND Phosphorus IS NOT NULL
AND Potassium IS NOT NULL
AND Sodium IS NOT NULL
AND ns_product_data.Product_Name NOT LIKE '%Tuffy%'
GROUP BY Formula_No
ORDER BY Product_Name ASC |
Animal_Type = Dog
Kibble_Size = Standard Adult
Product_Type = Dry
|
|
Chicken, Lamb, Salmon |
2024-12-14 10:34:23 |
| 31629 |
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
WHERE Ing_Class IN ('Chicken', 'Lamb', 'Salmon')
ORDER BY Product_Name)
AND ns_product_data.Animal_Type = 'Dog' AND Kibble_Size = 'Large Breed Adult' AND ns_product_data.Product_Type = 'Dry'
AND ns_product_data.Formula_No 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
Kibble_Size = Large Breed Adult
Product_Type = Dry
|
|
Chicken, Lamb, Salmon |
2024-12-14 10:34:11 |
| 31628 |
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 = '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
Kibble_Size = Large Breed Adult
Product_Type = Dry
|
|
|
2024-12-14 10:33:24 |
| 31627 |
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 = '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
Grain_Free = Yes
Product_Type = Dry
|
|
|
2024-12-14 10:17:57 |
| 31626 |
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.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
|
|
|
2024-12-14 10:17:52 |
| 31625 |
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 = '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
Grain_Free = Yes
Product_Type = Dry
|
|
|
2024-12-14 08:25:05 |
| 31624 |
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
WHERE Ing_Class IN ('Chicken', 'Lamb')
ORDER BY Product_Name)
AND 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%'
GROUP BY Formula_No
ORDER BY Product_Name ASC |
Animal_Type = Dog
Grain_Free = Yes
Kibble_Size = Standard Adult
Product_Type = Dry
|
|
Chicken, Lamb |
2024-12-14 00:53:06 |
| 31623 |
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
WHERE Ing_Class IN ('Chicken', 'Lamb', 'Salmon')
ORDER BY Product_Name)
AND 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%'
GROUP BY Formula_No
ORDER BY Product_Name ASC |
Animal_Type = Dog
Grain_Free = Yes
Kibble_Size = Standard Adult
Product_Type = Dry
|
|
Chicken, Lamb, Salmon |
2024-12-14 00:52:53 |
| 31622 |
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
|
|
|
2024-12-14 00:50:07 |
| 31621 |
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.200000 AND Min_Fat <= 0.250000
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.200000
Min_Fat <= 0.250000
|
|
2024-12-14 00:49:31 |
| 31620 |
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
|
|
|
2024-12-14 00:34:14 |
| 31619 |
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
|
|
|
2024-12-14 00:12:20 |
| 31618 |
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
|
|
|
2024-12-13 23:14:24 |
| 31617 |
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
|
|
|
2024-12-13 21:55:03 |
| 31616 |
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
|
|
|
2024-12-13 21:51:58 |
| 31615 |
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
|
|
|
2024-12-13 21:51:02 |
| 31614 |
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
|
|
|
2024-12-13 20:59:01 |
| 31613 |
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
WHERE Ing_Class IN ('Chicken', 'Chickpeas', 'Corn', 'Lentils', 'Peas')
ORDER BY Product_Name)
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
|
|
Chicken, Chickpeas, Corn, Lentils, Peas |
2024-12-13 20:18:01 |
| 31612 |
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
|
|
|
2024-12-13 20:15:57 |
| 31611 |
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
|
|
|
2024-12-13 19:04:03 |
| 31610 |
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
|
|
|
2024-12-13 18:27:47 |
| 31609 |
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 Min_Protein >= 0.230000 AND Min_Protein <= 0.290000
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
|
Min_Protein >= 0.230000
Min_Protein <= 0.290000
|
|
2024-12-13 18:17:07 |
| 31608 |
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 = '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
Product_Type = Cans
|
|
|
2024-12-13 17:26:15 |
| 31607 |
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.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
|
|
|
2024-12-13 17:25:32 |
| 31606 |
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
WHERE Ing_Class IN ('Chicken', 'Chickpeas', 'Lentils')
ORDER BY Product_Name)
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
|
|
Chicken, Chickpeas, Lentils |
2024-12-13 16:43:21 |
| 31605 |
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 Min_Protein >= 0.280000
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
|
Min_Protein >= 0.280000
|
|
2024-12-13 16:42:40 |
| 31604 |
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
|
|
|
2024-12-13 16:36:25 |
| 31603 |
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
|
|
|
2024-12-13 16:33:32 |
| 31602 |
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 = 'Senior' AND Min_Protein >= 0.150000 AND Min_Protein <= 0.260000
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 = Senior
|
Min_Protein >= 0.150000
Min_Protein <= 0.260000
|
|
2024-12-13 16:33:28 |
| 31601 |
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 Min_Protein >= 0.150000 AND Min_Protein <= 0.260000
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
|
Min_Protein >= 0.150000
Min_Protein <= 0.260000
|
|
2024-12-13 16:32:48 |
| 31600 |
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 = 'Senior'
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 = Senior
|
|
|
2024-12-13 15:34:26 |
| 31599 |
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
|
|
|
2024-12-13 14:53:28 |
| 31598 |
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.050000 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.050000
Min_Fat <= 0.100000
|
|
2024-12-13 14:39:42 |
| 31597 |
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
|
|
|
2024-12-13 11:59:16 |
| 31596 |
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
|
|
|
2024-12-13 11:35:23 |
| 31595 |
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 Min_Protein >= 0.300000 AND Min_Protein <= 0.400000
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
|
Min_Protein >= 0.300000
Min_Protein <= 0.400000
|
|
2024-12-13 10:56:39 |
| 31594 |
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
|
|
|
2024-12-13 10:47:06 |
| 31593 |
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
|
|
|
2024-12-13 10:44:52 |
| 31592 |
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
WHERE Ing_Class IN ('Chicken')
ORDER BY Product_Name)
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
|
|
Chicken |
2024-12-13 10:44:46 |
| 31591 |
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 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
|
|
|
2024-12-13 10:44:40 |
| 31590 |
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
WHERE Ing_Class IN ('Corn', 'Soy', 'Wheat')
ORDER BY Product_Name)
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
|
|
Corn, Soy, Wheat |
2024-12-13 10:43:03 |
| 31589 |
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 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
|
|
|
2024-12-13 10:42:42 |
| 31588 |
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
|
|
|
2024-12-13 10:40:53 |
| 31587 |
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
|
|
|
2024-12-13 10:40:28 |
| 31586 |
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
WHERE Ing_Class IN ('Chicken')
ORDER BY Product_Name)
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
|
|
Chicken |
2024-12-13 10:37:42 |
| 31585 |
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
|
|
|
2024-12-13 10:36:35 |
| 31584 |
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
|
|
|
2024-12-13 10:28:19 |
| 31583 |
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
|
|
|
2024-12-13 08:43:41 |
| 31582 |
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
WHERE Ing_Class IN ('Beef', 'Chicken', 'Lamb', 'Turkey', 'Venison')
ORDER BY Product_Name)
AND ns_product_data.Animal_Type = 'Dog'
AND ns_product_data.Formula_No NOT LIKE '%FT'
AND Ash IS NOT NULL
AND Calcium IS NOT NULL
AND Max_Fiber IS NOT NULL
AND Min_Fat IS NOT NULL
AND Min_Protein IS NOT NULL
AND Phosphorus IS NOT NULL
AND Potassium IS NOT NULL
AND Sodium IS NOT NULL
AND ns_product_data.Product_Name NOT LIKE '%Tuffy%'
GROUP BY Formula_No
ORDER BY Product_Name ASC |
Animal_Type = Dog
|
|
Beef, Chicken, Lamb, Turkey, Venison |
2024-12-13 07:47:55 |
| 31581 |
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 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
Product_Type = Dry
|
|
|
2024-12-13 07:41:19 |
| 31580 |
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
WHERE Ing_Class IN ('Beef', 'Chicken', 'Lamb', 'Turkey', 'Venison')
ORDER BY Product_Name)
AND ns_product_data.Animal_Type = 'Dog'
AND ns_product_data.Formula_No NOT LIKE '%FT'
AND Ash IS NOT NULL
AND Calcium IS NOT NULL
AND Max_Fiber IS NOT NULL
AND Min_Fat IS NOT NULL
AND Min_Protein IS NOT NULL
AND Phosphorus IS NOT NULL
AND Potassium IS NOT NULL
AND Sodium IS NOT NULL
AND ns_product_data.Product_Name NOT LIKE '%Tuffy%'
GROUP BY Formula_No
ORDER BY Product_Name ASC |
Animal_Type = Dog
|
|
Beef, Chicken, Lamb, Turkey, Venison |
2024-12-13 07:41:10 |
| 31579 |
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 |
Animal_Type = Dog
Grain_Free = No
Kibble_Size = Puppy
Product_Type = Dry
|
|
|
2024-12-13 07:15:39 |
| 31578 |
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
|
|
|
2024-12-13 04:37:49 |
| 31577 |
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
WHERE Ing_Class IN ('Kangaroo', 'Tomato Pomace')
ORDER BY Product_Name)
AND 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%'
GROUP BY Formula_No
ORDER BY Product_Name ASC |
Animal_Type = Cat
Product_Type = Dry
|
|
Kangaroo, Tomato Pomace |
2024-12-13 03:35:46 |
| 31576 |
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
WHERE Ing_Class IN ('Pork')
ORDER BY Product_Name)
AND 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%'
GROUP BY Formula_No
ORDER BY Product_Name ASC |
Animal_Type = Cat
Product_Type = Dry
|
|
Pork |
2024-12-13 03:35:11 |
| 31575 |
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
WHERE Ing_Class IN ('Pork')
ORDER BY Product_Name)
AND 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%'
GROUP BY Formula_No
ORDER BY Product_Name ASC |
Animal_Type = Cat
Product_Type = Dry
|
|
Pork |
2024-12-13 03:34:37 |
| 31574 |
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
|
|
|
2024-12-13 03:33:12 |
| 31573 |
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
WHERE Ing_Class IN ('Kangaroo', 'Tomato Pomace')
ORDER BY Product_Name)
AND 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%'
GROUP BY Formula_No
ORDER BY Product_Name ASC |
Animal_Type = Cat
Product_Type = Dry
|
|
Kangaroo, Tomato Pomace |
2024-12-13 02:42:22 |
| 31572 |
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.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
|
|
|
2024-12-13 02:35:57 |
| 31571 |
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.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
|
|
|
2024-12-13 02:34:40 |
| 31570 |
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
|
|
|
2024-12-13 02:34:34 |
| 31569 |
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.015000
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.015000
|
|
2024-12-13 01:26:29 |
| 31568 |
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
|
|
|
2024-12-13 01:22:50 |
| 31567 |
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.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
|
|
|
2024-12-13 01:22:42 |
| 31566 |
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
|
|
|
2024-12-13 01:14:42 |
| 31565 |
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
|
|
|
2024-12-13 01:14:34 |
| 31564 |
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.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
|
|
|
2024-12-13 01:13:50 |
| 31563 |
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 = 'Element' 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 = Element
Product_Type = Dry
|
|
|
2024-12-13 01:11:55 |
| 31562 |
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.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
|
|
|
2024-12-12 23:04:08 |
| 31561 |
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
|
|
|
2024-12-12 21:30:45 |
| 31560 |
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
|
|
|
2024-12-12 21:30:35 |
| 31559 |
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
|
|
|
2024-12-12 21:09:15 |
| 31558 |
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
|
|
|
2024-12-12 21:08:55 |
| 31557 |
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
WHERE Ing_Class IN ('Apple', 'Apple Cider Vinegar', 'Beef', 'Lamb', 'Peanut', 'Peas', 'Sunflower', 'Wheat')
ORDER BY Product_Name)
AND ns_product_data.Animal_Type = 'Dog' AND Kibble_Size = 'Standard Adult' AND ns_product_data.Product_Type = 'Dry'
AND ns_product_data.Formula_No NOT LIKE '%FT'
AND Ash IS NOT NULL
AND Calcium IS NOT NULL
AND Max_Fiber IS NOT NULL
AND Min_Fat IS NOT NULL
AND Min_Protein IS NOT NULL
AND Phosphorus IS NOT NULL
AND Potassium IS NOT NULL
AND Sodium IS NOT NULL
AND ns_product_data.Product_Name NOT LIKE '%Tuffy%'
GROUP BY Formula_No
ORDER BY Product_Name ASC |
Animal_Type = Dog
Kibble_Size = Standard Adult
Product_Type = Dry
|
|
Apple, Apple Cider Vinegar, Beef, Lamb, Peanut, Peas, Sunflower, Wheat |
2024-12-12 20:56:05 |
| 31556 |
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
|
|
|
2024-12-12 19:57:45 |
| 31555 |
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
|
|
|
2024-12-12 17:38:20 |
| 31554 |
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
|
|
|
2024-12-12 17:29:57 |
| 31553 |
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
|
|
|
2024-12-12 15:36:40 |
| 31552 |
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
|
|
|
2024-12-12 14:20:02 |
EN 
ES 
FR