Australian Dairy Foods

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

Australian Dairy Foods

ADF December 2016

In this issue:

Milk flow balance critical to achieve: Market report
Brave new world for inner city milk: Saint David Dairy
Five ways to raise your HR standards
Y the Millennials are changing the face of packaging
Factory water treatment basics
Stilton: Uncrowned king of English cheese
Hang in there, hungover friend: 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 2016

In this issue:

2016 DIAA Qld Dairy Product Awards
2016 SA Dairy Product Awards
The Dairy Report: Snow Brand Australia
2016 DIAA Qld Conference
Mind the laws when exporting to China
Break the dairy commodity mindset with technology
Calling all gastronauts and supertasters: 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 2016

In this issue:

2016 DIAA NSW Dairy Product Awards
The Dairy Report: Brownes Dairy' marketing hat trick
2016 DIAA Tasmanian Conference
2016 DIAA NSW Conference
Shifting views on the over-50 employees
Dairy food inspection technologies
Godly butter, saintly TV, heavenly whey: 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 2016

In this issue:

2016 DIAA Awards of Excellence
The Dairy Report: Bannister Downs Dairy
2016 DIAA Victorian Conference
2016 DIAA Victorian Dairy Awards
Want to open a petting zoo? Read this first!
Best blue in the world: Berrys Creek Cheese
Theories, hypotheses and dairy 'crack': 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 2016

In this issue:

2016 DIAA WA Dairy Product Awards results
The Dairy Report: Cambray Sheep Cheese
Frills and thrills: Bonuses that deliver
Raise your glasses to drinking yoghurts: Global report
Is your retail milk supply agreement sound?
Divide and conquer or sell together?
Packaging that mitigates risk and builds trust
Judgement day - chewing the fat: 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 2016

In this issue:

2016 Australian Grand Dairy Awards results
Top 10 dairy product trends for 2016
Neha's: Indian-inspired, Australian-made
Are you up for a little competition?: 2016 DIAA competition guide
Olive oil, black pepper, what's next: novel ice-cream flavours
Bigger, longer, sower, stranger dairy: 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 2015

In this issue:

Inside That's Amore's new factory
Highlights from the 2015 IDF Dairy Summit in Lithuania
The story behind Ruby & Roy's 'out of this world' yoghurt
Artisan Cheese Making Academy Australia: a profile
Natural gas as an efficient fuel alternative
Butter wouldn't melt for industrial design: 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 2015

In this issue:

2015 SA and Qld Dairy Product Awards
DIAA Queensland Division Conference Coverage
How Baskin-Robbins does winter
Cow and the Moon: The story behind the world's best gelato
10 ways HR can affect workplace safety
Inside Tasmania's Ashgrove Cheese
Golden Gaytime wins Facebook...maybe: 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 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

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

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

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

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

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

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)

Refine Search

Year

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
        )

)

Clear

Are you a
DIAA member?