Detail-Info

media-query-regex first: SELECT DISTINCTROW t.name tag_name, t.slug tag_slug, tt.taxonomy, tt.description, p.id post_id, p.post_name, p.post_title, LEFT(p.post_title,13) sigx, p.guid post_guid, p.post_mime_type FROM wp_terms t JOIN wp_term_taxonomy tt ON t.term_id = tt.term_id AND tt.taxonomy = 'post_tag' JOIN wp_term_relationships tr ON tt.term_taxonomy_id = tr.term_taxonomy_id JOIN wp_posts p on tr.object_id = p.id and p.post_type = 'attachment' AND p.post_mime_type = 'image/jpeg' WHERE REPLACE(p.post_title,'_','') regexp '^P[A-Z]{2}\.[A-Z][A-Z0-9]{3}\.[A-Z0-9][0-9]{2}[a-z]?' AND (t.name regexp %s or t.slug regexp %s) ORDER BY p.post_name LIMIT 1;

media-query-regex next: SELECT DISTINCTROW t.name tag_name, t.slug tag_slug, tt.taxonomy, tt.description, p.id post_id, p.post_name, p.post_title, LEFT(p.post_title,13) sigx, p.guid post_guid, p.post_mime_type FROM wp_terms t JOIN wp_term_taxonomy tt ON t.term_id = tt.term_id AND tt.taxonomy = 'post_tag' JOIN wp_term_relationships tr ON tt.term_taxonomy_id = tr.term_taxonomy_id JOIN wp_posts p on tr.object_id = p.id and p.post_type = 'attachment' AND p.post_mime_type = 'image/jpeg' WHERE REPLACE(p.post_title,'_','') regexp '^P[A-Z]{2}\.[A-Z][A-Z0-9]{3}\.[A-Z0-9][0-9]{2}[a-z]?' AND (t.name regexp %s or t.slug regexp %s) and p.post_name > concat(%s,'z') ORDER BY p.post_name LIMIT 1;

SELECT DISTINCTROW upper(left(p.image_slug,9)) as bild, t.name tag_name FROM wp_terms t JOIN wp_term_taxonomy tt ON t.term_id = tt.term_id AND tt.taxonomy = 'ngg_tag' JOIN wp_term_relationships tr ON tt.term_taxonomy_id = tr.term_taxonomy_id JOIN wp_ngg_pictures p on tr.object_id = p.pid WHERE (t.name regexp %s or t.slug regexp %s) and p.image_slug > concat(%s,'z') ORDER BY p.image_slug LIMIT 1;

ngg1 rows: 1 regex: ^(Bäretswil)$ - bild: GSOBD-115