An error occured in: ERROR: invalid reference to FROM-clause entry for table "ip_powiat"
LINE 9: ....cs_id AND cat.speccat_id=744 AND city.powiat_id=ip_powiat....
^
HINT: Perhaps you meant to reference the table alias "powiat". 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.speccat_id=744 AND city.powiat_id=ip_powiat.powiat_id AND ip_powiat.state_id=1 AND city.powiat_id=38 AND city.city_id=278
iPolska.info
