An error occured in: Query: SELECT state_id as id, state_name as name, state_seo as seo, 'ip_state' as poziom, 0 as parent_id, NULL as google_border FROM ip_state WHERE state_seo='zachodniopomorskie'
UNION
SELECT powiat_id as id, powiat_name as name, powiat_seo as seo, 'ip_powiat' as poziom, state_id as parent_id, google_border FROM ip_powiat WHERE powiat_seo='zachodniopomorskie'
UNION
SELECT city_id as id, city_name as name, city_seo as seo, 'ip_city' as poziom, powiat_id as parent_id, NULL as google_border FROM ip_city WHERE city_seo='zachodniopomorskie'
An error occured in: Query: SELECT DISTINCT ip_category.cat_id as id, cat_name as name, cat_seo as seo, 'cat' as poziom, 0 as parent_id FROM ip_category, ip_cs WHERE ip_cs.cat_id=ip_category.cat_id AND cat_seo='region'
UNION
SELECT DISTINCT ip_subcategory.subcat_id as id, subcat_name as name, subcat_seo as seo, 'subcat' as poziom, ip_cs.cat_id as parent_id FROM ip_subcategory, ip_cs WHERE ip_cs.subcat_id=ip_subcategory.subcat_id AND subcat_seo='region'
UNION
SELECT DISTINCT ip_speccategory.speccat_id as id, speccat_name as name, speccat_seo as seo, 'speccat' as poziom, ip_cs.subcat_id as parent_id FROM ip_speccategory, ip_cs WHERE ip_cs.speccat_id=ip_speccategory.speccat_id AND speccat_seo='region'
- iPolska.info
An error occured in: Query: SELECT count(DISTINCT(card.card_id)) as ilosc
FROM
ip_card card,
ip_city city
WHERE
city.city_id=card.city_id AND
card.card_status = '0'
An error occured in: 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_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=0 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
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_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
ORDER BY card.card_name ASC
)
LIMIT 10 OFFSET 0
iPolska.info
Zaprezentuj Firmę
Robimy dobre strony
Program Partnerski
Zaloguj się
Regulamin
Reklama
Kontakt