'); define('HEADING_TITLE', '
'.STORE_NAME.'
'.nl2br(STORE_NAME_ADDRESS).'
Email: '.STORE_OWNER_EMAIL_ADDRESS.'
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.
'); // comment the above line and uncomment out the line above it if you have an older OSC Release before Nov1 2002 define('TABLE_HEADING_IMAGES', 'Image'); define('TABLE_HEADING_MANUFACTURERS', 'Manufacturer'); define('TABLE_HEADING_PRODUCTS', 'Name'); define('TABLE_HEADING_DESCRIPTION', 'Description'); define('TABLE_HEADING_OPTIONS','Options'); define('TABLE_HEADING_CATEGORIES', 'Category'); define('TABLE_HEADING_MODEL', 'Model'); define('TABLE_HEADING_UPC', 'UPC'); define('TABLE_HEADING_QUANTITY', 'Quantity'); define('TABLE_HEADING_WEIGHT', 'Weight'); define('TABLE_HEADING_PRICE', 'Price'); define('BOX_STATS_PRODUCTS_WITH_IMAGES', 'Printable Catalog'); define('FONT_STYLE_TOP_BAR', 'Printable Catalog'); define('NAVBAR_TITLE', 'Printable Catalog'); define('TABLE_HEADING_DATE','Date added'); define('BOX_CATALOG_NEXT', 'NEXT'); define('BOX_CATALOG_PREV', 'PREV'); ?> NAVBAR_TITLEDoherty Machine
SIMPLY THE BEST!
Back to Home Page
Categories
Big Twin Products
V-Rod Products
Custom Build Products
Dealer Applications
Installation Guides
Installation Videos

Magazine Articles

HEADING_TITLE
Currencies
1054 - Unknown column 'p.products_id' in 'on clause'

select distinct p.products_id, p.products_image, p.products_model, p.products_quantity, p.products_weight, pd.products_name, p.manufacturers_id, p.products_price, p.products_date_added, 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, m.manufacturers_name, pd.products_description, cd.categories_name from products_description pd, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_to_categories p2c left join categories_description cd on p2c.categories_id = cd.categories_id 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' and cd.language_id = '1' order by cd.categories_name, pd.products_name

[TEP STOP]

 
  		TABLE_HEADING_IMAGES
Sort Asending
Sort Desending		 TABLE_HEADING_PRODUCTS
Sort Asending
Sort Desending		 TABLE_HEADING_CATEGORIES
Sort Asending
Sort Desending		 TABLE_HEADING_MODEL
Sort Asending
Sort Desending		 TABLE_HEADING_PRICE