An error occured in: ERROR: table name "powiat" specified more than once 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, ip_powiat powiat, ip_state WHERE city.city_id=card.city_id AND city.powiat_id=powiat.powiat_id AND powiat.state_id=ip_state.state_id AND card.card_status = '0' AND card.card_id=cc.card_id AND cc.cs_id=cat.cs_id AND cat.speccat_id=121 AND city.powiat_id=powiat.powiat_id AND powiat.state_id=3 AND city.powiat_id=147 An error occured in: ERROR: table name "powiat" specified more than once 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, 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 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=42042 AND poz.subcat_id=42197) WHERE city.city_id=card.city_id AND city.powiat_id=powiat.powiat_id AND 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.speccat_id=121 AND city.powiat_id=powiat.powiat_id AND powiat.state_id=3 AND city.powiat_id=147 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, 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 powiat, ip_state, ip_card card WHERE city.city_id=card.city_id AND city.powiat_id=powiat.powiat_id AND 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.speccat_id=121 AND city.powiat_id=powiat.powiat_id AND powiat.state_id=3 AND city.powiat_id=147 ORDER BY card.card_name ASC ) LIMIT 10 OFFSET 0