Database Queries

SELECT 1 AS `name`, SUM(IF(h.inn1='1',1,0)) AS Y FROM env_com_innovation h INNER JOIN cchangwat c ON c.changwatcode=LEFT(h.areacode,2) INNER JOIN env_com_region z ON z.region_code=c.regioncode

SELECT 2 AS `name`, SUM(IF(h.inn2='1',1,0)) AS Y FROM env_com_innovation h INNER JOIN cchangwat c ON c.changwatcode=LEFT(h.areacode,2) INNER JOIN env_com_region z ON z.region_code=c.regioncode

SELECT 3 AS `name`, SUM(IF(h.inn3='1',1,0)) AS Y FROM env_com_innovation h INNER JOIN cchangwat c ON c.changwatcode=LEFT(h.areacode,2) INNER JOIN env_com_region z ON z.region_code=c.regioncode

SELECT 4 AS `name`, SUM(IF(h.inn4='1',1,0)) AS Y FROM env_com_innovation h INNER JOIN cchangwat c ON c.changwatcode=LEFT(h.areacode,2) INNER JOIN env_com_region z ON z.region_code=c.regioncode

SELECT 5 AS `name`, SUM(IF(h.inn5='1',1,0)) AS Y FROM env_com_innovation h INNER JOIN cchangwat c ON c.changwatcode=LEFT(h.areacode,2) INNER JOIN env_com_region z ON z.region_code=c.regioncode

SELECT 6 AS `name`, SUM(IF(h.inn6='1',1,0)) AS Y FROM env_com_innovation h INNER JOIN cchangwat c ON c.changwatcode=LEFT(h.areacode,2) INNER JOIN env_com_region z ON z.region_code=c.regioncode

SELECT 7 AS `name`, SUM(IF(h.inn7='1',1,0)) AS Y FROM env_com_innovation h INNER JOIN cchangwat c ON c.changwatcode=LEFT(h.areacode,2) INNER JOIN env_com_region z ON z.region_code=c.regioncode

SELECT 8 AS `name`, SUM(IF(h.inn8='1',1,0)) AS Y FROM env_com_innovation h INNER JOIN cchangwat c ON c.changwatcode=LEFT(h.areacode,2) INNER JOIN env_com_region z ON z.region_code=c.regioncode

SELECT 9 AS `name`, SUM(IF(h.inn9='1',1,0)) AS Y FROM env_com_innovation h INNER JOIN cchangwat c ON c.changwatcode=LEFT(h.areacode,2) INNER JOIN env_com_region z ON z.region_code=c.regioncode

SELECT 10 AS `name`, SUM(IF(h.inn10='1',1,0)) AS Y FROM env_com_innovation h INNER JOIN cchangwat c ON c.changwatcode=LEFT(h.areacode,2) INNER JOIN env_com_region z ON z.region_code=c.regioncode

SELECT IFNULL(z.region_code,'TOTAL') AS areacode, t.target AS `value`, t.target2 AS `value2`, z.region_name AS areaname_new, COUNT(z.region_code) AS total, -- SUM(IF(IFNULL(h.result_S,0)='N',1,0)) AS noeval, s.tpass AS tpass, h.apass AS apass FROM env_com_region z LEFT JOIN (SELECT COUNT(DISTINCT areacode) AS tpass,regionBy AS sregion FROM env_com_report WHERE ryear = '2568' AND regionBy NOT IN ('00','20') GROUP BY regionBy) s ON z.region_code = s.sregion LEFT JOIN (SELECT SUM(target) AS target ,SUM(target2) AS target2 ,areacode FROM env_com_result WHERE b_year='2568' GROUP BY areacode) t ON z.region_code=t.areacode LEFT JOIN (SELECT e.id,e.areacode, SUM(IF(e.result_S='1',1,0)) AS apass,e.regionBy AS regioncode FROM env_com_report e WHERE e.id IN (SELECT MAX(id) FROM env_com_report WHERE ryear = '2568' AND result_S = '1' AND regionBy IN ('01','02','03','04','05','06','07','08','09','10','11','12','20') GROUP BY areacode,regionBy )GROUP BY e.regionBy) h ON z.region_code = h.regioncode WHERE z.region_code NOT IN ('13','00','99') GROUP BY h.regioncode order by z.region_code

