From 34cf9543ab0aa5c46bd2713abf3602356f47caea Mon Sep 17 00:00:00 2001 From: Zachary Vance Date: Tue, 4 Aug 2015 19:33:56 -0700 Subject: [PATCH] Stylish db query --- stylish.db | 1 + 1 file changed, 1 insertion(+) create mode 100644 stylish.db diff --git a/stylish.db b/stylish.db new file mode 100644 index 0000000..4acefc8 --- /dev/null +++ b/stylish.db @@ -0,0 +1 @@ +SELECT style, code, GROUP_CONCAT(section_meta.value) as 'website(s)' FROM (SELECT styles.name AS style,sections.code AS code,sections.id AS sections_id FROM styles INNER JOIN sections ON sections.style_id = styles.id) LEFT JOIN section_meta ON section_meta.section_id = sections_id GROUP BY style; -- 2.47.3