American Wrestling group
Keep track of American Wrestling events, tickets and news - all in one place. Join this group now for updates as they happen!
SELECT artists.* , MIN(iEventDate) as firstEventDate, EventName as firstEventName, ListingInstance.iListingInstance as firstEventILID FROM artists INNER JOIN artistListing ON artists.artistID = artistListing.artistID INNER JOIN Listings ON Listings.ListingID = artistListing.ListingID INNER JOIN ListingInstance ON ListingInstance.iListingID = Listings.ListingID INNER JOIN ListingPromotionBrand ON ListingPromotionBrand.listingID = Listings.ListingID
WHERE 1=1 AND Listings.active=1 and iEventDate >= CURDATE() AND promotionBrandID = 6476 AND artists.active=1 GROUP BY artists.artistID ORDER BY ISNULL(artistRank) ASC, artistRank ASC LIMIT 6 OFFSET 0 next 2 American Wrestling Events
about American Wrestling
American Style featuring all the stars of the World Wide Wrestling League - Great fun for all the family! Visit the promotions website W3Lwrestling.com for more event details, videos and bios on the wrestlers that will be appearing. Body Slamming action as seen on TV!
Discuss American Wrestling