SELECT
    p.products_id
    ,p.products_quantity
    ,p.products_model
    ,p.products_mpn
    ,p.products_image
    ,p.products_price
    ,p.products_price_ebay
    ,p.products_date_added
    ,p.products_last_modified
    ,p.products_date_available
    ,p.products_weight
    ,p.products_status
    ,p.products_manufacturer_nr
    ,p.products_tax_class_id
    ,p.manufacturers_id
    ,p.products_ordered
    ,p.products_manual
    ,p.products_availability_id
    ,p.products_ean
    ,p.products_last_data_changed
    ,p.products_name_manual
    ,pd.language_id
    ,pd.products_name
    ,pd.products_description
    ,c.categories_id
    ,c.categories_image
    ,c.parent_id
    ,c.sort_order
    ,c.date_added
    ,c.last_modified
    ,c.categories_path
    ,p2e.ebay_id
    ,IF(op.products_id IS NOT NULL,'yes','no') AS bereits_bestellt

FROM
    preiscompany_sandbox.products AS p
    LEFT JOIN
        preiscompany_sandbox.products_to_price_se_excludes AS psee
    ON
        p.products_id = psee.products_id,
    preiscompany_sandbox.products_description AS pd,
    preiscompany_sandbox.categories AS c,
    preiscompany_sandbox.products_to_categories AS ptc,
    preiscompany_ebay.products2ebay AS p2e
    LEFT JOIN
        preiscompany_sandbox.orders_products AS op
    ON
        p2e.products_id = op.products_id
    LEFT JOIN
        preiscompany_sandbox.orders AS o
    ON
        o.orders_id = op.orders_id

WHERE
    p.products_id = p2e.products_id
    AND p.products_id = pd.products_id
    AND p.products_model <> p.products_id
    AND p.products_price >= 0.01
    AND ptc.categories_id = c.categories_id
    AND ptc.products_id = p.products_id
    AND psee.products_id IS NULL
    AND p.products_availability_id = 0
    AND pd.language_id = 2

GROUP BY
    p2e.products_id

HAVING p.products_last_data_changed >  FROM_UNIXTIME(:lastUpdate)