30711

SELECT id, subject, body, view_href, author.view_href, author.id, author.login, board.id, author.avatar.profile, author.rank, post_time, post_time_friendly, conversation.last_post_time, conversation.last_post_time_friendly, conversation.solved, conversation.thread_style, replies.count(*), board.view_href, board.title FROM messages WHERE depth = 0 AND board.id IN ( 'troubleshooting','Retail-Discussions','Food-Discussions','capital-faqs','Square-Online-Store-Discussion','Beauty-and-Wellnessforum-board','Community-Events-US','Food-and-Beverageforum-board','square-contracts','appointments','square-invoices','pos','checking','loyalty','square-marketing','register','savings','terminal','customer-directory','RetailAndECommerceforum-board','SquarePOSapp','SquareforRetail','SquareDirectory','Square-Online','SquareAppointments','SquareLoyalty','SquareInvoices','SquareVirtualTerminal','Reporting','SquareHardwareAccessories','SquareforRestaurants','SquareMessages','SquareBusinessBanking','SquareAPI','SquareOrderManager','SquareKDS','CommercePlatform','SquareSubscriptions','SquareMarketing','SquareGiftCards','square-hardware','LeisureandEntertainmentforum-board','ArtistsandMakersforum-board','SquareReadersBookClubforum-board','SellerCommunityBlog','StaffAndPayroll','Staff-and-Payroll','AllProductUpdates','CommunityResources','CommunityCorner','VideoLibrary','EventDiscussions','super_seller','SquareReadersBookCluboccasion-board' ) ORDER BY conversation.last_post_time DESC LIMIT 5 OFFSET 0