Top » Catalog » Neck Strings » Military Str My Account  |  Cart Contents  |  Checkout   
Categories
Manufacturers
What's New? more
Blackberry 9700 Black Silicon Case
Blackberry 9700 Black Silicon Case
£1.00
Quick Find
 

Use keywords to find the product you are looking for.
Advanced Search
Information
Conditions of Use
Contact Us
Camouflage Neck String
[Military Str]		 £0.30

Camouflage Neck String.

2 colours available as in photo.

Can be used with cameras, IPOD, PSP, MP3, MP4, PDA, mobile phones, bus pass, staff pass, keys or whatever you want.
This product was added to our catalog on Sunday 18 November, 2007.
 Reviews 
1104 - The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET SQL_MAX_JOIN_SIZE=# if the SELECT is okay

select p.products_id, p.products_image from orders_products opa, orders_products opb, orders o, products p where opa.products_id = '275' and opa.orders_id = opb.orders_id and opb.products_id != '275' 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

[TEP STOP]