Go back to John Temple Gallery home page Image Gallery Special Exhibition New Images Send Free Post Card Contact us and gallery location About John Temple
images/CollectionsBanner.jpg
  John Temple Gallery » Collections My Account  |  Cart Contents  |  Checkout   
What's New? more
Snowy River and Mount Kosciuszko
Snowy River and Mount Kosciuszko
Search for images
 

Search Limited Edition prints only
Advanced Search
Information
Shipping & Returns
Privacy Notice
Conditions of Use
Contact Us
Collections
Bridges
Bridges
Cities
Cities
Coastal
Coastal
High Country
High Country
Historic Places
Historic Places
Islands
Islands
Lakes
Lakes
Mountains
Mountains
National Parks
National Parks
Rivers
Rivers
Rural
Rural
Waterfalls
Waterfalls
New Images For August
3065 - Expression #1 of ORDER BY clause is not in SELECT list, references column 'johntemp_jtgdb.p.products_date_added' which is not in SELECT list; this is incompatible with DISTINCT

select distinct p.products_id, p.products_image, p.products_image_thumbnail, p.products_tax_class_id, pd.products_name, if(s.status, s.specials_new_products_price, p.products_price) as products_price from products p left join specials s on p.products_id = s.products_id, products_description pd, products_to_categories p2c, categories c where p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and c.parent_id = '26' and p.products_status = '1' and p.products_id = pd.products_id and pd.language_id = '1' order by p.products_date_added desc limit 9

[TEP STOP]