SELECT
                  l.Datacode AS Datacode,
                  e.URL AS URL,l.Sale,
                  l.Listing_Name AS Listing_Name,
                  l.Listing_Detail AS Listing_Detail,
                  l.Locationcode AS Locationcode
                 FROM listing l
                 JOIN data_entry e ON l.Datacode = e.Datacode
                 WHERE l.Datacode = 527
                 GROUP BY l.Datacode
                 ORDER BY l.Listing_Index