SELECT 
  `PF`.`filter_id`, 
  `PFV`.`feature_id`, 
  `PFV`.`variant_id`, 
  `PFVD`.`variant` 
FROM 
  `cscart_product_feature_variant_descriptions` AS `PFVD` 
  LEFT JOIN `cscart_product_feature_variants` AS `PFV` ON `PFVD`.`variant_id` = `PFV`.`variant_id` 
  LEFT JOIN `cscart_product_filters` AS `PF` ON `PF`.`feature_id` = `PFV`.`feature_id` 
WHERE 
  `PFV`.`feature_id` IN ('737', '740', '744', '775') 
ORDER BY 
  `PFVD`.`variant` ASC