An error occured in: ERROR: could not resize shared memory segment "/PostgreSQL.831556876" to 1048576 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 Region Łódzkie - iPolska.info An error occured in: ERROR: could not resize shared memory segment "/PostgreSQL.2058150019" to 1048576 bytes: No space left on device Query: SELECT count(DISTINCT(card.card_id)) as ilosc FROM ip_cs cat, ip_card_cs cc, ip_powiat powiat, 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.cat_id=44102 AND city.powiat_id=powiat.powiat_id AND powiat.state_id=16 An error occured in: ERROR: could not resize shared memory segment "/PostgreSQL.1014822622" to 1048576 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_powiat powiat, 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=44102 AND poz.subcat_id=0) 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.cat_id=44102 AND city.powiat_id=powiat.powiat_id AND powiat.state_id=16 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_powiat powiat, 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.cat_id=44102 AND city.powiat_id=powiat.powiat_id AND powiat.state_id=16 ORDER BY card.card_name ASC ) LIMIT 10 OFFSET 0
An error occured in: ERROR: could not resize shared memory segment "/PostgreSQL.741265623" 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.cat_id = 44102 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=16 GROUP BY id, name, seo, google_border ORDER BY powiat_seo, REPLACE(powiat_name, 'm.', '') « Cofnij do: Cała polska
Copyright © 2005-24 iPolska. Wszelkie prawa zastrzeżone. Nota Prawna » Koszystanie z serwisu oznacza akceptację regulaminu | polityka prywatności | cookies
Wdrożenie: iPolska.com.pl