מבצעי חודש נובמבר ברשת אניפט

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 '%"1077"%' AND sale_post.ID != 5599 AND details_postmeta_date_start.meta_value < 20261103 AND details_postmeta_date_end.meta_value > 20261103 ORDER BY sale_post.ID LIMIT 4
Mall ID: 1077
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] => 5529 [meta_value] => a:1:{i:0;s:1:"9";} ) [8] => stdClass Object ( [post_id] => 5359 [meta_value] => a:1:{i:0;s:4:"1084";} ) [9] => stdClass Object ( [post_id] => 4255 [meta_value] => a:1:{i:0;s:4:"1087";} ) )
Sales with mall 1077: Array ( [0] => stdClass Object ( [post_id] => 4268 [meta_value] => a:1:{i:0;s:4:"1077";} ) [1] => stdClass Object ( [post_id] => 4266 [meta_value] => a:1:{i:0;s:4:"1077";} ) [2] => stdClass Object ( [post_id] => 4763 [meta_value] => a:1:{i:0;s:4:"1077";} ) [3] => stdClass Object ( [post_id] => 4788 [meta_value] => a:1:{i:0;s:4:"1077";} ) [4] => stdClass Object ( [post_id] => 4857 [meta_value] => a:1:{i:0;s:4:"1077";} ) [5] => stdClass Object ( [post_id] => 4624 [meta_value] => a:1:{i:0;s:4:"1077";} ) [6] => stdClass Object ( [post_id] => 5028 [meta_value] => a:1:{i:0;s:4:"1077";} ) [7] => stdClass Object ( [post_id] => 5034 [meta_value] => a:1:{i:0;s:4:"1077";} ) [8] => stdClass Object ( [post_id] => 5186 [meta_value] => a:1:{i:0;s:4:"1077";} ) [9] => stdClass Object ( [post_id] => 5595 [meta_value] => a:1:{i:0;s:4:"1077";} ) )