select *, itineraries_images.thumb as thumb, packages_prices.price as price, DATE_FORMAT(packages.created_at, '%d/%m/%Y %H:%i:%s') AS created, DATE_FORMAT(packages.updated_at, '%d/%m/%Y %H:%i:%s') AS updated from `packages` inner join `packages_itineraries` on `packages_itineraries`.`id_package` = `packages`.`id_package` inner join `itineraries_images` on `itineraries_images`.`id_itinerary` = `packages_itineraries`.`id_itinerary` inner join `packages_prices` on `packages_prices`.`id_package` = `packages`.`id_package` where `group` = ? and `status` = ? group by `packages`.`id_package`