50 בקניית 2 פריטים ויותר

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 '%"1084"%' AND sale_post.ID != 5390 AND details_postmeta_date_start.meta_value < 20260519 AND details_postmeta_date_end.meta_value > 20260519 ORDER BY sale_post.ID LIMIT 4
Mall ID: 1084
mall_multiple values: Array ( [0] => stdClass Object ( [post_id] => 5362 [meta_value] => a:2:{i:0;s:4:"1084";i:1;s:4:"1068";} ) [1] => stdClass Object ( [post_id] => 1810 [meta_value] => a:1:{i:0;s:4:"1074";} ) [2] => stdClass Object ( [post_id] => 1697 [meta_value] => a:1:{i:0;s:4:"1074";} ) [3] => stdClass Object ( [post_id] => 4203 [meta_value] => a:1:{i:0;s:4:"1074";} ) [4] => stdClass Object ( [post_id] => 4207 [meta_value] => a:1:{i:0;s:4:"1074";} ) [5] => stdClass Object ( [post_id] => 4211 [meta_value] => a:1:{i:0;s:4:"1074";} ) [6] => stdClass Object ( [post_id] => 4232 [meta_value] => a:1:{i:0;s:4:"1084";} ) [7] => stdClass Object ( [post_id] => 5359 [meta_value] => a:1:{i:0;s:4:"1084";} ) [8] => stdClass Object ( [post_id] => 4255 [meta_value] => a:1:{i:0;s:4:"1087";} ) [9] => stdClass Object ( [post_id] => 4268 [meta_value] => a:1:{i:0;s:4:"1077";} ) )
Sales with mall 1084: Array ( [0] => stdClass Object ( [post_id] => 5362 [meta_value] => a:2:{i:0;s:4:"1084";i:1;s:4:"1068";} ) [1] => stdClass Object ( [post_id] => 4232 [meta_value] => a:1:{i:0;s:4:"1084";} ) [2] => stdClass Object ( [post_id] => 5359 [meta_value] => a:1:{i:0;s:4:"1084";} ) [3] => stdClass Object ( [post_id] => 5258 [meta_value] => a:1:{i:0;s:4:"1084";} ) [4] => stdClass Object ( [post_id] => 5387 [meta_value] => a:1:{i:0;s:4:"1084";} ) [5] => stdClass Object ( [post_id] => 5349 [meta_value] => a:1:{i:0;s:4:"1084";} ) [6] => stdClass Object ( [post_id] => 5364 [meta_value] => a:1:{i:0;s:4:"1084";} ) [7] => stdClass Object ( [post_id] => 5357 [meta_value] => a:1:{i:0;s:4:"1084";} ) [8] => stdClass Object ( [post_id] => 5367 [meta_value] => a:1:{i:0;s:4:"1084";} ) [9] => stdClass Object ( [post_id] => 5373 [meta_value] => a:1:{i:0;s:4:"1084";} ) )