SELECT,p.product_id, p.product_name as name, p.product_short_description, p.product_description, p.dimensions, p.custom_spec,, p.is_live, p.is_new, p.lm_collection, p.sample_sale,, pi.image_file FROM products as p, products_to_categories as ptc, product_images as pi WHERE AND pi.product_id = AND pi.sort_order = 0 AND p.is_live='1' AND p.archive='0' AND pi.image_file!='' AND ptc.category_id= 13 ORDER by ptc.order ASC Lorin Marsh | Furniture | Consoles and Credenzas


Sign Up for Lorin Marsh Updates

All fields are required.

Lorin Marsh Thank You

Thank you
for signing up