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
)
)
Australian Dairy Foods
In this issue:
2018 DIAA Awards of Excellence
Market Report: Signs of improvement
Raw milk: Consumer choice or pathogen cocktail?
2018 DIAA Victorian Conference report
2018 DIAA Victorian Dairy Product Awards
DIAA competitions: Making sense of judges' feedback
Whey protein: From waste to value
Labelling with food waste in mind
Is that ice-cream in your hair?: 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)
Add to Cart
In this issue:
2018 DIAA WA Dairy Product Awards
Striking the right balance a challenge: Market Report
Cheesemaking with a side of chill: Coldstream Dairy
Small cheese factory equipment must-haves
Packaging re-design done right
Sugar: enemy or opportunity?
Five types of problem employees and how to handle them in style
Medal detection vs X-ray inspection:which is better for dairy foods?
Cheese, tea and social media 'techlash': 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)
Add to Cart
In this issue:
2018 Australian Grand Dairy Awards
Blockchain - an agricultural revolution waiting to happen?
Passion for Alpine cheeses is catching on for Section 28
Food trends coming our way in 2018
Memberane material in milk - what is it good for, anyway
World Dairy Summit highlights common challenges and solutions
Dairy product basics for an ageing consumer base
Packaging design with age in mind
The wisdom of the crowd: 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)
Add to Cart
In this issue:
Lingering uncetainty here and abroad: Market Report
Robotic dairy leads to opportunities: 4Real Milk and Scenic Rim Dairy
How do disrupt Australia's dairy industry
Raw milk 'terroir' without the risk
How to get prospects to take the first step and connect with you online
Seasonal packaging - waste or opportunity?
Termination of employment: when is it good to lack initiative?
Parmesan and other 'first world problems': 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)
Add to Cart
In this issue:
2017 DIAA NSW Dairy Product Competition Results
2017 SA Dairy Product Competition Results
Relatively quiet, but not all equal: Market Report
Business model works brand wonders: Tasmanian Food Co
Commond ground for the big and the small: 2017 DIAA NSW Conference
Extended shelf life (ESL) milk explained
Use your website and email to get business referrals
Is there a place for information-driven manufacturing in dairy?
Serious tech for products of the future: 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)
Add to Cart
In this issue:
2017 DIAA QLD Dairy Product Competition Results
Farmer confidence, milk volumes down: Market Report
Udder Delights' Divine organic partnership
Working for a stronger 'Brand Tasmania': 2017 DIAA Tasmanian Conference
Northern dairy industry in focus: 2017 DIAA Qld Conference
Are you ready for your 'nightmare crisis' scenario?
Boost your career and business with an e-ttractive online image
The ultimate checkilist to optimise your dairy packaging and supply chain
2017 ADF Reader Survey results
Celebrating failure, one flop at a time: 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)
Add to Cart
In this issue:
2017 Awards of Excellence
Dare to dairy: notes from the IDF World Dairy Summit
Behind the scenes at the 2017 DIAA Australian Dairy Product Competition
Dairying today and into the future: 2017 DIAA Victorian Conference
2017 DIAA Victorian Dairy Product Awards
How to build an e-ttractive online brand
The real cost of unreliable equipment
Laundry for cooking, oven for drying?: 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)
Add to Cart
In this issue:
2017 DIAA WA Dairy Product Awards
How consumer trends have influenced dairy packaging
Perth's Gelatino changes tack
ChAFTA's key outcomes for Australia
SWOT-analyse yourself to a better job
How to keep an eye on staff communication without being a Yahoo
Beer o'clock on a cheese watch: 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)
Add to Cart
In this issue:
2017 Australian Grand Dairy Awards
Big food trends for the year ahead
Ice-cream, but not as you know it
Getting it right at the 2017 DIAA Dairy Product Competitions
Unstoppable progress: Industry 4.0
Little baby cheeses are coming next Christmas: 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)
Add to Cart
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)
Add to Cart
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)
Add to Cart
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)
Add to Cart
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)
Add to Cart
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)
Add to Cart
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)
Add to Cart