40% הנחה בקניית 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 '%"1068"%' AND sale_post.ID != 5260 AND details_postmeta_date_start.meta_value < 20260316 AND details_postmeta_date_end.meta_value > 20260316 ORDER BY sale_post.ID LIMIT 4
Mall ID: 1068
mall_multiple values: Array ( [0] => stdClass Object ( [post_id] => 1810 [meta_value] => a:1:{i:0;s:4:"1074";} ) [1] => stdClass Object ( [post_id] => 1697 [meta_value] => a:1:{i:0;s:4:"1074";} ) [2] => stdClass Object ( [post_id] => 4203 [meta_value] => a:1:{i:0;s:4:"1074";} ) [3] => stdClass Object ( [post_id] => 4207 [meta_value] => a:1:{i:0;s:4:"1074";} ) [4] => stdClass Object ( [post_id] => 4211 [meta_value] => a:1:{i:0;s:4:"1074";} ) [5] => stdClass Object ( [post_id] => 4232 [meta_value] => a:1:{i:0;s:4:"1084";} ) [6] => stdClass Object ( [post_id] => 4255 [meta_value] => a:1:{i:0;s:4:"1087";} ) [7] => stdClass Object ( [post_id] => 4268 [meta_value] => a:1:{i:0;s:4:"1077";} ) [8] => stdClass Object ( [post_id] => 4266 [meta_value] => a:1:{i:0;s:4:"1077";} ) [9] => stdClass Object ( [post_id] => 5258 [meta_value] => a:1:{i:0;s:4:"1084";} ) )
Sales with mall 1068: Array ( [0] => stdClass Object ( [post_id] => 4297 [meta_value] => a:1:{i:0;s:4:"1068";} ) [1] => stdClass Object ( [post_id] => 5159 [meta_value] => a:1:{i:0;s:4:"1068";} ) [2] => stdClass Object ( [post_id] => 5154 [meta_value] => a:1:{i:0;s:4:"1068";} ) [3] => stdClass Object ( [post_id] => 5260 [meta_value] => a:2:{i:0;s:4:"1068";i:1;s:4:"1074";} ) [4] => stdClass Object ( [post_id] => 5263 [meta_value] => a:2:{i:0;s:4:"1084";i:1;s:4:"1068";} ) )