MEMBER HOTLINE    03 8742 6600

twitterfacebookinstagramlinkedin

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 2014

ADF October 2014

 

In this issue:

  • 2014 DIAA SA and Qld Dairy Product Awards
  • Who are the raw milk consumers?
  • The end of performance reviews as we know them
  • Latest ice-cream trends from the US
  • Gelato Messina is expanding overseas
  • What is the big deal with this ice-cream?: Final Washup
Also in the issue the latest news, events, research, people movements and more!

$25.00 Ex Tax: $22.73

Price: $25.00 (inc. GST)
ADF August 2014

ADF August 2014

 

In this issue:

  • 2014 DIAA NSW Dairy Product Awards
  • Rind Farming: The art and science of affinage
  • 2014 DIAA Tasmanian Conference
  • Australia's dairy leads in sustainability
  • 2014 DIAA NSW Conference
  • Don't be overwhelmed by 'overwhelm'
  • Get behind the barcode, Satan!: Final Washup
Also in the issue the latest news, events, research, people movements and more!

$25.00 Ex Tax: $22.73

Price: $25.00 (inc. GST)
ADF June 2014

ADF June 2014

 

In this issue:

  • 2014 Awards of Excellence
  • 2014 DIAA WA Dairy Product Awards
  • Opportunities for dairy innovation: omega 3, protein, ancient grains
  • 2014 DIAA Victorian Division Conference
  • 2014 DIAA Victorian Dairy Awards
  • IDF Symposia in Melbourne
  • Enter the Courage Zone
  • UV disinfection as a bio-security tool
  • Sweet ice-cream music and camel milk: Final Washup
Also in the issue the latest news, events, research, people movements and more!

$25.00 Ex Tax: $22.73

Price: $25.00 (inc. GST)
ADF April 2014

ADF April 2014

 

In this issue:

  • Harry & Larry's ice-cream 'dream team'
  • Global trends for dairy products
  • Infant nutrition science vs marketing
  • Notes from the IDF Summit in Japan
  • Get stress under control
  • Don't eat yellow snow, unless it's cheese: Final Washup
Also in the issue the latest news, events, research, people movements and more!

$25.00 Ex Tax: $22.73

Price: $25.00 (inc. GST)
ADF February 2014

ADF February 2014

 

In this issue:

  • 2014 Australian Grand Dairy Awards results
  • What consumers want in 2014
  • Tips and tricks to get competition gold
  • The importance of clean raw milk
  • Co-generate some efficiencies
  • Jellyfish ice-cream, belly button cheese: Final Washup
Also in the issue the latest news, events, research, people movements and more!

$25.00 Ex Tax: $22.73

Price: $25.00 (inc. GST)
ADF December 2013

ADF December 2013

 

In this issue:

  • The world of gelato comes to Melbourne
  • 2013 Royal Melbourne and Royal Perth Show results
  • Dairy and Health - the vital connection
  • Fruity and plain are the flavours of choice in yogurt
  • Cheddar research back then, today and into the future
  • Finally, perfect cheese on toast: Final Washup
Also in the issue the latest news, events, research, people movements and more!

$25.00 Ex Tax: $22.73

Price: $25.00 (inc. GST)
ADF October 2013

ADF October 2013

In this issue:

  • 2013 DIAA Queensland Dairy Product Awards
  • 2013 South Australian Dairy Product Awards
  • Bulla's $6.5 million enviromental upgrade
  • Hazard blindspots - don't risk your business
  • Why you should never check email first thing in the morning
  • Farewell to one of dairy industry's brightest
  • Impulsive? Idealist? You must be vanilla: Final Washup
Also in the issue the latest news, events, research, people movements and more!

$25.00 Ex Tax: $22.73

Price: $25.00 (inc. GST)
ADF August 2013

ADF August 2013

In this issue:

  • The state of Australian dairy retail
  • DIAA Tasmanian Conference
  • 2013 DIAA NSW Dairy Product Awards
  • Nut-based beverages compete with dairy
  • Aflatoxins - a growing problem
  • Social media crises managed
  • Got hype? Zits, riots, brogurt & stiff drinks: Final Washup
Also in the issue the latest news, events, research, people movements and more!

$25.00 Ex Tax: $22.73

Price: $25.00 (inc. GST)
ADF June 2013

ADF June 2013

In this issue:

  • 2013 Awards of Excellence
  • DIAA Victorian Conference
  • 2013 DIAA Victorian Dairy Product Awards
  • Pepe Saya Butter
  • Safety in colours - colour-coding your brushware
  • Long legacy of Australian butter research
  • The ugly, the bad and the good: Final Washup
Also in the issue the latest news, events, research, people movements and more!

$25.00 Ex Tax: $22.73

Price: $25.00 (inc. GST)
ADF April 2013

ADF April 2013

In this issue:

  • The story of Goodness Me gelateria
  • World Dairy Summit round-up
  • Grandvewe's thistle-ripened cheese
  • How to plan for a crisis
  • Global opportunities for Australia’s agriculture: Report
  • Milk, movies, moguls and Nobel prizes: Final Washup
Also in the issue the latest news, events, research, people movements and more!

$25.00 Ex Tax: $22.73

Price: $25.00 (inc. GST)
ADF February 2013

ADF February 2013

In this issue:

  • 2013 Australian Grand Dairy Awards results
  • La Casa Del Formaggio profile
  • Brand names that won't trigger law suits
  • Tips and tricks to win gold in technical dairy competitions
  • Keep Listeria under control with the latest research
  • 'Clumpy mozzarella' is world's first cheese?
Also in the issue the latest news, events, research, people movements and more!

$25.00 Ex Tax: $22.73

Price: $25.00 (inc. GST)
ADF December 2012

ADF December 2012

In this issue:

  • Tasmania's Wicked Cheese
  • Turning staff surveys into action
  • The promise of stevia
  • Raw milk under the microscope
  • Pick the right electric motor for the job
  • Farewell to Bob Irvine, dairy industry pioneer
Also in the issue the latest news, events, research, people movements and more!

$25.00 Ex Tax: $22.73

Price: $25.00 (inc. GST)
ADF October 2012

ADF October 2012

In this issue:

  • 2012 South Australian Dairy Product Awards
  • Olympus Cheese story
  • Milk Foamability - what affects it
  • Seven deadly website sins
  • Lactose-free products on the up
Also in the issue the latest news, events, research, people movements and more!

$25.00 Ex Tax: $22.73

Price: $25.00 (inc. GST)
ADF August 2012

ADF August 2012

In this issue:

  • DIAA Qld and NSW Dairy Product Awards
  • DIAA Conference Round-up: Tasmania, Qld and NSW
  • Grandvewe Cheese company profile
  • Effective Listeria defence
  • Ten ‘golden rules’ of product development
Also in the issue the latest news, events, research, people movements and more!

$25.00 Ex Tax: $22.73

Price: $25.00 (inc. GST)
ADF June 2012

ADF June 2012

In this issue:

  • 2012 Awards of Excellence
  • DIAA WA Dairy Product Awards
  • 2012 DIAA Victorian Conference and Dairy Product Awards
  • Measure your energy use to save - lessons from Tatura's Meterman Project
  • Mundella Foods - WA's yogurt powerhouse
  • Brave new world of cheese - Neal's Yard Dairy's Jason Hinds
  • Dairy ingredients news from CalPoly Symposium
  • Australia's 'Drumstick' man - Derek Shew
Also in the issue the latest news, events, research, people movements and more!

$25.00 Ex Tax: $22.73

Price: $25.00 (inc. GST)
No Internet Connection