## 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 != '559' AND A.skip_related1 != '1' AND A.artist_id1 != '34' AND A.category_id1 = '30' AND (A.id1 != '847') AND A.display1 != 'Hidden' AND A.display1 != 'Archived' AND A.archive1 != '1' AND A.archived1 != '1' AND B.quantity1 > 0 ORDER BY RAND() LIMIT 4