[SOLVED] Mysql - display only the last 10 tickets recorded via web?

[amdkryn]

Can anyone help me in the query below to display only the last 10 tickets registered?

I know nothing about SQL, it was not me who created this query.

SELECT ticket.tn, tht.name FROM `ticket_history` th left join ticket on ticket.id = th.ticket_id left join ticket_history_type tht on tht.id = th.history_type_id WHERE th.history_type_id in (29)

Thanks,

[crythias]

Code: Select all

SELECT ticket.tn, tht.name FROM `ticket_history` th left join ticket on ticket.id = th.ticket_id left join ticket_history_type tht on tht.id = th.history_type_id WHERE th.history_type_id in (29)

This selects ticket number and ticket history type from those with WebRequestCustomer

Code: Select all

SELECT ticket.tn, tht.name FROM `ticket_history` th left join ticket on ticket.id = th.ticket_id left join ticket_history_type tht on tht.id = th.history_type_id WHERE th.history_type_id in (29) order by ticket.tn desc limit 10

I'm ordering by ticket number, assuming that is numerically incremental in some way rather than alphanumeric randomized. Otherwise you can

Code: Select all

SELECT ticket.tn, tht.name FROM `ticket_history` th left join ticket on ticket.id = th.ticket_id left join ticket_history_type tht on tht.id = th.history_type_id WHERE th.history_type_id in (29) order by ticket.create_time desc limit 10

[amdkryn]

Great, thank you.