An error occured in: ERROR: could not resize shared memory segment "/PostgreSQL.322215448" to 197920 bytes: No space left on device Query: SELECT
ip_city.city_id as id,
city_name as name,
city_seo as seo,
COALESCE(ic.ile,0) as ile
FROM
ip_city
LEFT JOIN(
SELECT
count(card_id) as ile,
ip_city.city_id
FROM
ip_card,
ip_city
WHERE
ip_card.card_status = '0' AND
ip_card.city_id=ip_city.city_id
GROUP BY ip_city.city_id
) ic ON (ic.city_id = ip_city.city_id)
WHERE
ip_city.powiat_id=320
ORDER BY city_name
Branże:
An error occured in: ERROR: could not resize shared memory segment "/PostgreSQL.610625454" to 99488 bytes: No space left on device Query:
SELECT ic.cat_id as idkategoria,
cat_name as kategoria,
cat_seo as cat_seo,
ic.subcat_id as idpodkategoria,
subcat.subcat_name as podkategoria,
subcat.subcat_seo as subcat_seo,
speccat.speccat_id as idspeckategoria,
speccat.speccat_name as speckategoria,
speccat.speccat_seo as speccat_seo,
ics.cs_id
FROM ip_card_cs ics,
ip_category cat,
ip_subcategory subcat,
ip_cs ic
LEFT JOIN
ip_speccategory speccat ON (ic.speccat_id=speccat.speccat_id )
WHERE
ics.cs_id=ic.cs_id
AND ics.card_id=687969
AND ic.cat_id=cat.cat_id
AND ic.subcat_id=subcat.subcat_id
ORDER BY kategoria, podkategoria, speckategoria
Zobacz więcej