We are a technology company that develops and operates web applications and websites for small and medium-sized businesses.
Our core business is contract-based development, and we also build and run our own services to help improve business operations and launch online services.
Using HTML, PHP, JavaScript, CSS, and Shell as our foundation, we combine public APIs and modern web technologies to create systems that best fit our clients’ needs and businesses.
From planning and design to development and hosting, we provide a complete one-stop service, delivering web systems that our clients can rely on long after launch.
In our “Showcase”, you can see examples of websites, web applications, and desktop applications that we have built.
If you like what you see here, you can buy me a coffee. ☕

We are based in Hiroshima, Japan.
For inquiries, please click contact us.
If you like what you see here, you can buy me a coffee. ☕
日付と項目と金額を格納したテーブルがあります。date char(10)
itemid char(2)
amount int(11)
ここから、itemid が 'in' のものとそうでないものを分けて amount を集計しようと思います。最終的には、受け取った結果から、収支バランス(income - expense)を求めます。select
(select sum(`amount`) from `hhab` where `itemid` = 'in' and `date` >= '2026-11-01') as `income`,
(select sum(`amount`) from `hhab` where `itemid` != 'in' and `date` >= '2026-11-01') as `expense`
こんなことをやっていました。たぶん、内部で select を2回繰り返しているんだと思います。SELECT
SUM(CASE WHEN itemid = 'in' THEN amount ELSE 0 END) AS income,
SUM(CASE WHEN itemid != 'in' THEN amount ELSE 0 END) AS expense
FROM hhab
WHERE date >= '2026-11-01';
なるほど🤔 sum()関数の中で case when で条件を設定するんですね。SELECT
SUM(IF(itemid = 'in', amount, 0)) AS income,
SUM(IF(itemid != 'in', amount, 0)) AS expense
FROM hhab
WHERE date >= '2026-11-01';
こっちの方が見慣れている感じがしてわかりやすいですね😊SELECT
COALESCE(SUM(IF(itemid = 'in', amount, 0)), 0) AS income,
COALESCE(SUM(IF(itemid != 'in', amount, 0)), 0) AS expense
FROM hhab
WHERE date >= '2026-11-01';
こんな感じで条件付きsum()関数を coalesce() で囲むと 0 が返ってくるようになります。SELECT
COALESCE(SUM(IF(itemid = 'in', amount, 0)), 0) AS income,
COALESCE(SUM(IF(itemid != 'in', amount, 0)), 0) AS expense,
COALESCE(SUM(IF(itemid = 'in', amount, -amount)), 0) AS balance
FROM hhab
WHERE date >= '2026-11-01'
AND date < '2026-12-01';
たぶん、次のように読みます。COALESCE(SUM(IF(item != 'in', amount, 0)), 0) AS expense,
item が in でなかったら amount を、そうでなかったら 0 を expense に集計
最後、null だったら 0 を返す
COALESCE(SUM(IF(item = 'in', amount, -amount)), 0) AS balance
item が in だったら amount を、そうでなかったら -amount を balance に集計
最後、null だったら 0 を返す
PHPの重大な脆弱性(CVE-2026-109618とCVE-2026-109619)が発表されました。