Help needed for Mautic tracking code

[swguy]

Just add an order by to your query.

ORDER BY orders_id DESC LIMIT 1

[hubert]

Just add an order by to your query.

ORDER BY orders_id DESC LIMIT 1

I think I misunderstood cause

SELECT
    customers.customers_id, 
    customers.customers_firstname, 
    customers.customers_lastname, 
    customers.customers_email_address, 
    customers_info.customers_info_date_of_last_logon, 
    customers_info.customers_info_number_of_logons, 
    customers_info.customers_info_date_account_last_modified, 
    customers_info.customers_info_date_account_created, 
    orders.order_total, 
    SUM(orders.order_total) AS zc_orders_tot, 
    SUBSTRING_INDEX(orders.ip_address,' - ',1) AS ip_address1, 
    SUBSTRING_INDEX(orders.ip_address,' - ',-1) AS ip_address2, 
    reward_customer_points.reward_points, 
    reward_customer_points.pending_points, 
    customers.customers_newsletter, 
    customers.customers_dob, 
    customers.customers_gender, 
    customers.customers_email_format, 
    orders.date_completed, 
    orders.date_purchased
FROM
    customers
    LEFT JOIN
    customers_info
    ON 
        customers.customers_id = customers_info.customers_info_id
    LEFT JOIN
    orders
    ON 
        customers.customers_id = orders.customers_id
    LEFT JOIN
    reward_customer_points
    ON 
        customers.customers_id = reward_customer_points.customers_id
GROUP BY
    customers.customers_id
ORDER BY orders_id DESC

still returns the amount of customers first order not last.

[swguy]

you don't need the GROUP BY

[hubert]

you don't need the GROUP BY

I removed and the answer stays the same. Could you please elaborate or post your complete query.

Thanks

[lat9]

Shouldn't there be a WHERE clause within that query so that you're pulling the information for the currently-logged-in customer?