On the "Top employers" box in the main page https://careerjob.mb-themes.com/ how to show only the number of the "job offers" that are still open and not expired?

Cause the problem here if the ads are expired and the user added 20 jobs the last year and the last month nothing, in these box will show the number of the 20 job offers but when you click on it will show no ads if there are nothing active!

@developGr
THis is query used:
  $sql = 'SELECT * FROM ' . DB_TABLE_PREFIX . 't_user WHERE i_items > 0 AND b_company = 1 ORDER BY i_items DESC LIMIT ' . $limit;

So this information is retrieved from i_items field in user table.

so you cant show the correct number of the listings that are active for the user-company?

@developGr
I do not remember what everything counts toward that field but if it is all then yes, you would have to use some different method of getting active listings or adjust counter