You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
hey scribu,
i cannot get result from querying private posts but when i alter the sql request to
INNER JOIN acwp_p2p
WHERE 1 =1
AND acwp_posts.post_type
IN (
'animes', 'manga'
)
AND (
acwp_posts.post_status = 'private'
OR acwp_posts.post_status = 'private'
)
AND (
acwp_p2p.p2p_type = 'Adaptation'
AND (
(
acwp_posts.ID = acwp_p2p.p2p_to
AND acwp_p2p.p2p_from
IN (
SELECT acwp_posts.ID
FROM acwp_posts
WHERE 1 =1
AND acwp_posts.ID
IN ( 3317 )
AND acwp_posts.post_type
IN (
'animes', 'manga'
)
AND (
acwp_posts.post_status = 'private'
OR acwp_posts.post_author =1
AND acwp_posts.post_status = 'private'
)
ORDER BY acwp_posts.post_date DESC
)
)
OR (
acwp_posts.ID = acwp_p2p.p2p_from
AND acwp_p2p.p2p_to
IN (
SELECT acwp_posts.ID
FROM acwp_posts
WHERE 1 =1
AND acwp_posts.ID
IN ( 3317 )
AND acwp_posts.post_type
IN (
'animes', 'manga'
)
AND (
acwp_posts.post_status = 'private'
OR acwp_posts.post_author =1
AND acwp_posts.post_status = 'private'
)
ORDER BY acwp_posts.post_date DESC
)
)
)
)
ORDER BY acwp_posts.post_date DESC
LIMIT 0 , 30
it work.
i couldn't find any place in plugins to solve this issue.
The text was updated successfully, but these errors were encountered:
hey scribu,
i cannot get result from querying private posts but when i alter the sql request to
INNER JOIN acwp_p2p
WHERE 1 =1
AND acwp_posts.post_type
IN (
'animes', 'manga'
)
AND (
acwp_posts.post_status = 'private'
OR acwp_posts.post_status = 'private'
)
AND (
acwp_p2p.p2p_type = 'Adaptation'
AND (
(
acwp_posts.ID = acwp_p2p.p2p_to
AND acwp_p2p.p2p_from
IN (
SELECT acwp_posts.ID
FROM acwp_posts
WHERE 1 =1
AND acwp_posts.ID
IN ( 3317 )
AND acwp_posts.post_type
IN (
'animes', 'manga'
)
AND (
acwp_posts.post_status = 'private'
OR acwp_posts.post_author =1
AND acwp_posts.post_status = 'private'
)
ORDER BY acwp_posts.post_date DESC
)
)
OR (
acwp_posts.ID = acwp_p2p.p2p_from
AND acwp_p2p.p2p_to
IN (
SELECT acwp_posts.ID
FROM acwp_posts
WHERE 1 =1
AND acwp_posts.ID
IN ( 3317 )
AND acwp_posts.post_type
IN (
'animes', 'manga'
)
AND (
acwp_posts.post_status = 'private'
OR acwp_posts.post_author =1
AND acwp_posts.post_status = 'private'
)
ORDER BY acwp_posts.post_date DESC
)
)
)
)
ORDER BY acwp_posts.post_date DESC
LIMIT 0 , 30
it work.
i couldn't find any place in plugins to solve this issue.
The text was updated successfully, but these errors were encountered: