phpMyAdmin - search for items with 4 cards

[China]

I was wondering if you could search for items with 4 cards in them ( whether cards or items ) and delete them whether they're in inventory/storage cause a GM lvl 99 just leaked some and I don't think I found all yet but I deleted probably half of what he leaked... Thanks in advance!

[Brian]

Run each of these queries, one at a time.

They will list items (in auction, cart_inventory, guild_storage, inventory, mail, storage) with 4 cards in them.

SELECT * FROM `auction` WHERE card0 AND card1 AND card2 AND card3;
SELECT * FROM `cart_inventory` WHERE card0 AND card1 AND card2 AND card3;
SELECT * FROM `guild_storage` WHERE card0 AND card1 AND card2 AND card3;
SELECT * FROM `inventory` WHERE card0 AND card1 AND card2 AND card3;
SELECT * FROM `mail` WHERE card0 AND card1 AND card2 AND card3;
SELECT * FROM `storage` WHERE card0 AND card1 AND card2 AND card3;

[China]

Alrighty, thanks! Now time to find those equipment.