SELECT 
  cscart_products.product_id, 
  cscart_products.product_code, 
  cscart_products.status, 
  cscart_products.company_id, 
  cscart_products.list_price, 
  cscart_products.shipping_params, 
  cscart_product_review_prepared_data.average_rating, 
  cscart_product_descriptions.product, 
  cscart_product_descriptions.short_description, 
  cscart_product_descriptions.full_description, 
  cscart_product_descriptions.promo_text, 
  IFNULL(
    avg(opr.rating_value), 
    3
  ) as actual_rating, 
  cd.category, 
  cd.category_id, 
  cc.category_id as main_category, 
  pvd.variant_id, 
  pvd.variant, 
  MIN(
    IF(
      cscart_product_prices.percentage_discount = 0, 
      cscart_product_prices.price, 
      cscart_product_prices.price - (
        cscart_product_prices.price * cscart_product_prices.percentage_discount
      )/ 100
    )
  ) as price 
FROM 
  cscart_products 
  LEFT JOIN cscart_product_prices ON cscart_product_prices.product_id = cscart_products.product_id 
  AND cscart_product_prices.lower_limit = 1 
  AND cscart_product_prices.usergroup_id IN (0) 
  LEFT JOIN cscart_product_descriptions ON cscart_product_descriptions.product_id = cscart_products.product_id 
  LEFT JOIN cscart_product_review_prepared_data ON cscart_product_review_prepared_data.product_id = cscart_products.product_id 
  left join cscart_product_reviews opr on opr.product_id = cscart_products.product_id 
  and opr.status = "A" 
  left join cscart_product_features_values pfv on pfv.product_id = cscart_products.product_id 
  AND pfv.feature_id = 62 
  left join cscart_product_feature_variant_descriptions pvd on pvd.variant_id = pfv.variant_id 
  inner join cscart_products_categories pc on pc.product_id = cscart_products.product_id 
  inner join cscart_categories cc on cc.category_id = pc.category_id 
  and pc.link_type = "M" 
  inner join cscart_category_descriptions cd on cd.category_id = cc.parent_id 
  AND cscart_product_descriptions.lang_code = 'en' 
WHERE 
  cscart_products.product_id = 53620