driano

Thanks for all!! ?? i think it will be work!

I need to get all ids from posts in these conditions: custom post type + taxonomy term + sticky and return in $sticky_posts

The code is wright but i will need to do a loop to get all ids and save in array. To use in my next query for example that have:

‘post__in’=> $sticky_posts
or
‘post__not_in’=>$sticky_posts

The code:
$sticky_IDs = $wpdb->get_col(“SELECT ID from “.$wpdb->prefix.”posts WHERE post_type = ‘hoteis'”); (need a modification)
$sticky_posts = array_intersect(get_option(‘sticky_posts’),$sticky_IDs);

get me the ids without make a loop… but i can use the code that you make and a loop to return…

but thats ok ??

Hi!! Thanks for the support! I modify the code:

$args = array(
			 'posts_per_page' => -1,
			 'orderby' => 'ASC',
			 'post_type' => 'Hoteis',
			 'localhotel' => 'juiz de fora',
			 'post_status' => 'publish',
			 'post__in'=> get_option( 'sticky_posts' ),
		);
		$post_ids = get_posts( $args );

[Moderator Note: Please post code & markup between backticks or use the code button. Your posted code may now have been permanently damaged by the forum’s parser.]

that works, but i will need to make a loop to get all the ids…

And if i use $wpdb->get_col, im get the ids using this:

$sticky_IDs = $wpdb->get_col(“SELECT ID from “.$wpdb->prefix.”posts WHERE post_type = ‘hoteis'”);
$sticky_posts = array_intersect(get_option(‘sticky_posts’),$sticky_IDs);

You know how make the query works using $wpdb->get_col? I know that i need to combine other table with wp_posts, but i dont know how, if is inner join…

Resolved!

i do this https://pastebin.com/wEu5zRKT and works now the pagination with 2 queries ??

This is the same thing to change the order of a post type, i put the firsts with 0 and others 1.

But i need to have all the posts in a rand mode.
The premiums will display first and random , and after the others posts in random.

:/

I need to have control with what is showing! If i have 2 taxonomy terms, and all posts from one must show first than other , and the 2 taxonomy must be showing first than others posts.

And all must be working with the pagination…

Orin is the same problem! But here, i can send the images! I cant see the thumbs in media gallery like your first screenshot…

for me, doesn’t show too! =/

i need a solution too! =/

this work automatic =) sorry!

Now working!

In this case show de date…
https://www.asianhairandbeauty.com/feed/rss2/

=)