If you want to use a SR2 Type 9, 10 or 14 to query another Asset Type that contains published assets, be sure to query the View instead of the table.
Here's an example of sql query that will return all the published asset for products:
select assetid as id, title as name from assets_v_product where publishedversionid=versionID
If you wanted to just see only the current version of the assets:
select assetid as id, title as name from assets_v_product where currentversionid=versionID