WordPress database error: [Not unique table/alias: 'wp_postmeta']SELECT wp_posts.*
FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) INNER JOIN wp_postmeta ON (wp_posts.ID = wp_postmeta.post_id)
WHERE 1=1 AND ( wp_postmeta.meta_key = '_simple_preorder' AND wp_postmeta.meta_value = 'yes' ) OR ( wp_postmeta.meta_key = '_wpro_variable_is_preorder' AND wp_postmeta.meta_value = 'yes' ) AND (
( wp_postmeta.meta_key = '_wp_page_template' AND wp_postmeta.meta_value = 'portfolio.php' )
) AND wp_posts.post_type = 'page' AND ((wp_posts.post_status = 'publish'))
GROUP BY wp_posts.ID
ORDER BY wp_posts.post_title ASC
WordPress database error: [Not unique table/alias: 'wp_postmeta']SELECT SQL_CALC_FOUND_ROWS wp_posts.ID
FROM wp_posts LEFT JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) INNER JOIN wp_postmeta ON (wp_posts.ID = wp_postmeta.post_id) LEFT JOIN wp_wc_product_meta_lookup wc_product_meta_lookup ON wp_posts.ID = wc_product_meta_lookup.product_id
WHERE 1=1 AND ( wp_postmeta.meta_key = '_simple_preorder' AND wp_postmeta.meta_value = 'yes' ) OR ( wp_postmeta.meta_key = '_wpro_variable_is_preorder' AND wp_postmeta.meta_value = 'yes' ) AND (
wp_posts.ID NOT IN (
SELECT object_id
FROM wp_term_relationships
WHERE term_taxonomy_id IN (7)
)
AND
wp_term_relationships.term_taxonomy_id IN (1008)
) AND (
( wp_postmeta.meta_key = '_stock_status' AND wp_postmeta.meta_value = 'instock' )
) AND ((wp_posts.post_type = 'product' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'cwg_mailsent' OR wp_posts.post_status = 'cwg_mailnotsent' OR wp_posts.post_status = 'cwg_subscribed' OR wp_posts.post_status = 'cwg_unsubscribed' OR wp_posts.post_status = 'cwg_converted' OR wp_posts.post_status = 'wc-partial-shipped'))) AND (
wp_posts.ID IN ( SELECT product_or_parent_id FROM (
SELECT product_or_parent_id
FROM wp_wc_product_attributes_lookup lt
WHERE term_id in (853)
) temp ) AND
wp_posts.ID IN ( SELECT product_or_parent_id FROM (
SELECT product_or_parent_id
FROM wp_wc_product_attributes_lookup lt
WHERE term_id in (1069,473)
) temp ))
GROUP BY wp_posts.ID
ORDER BY wc_product_meta_lookup.average_rating DESC, wc_product_meta_lookup.rating_count DESC, wc_product_meta_lookup.product_id DESC
LIMIT 0, 9
No account yet?
Create an Account