SELECT * FROM tb_record AS tr LEFT JOIN tb_make AS tm ON tm.makeID=tr.rv_make LEFT JOIN tb_type AS tt ON tt.typeID=tr.rv_type LEFT JOIN tb_location AS tl ON tl.locID=tr.rv_location WHERE tr.rv_stock = 'Y1101' LIMIT 1;