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 August 2015

ADF August 2015

In this issue:

  • 2015 DIAA NSW Dairy Product Awards
  • DIAA Tasmanian Division Conference Coverage
  • DIAA NSW Division Conference Coverage
  • Brancourts: A new direction for dairy pedigree
  • Six steps to team motivation
  • Milk quality and dairy product shelf life
  • Be warned - the devil is in the (Jersey) 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 June 2015

ADF June 2015

In this issue:

  • 2015 DIAA Awards of Excellence
  • DIAA Victorian Division Conference Coverage
  • 2015 DIAA Victorian Dairy Product Awards
  • Bulla Dairy: new brand, new direction
  • Freezing not foolproof protection from pathogens
  • Can you legally refuse to hire a smoker?
  • Toasties, warm fuzzies and PMT cures: 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 2015

ADF April 2015

In this issue:

  • 2015 DIAA WA Dairy Product Awards
  • The story of Melbourne's Fritz Gelato
  • Friends with benefits, not FTAs in China
  • Know your enemy's DNA: Spore-formers
  • New Montague facility
  • Cheese as drink, art, culinary impossibility: 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 2015

ADF February 2015

In this issue:

  • 2015 Australian Grand Dairy Awards results
  • More milk matters: Rabobank report
  • Top ten food and drink trends for 2015
  • Latest whey research from the 7th World Whey Conference
  • Put your products to the test
  • 'Sleeping spoilers': spore-forming bacteria
  • World dairy records to beat
  • Pin-ups, donkeys, Hitler and creative beer: 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 2014

ADF December 2014

In this issue:

  • Udderly good news for dairy demand: IBISWorld Report
  • Dairy commodity bear market looms: Rabobank
  • Chilled coffee market on the up and up
  • Protein, concentrates and spray drying efficiency: Latest research
  • Creativity - is yours stifled by fear, conservatism and outsourcing?
  • Arcobacter butzleri - Underestimated and dangerous
  • Easy peasy Japanesey dairy innovations: 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 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)
No Internet Connection