2MCCTV.com       
  Home » Books » Printable Catalog Contact Us  | My Account  |  Cart Contents  |  Checkout   
www.kvisionbooks.com
13011 Dotty Avenue
Hawthorne, CA 90250
Email: sales@kvisionbooks.com
Phone: 1-866-98-BOOKS
Note: All prices are subject to change without notice. All products will be billed in our shop Currency only.
          The Currency feature is just for your convenience. This catalog is current on the day of printing.
1054 - Unknown column 'p.products_id' in 'on clause'

select p.products_id, p.products_image, p.products_model, pd.products_name, p.manufacturers_id, p.products_price, 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 from products_description pd, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_to_categories p2c left join specials s on p.products_id = s.products_id where p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '1' order by pd.products_name

[TEP STOP]

Image Products Author Price