select            b.product_id,
                            b.name,
                            b.current_price,
                            b.inventory,
                            i.product_identifier as isbn10,
                            j.product_identifier as isbn13,
                            m2.name as publisher,
                            d.attribute_value as pub_date,
                            b.sugg_retail_price
          from              tbl_product b
          join              tbl_product_identifier i
          on                b.product_id = i.product_id
          and               i.product_identifier_type_id = 1
          join              tbl_product_identifier j
          on                b.product_id = j.product_id
          and               j.product_identifier_type_id = 4
          join              tbl_product_attr_date d
          on                b.product_id = d.product_id
          and               d.attr_type_id = 1
          join              tbl_product_manufacturer m
          on                b.product_id = m.product_id
          join              tbl_manufacturer m2
          on                m.manufacturer_id = m2.manufacturer_id
          order by          b.product_id