Westgate Fine Art

select p.products_image, p.products_quantity, pd.products_name, p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, if(s.status, s.specials_new_products_price, null) as specials_new_products_price, if(s.status, s.specials_new_products_price, p.products_price) as final_price, str_to_date(concat(pes_date.products_extra_fields_value, ' 2011'),'%b %d %y') as created_date, time_to_sec(time_format(left(pes_time.products_extra_fields_value, locate(' ',pes_time.products_extra_fields_value) ), '%l:%i %p')) as created_time, concat(pes_date.products_extra_fields_value, ' 2011') from (products p left join specials s on(s.products_id = p.products_id and s.status = 1) left join products_to_products_extra_fields pes_date on (pes_date.products_id = p.products_id and pes_date.products_extra_fields_id = 2) left join products_to_products_extra_fields pes_time on (pes_time.products_id = p.products_id and pes_time.products_extra_fields_id = 1) ) left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_description pd, products_to_categories p2c where p.products_status = 1 and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = 1 and p2c.categories_id = 2 order by created_date asc, created_time asc limit 0, 20