10 lines
383 B
Bash
10 lines
383 B
Bash
#!/bin/bash
|
|
PGPASSWORD=MKstaging2026 psql -U metallkart -d erp_staging -h localhost -t -c "
|
|
SELECT s.id AS smeta_id, s.order_id, o.order_code,
|
|
(SELECT count(*) FROM smeta_labor_nodes n WHERE n.smeta_id=s.id) AS nodes
|
|
FROM smetas s
|
|
JOIN orders o ON o.id = s.order_id
|
|
WHERE s.is_locked = true
|
|
AND EXISTS (SELECT 1 FROM smeta_labor_nodes n WHERE n.smeta_id=s.id)
|
|
ORDER BY s.id;
|
|
" |