SELECT distinct a.id
FROM tab1 as a
LEFT JOIN tab2 as b ON a.id_c=b.id_c
LEFT JOIN tab3 as f ON b.id_co=f.id_co
LEFT JOIN tab4 as g ON a.id=g.id
LEFT JOIN tab5 as h ON a.id=h.id
LEFT JOIN tab6 as i ON a.id=i.id
LEFT JOIN tab7 as j ON a.id=j.id
WHERE g.l BETWEEN 1 AND 100
AND g.b BETWEEN 1 AND 100
AND lifting_capacity >= 1
AND h.l BETWEEN 1 AND 100
AND h.b BETWEEN 1 AND 100
AND i.lift >= 1
AND i.l >= 1
AND i.b >= 1  
AND j.lift >= 1
AND j.l >= 1
AND j.b >= 1
AND a.id_c=3417
AND b.id_co=328
AND (b.id_oc=23 OR b.id_oc2=23 OR b.id_oc3=23)
AND a.ma=1
AND a.li=1
AND a.un=1
AND a.fl=1
ORDER BY name ASC;