id	summary	reporter	owner	description	type	status	priority	milestone	component	version	severity	resolution	keywords	cc
20193	wp_post_mime_type_where does not properly prefix table names	benbalter	nacin	"When called from the iframe media gallery, for example, `wp_post_mime_type_where` does not properly prefix the table name of `post_mime_type` in the `WHERE` clause, leading to a possible ambiguity if a plugin filters the media list by adding a join.

Related: #19779 and #12750.

Steps to reproduce:

1. Add a filter to `posts_where` that joins wp_posts (e.g., attachment:example-filter.php:ticket:19779)
2. Navigate to a post and attempt to insert an existing image from the gallery via the media upload iframe
3. Receive an error message that `post_mime_type` is ambiguous

I propose that when no table alias is given, the function defaults to `$wpdb->posts` to prevent ambiguity.
"	defect (bug)	closed	normal	3.4	Media	3.4	minor	fixed	has-patch	lkraav