##
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 != '1480' AND A.skip_related1 != '1' AND A.artist_id1 != '6' AND A.category_id1 = '30' AND (A.id1 != '1326' AND A.id1 != '1328' AND A.id1 != '1711') AND A.display1 != 'Hidden' AND A.display1 != 'Archived' AND A.archive1 != '1' AND A.archived1 != '1' AND B.quantity1 > 0 ORDER BY RAND() LIMIT 2
August Burns Red
ABR Custom Pick Pack
Custom Dunlop Guitar Picks
August Burns Red themed custom pick pack containing 10 Dunlop guitar picks.
- 2x Black w/ Holographic Foil .73mm (Chug)
- 2x Black w/ Gold Foil .73mm (Flame Logo)
- 2x Black w/ Red Foil .73mm (ABR Logo)
- 2x White w/ Black Foil .73mm (EST 2003 Logo)
- 2x White w/ Pink Foil .73mm (Angry Music)
1 Buying Option:
10 Custom Dunlop Guitar Picks
$12
All prices in USD Dollars