select * from geojson where areatype=1

SELECT z.region_code AS cname, COUNT(z.region_code) AS total, t.target AS `value`, t.target2 AS `value2`, (SELECT SUM(target) FROM env_com_result WHERE b_year='2568' AND areacode NOT IN ('13','00','20','99') ) AS target, (SELECT result1 FROM env_com_result WHERE b_year='2568' AND areacode='01' ) AS result1, z.region_name AS areaname, s.tpass AS tpass, h.apass AS apass FROM env_com_region z LEFT JOIN (SELECT COUNT(DISTINCT areacode) AS tpass,regionBy AS sregion FROM env_com_report WHERE ryear = '2568' AND regionBy NOT IN ('00','20') GROUP BY regionBy) s ON z.region_code = s.sregion LEFT JOIN (SELECT SUM(target) AS target ,SUM(target2) AS target2 ,areacode FROM env_com_result WHERE b_year='2568' GROUP BY areacode) t ON z.region_code=t.areacode LEFT JOIN (SELECT e.id,e.areacode, SUM(IF(e.result_S='1',1,0)) AS apass,e.regionBy AS regioncode FROM env_com_report e WHERE e.id IN (SELECT MAX(id) FROM env_com_report WHERE ryear = '2568' AND result_S = '1' AND regionBy IN ('01','02','03','04','05','06','07','08','09','10','11','12','20') GROUP BY areacode,regionBy )GROUP BY e.regionBy) h ON z.region_code = h.regioncode WHERE z.region_code NOT IN ('13','00','20','99') GROUP BY h.regioncode

SELECT z.region_name AS cname, COUNT(z.region_code) AS total, t.target AS `value`, h.npass AS npass, h.apass AS apass, h.inno1 AS inno1, h.inno2 AS inno2, h.inno3 AS inno3, h.inno4 AS inno4, h.inno5 AS inno5, h.inno6 AS inno6, h.inno7 AS inno7, h.inno8 AS inno8, h.inno9 AS inno9, h.inno10 AS inno10, (SELECT SUM(target) FROM env_com_result WHERE b_year='2568') AS target FROM env_com_region z LEFT JOIN (SELECT e.areacode , SUM(IF(e.result_S='0',1,0)) AS npass, SUM(IF(e.result_S='1',1,0)) AS apass, SUM(IF(e.inno1='1',1,0)) AS inno1, SUM(IF(e.inno2='1',1,0)) AS inno2, SUM(IF(e.inno3='1',1,0)) AS inno3, SUM(IF(e.inno4='1',1,0)) AS inno4, SUM(IF(e.inno5='1',1,0)) AS inno5, SUM(IF(e.inno6='1',1,0)) AS inno6, SUM(IF(e.inno7='1',1,0)) AS inno7, SUM(IF(e.inno8='1',1,0)) AS inno8, SUM(IF(e.inno9='1',1,0)) AS inno9, SUM(IF(e.inno10='1',1,0)) AS inno10, e.regionBy AS regioncode,e.regionBy AS regionBy FROM env_com_report e WHERE e.id IN (SELECT MAX(id) FROM env_com_report WHERE ryear = '2568' AND regionBy NOT IN ('00','20') GROUP BY areacode )GROUP BY e.regionBy) h ON z.region_code = h.regionBy LEFT JOIN (SELECT SUM(target) AS target ,areacode FROM env_com_result WHERE b_year='2568' GROUP BY areacode) t ON h.regionBy=t.areacode WHERE z.region_code NOT IN ('00','13','99') GROUP BY z.region_code

SELECT `data` FROM `session` WHERE `expire`>1754317507 AND `id`='ce4h01r4nj9o5spas0lc6gjuq6'

SHOW FULL COLUMNS FROM `session`

SELECT kcu.constraint_name, kcu.column_name, kcu.referenced_table_name, kcu.referenced_column_name FROM information_schema.referential_constraints AS rc JOIN information_schema.key_column_usage AS kcu ON ( kcu.constraint_catalog = rc.constraint_catalog OR (kcu.constraint_catalog IS NULL AND rc.constraint_catalog IS NULL) ) AND kcu.constraint_schema = rc.constraint_schema AND kcu.constraint_name = rc.constraint_name WHERE rc.constraint_schema = database() AND kcu.table_schema = database() AND rc.table_name = 'session' AND kcu.table_name = 'session'

