'SELECT SQL_CALC_FOUND_ROWS wp_posts.ID
FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id )
WHERE 1=1 AND (
wp_posts.ID NOT IN (
SELECT object_id
FROM wp_term_relationships
WHERE term_taxonomy_id IN (47485,47486)
)
) AND (
(
( wp_postmeta.meta_key = \'the_author\' AND wp_postmeta.meta_value = \'3478127\' )
OR
( wp_postmeta.meta_key = \'secondary_author\' AND wp_postmeta.meta_value LIKE \'{2c2167cf580b1840ff52dede7d3d1b9c173bb4dc65176b594e4e31fb21840bd3}\\"3478127\\"{2c2167cf580b1840ff52dede7d3d1b9c173bb4dc65176b594e4e31fb21840bd3}\' )
)
) AND wp_posts.post_type = \'post\' AND ((wp_posts.post_status = \'publish\'))
GROUP BY wp_posts.ID
ORDER BY wp_posts.post_date DESC
LIMIT 0, 6'
Rojava: A Practical Example of Ecosocialism?
The Rojava Internationalist Commune was founded in 2017 by internationalists from all over the world, supported by the Rojava Youth Movement (YCR/YJC). The aim of this structure is to share knowledge, skills and experience through an internationalist perspective, as well as to support projects and the revolution in Rojava.
August 12, 2019