An error occured in: ERROR: could not resize shared memory segment "/PostgreSQL.176689475" to 1048576 bytes: No space left on device Query: SELECT
ip_state.state_id as id,
ip_state.state_name as name,
ip_state.state_seo as seo,
COALESCE(SUM(ip.ile),0) as ile
FROM
ip_state
LEFT JOIN (
SELECT
ip_powiat.powiat_id,
ip_powiat.state_id,
ip_powiat.powiat_name,
ic.ile
FROM
ip_powiat
LEFT JOIN(
SELECT ip_city.city_id, ip_city.powiat_id, c.ile
FROM ip_city
LEFT JOIN(
SELECT
count(DISTINCT(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.card_status = '0' AND
ip_card.city_id=ip_city.city_id AND
ip_card.card_id = icc.card_id AND
icc.cs_id=ic.cs_id AND
ic.speccat_id = 412
GROUP BY
ip_card.city_id
) c ON (c.city_id = ip_city.city_id )
) ic ON (ic.powiat_id = ip_powiat.powiat_id)
) ip ON (ip_state.state_id = ip.state_id)
GROUP BY ip_state.state_id, ip_state.state_name, ip_state.state_seo
ORDER BY translate(state_name, 'ążśźęćńłó', 'azszecnlo')
An error occured in: ERROR: could not resize shared memory segment "/PostgreSQL.2077692276" to 1048576 bytes: No space left on device Query: SELECT DISTINCT
ip_speccategory.speccat_id AS id,
ip_speccategory.speccat_name AS name,
ip_speccategory.speccat_seo AS seo,
COALESCE(ips.ile, 0) as ile
FROM
ip_speccategory
LEFT JOIN (
SELECT
count(DISTINCT(card.card_id)) as ile,
speccat_id
FROM
ip_card_cs,
ip_cs,
ip_card card,
ip_city city
WHERE
card.card_status = '0' AND
card.card_id = ip_card_cs.card_id AND
city.city_id=card.city_id AND
ip_card_cs.cs_id=ip_cs.cs_id AND
ip_cs.subcat_id=42980
GROUP BY speccat_id
) ips ON (ips.speccat_id=ip_speccategory.speccat_id ),
ip_cs
WHERE
ip_cs.subcat_id=42980 AND
ip_cs.speccat_id=ip_speccategory.speccat_id
ORDER BY
ip_speccategory.speccat_name