SELECT SQL_CALC_FOUND_ROWS uzlis_posts.ID FROM uzlis_posts INNER JOIN uzlis_postmeta ON ( uzlis_posts.ID = uzlis_postmeta.post_id ) INNER JOIN uzlis_postmeta AS mt1 ON ( uzlis_posts.ID = mt1.post_id ) INNER JOIN uzlis_postmeta AS mt2 ON ( uzlis_posts.ID = mt2.post_id ) WHERE 1=1 AND ( 0 = 1 ) AND ( ( uzlis_postmeta.meta_key = 'cena' AND CAST(uzlis_postmeta.meta_value AS SIGNED) >= '0' ) AND ( mt1.meta_key = 'cena' AND CAST(mt1.meta_value AS SIGNED) <= '14000000' ) AND ( ( mt2.meta_key = 'miasto' AND mt2.meta_value REGEXP '([[:blank:][:punct:]]|^)([[:blank:][:punct:]]|$)' ) OR ( mt2.meta_key = 'numer_oferty' AND mt2.meta_value LIKE '%%' ) OR ( mt2.meta_key = 'wojewodztwo' AND mt2.meta_value = '' ) OR ( mt2.meta_key = 'ulica' AND mt2.meta_value LIKE '%%' ) ) ) AND uzlis_posts.post_type = 'nieruchomosc' AND ((uzlis_posts.post_status = 'publish')) GROUP BY uzlis_posts.ID ORDER BY uzlis_posts.post_date DESC LIMIT 0, 10
Domiporta Gratka OtoDom Domy.pl nportal.pl KLIKmapa.pl
Obserwowane: 0