SELECTd0_.idASid_0,d0_.nameASname_1,d0_.slugASslug_2FROMdesign_typed0_LEFT JOINvehiclev1_ON (v1_.design_type_id=d0_.id) LEFT JOINseriess2_ON (s2_.id=v1_.series_id) LEFT JOINtypet3_ON (t3_.id=v1_.type_id) LEFT JOINbrandb4_ON (b4_.id=v1_.brand_id) WHEREv1_.status=?ANDv1_.approved=?ANDv1_.visible=?ANDs2_.slug=?ANDv1_.construction_year=?ANDt3_.slug=?ANDb4_.slug=?ORDER BYd0_.nameASC
SELECTd0_.idASid_0,d0_.nameASname_1,d0_.slugASslug_2FROMdesign_typed0_LEFT JOINvehiclev1_ON (v1_.design_type_id=d0_.id)
LEFT JOINseriess2_ON (s2_.id=v1_.series_id)
LEFT JOINtypet3_ON (t3_.id=v1_.type_id)
LEFT JOINbrandb4_ON (b4_.id=v1_.brand_id)
WHEREv1_.status=?ANDv1_.approved=?ANDv1_.visible=?ANDs2_.slug=?ANDv1_.construction_year=?ANDt3_.slug=?ANDb4_.slug=?ORDER BYd0_.nameASC
SELECTd0_.idASid_0,d0_.nameASname_1,d0_.slugASslug_2FROMdesign_typed0_LEFT JOINvehiclev1_ON (v1_.design_type_id=d0_.id) LEFT JOINseriess2_ON (s2_.id=v1_.series_id) LEFT JOINtypet3_ON (t3_.id=v1_.type_id) LEFT JOINbrandb4_ON (b4_.id=v1_.brand_id) WHEREv1_.status='collection'ANDv1_.approved=1ANDv1_.visible=1ANDs2_.slug='192-5-mp-mbx-rescue-iv-chassis-mit-jbx32-pragung'ANDv1_.construction_year='2025'ANDt3_.slug='619-emergency-rescue-4x4'ANDb4_.slug='4-unbekannt'ORDER BYd0_.nameASC;
SELECTm0_.idASid_0,m0_.nameASname_1,m0_.slugASslug_2FROMmanufacturerm0_LEFT JOINvehiclev1_ON (v1_.manufacturer_id=m0_.id) LEFT JOINseriess2_ON (s2_.id=v1_.series_id) LEFT JOINtypet3_ON (t3_.id=v1_.type_id) LEFT JOINbrandb4_ON (b4_.id=v1_.brand_id) WHEREv1_.status=?ANDv1_.approved=?ANDv1_.visible=?ANDs2_.slug=?ANDv1_.construction_year=?ANDt3_.slug=?ANDb4_.slug=?ORDER BYm0_.nameASC
SELECTm0_.idASid_0,m0_.nameASname_1,m0_.slugASslug_2FROMmanufacturerm0_LEFT JOINvehiclev1_ON (v1_.manufacturer_id=m0_.id)
LEFT JOINseriess2_ON (s2_.id=v1_.series_id)
LEFT JOINtypet3_ON (t3_.id=v1_.type_id)
LEFT JOINbrandb4_ON (b4_.id=v1_.brand_id)
WHEREv1_.status=?ANDv1_.approved=?ANDv1_.visible=?ANDs2_.slug=?ANDv1_.construction_year=?ANDt3_.slug=?ANDb4_.slug=?ORDER BYm0_.nameASC
SELECTm0_.idASid_0,m0_.nameASname_1,m0_.slugASslug_2FROMmanufacturerm0_LEFT JOINvehiclev1_ON (v1_.manufacturer_id=m0_.id) LEFT JOINseriess2_ON (s2_.id=v1_.series_id) LEFT JOINtypet3_ON (t3_.id=v1_.type_id) LEFT JOINbrandb4_ON (b4_.id=v1_.brand_id) WHEREv1_.status='collection'ANDv1_.approved=1ANDv1_.visible=1ANDs2_.slug='192-5-mp-mbx-rescue-iv-chassis-mit-jbx32-pragung'ANDv1_.construction_year='2025'ANDt3_.slug='619-emergency-rescue-4x4'ANDb4_.slug='4-unbekannt'ORDER BYm0_.nameASC;
SELECTs0_.idASid_0,s0_.nameASname_1,s0_.slugASslug_2FROMscales0_LEFT JOINvehiclev1_ON (v1_.scale_id=s0_.id) LEFT JOINseriess2_ON (s2_.id=v1_.series_id) LEFT JOINtypet3_ON (t3_.id=v1_.type_id) LEFT JOINbrandb4_ON (b4_.id=v1_.brand_id) WHEREv1_.status=?ANDv1_.approved=?ANDv1_.visible=?ANDs2_.slug=?ANDv1_.construction_year=?ANDt3_.slug=?ANDb4_.slug=?ORDER BYs0_.nameASC
SELECTs0_.idASid_0,s0_.nameASname_1,s0_.slugASslug_2FROMscales0_LEFT JOINvehiclev1_ON (v1_.scale_id=s0_.id)
LEFT JOINseriess2_ON (s2_.id=v1_.series_id)
LEFT JOINtypet3_ON (t3_.id=v1_.type_id)
LEFT JOINbrandb4_ON (b4_.id=v1_.brand_id)
WHEREv1_.status=?ANDv1_.approved=?ANDv1_.visible=?ANDs2_.slug=?ANDv1_.construction_year=?ANDt3_.slug=?ANDb4_.slug=?ORDER BYs0_.nameASC
SELECTs0_.idASid_0,s0_.nameASname_1,s0_.slugASslug_2FROMscales0_LEFT JOINvehiclev1_ON (v1_.scale_id=s0_.id) LEFT JOINseriess2_ON (s2_.id=v1_.series_id) LEFT JOINtypet3_ON (t3_.id=v1_.type_id) LEFT JOINbrandb4_ON (b4_.id=v1_.brand_id) WHEREv1_.status='collection'ANDv1_.approved=1ANDv1_.visible=1ANDs2_.slug='192-5-mp-mbx-rescue-iv-chassis-mit-jbx32-pragung'ANDv1_.construction_year='2025'ANDt3_.slug='619-emergency-rescue-4x4'ANDb4_.slug='4-unbekannt'ORDER BYs0_.nameASC;