312123123123

SELECT
"Extent1".product_id,
"Extent1".contract_id,
"Extent2".contract_tariff_id,
"Extent5".contract_tariff_id AS contract_tariff_id1,
"Extent2".initial_date,
"Extent2".end_date,
"Extent2".registration_date,
"Extent2".step_id,
"Extent2".waiting_days,
"Extent2".price,
"Extent2"."sum",
"Extent2".tariff_id,
"Extent7".tariff_type_id,
"Extent2".section_id,
"Extent3".registered_name,
"Extent4".price_id,
"Extent2"."number",
"Extent2".registration_number
FROM       public.ro_product AS "Extent1"
INNER JOIN public.ro_contract_tariff AS "Extent2" ON "Extent1".contract_id = "Extent2".contract_id
INNER JOIN public.ro_price_tariff AS "Extent3" ON ("Extent2".tariff_id = "Extent3".tariff_id) AND ("Extent2".section_id = "Extent3".section_id)
INNER JOIN public.ro_price_section AS "Extent4" ON "Extent3".section_id = "Extent4".section_id
LEFT OUTER JOIN public.ro_contract_tariff_extension AS "Extent5" ON "Extent5".extension_id = "Extent2".contract_tariff_id
LEFT OUTER JOIN public.ro_product_tariff AS "Extent6" ON "Extent6".contract_tariff_id = "Extent2".contract_tariff_id
LEFT OUTER JOIN public.ro_tariff AS "Extent7" ON "Extent2".tariff_id = "Extent7".tariff_id
WHERE ("Extent1".product_id = (CAST(:p__linq__0 AS int))) AND ((("Extent6".product_id IS NULL) AND ("Extent1".proxy_agent_id IS NULL)) OR ("Extent6".product_id = "Extent1".product_id))