SELECT pd.*, p.*, IF(s.status,s.specials_new_products_price,NULL) AS specials_new_products_price, IF(s.status,s.specials_new_products_price,p.products_price) AS base_price, p.products_quantity AS in_stock, IF(s.status,1,0) AS is_special, IF(s.status,s.expires_date,NULL) AS special_expiration, IF(COALESCE(a.attribute_count,0) > 0,1,0) AS has_attributes FROM 1_common_products_description pd INNER JOIN 1_common_products p ON pd.products_id = p.products_id LEFT JOIN 3_hanfhaus_specials s ON p.products_id = s.products_id LEFT JOIN (SELECT products_id, COUNT(*) AS attribute_count FROM 1_common_products_attributes GROUP BY products_id) a ON p.products_id = a.products_id WHERE p.products_id = 47329 AND pd.language_id = 2 AND p.products_status = 1