An error occured in: ERROR: could not resize shared memory segment "/PostgreSQL.833875271" to 1048576 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(ip_card.card_id) as ile,
ip_city.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.subcat_id = 43332
GROUP BY ip_city.city_id
) ic ON (ic.city_id = ip_city.city_id)
WHERE
ip_city.powiat_id=48
ORDER BY city_name
« Cofnij do: Wielkopolskie
Kaliski: An error occured in: ERROR: could not resize shared memory segment "/PostgreSQL.1288068894" to 1048576 bytes: No space left on device Query: SELECT DISTINCT
ip_subcategory.subcat_id AS id,
ip_subcategory.subcat_name AS name,
ip_subcategory.subcat_seo AS seo,
COALESCE(ips.ile,0) as ile
FROM
ip_subcategory
LEFT JOIN (
SELECT count(DISTINCT(ip_card.card_id)) as ile, subcat_id
FROM
ip_card_cs,
ip_cs,
ip_card,
ip_city,
ip_powiat
WHERE
ip_card_cs.cs_id=ip_cs.cs_id AND
ip_card_cs.card_id = ip_card.card_id AND
ip_card.city_id = ip_city.city_id AND
ip_card.card_status = '0' AND
ip_city.powiat_id=ip_powiat.powiat_id AND
ip_powiat.powiat_id=48 AND
ip_cs.cat_id=42058
GROUP BY subcat_id
) ips ON (ips.subcat_id=ip_subcategory.subcat_id ),
ip_cs
WHERE
ip_cs.cat_id=42058 AND
ip_cs.subcat_id=ip_subcategory.subcat_id
ORDER BY
ip_subcategory.subcat_name
iPolska.info
Zaprezentuj Firmê
Robimy dobre strony
Program Partnerski
Zaloguj siê
Regulamin
Reklama
Kontakt