תכשיט שלישי מתנה

Last query: SELECT DISTINCT(sale_post.ID) as sale_id FROM amot_posts sale_post INNER JOIN amot_postmeta postmeta_mall_id ON postmeta_mall_id.post_id = sale_post.ID AND postmeta_mall_id.meta_key = 'mall_multiple' INNER JOIN amot_postmeta details_postmeta_date_start ON sale_post.ID = details_postmeta_date_start.post_id AND details_postmeta_date_start.meta_key = 'date_start' INNER JOIN amot_postmeta details_postmeta_date_end ON sale_post.ID = details_postmeta_date_end.post_id AND details_postmeta_date_end.meta_key = 'date_end' WHERE sale_post.post_type='sale' AND sale_post.post_status='publish' AND postmeta_mall_id.meta_value LIKE '%"1074"%' AND sale_post.ID != 5225 AND details_postmeta_date_start.meta_value < 20260309 AND details_postmeta_date_end.meta_value > 20260309 ORDER BY sale_post.ID LIMIT 4
Mall ID: 1074
mall_multiple values: Array ( [0] => stdClass Object ( [post_id] => 5205 [meta_value] => a:1:{i:0;s:4:"1084";} ) [1] => stdClass Object ( [post_id] => 5175 [meta_value] => a:1:{i:0;s:4:"1077";} ) [2] => stdClass Object ( [post_id] => 5204 [meta_value] => a:2:{i:0;s:4:"1074";i:1;s:4:"1084";} ) [3] => stdClass Object ( [post_id] => 5201 [meta_value] => a:1:{i:0;s:4:"1084";} ) [4] => stdClass Object ( [post_id] => 5199 [meta_value] => a:1:{i:0;s:4:"1084";} ) [5] => stdClass Object ( [post_id] => 5197 [meta_value] => a:1:{i:0;s:4:"1084";} ) [6] => stdClass Object ( [post_id] => 5195 [meta_value] => a:1:{i:0;s:4:"1084";} ) [7] => stdClass Object ( [post_id] => 5183 [meta_value] => a:1:{i:0;s:4:"1077";} ) [8] => stdClass Object ( [post_id] => 5176 [meta_value] => a:1:{i:0;s:4:"1077";} ) [9] => stdClass Object ( [post_id] => 5173 [meta_value] => a:1:{i:0;s:4:"1077";} ) )
Sales with mall 1074: Array ( [0] => stdClass Object ( [post_id] => 5204 [meta_value] => a:2:{i:0;s:4:"1074";i:1;s:4:"1084";} ) [1] => stdClass Object ( [post_id] => 5170 [meta_value] => a:1:{i:0;s:4:"1074";} ) [2] => stdClass Object ( [post_id] => 5161 [meta_value] => a:1:{i:0;s:4:"1074";} ) [3] => stdClass Object ( [post_id] => 5157 [meta_value] => a:1:{i:0;s:4:"1074";} ) [4] => stdClass Object ( [post_id] => 5225 [meta_value] => a:1:{i:0;s:4:"1074";} ) [5] => stdClass Object ( [post_id] => 5228 [meta_value] => a:1:{i:0;s:4:"1074";} ) [6] => stdClass Object ( [post_id] => 5233 [meta_value] => a:1:{i:0;s:4:"1074";} ) )