WordPress database error: [Table 'umart_data.zILBM_wc_product_attributes_lookup' doesn't exist]
SELECT SQL_CALC_FOUND_ROWS zILBM_posts.ID
FROM zILBM_posts LEFT JOIN zILBM_term_relationships ON (zILBM_posts.ID = zILBM_term_relationships.object_id) LEFT JOIN zILBM_icl_translations wpml_translations
ON zILBM_posts.ID = wpml_translations.element_id
AND wpml_translations.element_type = CONCAT('post_', zILBM_posts.post_type)
WHERE 1=1 AND zILBM_posts.ID IN (4967,5411,5424,5425,7371,7377,7404,7562,8298,8302,8303,8308,8310,8312,8316,8317,8319,8353,8356,8366,8376,8382,8397,8942,8948,8967,8979,9000,9019,9022,9026,9036,9065,9072,9080,9088,9150,9152,9153,9223,9244,9282,9284,9293,9382,9506,9616,9732,9735,9737,9766,9769,9773,9800,9804,9806,9837,9943,10033,10056,10058,10061,10068,10070,10072,10074,10102,10205,10206,10209,10211,10212,10219,10221,10223,10224,10227,10230,10232,10233,10234,10235,10236,10238,10250,10254,10255,10256,10257,10263,10267,10270,10272,10273,10274,10275,10278,10282,10284,10291,10292,10293,10295,10301,10303,10304,10305,10306,10307,10310,10311,10312,10313,10316,10318,10319,10320,10321,10324,10325,10326,10328,10330,10332,10333,10335,10337,10342,10344,10347,10348,10351,10353,10355,10356,10366,10371,10372,10373,10374,10384,10390,10393,10399,10400,10401,10413,10414,10419,10420,10421,10422,10426,10428,10429,10435,10436,10437,10438,10439,10440,10441,10445,10447,10448,10449,10454,10457,10458,10459,10461,10462,10463,10464,10465,10466,10468,10469,10471,10472,10473,10474,10475,10479,10480,10481,10482,10483,10484,10485,10486,10489,10490,10493,10500,10506,10511,10514,10515,10516,10517,10518,10524,10525,10528,10529,10533,10534,10535,10536,10537,10538,10541,10546,10547,10548,10549,10551,10554,10555,10556,10557,10558,10559,10561,10563,10564,10566,10567,10568,10569,10570,10571,10572,10574,10578,10582,10587,10588,10589,10590,10591,10592,10595,10596,10598,10599,10600,10601,10602,10607,10609,10610,10612,10614,10616,10617,10619,10620,10623,10624,10627,10628,10629,10630,10633,10635,10637,10640,10641,10642,10643,10644,10645,10646,10647,10648,10650,10652,10654,10655,10656,10657,10658,10659,10662,10664,10667,10670,10671,10673,10674,10675,10677,10678,10679,10680,10681,10682,10683,10684,10686,10687,10688,10692,10695,10697,10700,10701,10960,10962,11102,11110,11112,11138,11140,11143,11145,11147,11149,11151,11152,11187,11194,11208,11423,11516,11520,11523,11526,11542,11546,11550,11554,11558,11568,11576,11580,11590,11597,11604,11611,11618,11652,11765,11782,11791,11801,11802,11827,11840,11908,11926,11966,12023,12388,12392,12394,13500,13510,13516,13519,13542,13545,13549,13551,13553,13563,13565,13568,13846,13856,13859,13861,13862,13903,13910,13911,13912,13927,13928,13930,13939,13940,13941,13942,14191,14192,14195,14197,14198,14199,14203,14207,14208,14213,14215,14217,14221,14223,14227,14228,14230,14295,14297,14305,14306,14307,14308,14311,14312,14314,14315,14320,14323,14325,14328,14330,14381,14385,14389,14418,14566,14572,14578,14581,14584,14593,14599,14603,14607,14613,14617,14621,14636,14645,14650,14659,14663,14668,14669,14670,14671,14676,14684,14687,14696,14702,14705,14709,14712,14716,14719,14725,14730,14733,14739,14742,14745,14749,14752,14755,14759,14761,14764,14770,14773,14776,14780,14784,14787,14790,14796,14799,14805,14811,14814,14817,14821,14824,14831,14837,14843,14846,14851,14854,14862,14865,14868,15066,15130,15142,15146,15149,15151,15152,15153,15155,15156,15160,15162,15163,15164,15168,15173,15176,15178,15190,15191,15192,15193,15194,15206,15208,15218,15220,15227,15229,15230,15235,15238,15240,15241,15244,15245,15254,15257,15258,15259,15261,15265,15267,15273,15287,15290,15293,15296,15302,15366,15642,15679,15731,15739,15742,15771,15791,16003,16189,16543,16546,16551,16554,16557,17689,18177,18187,18217,18223,18225,18597,18611,18617,18622,18632,18637,18651,18656,18706,18821,18875,19108,19426,19441,19449,19459,19465,19468,19476,19481,19485,19489,19493,19540,19547,19554,19559,19575,19590,19760,19860,20211,20420,20437,20631,20637,20652,20662,20669,20672,20731,20970,20993,21377,21421,21433,21538,21626,21632,21649,21655,21683,21686,21691,21804,21817,21824,21830,21833,21836,21848,21854,21959,22029,22051,22146,22153,22155,22163,22177,22190,22193,22197,22198,22203,22206,22208,22810,22872,22882,22896,22927,22973,22992,22997,23021,23091,23104,23109,23131,23135,23138,23145,23150,23160,23165,23167,23180,23182,23186,23189,23308,23310,23481,23484,23486,23490,23492,23498,23512,23516,23519,23523,23527,23564,25244,26775,26812,26825,26831,26836,26839,26842,26846,26851,26857,26902,26906,26909,26913,26916,26919,26923,26926,27657,27809,27822,27870,28359,29165,29172,29203,29233,29244,29256,29280,29305,29350,29913,29916,29918,29926,29932,29936,29939,29942,29946,29950,29956,29959,29981,29989,29994,30006,30010,30021,30030,30086,30104,30111,30124,30127,30134,30138,30141,30145,30148,30152,30156,30172,30184,30188,30191,30219,30223,30226,30234,30235,30241,30245,30249,30252,30258,30261,30264,30267,30271,30427,30432,30438,30441,30445,30451,30454,30461,30472,30485,30499,30502,30589,30618,30624,30627,30632,30638,30669,30677,30682,30687,30692,30697,30703,30722,31088,31105,31110,31214,31247,31281,31512,31532,31612,31618,31649,31711,31719,31728,31734,31738,31742,31757,31772,31780,31781,31789,31797,31815,31824,31826,31833,31849,33335,33341,33345,33351,33399,33402,33408,33437,33440,33445,33447,33455,33467,33471,33475,33478,33483,33486,33489,33493,33690,34317,34356,34379,34545,34556,34882,34892,35017,35024,35679,35749,35800,35816,35831,36191,36215,36295,36388,37727,37734,37736,37739,37742,37744,37752,37756,37758,37760,37762,37764,37774,37795,37812,37828,37895,37900,37904,37916,37918,37919,37931,39607,39670,39691,39693,39696,39699,39701,39711,39724,39725,39763,39809,39813,39814,39822,39868,39884,39901,39906,39910,39916,39917,39924,39968,39989,39993,40000,40068,40074,40083,40090,40097,40103,40108,40112,40118,40128,40241,40466,40501,40538,40560,40575,40585,40596,40724,41235,41581,41595,41624,41657,41696,43351,43369,43377,43378,43380,43386,43396,43403,43406,43409,43411,43444,43446,43450,43451,43458,43466,43475,43486,43490,43500,43501,43503,43510,43511,43520,43522,43523,43539,43547,43567,43570,43579,43594,43671,43739,43747,43769,43780,43801,43805,43807,45212,45245,46180,46186,46188,46223,46354,46523,46528,46553,46558,46609,46615,46618,46649,46654,46795,46808,46858,46957,46969,46989,47206,47220,47223,47230,47236,47243,47245,47248,47250,47254,47275,47321,47329,47701,47803,47816,47824,47849,47951,48014,48026,48028,48034,48038,48040,48148,48154,48181,48256,48268,48270,48300,48374,48387,48390,48408,48414,48450,48465,48490,48532,48612,48750,48789,48795,48811,48814,48822,48827,48835,48845,48847,48852,48855,48858,48862,48868,48870,48874,48887,48907,48960,48962,48987,49000,49003,49011,49015,49021,49053,49091,49098,49121,49129,49131,49133,49135,49137,49139,49141,49143,49145,49147,49261,49350,49362,49375,49432,49437,49450,49471,49505,49531,49532,49594,49606,49622,49635,49659,49671,49674,49684,49702,49748,49771,49802,49809,49812,49840,49977,50070,50077,50079,50084,50087,50107,50152,50218,50221,50223,50232,50242,50247,50251,50256,50339,50477,50499,50514,50612,50667,50726,50734,50772,50779,50784,52968,52991,53517,53547,53565,53994,54352,54384,54391,54461,54524,54537,54574,54582,54588,54595,54605,54609,54628,54634,54640,54646,54649,54657,54683,54688,54692,54721,54726,54730,54733,54737,54741,54743,54762,54764,54821,54826,54828,54832,54835,54855,54874,54877,54882,54885,54889,54891,54893,54908,54933,54939,54942,54949,54956,54967,54973,54978,54979,54985,54996,55018,55026,55033,55042,55050,55068,55072,55076,55083,55085,55088,55091,55104,55164,55166,55169,55220,55238,55499,55502,55508,55513,55519,55620,55839,55921,55931,56474,56491,56625,56690,56713,56724,56730,56749,56786,56792,56804,56892,56898,56947,57023,57088,57111,57122,57178,57189,57207,57214,57246,57261,57281,57285,57305,57325,57353,57355,57357,57359,57361,57363,57365,57367,57369,57371,57378,57391,57402,57413,57419,57423,57425,57429,57432,57443,57460,57462,57464,57487,57515,57538,57556,57560,57562,57564,57568,57578,57580,57584,57587,57589,57594,57599,57604,57608,57614,57630,57634,57665,57670,57674,57685,57717,57783,57818,57824,57841,57847,57852,57889,57891,57924,57927,57936,57947,57982,57992,58002,58020,58029,58031,58098,58131,58133,58135,58139,58143,58168,58222,58239,58246,58258,58311,58332,58360,58404,58423,58492,58529,58537,58565,58609,58638,58645,59229,59527,59574,59597,59624,59661,59671,59686,59739,59762,59812,59820,59829,59964,60005,60040,60435,61672,61704,61713,61732,61741,61742,61747,61752,62247,62296,62304,62830,62861,62869,62876,62881,62897,62909,63702,63710,63745,63746,63753,63762,64032,64043,64052,64097,64106,64120,66625,67341,67346,67351,67360,67365,67408,67979,67989,68001,68010,68018,68028,68034,68040,68140,68158,68167,68176,68188,68192,68198,68217,68238,68250,68264,68275,68468,69000,69105,69123,69174,69194,69237,69243,69248,69255,69256,69268,69276,69279,69286,69289,69294,69296,69300,69307,69319,69322,69325,69329,69330,69338,69343,69351,69401,69404,69413,69414,69415,69425,69436,69442,69447,69450,69454,69460,69464,69469,69473,69478,69483,69488,69493,69506,69515,69522,69526,69539,69543,69547,69552,69555,69560,69583,69586,69592,69597,69600,69604,69609,69617,69620,69623,69628,69651,69659,69663,69673,69681,69689,69697,69701,69705,69787,69793,69794,69816,69823,69831,69840,69850,69854,69865,69876,69882,69888,69898,69903,69905,69917,69925,69929,69933,70028,70034,70039,70045,70141,70161,70190,70203,70211,70218,70235,70237,70253,70254,70262,70265,70275,70283,70301,70315,70323,70356,70370,70378,70385,70391,70398,70416,70640,70676,70685,70761,70788,70795,70827,70836,70855,70898,70920,70971,70980,71002,71004,71005,71015,71017,71029,71035,71037,71055,71073,71074,71090,71091,71093,71095,71096,71118,71119,71121,71131,71132,71133,71142,71152,71153,71154,71163,71166,71167,71168,71169,71170,71171,71172,71173,71175,71191,71194,71322,71323,71324,71325,71326,71329,71333,71335,71337,71339,71340,71341,71342,71343,71345,71347,71348,71350,71352,71354,71357,71360,71367,71396,71507,71515,71519,71523,71541,71542,71543,71544,71545,71547,71548,71549,71551,71554,71555,71567,71568,71577,71580,71585,71586,71587,71597,71613,71619,71622,71624,71631,71639,71641,71649,71653,71672,71683,71686,71692,71697,71699,71701,71703,71707,71715,71716,71718,71720,71722,71726,71728,71738,71740,71757,71759,71776,71778,71780,71782,71784,71786,71788,71798,71803,71807,71815,71824,71828,71830,71843,71851,71864,71866,71874,71879,71883,71887,71889,71913,71914,71915,71918,71919,71936,71941,71965,71980,71982,71986,71993,71997,72010,72023,72025,72027,72029,72031,72033,72035,72037,72048,72055,72058,72073,72075,72077,72079,72081,72083,72085,72102,72104,72110,72113,72115,72119,72155,72156,72157,72158,72190,72192,72194,72196,72199,72215,72218,72253,72254,72279,72282,72283,72285,72287,72290,72293,72298,72300,72304,72307,72314,72315,72320,72326,72337,72375,72378,72388,72393,72400,72406,72463,72466,72483,72531,72533,72541,72543,72549,72550,72567,72571,72576,72579,72589,72590,72607,72608,72612,72619,72620,72621,72622,72624,72626,72629,72633,72640,72659,72663,72670,72677,72679,72685,72689,72696,72698,72700,72702,72708,72715,72717,72719,72721,72750,72757,72761,72768,72782,72819,72844,72848,72859,72861,72863,72875,72879,72886,72891,72896,72903,72922,72924,72926,72937,72939,72949,72955,72963,72969,72972,72978,72989,72992,72995,73000,73004,73027,73082,73089,73099,73118,73120,73139,73206,73270,73272,73274,73276,73278,73281,73287,73312,73316,73318,73320,73332,73355,73359,73361,73393,73397,73399,73402,73404,73433,73437,73482,73487,73490,73507,73517,73523,73526,73541,73590,73601,73603,73652,73659,73661,73662,73664,73681,73683,73685,73705,73719,73728,73761,73764,73776,73780,73785,73804,73808,73810,73812,73860,73862,73865,73868,73883,73886,73890,73892,73900,73918,73933,73937,73940,73947,73951,73954,73959,73968,73970,73984,74003,74018,74033,74036,74038,74040,74050,74052,74093,74108,74113,74115,74118,74119,74132,74172,74251,74268,74271,74280,74369,74370,74371,74372,74373,74606,74681,74686,74701,74714,74722,74742,74813,74822,74865,74880,74887,74908,74909,74911,74940,74946,74948,74950,75058,75061,75074,75090,75107,75108,75110,75112,75131,75134,75135,75136,75138,75143,75157,75163,75165,75167,75169,75174,75179,75182,75183,75185,75186,75188,75189,75191,75195,75198,75204,75205,75207,75213,75223,75263,75272,75273,75276,75282,75283,75284,75285,75287,75309,75310,75311,75312,75315,75316,75322,75324,75330,75332,75333,75337,75338,75351,75565,76094,77274,77275,77290,77291,77304,77305,77309,77323,77332,77361,77365,77372,77375,77381,77387,77395,77396,79552,79559,79573,79585,79591,79594,79597,79598,79650,79652,79657,80425,80462,80467,80468,80492,80493,80614,80648,80663,80686,80687,81399,81606,81607,81608,81609,81652,81656,81660,81669,81675,81680,80599,80613) AND (
zILBM_posts.ID NOT IN (
SELECT object_id
FROM zILBM_term_relationships
WHERE term_taxonomy_id IN (6999)
)
AND
zILBM_term_relationships.term_taxonomy_id IN (7011)
) AND ((zILBM_posts.post_type = 'product' AND (zILBM_posts.post_status = 'publish'))) AND ( ( ( wpml_translations.language_code = 'en' OR (
wpml_translations.language_code = 'en'
AND zILBM_posts.post_type IN ( 'e-landing-page','elementor_library' )
AND ( (
( SELECT COUNT(element_id)
FROM zILBM_icl_translations
WHERE trid = wpml_translations.trid
AND language_code = 'en'
) = 0
) OR (
( SELECT COUNT(element_id)
FROM zILBM_icl_translations t2
JOIN zILBM_posts p ON p.id = t2.element_id
WHERE t2.trid = wpml_translations.trid
AND t2.language_code = 'en'
AND (
p.post_status = 'publish' OR p.post_status = 'private' OR
( p.post_type='attachment' AND p.post_status = 'inherit' )
)
) = 0 ) )
) ) AND zILBM_posts.post_type IN ('post','page','attachment','wp_block','wp_template','wp_template_part','wp_navigation','e-landing-page','elementor_library','product','product_variation' ) ) OR zILBM_posts.post_type NOT IN ('post','page','attachment','wp_block','wp_template','wp_template_part','wp_navigation','e-landing-page','elementor_library','product','product_variation' ) ) AND (
zILBM_posts.ID IN ( SELECT product_or_parent_id FROM (
SELECT product_or_parent_id
FROM zILBM_wc_product_attributes_lookup lt
WHERE term_id in (6830,6990,6843,6844,6668,6681)
) temp ))
GROUP BY zILBM_posts.ID
ORDER BY zILBM_posts.post_date DESC, zILBM_posts.ID DESC
LIMIT 0, 20
No products were found matching your selection.
