fbpx

WordPress databasefout: [Not unique table/alias: 'adverts']
SELECT SQL_CALC_FOUND_ROWS wp_posts.ID, adverts.*, IF( sale_price > 0, sale_price, price ) AS sort_price , adverts.*, IF( sale_price > 0, sale_price, price ) AS sort_price FROM wp_posts LEFT JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) LEFT JOIN wp_postmeta AS mt1 ON (wp_posts.ID = mt1.post_id AND mt1.meta_key = 'wp_rebid_ads_advert_rented' ) JOIN wp_icl_translations wpml_translations ON wp_posts.ID = wpml_translations.element_id AND wpml_translations.element_type = CONCAT('post_', wp_posts.post_type) INNER JOIN wp_adifier_advert_data AS adverts ON wp_posts.ID = adverts.post_id INNER JOIN wp_adifier_advert_data AS adverts ON wp_posts.ID = adverts.post_id WHERE 1=1 AND wp_posts.ID IN (3104,3128,3511,3538,3665,3667,3964,4009,4011,4013,4044,4380,4522,4698,4734,4776,4845,4867,4909,4953,4955,5201,5224,5268,5272,5290,5293,5295,5303,5341,5363,5367,5380,5385,5388,5391,5398,5451,5455,5523,5566,5607,5609,5611,5613,5757,5763,5856,6151,6305,6467,6484,6492,6494,6529,6558,6574,6608,6612,6619,6629,6631,6642,7073,7136,7140,7186,7189,7233,7259,7268,7270,7286,7289,7306,7308,7310,7330,7370,7390,7393,7472,7612,7761,7781,7883,7967,8186,8217,8368,8382,8450,8495,8567,8680,8684,8723,8800,8915,8917,9001,9040,9515,9589,9703,9736,10187,10194,10314,10417,10622,10798,10811,10813,10817,10819,10894,10896,10900,10902,10954,10970,10973,10975,11064,11211,11327,11449,11553,11630,11631,11632,11633,11634,11636,11637,11638,11639,11640,11641,11642,11643,11644,11645,11646,11647,11826,11827,11828,11829,11830,11833,11834,11835,11836,11962,12499,12581,12648,12699,12825,12874,12878,12937,12939,12941,12965,12976,13061,13193,13250,13339,13340,13347,13410,13446,13514,13587,13733,13928,14426,14455,14465,14470,14647,14883,14913,14917,14991,15004,15245,15252,15263,15463,15472,15474,15475,15566,15567,15568,15569,15690,15691,15692,15693,15694,15695,15842,15847,16074,16308,16358,16510,16575,16579,16584,16810,17101,17234,17238,17268,17302,17306,17325,17486,17488,17578,17586,17592,17594,17646,17652,17653,17654,17699,17740,17842,17843,17844,17897,17918,17925,18103,18154,18324,18882,18917,18950,19040,19499,19565,19668,19779,19853,19910,19918,19954,20079,20083,20140,20263,20379,20388,20481,20745,20970,21003,21438,21468,21627,21640,21723,21724,21729,21792,21809,21816,21835,21844,22193,22220,22230,22272,22283,22292,22381,22537,22539,22542,22575,22654,22890,22895,22970,22995,23002,23010,23018,23121,23235,23281,23342,23816,23860,23899,23919,23992,24062,24069,24171,24175,24176,24202,24223,24227,24236,24237,24291,24507,24598,24628,24932,24935,24977,24996,25002,25059,25064,25073,25124,25338,25341,25443,25445,25464,25622,25908,25947,26073,26094,26310,26336,26475,26531,26908,26910,27095,27283,27287,27352,27531,27536,27539,27574,27788,27799,27882,27884,27954,27956,29158,29161,37285,37291,37300,37559,37623,37632,37640,37661,37665,37723,37726,37772,37776,37787,37790,38096,38101,38131,38235,38249,38273,38275,38343,38412,38414,38611,38616,38678,39132,39219,39271,39295,39762,39803,39810,39920,39924,40038,40048,40314,40387,40502,40512,40577,40596,40749,40764,40859,41000,41050,41244,41246,41249,41251,41751,41917,41959,42006,42007,42609,42644,42995,43382,43404,43406,43412,43427,43438,43552,43565,43608,43656,43754,43777,43784,43815,44042,44138,44216,44220,44396,44560,44576,44766,44770,44881,44926,45406,45675,45851,46339,46415,46545,46550,46561,46643,46647,46726,46930,46940,47110,47115,47247,47250,47348,47460,47713,47722,47767,48203,48409,48418,48469,48748,48750,48752,48843,48851,48959,48963,49329,49333,49348,49352,49471,49493,49598,49674,49834,49898,49986,50080,50091,50248,50351,50470,50521,50526,50704,50706,50709,50874,51317,51451,51584,51612,51614,51724,52109,52205,52235,52255,52328,52342,52346,52578,52698,52703,52715,53153,53535,53539,53631,54081,54314,54317,54331,54362,54639,55497,55526,55528,55580,55594,55640,56535,56637,56647,56764,56968,57288,57335,57407,57838,57939,57958,57993,58008,58409,58428,58525,58652,58785,59247,59889,60040,60477,60732,60750,60982,61038,61166,61266,61958,61969,62014,62030,62069,62177,62244,62375,62457,63215,63222,63332,63362,64032,64061,64126,64362,64380,64383,64477,64553,64577,64582,64591,64602,64604,64625,64858,64997,65100,65165,65210,65214,65396,65512,65526,65538,65585,65634,66182,66441,67745,67948,68109,68129,68231,68393,68442,68569,68611,68688,68716,68856,68895,68903,69046,69232,69460,69470,69474,69479,69554,69686,69690,69926,69970,69993,70049,70075,70273,70318,70558,70632,70637,70996,71031,71296,71336,71338,71358,71613,71623,71630,71767,71770,71774,71779,72163,72173,72278,72853,72890,72891,73310,73482,73487,73672,73678,73780,73989,74026,74086,74132,74286,74288,74350,74436,74533,74631,75278,75370,75831,75833,75945,75949,76002,76005,76345,76388,76390,76402,76470,76472,76474,76650,76695,76708,76732,76743,76751,77006,77050,77070,77267,77408,77567,77668,77699,77704,77809,77868,78016,78136,78263,78366,78575,78589,78609,78718,79011,79034,79038,79044,79054,79058,79062,79179,79189,79303,79351,79355,79363,79367,79473,79902,80049,80056,80074,80294,80654,80841,80871,81202,81340,81342,81459,81876,82066,82084,82141,82151,82162,82192,82278,82302,82329,82351,82352,82480,82483,82491,82496) AND wp_posts.post_parent = 0 AND ( ( wp_postmeta.meta_key = 'wp_rebid_ads_advert_rented' AND wp_postmeta.meta_value = 'no' ) OR mt1.post_id IS NULL OR ( wp_postmeta.meta_key = 'wp_rebid_advert_location_city' AND wp_postmeta.meta_value = '' ) ) AND wp_posts.post_type = 'advert' AND ((wp_posts.post_status = 'publish')) AND ( ( ( wpml_translations.language_code = 'nl' OR ( wpml_translations.language_code = 'nl' AND wp_posts.post_type IN ( 'elementor_library','advert','kc-section' ) AND ( ( ( SELECT COUNT(element_id) FROM wp_icl_translations WHERE trid = wpml_translations.trid AND language_code = 'nl' ) = 0 ) OR ( ( SELECT COUNT(element_id) FROM wp_icl_translations t2 JOIN wp_posts p ON p.id = t2.element_id WHERE t2.trid = wpml_translations.trid AND t2.language_code = 'nl' AND ( p.post_status = 'publish' OR p.post_type='attachment' AND p.post_status = 'inherit' ) ) = 0 ) ) ) ) AND wp_posts.post_type IN ('post','page','attachment','wp_block','elementor_library','advert','docs','wprviewingrequest','kc-section' ) ) OR wp_posts.post_type NOT IN ('post','page','attachment','wp_block','elementor_library','advert','docs','wprviewingrequest','kc-section' ) ) AND adverts.expire > 1675800556 AND adverts.sold = 0 AND wp_posts.post_author NOT IN (11647) AND wp_posts.post_author NOT IN (1,7,146,157,151,161,145) AND adverts.expire > 1675800556 AND adverts.sold = 0 GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC LIMIT 0, 48

