mercredi 26 juillet 2017

Convert SQL query to Eloquent Laravel with many join

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