select bs.bookstore_id, bs.floor, bs.column, bs.type, pl.qty as quantity,
                    ifnull(pe.sku, pl.sku) as sku,
                    ifnull(name.value, fs.Name) as name
                    from fhs_bookshelf bs
                    join fhs_bookshelf_product_location pl on bs.entity_id = pl.bookshelf_entity_id
                    left join fahasa_stock fs on fs.sku = pl.sku
                    left join fhs_catalog_product_entity pe on pe.sku = pl.sku
                    left join fhs_catalog_product_entity_varchar name on name.entity_id = pe.entity_id and name.attribute_id=71
                    where bs.bookstore_id = 67
                    and bs.floor = 0
                    and bs.type = 'M'
                    and bs.column = 1
                    and bs.row = 2;