An error occured in: ERROR: could not resize shared memory segment "/PostgreSQL.1005499026" to 196864 bytes: No space left on device Query:
SELECT
card.card_id as id,
adres.addr_name as nazwa,
adres.addr_street as ulica,
adres.addr_street_nr as numer,
adres.addr_post_code as kod_pocztowy,
city.city_name as miasto,
adres.addr_telephone as telefon,
adres.addr_fax as fax,
adres.addr_email as email,
card.user_id,
card.card_business_type as rodzajdzialanosci,
card.card_keywords as slowakluczowe,
card.card_www as www,
card.google_localization,
card.card_kind as rodzaj,
card.card_open_www as otwieraj_www,
ip_powiat.powiat_trans as powiat,
ip_state.state_name as wojewodztwo,
card.card_desc,
card.card_ref,
card.card_service,
card.card_mark,
card.card_prom,
card.card_seo,
card.google_lat,
card.google_lng,
card.zasieg_dzialalnosci,
card.card_kind
FROM
ip_address adres,
ip_city city,
ip_card card,
ip_powiat,
ip_state
WHERE
card.card_id = adres.card_id AND
adres.addr_nr <= 1 AND
city.city_id=card.city_id AND
card.card_seo = '' AND
city.powiat_id = ip_powiat.powiat_id AND
ip_powiat.state_id = ip_state.state_id AND
card.card_status != 1
An error occured in: ERROR: could not resize shared memory segment "/PostgreSQL.66865450" to 196864 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=42978
GROUP BY speccat_id
) ips ON (ips.speccat_id=ip_speccategory.speccat_id ),
ip_cs
WHERE
ip_cs.subcat_id=42978 AND
ip_cs.speccat_id=ip_speccategory.speccat_id
ORDER BY
ip_speccategory.speccat_name
An error occured in: ERROR: could not resize shared memory segment "/PostgreSQL.1847326861" to 196864 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,
ips.ile
FROM
ip_subcategory
LEFT JOIN (
SELECT
count(DISTINCT(card.card_id)) as ile,
subcat_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
ip_card_cs.cs_id=ip_cs.cs_id AND
city.city_id=card.city_id AND
ip_cs.cat_id=42052
GROUP BY subcat_id
) ips ON (ips.subcat_id=ip_subcategory.subcat_id ),
ip_cs
WHERE
ip_cs.cat_id=42052 AND
ip_cs.subcat_id=ip_subcategory.subcat_id
ORDER BY
ip_subcategory.subcat_name
Maszyny przemysłowe - iPolska.info
An error occured in: ERROR: could not resize shared memory segment "/PostgreSQL.730957019" to 196864 bytes: No space left on device Query: SELECT count(DISTINCT(card.card_id)) as ilosc
FROM
ip_cs cat, ip_card_cs cc,
ip_card card,
ip_city city
WHERE
city.city_id=card.city_id AND
card.card_status = '0'
AND card.card_id=cc.card_id AND cc.cs_id=cat.cs_id AND cat.subcat_id=42978
An error occured in: ERROR: could not resize shared memory segment "/PostgreSQL.998044027" to 196864 bytes: No space left on device Query:
(
SELECT DISTINCT
card.card_id as id,
card.card_name as nazwa,
card.address_street as ulica,
card.address_street_nr as numer,
card.address_post_code as kod_pocztowy,
card.card_telephone as telefon,
card.card_email as card_telephone,
card.card_seo,
city.city_name as miasto,
city.city_id as city_id,
ip_powiat.powiat_name as powiat,
ip_state.state_name as wojewodztwo,
card.card_business_type as rodzajdzialanosci,
card.card_keywords as slowakluczowe,
card.card_www as www,
COALESCE(card.google_localization, '') as google_localization,
card.card_kind as rodzaj,
card.card_open_www as otwieraj_www,
card.card_kind,
poz.pos_position as pozycja
FROM
ip_cs cat, ip_card_cs cc,
ip_city city,
ip_powiat,
ip_state,
ip_card card
LEFT JOIN
ip_positioning poz ON (poz.user_id=card.user_id AND poz.state_id=0 AND poz.cat_id=42052 AND poz.subcat_id=42978)
WHERE
city.city_id=card.city_id AND
city.powiat_id=ip_powiat.powiat_id AND
ip_powiat.state_id=ip_state.state_id AND
card.card_status = '0' AND
card.card_kind != 0
AND card.card_id=cc.card_id AND cc.cs_id=cat.cs_id AND cat.subcat_id=42978
ORDER BY pozycja ASC, card.card_kind DESC, card.card_name ASC
) UNION ALL (
SELECT DISTINCT
card.card_id as id,
card.card_name as nazwa,
card.address_street as ulica,
card.address_street_nr as numer,
card.address_post_code as kod_pocztowy,
card.card_telephone as telefon,
card.card_email as card_telephone,
card.card_seo,
city.city_name as miasto,
city.city_id as city_id,
ip_powiat.powiat_name as powiat,
ip_state.state_name as wojewodztwo,
card.card_business_type as rodzajdzialanosci,
card.card_keywords as slowakluczowe,
card.card_www as www,
COALESCE(card.google_localization, '') as google_localization,
card.card_kind as rodzaj,
card.card_open_www as otwieraj_www,
card.card_kind,
100 as pozycja
FROM
ip_cs cat, ip_card_cs cc,
ip_city city,
ip_powiat,
ip_state,
ip_card card
WHERE
city.city_id=card.city_id AND
city.powiat_id=ip_powiat.powiat_id AND
ip_powiat.state_id=ip_state.state_id AND
card.card_status = '0' AND
card.card_kind = 0
AND card.card_id=cc.card_id AND cc.cs_id=cat.cs_id AND cat.subcat_id=42978
ORDER BY card.card_name ASC
)
LIMIT 10 OFFSET 0
An error occured in: ERROR: could not resize shared memory segment "/PostgreSQL.1826093983" to 196864 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.subcat_id = 42978
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.1616523805" to 196864 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=42978
GROUP BY speccat_id
) ips ON (ips.speccat_id=ip_speccategory.speccat_id ),
ip_cs
WHERE
ip_cs.subcat_id=42978 AND
ip_cs.speccat_id=ip_speccategory.speccat_id
ORDER BY
ip_speccategory.speccat_name
An error occured in: ERROR: could not resize shared memory segment "/PostgreSQL.1312386231" to 196864 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,
ips.ile
FROM
ip_subcategory
LEFT JOIN (
SELECT
count(DISTINCT(card.card_id)) as ile,
subcat_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
ip_card_cs.cs_id=ip_cs.cs_id AND
city.city_id=card.city_id AND
ip_cs.cat_id=42052
GROUP BY subcat_id
) ips ON (ips.subcat_id=ip_subcategory.subcat_id ),
ip_cs
WHERE
ip_cs.cat_id=42052 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