select backlinklookup.rel_list_id,backlinktext.backlink from backlinktext join backlinklookup on backlinklookup.rel_list_id=backlinktext.rel_list_id join mmp on mmp.id=backlinktext.rel_list_id where backlinklookup.rel_mmp_id= and mmp.status ="published"