SET
    @store := 1,
    @name_id := 71,
    @short_desc_id := 72,
    @desc_id := 73;

    SELECT
      CPE.sku      AS sku,
      CPEVN.value  AS name,
      CPEVSD.value AS short_description,
      CPEVD.value  AS description
    FROM catalog_product_entity AS CPE
      LEFT JOIN catalog_product_entity_varchar AS CPEVN
        ON (CPE.entity_id = CPEVN.entity_id
            AND CPEVN.attribute_id = @name_id
            AND CPEVN.store_id = @store)
      LEFT JOIN catalog_product_entity_varchar AS CPEVSD
        ON (CPE.entity_id = CPEVSD.entity_id
            AND CPEVSD.attribute_id = @short_desc_id
            AND CPEVSD.store_id = @store)
      LEFT JOIN catalog_product_entity_varchar AS CPEVD
        ON (CPE.entity_id = CPEVD.entity_id
            AND CPEVD.attribute_id = @desc_id
            AND CPEVD.store_id = @store);