משלמים על 1 מקבלים 3

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 '%"9"%' AND sale_post.ID != 5511 AND details_postmeta_date_start.meta_value < 20260910 AND details_postmeta_date_end.meta_value > 20260910 ORDER BY sale_post.ID LIMIT 4
Mall ID: 9
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 9: Array ( [0] => stdClass Object ( [post_id] => 4292 [meta_value] => a:1:{i:0;s:1:"9";} ) [1] => stdClass Object ( [post_id] => 5450 [meta_value] => a:1:{i:0;s:1:"9";} ) [2] => stdClass Object ( [post_id] => 5453 [meta_value] => a:1:{i:0;s:1:"9";} ) [3] => stdClass Object ( [post_id] => 5456 [meta_value] => a:1:{i:0;s:1:"9";} ) [4] => stdClass Object ( [post_id] => 5497 [meta_value] => a:1:{i:0;s:1:"9";} ) [5] => stdClass Object ( [post_id] => 5500 [meta_value] => a:1:{i:0;s:1:"9";} ) [6] => stdClass Object ( [post_id] => 5505 [meta_value] => a:1:{i:0;s:1:"9";} ) [7] => stdClass Object ( [post_id] => 5508 [meta_value] => a:1:{i:0;s:1:"9";} ) [8] => stdClass Object ( [post_id] => 5511 [meta_value] => a:1:{i:0;s:1:"9";} ) )