SELECT
wp_116_posts.*
FROM
wp_116_posts
INNER JOIN
wp_116_postmeta ON (wp_116_posts.ID = wp_116_postmeta.post_id)
WHERE
wp_116_posts.post_type = 'attachment'
AND
((wp_116_posts.post_status = 'inherit'))
AND
((wp_116_postmeta.meta_key = '_wp_attachment_is_custom_header' AND CAST(wp_116_postmeta.meta_value AS CHAR) = 'infax_2016_bootstrap'))
GROUP BY
wp_116_posts.ID
Array
(
[0] => stdClass Object
(
[ID] => 18
[post_author] => 1
[post_date] => 2016-10-19 14:54:19
[post_date_gmt] => 2016-10-19 12:54:19
[post_content] => http://infax.org/zilleoberkassel/wp-content/uploads/sites/116/2016/10/01DSCF5156.jpg
[post_title] => 01DSCF5156.jpg
[post_excerpt] =>
[post_status] => inherit
[comment_status] => open
[ping_status] => open
[post_password] =>
[post_name] => 01dscf5156-jpg
[to_ping] =>
[pinged] =>
[post_modified] => 2016-10-19 14:54:19
[post_modified_gmt] => 2016-10-19 12:54:19
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://infax.org/zilleoberkassel/wp-content/uploads/sites/116/2016/10/01DSCF5156.jpg
[menu_order] => 0
[post_type] => attachment
[post_mime_type] => image/jpeg
[comment_count] => 0
)
[1] => stdClass Object
(
[ID] => 19
[post_author] => 1
[post_date] => 2016-10-19 14:54:29
[post_date_gmt] => 2016-10-19 12:54:29
[post_content] => http://infax.org/zilleoberkassel/wp-content/uploads/sites/116/2016/10/02DSC_0018.jpg
[post_title] => 02DSC_0018.jpg
[post_excerpt] =>
[post_status] => inherit
[comment_status] => open
[ping_status] => open
[post_password] =>
[post_name] => 02dsc_0018-jpg
[to_ping] =>
[pinged] =>
[post_modified] => 2016-10-19 14:54:29
[post_modified_gmt] => 2016-10-19 12:54:29
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://infax.org/zilleoberkassel/wp-content/uploads/sites/116/2016/10/02DSC_0018.jpg
[menu_order] => 0
[post_type] => attachment
[post_mime_type] => image/jpeg
[comment_count] => 0
)
[2] => stdClass Object
(
[ID] => 20
[post_author] => 1
[post_date] => 2016-10-19 14:54:38
[post_date_gmt] => 2016-10-19 12:54:38
[post_content] => http://infax.org/zilleoberkassel/wp-content/uploads/sites/116/2016/10/03DSC_0011.jpg
[post_title] => 03DSC_0011.jpg
[post_excerpt] =>
[post_status] => inherit
[comment_status] => open
[ping_status] => open
[post_password] =>
[post_name] => 03dsc_0011-jpg
[to_ping] =>
[pinged] =>
[post_modified] => 2016-10-19 14:54:38
[post_modified_gmt] => 2016-10-19 12:54:38
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://infax.org/zilleoberkassel/wp-content/uploads/sites/116/2016/10/03DSC_0011.jpg
[menu_order] => 0
[post_type] => attachment
[post_mime_type] => image/jpeg
[comment_count] => 0
)
[3] => stdClass Object
(
[ID] => 21
[post_author] => 1
[post_date] => 2016-10-19 14:54:45
[post_date_gmt] => 2016-10-19 12:54:45
[post_content] => http://infax.org/zilleoberkassel/wp-content/uploads/sites/116/2016/10/DSC_0021.jpg
[post_title] => DSC_0021.jpg
[post_excerpt] =>
[post_status] => inherit
[comment_status] => open
[ping_status] => open
[post_password] =>
[post_name] => dsc_0021-jpg
[to_ping] =>
[pinged] =>
[post_modified] => 2016-10-19 14:54:45
[post_modified_gmt] => 2016-10-19 12:54:45
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://infax.org/zilleoberkassel/wp-content/uploads/sites/116/2016/10/DSC_0021.jpg
[menu_order] => 0
[post_type] => attachment
[post_mime_type] => image/jpeg
[comment_count] => 0
)
[4] => stdClass Object
(
[ID] => 22
[post_author] => 1
[post_date] => 2016-10-19 14:54:57
[post_date_gmt] => 2016-10-19 12:54:57
[post_content] => http://infax.org/zilleoberkassel/wp-content/uploads/sites/116/2016/10/DSCF5140.jpg
[post_title] => DSCF5140.jpg
[post_excerpt] =>
[post_status] => inherit
[comment_status] => open
[ping_status] => open
[post_password] =>
[post_name] => dscf5140-jpg
[to_ping] =>
[pinged] =>
[post_modified] => 2016-10-19 14:54:57
[post_modified_gmt] => 2016-10-19 12:54:57
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://infax.org/zilleoberkassel/wp-content/uploads/sites/116/2016/10/DSCF5140.jpg
[menu_order] => 0
[post_type] => attachment
[post_mime_type] => image/jpeg
[comment_count] => 0
)
[5] => stdClass Object
(
[ID] => 23
[post_author] => 1
[post_date] => 2016-10-19 14:55:06
[post_date_gmt] => 2016-10-19 12:55:06
[post_content] => http://infax.org/zilleoberkassel/wp-content/uploads/sites/116/2016/10/DSCF5155.jpg
[post_title] => DSCF5155.jpg
[post_excerpt] =>
[post_status] => inherit
[comment_status] => open
[ping_status] => open
[post_password] =>
[post_name] => dscf5155-jpg
[to_ping] =>
[pinged] =>
[post_modified] => 2016-10-19 14:55:06
[post_modified_gmt] => 2016-10-19 12:55:06
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://infax.org/zilleoberkassel/wp-content/uploads/sites/116/2016/10/DSCF5155.jpg
[menu_order] => 0
[post_type] => attachment
[post_mime_type] => image/jpeg
[comment_count] => 0
)
)
Array
(
[18] => Array
(
[attachment_id] => 18
[url] => https://infax.org/zilleoberkassel/wp-content/uploads/sites/116/2016/10/01DSCF5156.jpg
[thumbnail_url] => https://infax.org/zilleoberkassel/wp-content/uploads/sites/116/2016/10/01DSCF5156.jpg
[alt_text] =>
)
[19] => Array
(
[attachment_id] => 19
[url] => https://infax.org/zilleoberkassel/wp-content/uploads/sites/116/2016/10/02DSC_0018.jpg
[thumbnail_url] => https://infax.org/zilleoberkassel/wp-content/uploads/sites/116/2016/10/02DSC_0018.jpg
[alt_text] =>
)
[20] => Array
(
[attachment_id] => 20
[url] => https://infax.org/zilleoberkassel/wp-content/uploads/sites/116/2016/10/03DSC_0011.jpg
[thumbnail_url] => https://infax.org/zilleoberkassel/wp-content/uploads/sites/116/2016/10/03DSC_0011.jpg
[alt_text] =>
)
[21] => Array
(
[attachment_id] => 21
[url] => https://infax.org/zilleoberkassel/wp-content/uploads/sites/116/2016/10/DSC_0021.jpg
[thumbnail_url] => https://infax.org/zilleoberkassel/wp-content/uploads/sites/116/2016/10/DSC_0021.jpg
[alt_text] =>
)
[22] => Array
(
[attachment_id] => 22
[url] => https://infax.org/zilleoberkassel/wp-content/uploads/sites/116/2016/10/DSCF5140.jpg
[thumbnail_url] => https://infax.org/zilleoberkassel/wp-content/uploads/sites/116/2016/10/DSCF5140.jpg
[alt_text] =>
)
[23] => Array
(
[attachment_id] => 23
[url] => https://infax.org/zilleoberkassel/wp-content/uploads/sites/116/2016/10/DSCF5155.jpg
[thumbnail_url] => https://infax.org/zilleoberkassel/wp-content/uploads/sites/116/2016/10/DSCF5155.jpg
[alt_text] =>
)
)
#######
Wir nutzen Cookies, um dir den bestmöglichen Service zu gewährleisten. Wenn du auf der Seite weitersurfst, stimmst du der Cookie-Nutzung zu.Verstanden.Datenschutzerklärung
Load: 13 queries - 0ms - 42.1MB - 55 cache hits / 122
Query: 18 queries - 0ms - 42.1MB - 68 cache hits / 152
Display: 39 queries - 1000ms - 43.3MB - 1382 cache hits / 1595
Schreibe einen Kommentar
Du musst angemeldet sein, um einen Kommentar abzugeben.