SELECTm0_.idASid_0,m0_.nameASname_1,m0_.slugASslug_2FROMmanufacturerm0_LEFT JOINvehiclev1_ON (v1_.manufacturer_id=m0_.id) LEFT JOINbrandb2_ON (b2_.id=v1_.brand_id) LEFT JOINdesign_typed3_ON (d3_.id=v1_.design_type_id) LEFT JOINscales4_ON (s4_.id=v1_.scale_id) WHEREv1_.status=?ANDv1_.approved=?ANDv1_.visible=?ANDb2_.slug=?ANDv1_.construction_year=?ANDd3_.slug=?ANDs4_.slug=?ORDER BYm0_.nameASC
SELECTm0_.idASid_0,m0_.nameASname_1,m0_.slugASslug_2FROMmanufacturerm0_LEFT JOINvehiclev1_ON (v1_.manufacturer_id=m0_.id)
LEFT JOINbrandb2_ON (b2_.id=v1_.brand_id)
LEFT JOINdesign_typed3_ON (d3_.id=v1_.design_type_id)
LEFT JOINscales4_ON (s4_.id=v1_.scale_id)
WHEREv1_.status=?ANDv1_.approved=?ANDv1_.visible=?ANDb2_.slug=?ANDv1_.construction_year=?ANDd3_.slug=?ANDs4_.slug=?ORDER BYm0_.nameASC
SELECTm0_.idASid_0,m0_.nameASname_1,m0_.slugASslug_2FROMmanufacturerm0_LEFT JOINvehiclev1_ON (v1_.manufacturer_id=m0_.id) LEFT JOINbrandb2_ON (b2_.id=v1_.brand_id) LEFT JOINdesign_typed3_ON (d3_.id=v1_.design_type_id) LEFT JOINscales4_ON (s4_.id=v1_.scale_id) WHEREv1_.status='collection'ANDv1_.approved=1ANDv1_.visible=1ANDb2_.slug='103-rover'ANDv1_.construction_year='1981'ANDd3_.slug='6-limousine'ANDs4_.slug='5-1-64'ORDER BYm0_.nameASC;
SELECTt0_.idASid_0,t0_.nameASname_1,t0_.slugASslug_2FROMtypet0_LEFT JOINvehiclev1_ON (v1_.type_id=t0_.id) LEFT JOINbrandb2_ON (b2_.id=v1_.brand_id) LEFT JOINdesign_typed3_ON (d3_.id=v1_.design_type_id) LEFT JOINscales4_ON (s4_.id=v1_.scale_id) WHEREv1_.status=?ANDv1_.approved=?ANDv1_.visible=?ANDb2_.slug=?ANDv1_.construction_year=?ANDd3_.slug=?ANDs4_.slug=?ORDER BYt0_.nameASC
SELECTt0_.idASid_0,t0_.nameASname_1,t0_.slugASslug_2FROMtypet0_LEFT JOINvehiclev1_ON (v1_.type_id=t0_.id)
LEFT JOINbrandb2_ON (b2_.id=v1_.brand_id)
LEFT JOINdesign_typed3_ON (d3_.id=v1_.design_type_id)
LEFT JOINscales4_ON (s4_.id=v1_.scale_id)
WHEREv1_.status=?ANDv1_.approved=?ANDv1_.visible=?ANDb2_.slug=?ANDv1_.construction_year=?ANDd3_.slug=?ANDs4_.slug=?ORDER BYt0_.nameASC
SELECTt0_.idASid_0,t0_.nameASname_1,t0_.slugASslug_2FROMtypet0_LEFT JOINvehiclev1_ON (v1_.type_id=t0_.id) LEFT JOINbrandb2_ON (b2_.id=v1_.brand_id) LEFT JOINdesign_typed3_ON (d3_.id=v1_.design_type_id) LEFT JOINscales4_ON (s4_.id=v1_.scale_id) WHEREv1_.status='collection'ANDv1_.approved=1ANDv1_.visible=1ANDb2_.slug='103-rover'ANDv1_.construction_year='1981'ANDd3_.slug='6-limousine'ANDs4_.slug='5-1-64'ORDER BYt0_.nameASC;
SELECTs0_.idASid_0,s0_.nameASname_1,s0_.slugASslug_2FROMseriess0_LEFT JOINvehiclev1_ON (v1_.series_id=s0_.id) LEFT JOINbrandb2_ON (b2_.id=v1_.brand_id) LEFT JOINdesign_typed3_ON (d3_.id=v1_.design_type_id) LEFT JOINscales4_ON (s4_.id=v1_.scale_id) WHEREv1_.status=?ANDv1_.approved=?ANDv1_.visible=?ANDb2_.slug=?ANDv1_.construction_year=?ANDd3_.slug=?ANDs4_.slug=?ORDER BYs0_.nameASC
SELECTs0_.idASid_0,s0_.nameASname_1,s0_.slugASslug_2FROMseriess0_LEFT JOINvehiclev1_ON (v1_.series_id=s0_.id)
LEFT JOINbrandb2_ON (b2_.id=v1_.brand_id)
LEFT JOINdesign_typed3_ON (d3_.id=v1_.design_type_id)
LEFT JOINscales4_ON (s4_.id=v1_.scale_id)
WHEREv1_.status=?ANDv1_.approved=?ANDv1_.visible=?ANDb2_.slug=?ANDv1_.construction_year=?ANDd3_.slug=?ANDs4_.slug=?ORDER BYs0_.nameASC
SELECTs0_.idASid_0,s0_.nameASname_1,s0_.slugASslug_2FROMseriess0_LEFT JOINvehiclev1_ON (v1_.series_id=s0_.id) LEFT JOINbrandb2_ON (b2_.id=v1_.brand_id) LEFT JOINdesign_typed3_ON (d3_.id=v1_.design_type_id) LEFT JOINscales4_ON (s4_.id=v1_.scale_id) WHEREv1_.status='collection'ANDv1_.approved=1ANDv1_.visible=1ANDb2_.slug='103-rover'ANDv1_.construction_year='1981'ANDd3_.slug='6-limousine'ANDs4_.slug='5-1-64'ORDER BYs0_.nameASC;