The Title field is needed to identify the instance when adding a menu item, or when adding a child field in show layouts.
As for your case where only one instance is tied to one order, it is best to use a single query:
SELECT * FROM #__os_cck_orders as o
LEFT JOIN #__os_cck_content_entity_2 as ce ON o.fk_instance_id=ce.fk_eiid
Also, it may be necessary to display the selected price field values for the order.
In this case it is necessary to create a separate entity with the query:
SELECT op.*, f.field_name FROM #__os_cck_orders_price as op
LEFT JOIN #__os_cck_entity_field as f ON op.fk_fid=f.fid
Set the ID value in the fk_fid field and the Title value in the field_name field, as well as select the fk_order_id field as text or numeric.
Then in the Order Show Layout click Attach Child Enteties Add New, select the created entity, set the mapping by ID in Parents Fields and fk_order_id in Child Fields.
In the field below select the Price to display (the Title field came in handy here, without it it is impossible to identify the required fields) and select the fields we want to display. Repeat the procedure for all types of price fields.