select
p.products_id,
p.products_image,
p.products_price,
p.manufacturers_id,
pd.products_name,
p.products_tax_class_id,
p.products_date_added,
p.products_image ,
xp.xsell_id
products_price
from (products p
left join specials s on p.products_id = s.products_id),
products_xsell xp,
products_description pd
where
xp.products_id = '1332'
and p.products_id = xp.xsell_id
and pd.products_id = xp.xsell_id
and pd.language_id = '1'
and p.products_status = '1'
GROUP BY p.products_id order by rand(), xp.products_id asc limit 6includes/modules/xsell_products_buynow.php
**For international customers please add items into the shopping cart and you will see a shipping calculator. Simply select your country from the pull-down manual and hit "recalculate" to see the cost. **
We ship world- wide from Los Angeles, California. To find out the shipping cost, please add the items you are interested in to the shopping cart and you will see the shipping cost there. Free shipping on domestic orders above $200. Click here for more information about our Shipping and Return Policy.