My Account
Log In
Log Out
Create An Account


Train Universe | Lionel Trains | Discount Trains
MrToys.com LLC DBA TrainUniverse.com
973-551-1429
Email: sales@mrtoys.com
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.
1021 - Disk full (/tmp/#sql_1e3c_52.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")

select distinct p.products_id, p.products_image, p.products_model, p.products_quantity, p.products_weight, pd.products_name, p.manufacturers_id, IF(pg.customers_group_price IS NOT NULL, pg.customers_group_price, p.products_price) as products_price, p.products_date_added, IF(s.status = 1, s.specials_new_products_price, NULL) as final_price, m.manufacturers_name, pd.products_description, cd.categories_name, p.products_tax_class_id, p2c.categories_id from products_description pd left join products_groups pg on pg.products_id = pd.products_id and pg.customers_group_id = '0', products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id left join specials s on p.products_id = s.products_id and s.customers_group_id = '0', products_to_categories p2c left join categories_description cd on p2c.categories_id = cd.categories_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' and cd.language_id = '1' order by cd.categories_name, pd.products_name

[TEP STOP]

 
 
Image
Sort Asending
Sort Desending
Name
Sort Asending
Sort Desending
Category
Sort Asending
Sort Desending
Model
Sort Asending
Sort Desending
Price