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:
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)
Add to Cart
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)
Add to Cart
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)
Add to Cart
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)
Add to Cart
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)
Add to Cart
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)
Add to Cart
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)
Add to Cart
In this issue:
2012 Australian Grand Dairy Awards
'Golden Age' of dairy not all it seems
Herve Mons - affineur extraordinaire visits Australia
Consumer law - a new playing field
Butter Factory Myrtleford company profile
Yogurt ad strikes the wrong chord
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:
What will consumers want in 2012?
That's Amore Cheese company profile
Packaging that sells
Mexican Express - lessons in value adding
Global food security blueprint
Lawrie Muller tribute
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:
Better whey to go at the 2012 whey protein conference
Whitches Chase Cheese Co makes cheese on top of the world
Dr Adnan Tamime - Fermented milk products have a future in Australia
What do competition judges look for?
Non-thermal alternatives to milk
Cheese is a risky business
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:
DIAA NSW Division Conference
Demand outstrips supply for Kytren Goat Cheese
Good governance - get your board working for you, not against you
Efficient air system design
Experience meets fresh ideas
New look for white milk
Good god, it must be the 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)
Add to Cart
In this issue:
DIAA Queensland Confernece
Western Australia's Casa Dairy
DIAA Tasmania Conference
Are private labels a 'necessary evil'?
Fingerprinting milk powder
Adrian Turton's contribution to dairy
High fashion, high in calcium
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:
2011 Awards of Excellence
DIAA Victorian Conference
Doug Goff talks all things ice-cream
Goat ice-cream? Yes, please. Caprilac company profile.
How to survive the home brand war
When is a trade mark not a trade mark?
Dairy murder most foul
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:
DIAA Dairy Product Competitions - tips and tricks
Bill's Farm - at the consumer 'frontlines'
Untangle the online marketing web
'It's a Deal!' for Yo-Get-It yogurt
Portable hydraulics - get the right pump for the job
Milk price war, who is it good for?
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:
The view from the IDF Summit
New year, new trends
China and India - Global dairy's giants begin to wake
Maleny Cheese - Swiss expertise, Aussie gold
Put your best booth forward at the next trade show
What's Italian for 'ice-cream'?
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