 |
Categories |
 |
|
|
Shop Online 24 Hours a Day
Or Shop by Phone
Phone Operators Avail:
M-F 9am-7pm PST
Weekends 9am-5pm PST
Phone 619-634-5318 or
Phone 619-646-5580 or
OR EMAIL YOUR ORDER TO
sales@pacificathletics.com
|
|
|
Pacific Athletics and Rugby Supply
Pacific Athletics and Rugby Supply
4525 Florida Street,
San Diego CA 92116
Phone:(619) 634-5318 Fax: (619) 646-5580
sales@pacificathletics.com
Email: sales@pacificathletics.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. |
|
 |
|
|
|
 |
Manufacturer |
|
|
Name |
|
|
Description |
|
|
Category |
|
|
Quantity |
|
|
Weight |
|
|
Price |
|
|
1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'show' at line 1
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 LIMIT 0, show
[TEP STOP]
| | | |
Rugby
Specialty Sports