SELECT ma.*, m.*, c.ref_number,c.cars_id, c.finishes_id, s.* from FOR_cars as c, FOR_models as m,FOR_makes as ma, FOR_car_models_ext as cme, FOR_car_sizes_ext as cse, FOR_sizes as s where c.active='y' and m.models_id=cme.models_id and c.cars_id=cme.cars_id and m.makes_id=ma.makes_id and cse.cars_id=c.cars_id and s.sizes_id=cse.sizes_id