MEMBER HOTLINE    03 8742 6600

twitterfacebookinstagramlinkedin

When you join the DIAA, you become part of the post-farmgate dairy industry's widest information network.

MEMBER HOTLINE: 03 8742 6600

Join DIAA

SELECT COUNT(*) c, p.product_id, (SELECT AVG(rating) AS total FROM #__mijoshop_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT price FROM #__mijoshop_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM #__mijoshop_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special FROM #__mijoshop_product_to_category p2c LEFT JOIN #__mijoshop_product p ON (p2c.product_id = p.product_id) LEFT JOIN #__mijoshop_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN #__mijoshop_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '20' GROUP BY p.product_id ORDER BY p.sort_order, p.product_id DESC, LCASE(pd.name) DESC
Array ( [0] => Array ( [filter_id] => 3 [name] => 2000 ) [1] => Array ( [filter_id] => 4 [name] => 2001 ) [2] => Array ( [filter_id] => 10 [name] => 2002 ) [3] => Array ( [filter_id] => 11 [name] => 2003 ) [4] => Array ( [filter_id] => 12 [name] => 2004 ) [5] => Array ( [filter_id] => 13 [name] => 2005 ) [6] => Array ( [filter_id] => 5 [name] => 2006 ) [7] => Array ( [filter_id] => 6 [name] => 2007 ) [8] => Array ( [filter_id] => 7 [name] => 2008 ) [9] => Array ( [filter_id] => 8 [name] => 2009 ) [10] => Array ( [filter_id] => 9 [name] => 2010 ) [11] => Array ( [filter_id] => 15 [name] => 2011 ) [12] => Array ( [filter_id] => 14 [name] => 2012 ) [13] => Array ( [filter_id] => 16 [name] => 2013 ) [14] => Array ( [filter_id] => 17 [name] => 2014 ) [15] => Array ( [filter_id] => 18 [name] => 2015 ) [16] => Array ( [filter_id] => 88 [name] => 2016 ) [17] => Array ( [filter_id] => 89 [name] => 2017 ) [18] => Array ( [filter_id] => 90 [name] => 2018 ) )
0 item(s) - $0.00

Australian Dairy Foods

ADF October 2003

ADF October 2003

$20.00 Ex Tax: $18.18

Price: $20.00 (inc. GST)
ADF August 2003

ADF August 2003

$20.00 Ex Tax: $18.18

Price: $20.00 (inc. GST)
ADF June 2003

ADF June 2003

$20.00 Ex Tax: $18.18

Price: $20.00 (inc. GST)
ADF April 2003

ADF April 2003

$20.00 Ex Tax: $18.18

Price: $20.00 (inc. GST)
ADF February 2003

ADF February 2003

$20.00 Ex Tax: $18.18

Price: $20.00 (inc. GST)
ADF December 2002

ADF December 2002

$20.00 Ex Tax: $18.18

Price: $20.00 (inc. GST)
ADF October 2002

ADF October 2002

$20.00 Ex Tax: $18.18

Price: $20.00 (inc. GST)
ADF August 2002

ADF August 2002

$20.00 Ex Tax: $18.18

Price: $20.00 (inc. GST)
ADF June 2002

ADF June 2002

$20.00 Ex Tax: $18.18

Price: $20.00 (inc. GST)
ADF April 2002

ADF April 2002

$20.00 Ex Tax: $18.18

Price: $20.00 (inc. GST)
ADF February 2002

ADF February 2002

$20.00 Ex Tax: $18.18

Price: $20.00 (inc. GST)
ADF December 2001

ADF December 2001

$20.00 Ex Tax: $18.18

Price: $20.00 (inc. GST)
ADF October 2001

ADF October 2001

$20.00 Ex Tax: $18.18

Price: $20.00 (inc. GST)
ADF August 2001

ADF August 2001

$20.00 Ex Tax: $18.18

Price: $20.00 (inc. GST)
ADF June 2001

ADF June 2001

$20.00 Ex Tax: $18.18

Price: $20.00 (inc. GST)