1 SELECT * FROM
prod_custom_variables_prodno PRCV,
prod_custom_variables VARS
WHERE
VARS.pch_id=PRCV.pcp_parent_id
AND
PRCV.pcp_custom_jiwa_status='0'
AND
pcp_custom_jiwa_number <> ''
AND
(
pcp_prod_no='p65e6d1dac55c0942624686' )
ORDER BY
PRCV.pcp_is_default DESC,
VARS.pch_rank ASC 221 /home/abuco/ABU_SHOP/USER_FOLDERS/salce.com.au/templates/sub_tmpl/salce_res_sub_tmpl.php
Category
NONE
Pet Food Range A - Z
- - - - Cat Food And Supplies
- - - - - - Kitten
- - - - - - Adult Cat
- - - - - - Cat Litter
- - - - - - Cat Health
- - - - Dog Food And Supplies
- - - - - - Puppy
- - - - - - Adult Dog
- - - - - - Senior Dog
- - - - - - Dog Health
- - - - Poultry Feed
- - - - Animal Health
- - - - - - Parasite Control
- - - - - - Pet Treats
- - - - - - Animal Supplements
- - - - - - General Animal Health
- - - - Bird Feed Pro-Vit-Min
- - - - Horse Feed and Supplies
- - - - Accessories
- - - - Misc Pets
- - - - - - Rabbit-Guinea Pig
Livestock Supplies
Fertilisers
Pro-Vit-Min
Garden And Farm
Miscellaneous
Grains
Pest Control
Brand Name
ADVANCE
ADVANTAGE
ADVOCATE
ALKA PELLET PLUS
ANITONE
AUS ORGANIC
AUSSIE PET COMFORT
AVIONE
AVIONE PASSWELL
AVIONE PASSWELL
BAGABALE
BALANCED LIFE
BARASTOC
BAYER
BETADINE
BIG L
BLACK DOG
BLACK HAWK
BLACKDOG
BRAVECTO
BREEDERS CHOICE
BREWERS YEAST
BROMAKIL
CAMPBELLS
CATS CHOICE
CATSAN
CEMENT AUSTRALIA
CEN NUTRITION
CEVA
CHOOKS
CHUM
COBBER
COOPERS
COPRAMEAL
COPRICE
COUNTRY HERITAGE
DELTA
DEMCARE
DI- VETELACT
DIAE
DINE
DOG ROCKS
DOWNES RICE HULLS
DYNAVYTE
ECOPET
ENERGREEN
EQUILIBRIUM
EQUINADE
ERAQUELL
EUKANUBA
EUKANUBA
EUREKA
FANCY FEAST
FEEDERS AND DRINKERS
FEL EUR
FELIX
FIBRECYCLE
FIDO
FRISKIES
FRONTLINE
FURNEY
GIDDY UP
GRANNY REILLY
GREENIES
GROUP 1 FEEDS
HEART & SOUL
HILLS SCIENCE DIET
HORSEMATE
HORSEPOWER
HUMAVYTE
HYGAIN
HYPRO
HYPRO PREMIUM
INCA
INCITEC PIVOT
INTERNATIONAL ANIMAL HEALTH
IRON HORSE
IRONCYCLEN
IVORY COAT
JAMES & SON
JENS
JOHNSONS
JOSEPH LYDDY
KENTUCKY EQUINE RESEARCH
KOHNKES
KOOL GLOW
LAUCKE
LIDGERWOOD
LIVAMOL
LIXIT
MARIOS MUFFINS
MATE
MAVLAB
MC MAHON
MEALS FOR MEOWS
MEALS FOR MUTTS
MECWORMA
MEDTRACOS
MISC
MITAVITE
MUDGEE
MUIRS
MULTICUBE
MY DOG
NATTY CAT
NATURES GIFT
NEATSFOOT
NEUTRADEX
NRG
NUFARM
NUTRO
OLSSON
OMEGA
OMYACARB
OPTIMUM
OXBOW
OZ-PET
PASSWELL
PEDIGREE
PERRYS
PET RITE
PETER GIBBS
PETERS
PINDONE
POPE
POSEIDON
PRIME
PRIME 100
PRO PLAN
PRO-VIT-MIN
PROFELAC
PROTEIN MEAL
PROTEXIN
PRYDES
PURINA
RANVET
RAPIDVITE
RATSAK
REDOX
REID STOCKFEEDS
RELAX NUTRITION
RIDLEY
ROYAL CANIN
RUDDUCKS
SALTCO
SASHA'S BLEND
SCENEYS
SCHMACKOS
SENTINEL
SERESTO
SHOOF
SHOWMASTER
SOUTHERN CROSS FEEDS
STANCE EQUITEC
STOCKHOLM
STOCKMAN & PADDOCK
STRAW
SUPERCOAT
SUPERIOR PET GOODS
SUPERVITE
SUPPLEMENTS
SYNGENTA
TASTE OF THE WILD
TEATS
TERRA FIRMA
TOMCAT
TROUBLE & TRIX
UPL
VETOQUINOL
VETS ALL NATURAL
VETSENSE
VIRBAC
VITAGRAN
WHISKAS
WINNING EDGE
WOMBAROO
WSD AGRIBUSINESS
YATES
General Animal Health
FIBRECYCLE
FIBRECYCLE BACK 2 NATURE SMALL ANIMAL BEDDING 30LT