Prize Apps
S: SELECT ChainID,ChainTypeFLIP,ChainName,ChainURL,ChainPageDesc,ChainInstructions,ChainInstructionsMobile, ChainFromChainID,ChainSortOrder,PlatformFA,LinkspokeID,LSCitySpokesActive, LSSearchActive,LSTutorialActive FROM Chains,Platforms,Linkspokes WHERE ChainLinkSpokeID = LinkspokeID AND ChainPlatformID = PlatformID AND ChainFromChainID = 2758 AND ChainActive = 'Y' AND LSActive = 'Y' ORDER BY ChainSortOrder,ChainName