WordPress databasefout: [Not unique table/alias: 'adverts']
SELECT SQL_CALC_FOUND_ROWS wp_posts.ID, adverts.*, IF( sale_price > 0, sale_price, price ) AS sort_price , adverts.*, IF( sale_price > 0, sale_price, price ) AS sort_price FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) INNER JOIN wp_postmeta AS mt1 ON ( wp_posts.ID = mt1.post_id ) JOIN wp_icl_translations wpml_translations ON wp_posts.ID = wpml_translations.element_id AND wpml_translations.element_type = CONCAT('post_', wp_posts.post_type) INNER JOIN wp_adifier_advert_data AS adverts ON wp_posts.ID = adverts.post_id INNER JOIN wp_adifier_advert_data AS adverts ON wp_posts.ID = adverts.post_id WHERE 1=1 AND wp_posts.ID IN (3104,3128,3511,3538,3665,3667,3964,4009,4011,4013,4044,4380,4522,4698,4734,4776,4845,4867,4909,4953,4955,5201,5224,5268,5272,5290,5293,5295,5303,5341,5363,5367,5380,5385,5388,5391,5398,5451,5455,5523,5566,5607,5609,5611,5613,5757,5763,5856,6151,6305,6467,6484,6492,6494,6529,6558,6574,6608,6612,6619,6629,6631,6642,7073,7136,7140,7186,7189,7233,7259,7268,7270,7286,7289,7306,7308,7310,7330,7370,7390,7393,7472,7612,7761,7781,7883,7967,8186,8217,8368,8382,8450,8495,8567,8680,8684,8723,8800,8915,8917,9001,9040,9515,9589,9703,9736,10187,10194,10314,10417,10622,10798,10811,10813,10817,10819,10894,10896,10900,10902,10954,10970,10973,10975,11064,11211,11327,11449,11553,11630,11631,11632,11633,11634,11636,11637,11638,11639,11640,11641,11642,11643,11644,11645,11646,11647,11826,11827,11828,11829,11830,11833,11834,11835,11836,11962,12499,12581,12648,12699,12825,12874,12878,12937,12939,12941,12965,12976,13061,13193,13250,13339,13340,13347,13410,13446,13514,13587,13733,13928,14426,14455,14465,14470,14647,14883,14913,14917,14991,15004,15245,15252,15263,15463,15472,15474,15475,15566,15567,15568,15569,15690,15691,15692,15693,15694,15695,15842,15847,16074,16308,16358,16510,16575,16579,16584,16810,17101,17234,17238,17268,17302,17306,17325,17486,17488,17578,17586,17592,17594,17646,17652,17653,17654,17699,17740,17842,17843,17844,17897,17918,17925,18103,18154,18324,18882,18917,18950,19040,19499,19565,19668,19779,19853,19910,19918,19954,20079,20083,20140,20263,20379,20388,20481,20745,20970,21003,21438,21468,21627,21640,21723,21724,21729,21792,21809,21816,21835,21844,22193,22220,22230,22272,22283,22292,22381,22537,22539,22542,22575,22654,22890,22895,22970,22995,23002,23010,23018,23121,23235,23281,23342,23816,23860,23899,23919,23992,24062,24069,24171,24175,24176,24202,24223,24227,24236,24237,24291,24507,24598,24628,24932,24935,24977,24996,25002,25059,25064,25073,25124,25338,25341,25443,25445,25464,25622,25908,25947,26073,26094,26310,26336,26475,26531,26908,26910,27095,27283,27287,27352,27531,27536,27539,27574,27788,27799,27882,27884,27954,27956,29158,29161,37285,37291,37300,37559,37623,37632,37640,37661,37665,37723,37726,37772,37776,37787,37790,38096,38101,38131,38235,38249,38273,38275,38343,38412,38414,38611,38616,38678,39132,39219,39271,39295,39762,39803,39810,39920,39924,40038,40048,40314,40387,40502,40512,40577,40596,40749,40764,40859,41000,41050,41244,41246,41249,41251,41751,41917,41959,42006,42007,42609,42644,42995,43382,43404,43406,43412,43427,43438,43552,43565,43608,43656,43754,43777,43784,43815,44042,44138,44216,44220,44396,44560,44576,44766,44770,44881,44926,45406,45675,45851,46339,46415,46545,46550,46561,46643,46647,46726,46930,46940,47110,47115,47247,47250,47348,47460,47713,47722,47767,48203,48409,48418,48469,48748,48750,48752,48843,48851,48959,48963,49329,49333,49348,49352,49471,49493,49598,49674,49834,49898,49986,50080,50091,50248,50351,50470,50521,50526,50704,50706,50709,50874,51317,51451,51584,51612,51614,51724,52109,52205,52235,52255,52328,52342,52346,52578,52698,52703,52715,53153,53535,53539,53631,54081,54314,54317,54331,54362,54639,55497,55526,55528,55580,55594,55640,56535,56637,56647,56764,56968,57288,57335,57407,57838,57939,57958,57993,58008,58409,58428,58525,58652,58785,59247,59889,60040,60477,60732,60750,60982,61038,61166,61266,61958,61969,62014,62030,62069,62177,62244,62375,62457,63215,63222,63332,63362,64032,64061,64126,64362,64380,64383,64477,64553,64577,64582,64591,64602,64604,64625,64858,64997,65100,65165,65210,65214,65396,65512,65526,65538,65585,65634,66182,66441,67745,67948,68109,68129,68231,68393,68442,68569,68611,68688,68716,68856,68895,68903,69046,69232,69460,69470,69474,69479,69554,69686,69690,69926,69970,69993,70049,70075,70273,70318,70558,70632,70637,70996,71031,71296,71336,71338,71358,71613,71623,71630,71767,71770,71774,71779,72163,72173,72278,72853,72890,72891,73310,73482,73487,73672,73678,73780,73989,74026,74086,74132,74286,74288,74350,74436,74533,74631,75278,75370,75831,75833,75945,75949,76002,76005,76345,76388,76390,76402,76470,76472,76474,76650,76695,76708,76732,76743,76751,77006,77050,77070,77267,77408,77567,77668,77699,77704,77809,77868,78016,78136,78263,78366,78575,78589,78609,78718,79011,79034,79038,79044,79054,79058,79062,79179,79189,79303,79351,79355,79363,79367,79473,79902,80049,80056,80074,80294,80654,80841,80871,81202,81340,81342,81459,81876,82066,82084,82141,82151,82162,82192,82278,82302,82329,82351,82352,82480,82483,82491,82496) AND wp_posts.post_parent = 0 AND ( ( wp_postmeta.meta_key = 'wp_rebid_ads_advert_rented' AND wp_postmeta.meta_value = 'yes' ) AND mt1.meta_key = 'wp_rebid_ads_advert_rented' ) AND wp_posts.post_type = 'advert' AND ((wp_posts.post_status = 'publish' OR wp_posts.post_status = 'draft' OR wp_posts.post_status = 'pending')) AND ( ( ( wpml_translations.language_code = 'nl' OR ( wpml_translations.language_code = 'nl' AND wp_posts.post_type IN ( 'elementor_library','advert','kc-section' ) AND ( ( ( SELECT COUNT(element_id) FROM wp_icl_translations WHERE trid = wpml_translations.trid AND language_code = 'nl' ) = 0 ) OR ( ( SELECT COUNT(element_id) FROM wp_icl_translations t2 JOIN wp_posts p ON p.id = t2.element_id WHERE t2.trid = wpml_translations.trid AND t2.language_code = 'nl' AND ( p.post_status = 'publish' OR p.post_type='attachment' AND p.post_status = 'inherit' ) ) = 0 ) ) ) ) AND wp_posts.post_type IN ('post','page','attachment','wp_block','elementor_library','advert','docs','wprviewingrequest','kc-section' ) ) OR wp_posts.post_type NOT IN ('post','page','attachment','wp_block','elementor_library','advert','docs','wprviewingrequest','kc-section' ) ) AND adverts.expire > 1675800556 AND adverts.sold = 0 AND wp_posts.post_author NOT IN (11647) AND adverts.expire <= 1675800556 AND adverts.sold = 0 GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC LIMIT 0, 48

Filters