PRODUCT STATUS – In stock, Out of stock, On sale – not work;
when i turn on debug, i get this error:
In stock
WordPress-Datenbank-Fehler: [You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ” at line 14]
SELECT ID FROM wp_posts as p INNER JOIN wp_postmeta pm on p.ID = pm.post_id and pm.meta_key=’_stock_status’ AND pm.meta_value = ‘instock’ AND p.post_status = ‘publish’ AND p.post_type = ‘product’ AND p.ID NOT IN ( SELECT tr.object_id FROM wp_terms as t JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id JOIN wp_term_relationships AS tr ON tt.term_taxonomy_id = tr.term_taxonomy_id WHERE t.name = ‘exclude-from-catalog’) AND p.ID IN ( SELECT pl.element_id FROM wp_icl_translations WHERE pl.language_code = ‘de’ AND p.ID IN (7397,7445,7452,7458,7461,7617,7629,7644,7659,7675,544,754,834,844,853,885,902,904,2196,1995,2217,2204,2223,2228,2632,2680,7876,6606,44,150,363,370,380,387,396,4922,4946,4953,4962,5028,5287,5295,5528,7397,7445,7452,7458,7461,7684,7700,7707,7718,7723,7729,7733,7740,7749,7754,7858,7974,7994,8006,8018,8032,8043,8054,8074,8090,14158,8094,14148,8113,14133,8129,14118,8144,14105,8159,14099,8172,14088,8185,14076,8198,14064,8209,14055,8218,14039,8231,13996,8355,8359,8364,8380,8392,8408,8440,8454,8470,8490,8517,8531,8570,8591,8606,8618,8630,7617,7644,7675,7659,7629,8661,8693,8706,8714,8731,8770,8798,8812,8827,8838,8849,8862,8875,8903,8914,8949,8953,8957,8961,8963,8966,8969,8972,10214,10239,10253,10270,10279,10293,10300,10312,10505,10528,10541,10555,10567,10581,10594,10609,10625,10639,10666,10683,10698,10714,10723,10732,10746,10755,10785,10795,10804,10815,10826,10838,10851,10864,10881,10888,10899,10907,10921,10929,10939,10948,10960,10972,10984,10995,11008,11019,11030,11039,11052,11065,11084,11097,11111,11122,11137,11147,11158,11171,11184,11193,11206,11218,11232,11375,11382,11389,11396,11403,11410,11417,11424,11435,11444,11453,11460,11469,11478,11487,11496,11503,11510,11517,11524,11568,11594,11614,11634,11652,11669,11686,11702,11719,11734,11754,11773,11792,11811,11830,11860,11886,11972,11990,12021,12093,12248,12263,12279,12293,12309,12323,12339,12353,12369,12383,12395,12411,12425,12441,12477,12573,12626,12644,12677,12690,12711,12737,12758,12773,12786,12803,12814,12830,12842,12860,12870,12886,12900,12914,13150,13162,13176,13212,13233,13259,13277,13301,13329,13345,13366,13378,13388,13400,13412,13426,13439,13453,13467,13483,13497,13507,13517,13533,13541,13551,13561,13577,13595,13609,13621,13633,13650,13662,13674,13685,13695,13705,13715,13746,13759,13771,13782,13797,13807,13828,13840,13854,13859,13863,13867,13873,13922,13933,13945,13957,13971,13983,14005,14017,14028,14044,14059,14082,14104,14128,14153,14168,14181,14193,14206,14219,14232,14244,14257,14270,14280,14293,14305,14316,14328,14339,14351,14363,14374,14383,14395,14407,14419,14434,14446,14460,14474,14486,14497,14508,14522,14536,14550,14563,14576,14588,14600,14611,14623,14634,14643,14655,14666,14677,14687,14700,14713,14726,14737,14746,14757,14768,14779,14820,14833,14846,14857,14868,14879,14890,14903,14915,14928,14941,14954,14967,14979,14991,15004,15017,15031,15045,15060,15073,15085,15098,15110,15118,15125,15132,15142,15154,15165,15176,15186,15197,15208,15218,15227,15236,15246,15256,15266,15276,15285,15294,15304,15453,15464,15475,15486,15497,15507,15515,15526,15537,15548,15558,15569,15580,15591,15603,15616,15627,15638,15650,15662,15673,15686,15698,15710,15725,15739,15753,15766,15778,15790,15802,15814,15826,15841,15853,15865,15877,15889,15901,15916,15928,15939,15989,16001,16013,16025,16037,16049,16061,16073,16083,16094,16106,16118,16129,16140,16150,16160,16170,16180,16190,16200,16210,16220,16231,16240,16251,16260,16270,16279,16290,16300,16309,16319,16328,16338,16348,16358,16368,16378,16388,16398,16408,16418,16428,16438,16448,16457,16466,16476,16486,16644,16651,16658,16665,16674,16682,16691,16699,16707,16716,16724,16733,16741,16749,16757,16767,16777,16787,16801,16815,16830,16844,16858,16872,16885,16896,16911,16925,16937,16949,16959,16969,16979,16992,17002,17010,17018,17026,17037,17045,17053,17062,17069,17077,17085,17092,17099,17106,17113,17122,17130,17135,17139,17148,17153,17159,17185,17190,17193,17202,17206,17211,17219,17224,17230,17235,17239,17246,17278,17286,17290,17299,17305,17312,17318,17327,17340,17356,17373,17379,17384,17390,17635,17754,17786,17803,17821,17837,17858,17877,17892,17910,17928,17949,17967,17987,18007,18026,18044,18065,18081,18097,18142,18160,18179,18196,18214,18232,18253,18284,18303,18321,18339,18353,18371,18391,18410,18432,18451,18469,18486,18506,18532,18567,18574,18582,18588)
(0)
Out of stock
WordPress-Datenbank-Fehler: [You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ” at line 14]
SELECT ID FROM wp_posts as p INNER JOIN wp_postmeta pm on p.ID = pm.post_id and pm.meta_key=’_stock_status’ AND pm.meta_value = ‘outofstock’ AND p.post_status = ‘publish’ AND p.post_type = ‘product’ AND p.ID NOT IN ( SELECT tr.object_id FROM wp_terms as t JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id JOIN wp_term_relationships AS tr ON tt.term_taxonomy_id = tr.term_taxonomy_id WHERE t.name = ‘exclude-from-catalog’) AND p.ID IN ( SELECT pl.element_id FROM wp_icl_translations WHERE pl.language_code = ‘de’ AND p.ID IN (7397,7445,7452,7458,7461,7617,7629,7644,7659,7675,544,754,834,844,853,885,902,904,2196,1995,2217,2204,2223,2228,2632,2680,7876,6606,44,150,363,370,380,387,396,4922,4946,4953,4962,5028,5287,5295,5528,7397,7445,7452,7458,7461,7684,7700,7707,7718,7723,7729,7733,7740,7749,7754,7858,7974,7994,8006,8018,8032,8043,8054,8074,8090,14158,8094,14148,8113,14133,8129,14118,8144,14105,8159,14099,8172,14088,8185,14076,8198,14064,8209,14055,8218,14039,8231,13996,8355,8359,8364,8380,8392,8408,8440,8454,8470,8490,8517,8531,8570,8591,8606,8618,8630,7617,7644,7675,7659,7629,8661,8693,8706,8714,8731,8770,8798,8812,8827,8838,8849,8862,8875,8903,8914,8949,8953,8957,8961,8963,8966,8969,8972,10214,10239,10253,10270,10279,10293,10300,10312,10505,10528,10541,10555,10567,10581,10594,10609,10625,10639,10666,10683,10698,10714,10723,10732,10746,10755,10785,10795,10804,10815,10826,10838,10851,10864,10881,10888,10899,10907,10921,10929,10939,10948,10960,10972,10984,10995,11008,11019,11030,11039,11052,11065,11084,11097,11111,11122,11137,11147,11158,11171,11184,11193,11206,11218,11232,11375,11382,11389,11396,11403,11410,11417,11424,11435,11444,11453,11460,11469,11478,11487,11496,11503,11510,11517,11524,11568,11594,11614,11634,11652,11669,11686,11702,11719,11734,11754,11773,11792,11811,11830,11860,11886,11972,11990,12021,12093,12248,12263,12279,12293,12309,12323,12339,12353,12369,12383,12395,12411,12425,12441,12477,12573,12626,12644,12677,12690,12711,12737,12758,12773,12786,12803,12814,12830,12842,12860,12870,12886,12900,12914,13150,13162,13176,13212,13233,13259,13277,13301,13329,13345,13366,13378,13388,13400,13412,13426,13439,13453,13467,13483,13497,13507,13517,13533,13541,13551,13561,13577,13595,13609,13621,13633,13650,13662,13674,13685,13695,13705,13715,13746,13759,13771,13782,13797,13807,13828,13840,13854,13859,13863,13867,13873,13922,13933,13945,13957,13971,13983,14005,14017,14028,14044,14059,14082,14104,14128,14153,14168,14181,14193,14206,14219,14232,14244,14257,14270,14280,14293,14305,14316,14328,14339,14351,14363,14374,14383,14395,14407,14419,14434,14446,14460,14474,14486,14497,14508,14522,14536,14550,14563,14576,14588,14600,14611,14623,14634,14643,14655,14666,14677,14687,14700,14713,14726,14737,14746,14757,14768,14779,14820,14833,14846,14857,14868,14879,14890,14903,14915,14928,14941,14954,14967,14979,14991,15004,15017,15031,15045,15060,15073,15085,15098,15110,15118,15125,15132,15142,15154,15165,15176,15186,15197,15208,15218,15227,15236,15246,15256,15266,15276,15285,15294,15304,15453,15464,15475,15486,15497,15507,15515,15526,15537,15548,15558,15569,15580,15591,15603,15616,15627,15638,15650,15662,15673,15686,15698,15710,15725,15739,15753,15766,15778,15790,15802,15814,15826,15841,15853,15865,15877,15889,15901,15916,15928,15939,15989,16001,16013,16025,16037,16049,16061,16073,16083,16094,16106,16118,16129,16140,16150,16160,16170,16180,16190,16200,16210,16220,16231,16240,16251,16260,16270,16279,16290,16300,16309,16319,16328,16338,16348,16358,16368,16378,16388,16398,16408,16418,16428,16438,16448,16457,16466,16476,16486,16644,16651,16658,16665,16674,16682,16691,16699,16707,16716,16724,16733,16741,16749,16757,16767,16777,16787,16801,16815,16830,16844,16858,16872,16885,16896,16911,16925,16937,16949,16959,16969,16979,16992,17002,17010,17018,17026,17037,17045,17053,17062,17069,17077,17085,17092,17099,17106,17113,17122,17130,17135,17139,17148,17153,17159,17185,17190,17193,17202,17206,17211,17219,17224,17230,17235,17239,17246,17278,17286,17290,17299,17305,17312,17318,17327,17340,17356,17373,17379,17384,17390,17635,17754,17786,17803,17821,17837,17858,17877,17892,17910,17928,17949,17967,17987,18007,18026,18044,18065,18081,18097,18142,18160,18179,18196,18214,18232,18253,18284,18303,18321,18339,18353,18371,18391,18410,18432,18451,18469,18486,18506,18532,18567,18574,18582,18588)
(0)
On sale
WordPress-Datenbank-Fehler: [You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ” at line 11]
SELECT ID FROM wp_posts as p WHERE p.post_status = ‘publish’ AND p.post_type IN (‘product’) AND p.ID IN (7649,7650,7651,7652,7653,7654,7655,7656,7657,7658,7663,7664,7665,7666,7667,7668,7669,7670,7671,7672,8949,8953,8957,8961,8963,8966,8969,8972,11288,11289,11290,11291,11292,11293,11294,11295,11296,11297,11330,11331,11332,11333,11334,11335,11336,11337,11338,11339,11350,11351,11352,11353,11354,11355,11356,11357,11358,11359,12249,12250,12251,12252,12253,12254,12264,12265,12266,12267,12268,12269,12280,12281,12282,12283,12284,12285,12294,12295,12296,12297,12298,12299,12310,12311,12312,12313,12314,12315,12324,12325,12326,12327,12328,12329,12340,12341,12342,12343,12344,12345,12354,12355,12356,12357,12358,12359,12370,12371,12372,12373,12374,12375,12384,12385,12386,12387,12388,12389,12396,12397,12398,12399,12400,12401,12412,12413,12414,12415,12416,12417,12426,12427,12428,12429,12430,12431,12442,12443,12444,12445,12446,12447,12759,12760,12761,12762,12763,12764,12765,12774,12775,12776,12777,12778,12779,12780,12787,12788,12789,12790,12791,12792,12793,12804,12805,12806,12807,12808,12809,13497,13551,13561,7644,7659,7452,7458,12248,12263,12279,12293,12309,12323,12339,12353,12369,12383,12395,12411,12425,12441,12758,12773,12786,12803) AND p.ID NOT IN ( SELECT tr.object_id FROM wp_terms as t JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id JOIN wp_term_relationships AS tr ON tt.term_taxonomy_id = tr.term_taxonomy_id WHERE t.name = ‘exclude-from-catalog’) AND p.ID IN ( SELECT pl.element_id FROM wp_icl_translations WHERE pl.language_code = ‘de’ AND p.ID IN (7397,7445,7452,7458,7461,7617,7629,7644,7659,7675,544,754,834,844,853,885,902,904,2196,1995,2217,2204,2223,2228,2632,2680,7876,6606,44,150,363,370,380,387,396,4922,4946,4953,4962,5028,5287,5295,5528,7397,7445,7452,7458,7461,7684,7700,7707,7718,7723,7729,7733,7740,7749,7754,7858,7974,7994,8006,8018,8032,8043,8054,8074,8090,14158,8094,14148,8113,14133,8129,14118,8144,14105,8159,14099,8172,14088,8185,14076,8198,14064,8209,14055,8218,14039,8231,13996,8355,8359,8364,8380,8392,8408,8440,8454,8470,8490,8517,8531,8570,8591,8606,8618,8630,7617,7644,7675,7659,7629,8661,8693,8706,8714,8731,8770,8798,8812,8827,8838,8849,8862,8875,8903,8914,8949,8953,8957,8961,8963,8966,8969,8972,10214,10239,10253,10270,10279,10293,10300,10312,10505,10528,10541,10555,10567,10581,10594,10609,10625,10639,10666,10683,10698,10714,10723,10732,10746,10755,10785,10795,10804,10815,10826,10838,10851,10864,10881,10888,10899,10907,10921,10929,10939,10948,10960,10972,10984,10995,11008,11019,11030,11039,11052,11065,11084,11097,11111,11122,11137,11147,11158,11171,11184,11193,11206,11218,11232,11375,11382,11389,11396,11403,11410,11417,11424,11435,11444,11453,11460,11469,11478,11487,11496,11503,11510,11517,11524,11568,11594,11614,11634,11652,11669,11686,11702,11719,11734,11754,11773,11792,11811,11830,11860,11886,11972,11990,12021,12093,12248,12263,12279,12293,12309,12323,12339,12353,12369,12383,12395,12411,12425,12441,12477,12573,12626,12644,12677,12690,12711,12737,12758,12773,12786,12803,12814,12830,12842,12860,12870,12886,12900,12914,13150,13162,13176,13212,13233,13259,13277,13301,13329,13345,13366,13378,13388,13400,13412,13426,13439,13453,13467,13483,13497,13507,13517,13533,13541,13551,13561,13577,13595,13609,13621,13633,13650,13662,13674,13685,13695,13705,13715,13746,13759,13771,13782,13797,13807,13828,13840,13854,13859,13863,13867,13873,13922,13933,13945,13957,13971,13983,14005,14017,14028,14044,14059,14082,14104,14128,14153,14168,14181,14193,14206,14219,14232,14244,14257,14270,14280,14293,14305,14316,14328,14339,14351,14363,14374,14383,14395,14407,14419,14434,14446,14460,14474,14486,14497,14508,14522,14536,14550,14563,14576,14588,14600,14611,14623,14634,14643,14655,14666,14677,14687,14700,14713,14726,14737,14746,14757,14768,14779,14820,14833,14846,14857,14868,14879,14890,14903,14915,14928,14941,14954,14967,14979,14991,15004,15017,15031,15045,15060,15073,15085,15098,15110,15118,15125,15132,15142,15154,15165,15176,15186,15197,15208,15218,15227,15236,15246,15256,15266,15276,15285,15294,15304,15453,15464,15475,15486,15497,15507,15515,15526,15537,15548,15558,15569,15580,15591,15603,15616,15627,15638,15650,15662,15673,15686,15698,15710,15725,15739,15753,15766,15778,15790,15802,15814,15826,15841,15853,15865,15877,15889,15901,15916,15928,15939,15989,16001,16013,16025,16037,16049,16061,16073,16083,16094,16106,16118,16129,16140,16150,16160,16170,16180,16190,16200,16210,16220,16231,16240,16251,16260,16270,16279,16290,16300,16309,16319,16328,16338,16348,16358,16368,16378,16388,16398,16408,16418,16428,16438,16448,16457,16466,16476,16486,16644,16651,16658,16665,16674,16682,16691,16699,16707,16716,16724,16733,16741,16749,16757,16767,16777,16787,16801,16815,16830,16844,16858,16872,16885,16896,16911,16925,16937,16949,16959,16969,16979,16992,17002,17010,17018,17026,17037,17045,17053,17062,17069,17077,17085,17092,17099,17106,17113,17122,17130,17135,17139,17148,17153,17159,17185,17190,17193,17202,17206,17211,17219,17224,17230,17235,17239,17246,17278,17286,17290,17299,17305,17312,17318,17327,17340,17356,17373,17379,17384,17390,17635,17754,17786,17803,17821,17837,17858,17877,17892,17910,17928,17949,17967,17987,18007,18026,18044,18065,18081,18097,18142,18160,18179,18196,18214,18232,18253,18284,18303,18321,18339,18353,18371,18391,18410,18432,18451,18469,18486,18506,18532,18567,18574,18582,18588)
(0)