SELECT `kcu`.`CONSTRAINT_NAME` AS `name`, `kcu`.`COLUMN_NAME` AS `column_name`, `tc`.`CONSTRAINT_TYPE` AS `type`, CASE WHEN NULL IS NULL AND `kcu`.`REFERENCED_TABLE_SCHEMA` = DATABASE() THEN NULL ELSE `kcu`.`REFERENCED_TABLE_SCHEMA` END AS `foreign_table_schema`, `kcu`.`REFERENCED_TABLE_NAME` AS `foreign_table_name`, `kcu`.`REFERENCED_COLUMN_NAME` AS `foreign_column_name`, `rc`.`UPDATE_RULE` AS `on_update`, `rc`.`DELETE_RULE` AS `on_delete`, `kcu`.`ORDINAL_POSITION` AS `position` FROM `information_schema`.`KEY_COLUMN_USAGE` AS `kcu`, `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc`, `information_schema`.`TABLE_CONSTRAINTS` AS `tc` WHERE `kcu`.`TABLE_SCHEMA` = COALESCE(NULL, DATABASE()) AND `kcu`.`CONSTRAINT_SCHEMA` = `kcu`.`TABLE_SCHEMA` AND `kcu`.`TABLE_NAME` = 'session' AND `rc`.`CONSTRAINT_SCHEMA` = `kcu`.`TABLE_SCHEMA` AND `rc`.`TABLE_NAME` = 'session' AND `rc`.`CONSTRAINT_NAME` = `kcu`.`CONSTRAINT_NAME` AND `tc`.`TABLE_SCHEMA` = `kcu`.`TABLE_SCHEMA` AND `tc`.`TABLE_NAME` = 'session' AND `tc`.`CONSTRAINT_NAME` = `kcu`.`CONSTRAINT_NAME` AND `tc`.`CONSTRAINT_TYPE` = 'FOREIGN KEY' UNION SELECT `kcu`.`CONSTRAINT_NAME` AS `name`, `kcu`.`COLUMN_NAME` AS `column_name`, `tc`.`CONSTRAINT_TYPE` AS `type`, NULL AS `foreign_table_schema`, NULL AS `foreign_table_name`, NULL AS `foreign_column_name`, NULL AS `on_update`, NULL AS `on_delete`, `kcu`.`ORDINAL_POSITION` AS `position` FROM `information_schema`.`KEY_COLUMN_USAGE` AS `kcu`, `information_schema`.`TABLE_CONSTRAINTS` AS `tc` WHERE `kcu`.`TABLE_SCHEMA` = COALESCE(NULL, DATABASE()) AND `kcu`.`TABLE_NAME` = 'session' AND `tc`.`TABLE_SCHEMA` = `kcu`.`TABLE_SCHEMA` AND `tc`.`TABLE_NAME` = 'session' AND `tc`.`CONSTRAINT_NAME` = `kcu`.`CONSTRAINT_NAME` AND `tc`.`CONSTRAINT_TYPE` IN ('PRIMARY KEY', 'UNIQUE') ORDER BY `position` ASC

SELECT `s`.`INDEX_NAME` AS `name`, `s`.`COLUMN_NAME` AS `column_name`, `s`.`NON_UNIQUE` ^ 1 AS `index_is_unique`, `s`.`INDEX_NAME` = 'PRIMARY' AS `index_is_primary` FROM `information_schema`.`STATISTICS` AS `s` WHERE `s`.`TABLE_SCHEMA` = COALESCE(NULL, DATABASE()) AND `s`.`INDEX_SCHEMA` = `s`.`TABLE_SCHEMA` AND `s`.`TABLE_NAME` = 'session' ORDER BY `s`.`SEQ_IN_INDEX` ASC

INSERT INTO `session` (`data`, `id`, `expire`) VALUES ('__flash|a:0:{}', 'ce4h01r4nj9o5spas0lc6gjuq6', 1754318947) ON DUPLICATE KEY UPDATE `data`=VALUES(`data`), `expire`=VALUES(`expire`)