SELECT down_table.sikepuri_id AS sikepuri_id, down_table.down_count AS down_count, sikepuri_table.sikepuri_title AS sikepuri_title, sikepuri_table.sikepuri_creater AS sikepuri_creater, sikepuri_table.sikepuri_kind AS sikepuri_kind, sikepuri_table.classdata_id AS classdata_id, sikepuri_table.classdata_name1 AS classdata_name1, sikepuri_table.classdata_count AS classdata_count FROM (SELECT sikepuri_id, COUNT(*) AS down_count FROM sikepuri_downlog GROUP BY sikepuri_id) AS down_table, (SELECT sikepuri.id AS sikepuri_id, sikepuri.title AS sikepuri_title, sikepuri.kind AS sikepuri_kind, sikepuri.creater AS sikepuri_creater, classdata.id AS classdata_id, classdata.name1 AS classdata_name1, COUNT(DISTINCT classdata.id) AS classdata_count FROM sikepuri LEFT JOIN sikepuri_link ON sikepuri.id = sikepuri_link.sikepuri_id LEFT JOIN classdata ON sikepuri_link.classdata_id = classdata.id GROUP BY sikepuri.id) AS sikepuri_table WHERE down_table.sikepuri_id = sikepuri_table.sikepuri_id
Apply for WoSign Digital Certificates online: SSL Certificates| Code Signing Certificates| EV SSL Certificates | OV SSL Certificates | DV SSL Certificates | 2048bits Web Server Certificate, Support all types of browsers and servers, and support with Chinese in certificate subject, Support IDN domain names ! https://buy.wosign.com/free/
-----
中国製の無料SSL証明書発行サイトらしい
Think-Silicon/GLOVE: GLOVE (GL Over Vulkan) is a software library that acts as an intermediate layer between an OpenGL application and Vulkan https://github.com/Think-Silicon/GLOVE