SELECT fip.fulfilments_income_packages_id
, fip.fulfilments_income_packages_external_id
, fs0.categories_id
, s.suppliers_id
, s.juristic_name
, fiph.date_added
, opn.orders_id
, fip0.fulfilments_outgoing_packages_id
, NOW()
, DATEDIFF(NOW(), fiph.date_added)
, IF(DATEDIFF(NOW(), fiph.date_added) > 45, DATEDIFF(NOW(), fiph.date_added) - 45, 0) * 0.05 AS sum_store
FROM fulfilments_income_packages AS fip
JOIN fulfilments_supplies AS fs ON fs.fulfilments_supplies_id = fip.fulfilments_supplies_id
LEFT JOIN fulfilments_income_packages AS fip0 ON
    fip0.first_products_attributes_id = fip.first_products_attributes_id
    AND fip0.fulfilments_income_packages_id = IF(fip.fulfilments_income_packages_parent_id = 0, fip.fulfilments_income_packages_id, fip.fulfilments_income_packages_parent_id)
LEFT JOIN   fulfilments_supplies AS fs0 ON fs0.fulfilments_supplies_id = fip0.fulfilments_supplies_id

LEFT JOIN orders_products_new AS opn ON opn.id = fip0.orders_products_id

LEFT JOIN categories AS c ON c.categories_id = fs0.categories_id
LEFT JOIN suppliers AS s ON s.suppliers_id = c.suppliers_id

LEFT JOIN fulfilments_income_packages_status_history AS fiph ON fiph.object_id = fip.fulfilments_income_packages_id AND fiph.status_id IN(132, 217)

WHERE

fip.fulfilments_income_packages_external_id IN(
423928, 490046, 513007, 545908, 545994, 555991, 577895, 590551, 607556, 607719, 642915, 643284, 643292, 643299, 643311, 643797, 644262, 644822, 644827, 644869, 644930, 644935, 645002, 620410, 625817, 625842, 645424, 651823, 652219, 686430, 686431, 686257, 686611, 686613, 686614, 686615, 686705, 686706

)