OV
Size: a a a
OV
SR
W
М
S
RM
S
OV
М
RM
RM
OV
RM
$sql = "SELECT SQL_CALC_FOUND_ROWS a.ID, a.post_title, fn.meta_value AS first_name, ln.meta_value AS last_name,b.ID AS artist_id, COUNT(*) OVER() AS total FROM wp_posts a
INNER JOIN wp_postmeta wm ON wm.post_id = a.ID AND wm.meta_key = 'artist'
INNER JOIN wp_posts b ON b.ID = wm.meta_value
INNER JOIN wp_postmeta fn ON fn.post_id = b.ID AND fn.meta_key = 'first_name'
INNER JOIN wp_postmeta ln ON ln.post_id = b.ID AND ln.meta_key = 'last_name'";
RM
RM
RM
OV
$sql = "SELECT SQL_CALC_FOUND_ROWS a.ID, a.post_title, fn.meta_value AS first_name, ln.meta_value AS last_name,b.ID AS artist_id, COUNT(*) OVER() AS total FROM wp_posts a
INNER JOIN wp_postmeta wm ON wm.post_id = a.ID AND wm.meta_key = 'artist'
INNER JOIN wp_posts b ON b.ID = wm.meta_value
INNER JOIN wp_postmeta fn ON fn.post_id = b.ID AND fn.meta_key = 'first_name'
INNER JOIN wp_postmeta ln ON ln.post_id = b.ID AND ln.meta_key = 'last_name'";
RM
RM