0 items

Welcome to Jangoz Petworld - Online Pet Store

Jangoz Petworld is all about offering fellow pet owners high quality pet products from the best manufacturers in the industry at great affordable prices.

Owning a pet should also be about fun so we specialise in a great range of toys and treats for your dogs and cats, but we also range a selection of the other products you will need to take of your pet.

Featured Products
3065 - Expression #2 of ORDER BY clause is not in SELECT list, references column 'jangoz_store.p.products_date_added' which is not in SELECT list; this is incompatible with DISTINCT

select distinct p.products_image, p.products_id, pd.products_name, p.products_image from products p, products_description pd, featured f where p.products_status = '1' and f.status = '1' and p.products_id = f.products_id and pd.products_id = f.products_id and pd.language_id = '1' order by rand(),p.products_date_added DESC, pd.products_name limit 6