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