SELECT
    models.model_id,
    models.brand_id,
    model_property.msrp,
    model_property.ft_id,
    model_property.pass,
    model_property.dt_id,
    model_property.hp,
    model_property.leather,
    model_property.cloth,
    model_property.seat_heat,
    model_property.ster_hea,
    model_property.nav,
    model_property.t_screen,
    model_property.rear_cam,
    model_property.apple,
    model_property.android,
    model_property.hud,
    model_property.collision,
    model_property.acc,
    model_property.sensors,
    model_property.bspot,
    model_property.lanedep,
    model_property.sunroof,
    model_property.automatic,
    model_property.manual,
    model_property.prox_key,
    model_property.engin_type,
    brand_name,
    0.00 AS tax_tvq,
    13.00 AS tax_tps,
    category_name,
    ft_name,
    drive_type_name,
    model_package.mp_id,
    model_package.model_id AS pkg_m_id,
    model_package.model_package_name,
    model_package.leather,
    model_package.cloth,
    model_package.seat_heat,
    model_package.ster_hea,
    model_package.nav,
    model_package.t_screen,
    model_package.rear_cam,
    model_package.apple,
    model_package.android,
    model_package.hud,
    model_package.collision,
    model_package.acc,
    model_package.sensors,
    model_package.bspot,
    model_package.lanedep,
    model_package.sunroof,
    model_package.automatic,
    model_package.manual,
    model_package.prox_key,
    model_package.deleted_at AS pkg_deleted_at,
    models. YEAR,
    min(model_package.msrp) AS min_msrp
FROM
    model_package
INNER JOIN `models` ON `model_package`.`model_id` = `models`.`model_id`
INNER JOIN `model_property` ON `models`.`model_id` = `model_property`.`model_id`
INNER JOIN `brands` ON `brands`.`brand_id` = `models`.`brand_id`
INNER JOIN categories ON models.cat_id = categories.id
INNER JOIN fuel_types ON model_property.ft_id = fuel_types.ft_id
INNER JOIN drive_types ON model_property.dt_id = drive_types.dt_id
WHERE
 model_property.hp >= 100
AND model_property.hp <= 500
AND model_property.pass >= 2
AND model_property.pass <= 7
OR (
    model_package.SEAT_HEAT = 1
    OR model_property.SEAT_HEAT, = 1
)
AND (
    model_package.CLOTH = 1
    OR model_property.CLOTH = 1
)

AND (
    model_package.HUD = 1
    OR model_property.sunroof = 1
)
AND (
    model_package.ANDROID  = 1
    OR model_property.ANDROID  = 1
)
AND (
    model_package.LANEDEP  = 1
    OR model_property.LANEDEP  = 1
)
 GROUP BY
 model_package.model_id