Best practice to limit results in get_row()?

This is essentially a SQL question. The only possible WordPress related component would be if you were asking about database structure, which is in the Codex. Or you could just look at the database itself.

The post ID is incremented and never duplicated. The highest IDs are the last added. The query is simple.

SELECT * 
FROM {$wpdb->posts} 
WHERE post_title="{$titles_arr[$i]}"
ORDER BY {$wpdb->posts}.ID DESC
LIMIT 0,1000

Please note that I used $wpdb->posts instead of hard-coding the table name. Your query will break on a site that has a different prefix than wp_ and on multisite (I am pretty sure).

Note that the $wpdb->posts hold a lot of information besides simply post post types. If you specifically want just post post types you will need to add a further condition.

SELECT * 
FROM {$wpdb->posts} 
WHERE post_title="{$titles_arr[$i]}"
AND {$wpdb->posts}.post_type="post"
ORDER BY {$wpdb->posts}.ID DESC
LIMIT 0,1000

Still further conditions could be required to prevent the results from including ‘draft’ or ‘pending’ posts, or ‘revisions’, or a number of other things.

Related Posts: