An error occured in: ERROR: could not resize shared memory segment "/PostgreSQL.905724404" to 1048576 bytes: No space left on device Query: SELECT
ip_powiat.powiat_id as id,
REPLACE(powiat_name, 'm.', '') as name,
powiat_seo as seo,
ip_powiat.google_border,
COALESCE(SUM(ic.ile), 0) as ile
FROM
ip_powiat
LEFT JOIN(
SELECT ip_city.city_id, ip_city.powiat_id, c.ile
FROM ip_city
LEFT JOIN(
SELECT
count(ip_card.card_id) as ile,
ip_card.city_id
FROM
ip_card,
ip_city,
ip_card_cs icc,
ip_cs ic
WHERE
ip_card.city_id=ip_city.city_id AND
ip_card.card_id = icc.card_id AND
icc.cs_id=ic.cs_id AND
ip_card.card_status = '0' AND
ic.subcat_id = 43324
GROUP BY ip_card.city_id
) c ON (c.city_id = ip_city.city_id )
) ic ON (ic.powiat_id = ip_powiat.powiat_id)
WHERE
state_id=13
GROUP BY id, name, seo, google_border
ORDER BY powiat_seo, REPLACE(powiat_name, 'm.', '')
« Cofnij do: Ca³a polska