Pakkumised

Otsing
SELECT SQL_CALC_FOUND_ROWS g05u_posts.ID FROM g05u_posts INNER JOIN g05u_term_relationships ON (g05u_posts.ID = g05u_term_relationships.object_id) INNER JOIN g05u_postmeta ON ( g05u_posts.ID = g05u_postmeta.post_id ) JOIN g05u_icl_translations t ON g05u_posts.ID = t.element_id AND t.element_type = CONCAT('post_', g05u_posts.post_type) WHERE 1=1 AND ( g05u_term_relationships.term_taxonomy_id IN (11,12,13,14,15,16,17,18,19,300,16159) ) AND ( ( ( g05u_postmeta.meta_key = 'agent' AND CAST(g05u_postmeta.meta_value AS CHAR) = '' ) OR ( g05u_postmeta.meta_key = '_resolve_second_broker_id' AND CAST(g05u_postmeta.meta_value AS CHAR) = '' ) ) ) AND g05u_posts.post_type = 'property' AND ((g05u_posts.post_status = 'publish')) AND ( ( t.language_code = 'et' AND g05u_posts.post_type IN ('post','page','attachment','featured_post','property','agent' ) ) OR g05u_posts.post_type NOT IN ('post','page','attachment','featured_post','property','agent' ) ) GROUP BY g05u_posts.ID ORDER BY g05u_posts.post_modified DESC LIMIT 0, 15

Tulemusi ei leitud.

© 2016 Uus Maa Kinnisvarabüroo