SELECT d.*, sd.main_photo_vector, sd.default_background, sd.available_date_from, sd.available_date_to FROM othertees_design d LEFT JOIN othertees_shop_designs sd ON sd.id_design = d.id WHERE 1=1 AND main_photo_vector != '' AND (d.id_user = :id_user OR id_user_2nd = :id_user) AND d.status IN (5) AND d.id != :id_design AND d.status != 7 ORDER BY rand() DESC LIMIT :od,:na_stronie OtherTees - Limited Edition t-shirt every 24 hours - Winchester Coat of Arms
Shipping & Printing Schedule
Shipping & Printing Schedule

Shipping & Printing Schedule

Please wait, loading ...
This design was already on sale! Sold 20 Jun 2012 - 23 Jun 2012!

Winchester Coat of Arms

Winchester Coat of Arms
"Saving people. Hunting things. The family business."

Discuss this design