Query by meta_value_num and date?

Hi,
thanks for the quick reply!

It is high traffic, but I have checked if the votes have changed, which they have not. They duplicate on the first ajax request yes. The preloaded posts order correctly, but not the remaining ones.

The posts in the list are published with one minute in between, just to make sure they not have the exact same time.

In the current query, the _point is always set, either with 0 or a number of votes.

The query I mentioned have been used when I have had modified pre_get_posts on posts with a custom field that’s only set on some posts. It looks like this:

add_filter( 'posts_where', 'wpq_posts_where_archive', PHP_INT_MAX );

		$query->set( 'post_type', array( 'open_list', 'post' )  );

		$query->set( 'meta_query', array(
			'relation' => 'OR',
			array(
				'key'     => '_views_today',
				'compare' => 'NOT EXISTS',
			),
			array(
				'key'     => '_views_today',
				'compare'   => 'EXISTS',
			),
		));
		$query->set('orderby', array('meta_value_num' => 'DESC', 'date' => 'DESC'));

Could there be something wrong with how I have used the shortcode? To be honest, I haven’t fully been able to wrap my head around the query part of it.

A few possible issues I can think of:

• Is it ok to have a certain amount of preloaded posts, and another amount of posts per page? This is what I do in my case.
• Do I need to set an offset of the same amount of posts as the preloaded ones?
• Is it ok to use it without a meta_value as in my case? Since the values are all different?

Thanks!

// Jens.

Hey!
I haven’t added meta key because there isn’t a fixed number, but maybe I have missunderstood this parameter? Should i add something like meta_key=number or something like that?

Ok, so what should be added to key and value when I have a custom field called “_point” and different numbers stored on each post?

<?php get_header(); ?>
<?php if (have_posts()) : while (have_posts()) : the_post(); ?>

	<div id="content-single">
	<div id="single-post-wrapper">
	<div <?php post_class() ?> id="post-<?php the_ID(); ?>">
					<!-- google_ad_section_end -->
					<!-- google_ad_section_start -->
					 <div class="meta-wrapper-large clearfix"><?php if ( function_exists('yoast_breadcrumb') ) {
yoast_breadcrumb('<p id="breadcrumbs">','</p>');
} ?>
</div>

<h1 class="entry-title"><?php the_title(); ?></h1>

<div class="entry">

<?php the_content(); ?>

<?php
$initial_count = get_post_meta($post->ID, '_initial_count', true);
$images = get_children('post_parent='.$post->ID.'&post_status=publish&post_type=user_images');
if ( ! empty( $images ) ) {
    $image_ids = wp_list_pluck( $images, 'ID' );
    $image_ids = implode(',',$image_ids);
 echo do_shortcode('[ajax_load_more post_type="user_images" preloaded="true" preloaded_amount="'.$initial_count.'" meta_key="_point" post__in="'.$image_ids.'" orderby="meta_value_num" order="DESC" posts_per_page="20" pause="true" scroll="false" button_label="Ladda fler bilder..." transition="fade" container_type="div" css_classes="user-images"]');
}
wp_reset_postdata();
?>

	<?php endwhile; endif; ?>
	<?php get_sidebar('sidebar'); ?>
	</div>
	</div>
	</div>

	<?php get_footer(); ?>