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)
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 IN (5028,5320,6065,6305,25030,25576,25724,25725,25726,25727,25732,25733,26147,26659,27623,27797,27869,27870,28315,28557,28558,28559,28679,28681,28682,28683,28686,28687,28688,28689,28690,28691,28693,28694,28695,28696,28697,28698,28699,28700,28702,28703,28704,28705,28706,28707,28708,28709,28710,28711,28712,28713,28714,28725,28726,28729,28731,28732,28751,28752,28753,28754,28755,28757,28758,28759,28760,28762,28763,28764,28765,28766,28767,28768,28769,28770,28771,28772,28773,28775,28776,28777,28787,28788,28790,28791,28792,28793,28794,28803,28805,28807,28808,28809,28810,28811,28824,28826,28827,28829,28830,28836,28837,28839,28840,28841,28843,29108,29395,29396,29397,29399,29400,29401,29402,29403,29412,29413,29414,29415,29416,29417,29418,29419,29420,29439,29442,29496,29497,29498,29532,29550,29551,29553,29562,29585,29645,29647,29677,29763,29764,29789,29813,29822,29823,29824,29939,29940,29964,29965,29966,29967,30039,30041,30132,30133,30134,30230,30291,30292,30293,30835,30841,31502,31511,31520,31605,31606,31619,31984,32039,32123,32725,32844,32851,32917,32945,33006,33052,33132,33134,33136,33139,33170,33171,33195,33205,33206,33320,33321,33546,33578,33579,33580,33581,33609,33611,33612,33655,33657,33746,33748,33751,33752,33974,33975,33976,34051,34394,34395,34396,34398,34532,34533,34911,35113,35136,35138,35139,35444,35471,35472,35473,35476,35522,35853,36807,36884,36903,37030,37034,37495,37496,37497,37498,37499,37686,37688,37694,38153,38154,38260,38261,38262,38295,38297,38299,38328,38396,38399,38402,38417,38851,38852,38853,39092,39101,39103,39106,39107,39108,39243,39244,39245,39258,39259,39272,39274,39285,39301,39302,39346,39347,39348,39349,39416,39452,39456,39457,39466,39467,39469,39488,39489,39516,39534,39535,39565,39572,39573,39576,39578,39612,39613,39631,39649,39650,39652,39654,39655,39683,39692,39693,39709,39718,39720,39723,39750,39754,39854,39861,39862,39864,40618,40619,40620,40715,40796,40828,40873,40887,40888,40889,41327,41503,41504,41505,41768,41769,41770,41797,41798,41799,42123,42125,42166,42285,42289,42348,42393,42394,42458,42459,42561,42562,42563,42653,42654,42715,43004,43005,44223,44224,45073,45074,45078,45081,45082,45083,45084,45085,45087,45094,45097,45099,45224,45225,45319,45328,45561,45562,45563,45574,45575,45576,45578,45808,45840,45841,45842,45861,45862,45863,45945,45946,45947,46049,46050,46051,46052,46053,46054,46056,46057,46058,46292,46294,46295,46298,46299,46300,46315,46317,46319,46335,46336,46854,47306,47321,47322,47323,47810,47858,47859,47860,47993,48009,48049,48065,48092,48145,48146,48166,48168,48209,48212,48213,48216,48231,48267,48269,48270,48280,48281,48282,48297,48298,48334,48349,48378,48407,48408,48449,48477,48714,48717,48731,48758,48763,48783,48784,48795,48796,48817,48818,48819,48820,48821,48822,49518,49519,49520,49700,49701,49702,49717,49718,49719,49720,49721,49722,49736,49737,49738,49739,50107,50108,50109,50323,50324,50325,50326,50327,50328,50609,50610,50611,50612,50613,50614,50615,50616,50621,50622,50623,50624,50625,50626,50627,50628,60064,60065,60066,60084,60088,60111,60112,60113,60114,60115,60116,60117,60118,60150,60151,60152,60153,5024,5316,6061,6300,25025,25568,25722,25728,26088,26643,27593,27784,27858,28304,28545,28633,28715,28736,28778,28796,28813,28831,28863,29386,29404,29421,29486,29521,29539,29554,29569,29644,29666,29758,29779,29802,29654,29932,29951,30037,30120,30204,29916,30811,31041,31593,31611,31969,32028,32721,32833,32906,32937,32994,33011,33117,33159,33185,33202,33315,4382,33565,33583,33623,33721,33967,34025,34374,34531,34896,35105,33669,35434,35459,32881,35850,19926,36877,36898,35350,37486,37678,37690,38152,38259,38293,38371,38409,38839,39089,39100,39105,39234,39250,39263,39277,39291,39340,29170,32699,30847,27129,30917,27207,27502,34959,29217,31382,30694,32320,31364,39688,29235,29036,34914,27019,26458,27709,40600,40695,40745,40812,40859,40880,31187,41486,38406,41790,31989,30669,42271,42329,42378,42457,42547,42531,42702,42996,42262,44958,44960,44993,44991,45090,45092,45088,20036,20148,45515,45565,45795,45832,45860,45914,46028,46026,46024,46190,46175,46159,46113,46062,38302,38351,47803,47847,47983,47997,48040,48054,48081,48131,48148,48191,48220,48242,48274,48284,48328,48340,48370,47891,48438,48475,48701,48719,48756,48761,48771,48786,48802,48811,49356,49679,49707,49725,50097,50295,50461,50384,60053,60070,48406,45069) 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 (1001)
) 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 (1126)
) 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 is_variation_attribute=0
AND term_id in (550,549)
GROUP BY product_id
HAVING COUNT(product_id)=2
UNION
SELECT product_or_parent_id
FROM wp_wc_product_attributes_lookup lt
WHERE is_variation_attribute=1
AND term_id in (550,549)
) temp ))
GROUP BY wp_posts.ID
ORDER BY wp_posts.post_date DESC, wp_posts.ID DESC
LIMIT 0, 9
No account yet?
Create an Account