$1.00 Custom Order Option

Custom Order Option

This is an option to purchase and pay for an item(s) that we do not have listed on our webstore. This is ONLY for use if you have discussed a transaction using this option with one of our staff members. When you check out, there will be an area for you to list 'OTHER INFORMATION'. In this area you will list the details of the transaction that you have discussed with one of our staff members by telling us the item(s) you want and the price we have discussed with any applicable shipping charges. We will see these notes when we process the order, and will manually complete the transaction. Please contact us for details if you have any quesitons!

Available Options:

Who is your sales representative:

1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'speedfor_newstore.o.date_purchased' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

select p.products_id, p.products_image from orders_products opa, orders_products opb, orders o, products p INNER JOIN products_to_stores p2s ON p.products_id = p2s.products_id where p2s.stores_id = '1' AND opa.products_id = '844' and opa.orders_id = opb.orders_id and opb.products_id != '844' and opb.products_id = p.products_id and opb.orders_id = o.orders_id and p.products_status = '1' group by p.products_id order by o.date_purchased desc limit 6