0 | Database connection to mysql:host=xwp-topgear.xel.nl;dbname=wp74210-1db1;charset=utf8mb4; | 0.001 sec |
1 | SELECT t.slug, t.name, t.term_id, tt.term_taxonomy_id AS taxonomy_id, MIN(tm.meta_value) AS active FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id LEFT JOIN wp_termmeta AS tm ON (t.term_id = tm.term_id AND tm.meta_key = 'active') WHERE taxonomy = 'automerk' GROUP BY t.term_id ORDER BY t.name ASC | 0.000 sec |
2 | SELECT t.slug, t.name, t.term_id, tt.term_taxonomy_id AS taxonomy_id, MIN(tmm.meta_value) AS brand, MIN(tma.meta_value) AS active FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id INNER JOIN wp_termmeta AS tmm ON (t.term_id = tmm.term_id) INNER JOIN wp_termmeta AS tma ON (t.term_id = tma.term_id) WHERE tt.taxonomy = "automodel" AND tmm.meta_key = "Merk" AND tma.meta_key = "Active" GROUP BY t.term_id ORDER BY brand, t.name ASC | 0.001 sec |