How do I convert this query to Eloquent syntax
select * from (select f85,f86,f87,f88 , v1_position_id ,v1_companyuser_id , v89.position_value as f89 from
(select f85,f86,f87 , v1_position_id ,v1_companyuser_id , v88.position_value as f88 from
(select f85,f86 , v1_position_id ,v1_companyuser_id , v87.position_value as f87 from
(select f85 , v1_position_id ,v1_companyuser_id , v86.position_value as f86 from
( SELECT v1.position_id as v1_position_id , v1.companyuser_id as v1_companyuser_id , v1.position_value as f85 FROM
all_position_template_with_data v1 WHERE v1.position_id = 25 AND companyuser_id = 1 AND position_template_id = 85) v1
inner join all_position_template_with_data v86 on v1_position_id = v86.position_id AND v1_companyuser_id = v86.companyuser_id AND v86.position_template_id = 86 ) v86
inner join all_position_template_with_data v87 on v1_position_id = v87.position_id AND v1_companyuser_id = v87.companyuser_id AND v87.position_template_id = 87 ) v87
inner join all_position_template_with_data v88 on v1_position_id = v88.position_id AND v1_companyuser_id = v88.companyuser_id AND v88.position_template_id = 88 ) v88
inner join all_position_template_with_data v89 on v1_position_id = v89.position_id AND v1_companyuser_id = v89.companyuser_id AND v89.position_template_id = 89 ) v89
via Chebli Mohamed
Aucun commentaire:
Enregistrer un commentaire