PS. IF you change a product's structure in PROD, don't forget to do it also in Davinci cause in a future migration/deploy via IDX, it will be overriden again.

________________________________________________A_________________________________________________
select id,product2.Name, vlocity_cmt__OneTimeCharge__c, order.Offer_Name_CPQ__c from orderitem where vlocity_cmt__OneTimeCharge__c !=0 and vlocity_cmt__OneTimeCharge__c != null and Cod_Voce_Fatturabile__c ='' and CreatedDate = TODAY

________________________________________________B_________________________________________________
select Product2.Name,Product2.ProductCode,Id, Codice_Robinson__c, Bene_Servizio__c, Cluster_Commissioning__c, Codice_Prodotto_Neta__c, Cod_Voce_Fatturabile__c, Costo_di_acquisto__c, Gross_margin__c
from OrderItem 
where ID in 
(
'8027U000009DskAQAS'
)
order by Product2.Name	
limit 1000

________________________________________________C_________________________________________________
select Name,ProductCode
from product2
________________________________________________D_________________________________________________
select id,Product__r.name,Product__r.ProductCode, Product__r.Tipo__c, Product__r.Costo_di_acquisto__c, Product__r.Gross_margin__c, Service_Component__r.Codice_Prodotto_Robinson__c, Service_Component__r.Voce_Fatturabile_Net__c 
from Associazione_Product_Service_component__c 
where Product__r.name like 'Impianto Fotovoltaico'
________________________________________________E_________________________________________________

select id,name,vlocity_cmt__PicklistId__r.Name from vlocity_cmt__PicklistValue__c