SELECT
    p.date_added
    , p.products_id
    , pa.products_attributes_id
    , IFNULL(pal.products_attributes_parent_id, pa.products_attributes_id) AS products_attributes_parent_id
    , 0 AS incomes_attributes_id
    , -1 AS shipment_object_type_id
    , ptc.categories_id AS shipment_object_id
    , ptc.categories_id
    , 0 AS incomes_id
    , pp.products_purchase_price AS purchase_price
    , pp.products_VAT AS vat_rate
    , p.brandswelove_id
    , 1 AS shipment_products_type_id
    , p.date_added  AS last_date_update_p
    , pp.last_date_update AS last_date_update_pp
    , c.last_date_update AS last_date_update_c
FROM products AS p
    JOIN products_attributes AS pa ON pa.products_id = p.products_id
    LEFT JOIN products_attributes_legacy AS pal ON pal.products_attributes_id = pa.products_attributes_id
    JOIN products_to_categories AS ptc ON ptc.products_id = p.products_id
    JOIN products_prices AS pp ON pp.products_attributes_id = pa.products_attributes_id
    JOIN categories AS c ON ptc.categories_id = c.categories_id
WHERE p.entities_types_id = 46