##
SELECT DISTINCT A.id1, A.artist_id1, A.category_id1, A.title1, A.title2, A.instruments1, A.date1, A.display1
FROM catalogue AS A
INNER JOIN stock AS B ON B.product_id1 = A.id1
WHERE A.id1 != '941' AND A.skip_related1 != '1' AND A.artist_id1 != '38' AND A.category_id1 = '30' AND A.display1 != 'Hidden' AND A.display1 != 'Archived' AND A.archive1 != '1' AND A.archived1 != '1' AND B.quantity1 > 0 ORDER BY RAND() LIMIT 5
Sheet Happens
How To Rock
HTR Maroon Tee
MADE IN CANADA! (Fair Labour / Sweatshop Free)
50/50 Poly-Cotton Blend Tee - Jerico Fine Jersey in Maroon.
*Size Chart can be found at the Jerico link above*
1 Buying Option:
All prices in USD Dollars
