Select ProductName.SPID, ProductName.ProductName, MIN(Price.Price) from ProductName INNER JOIN Price on ProductName.SPID = Price.SPID AND Price.Price >= '0' AND Price.Price <= '1000' where MATCH (`ProductName`.`ProductName`) AGAINST ('book') GROUP BY ProductName.SPID ORDER BY Price.Price ASC LIMIT 9

Reply to "Untitled"

Here you can reply to the paste above

Author What's your name?

Title Give your paste a title.

Language What language is your paste written in?

Your paste Paste your paste here

Create a snipurl Create a shorter url that redirects to your paste?

Create a snipurl

Private Private paste aren't shown in recent listings.

Make Private

Delete After When should we delete your paste?

Feeling clever? Set some advanced options.