Changeset 1154345

Timestamp:

05/06/2015 07:20:29 AM (11 years ago)

Author:

2kblater.com

Message:

getProductsAsinsToUpdate fix where

File:

• 2kb-amazon-affiliates-store/trunk/KbAmazonStore.php (modified) (1 diff)

2kb-amazon-affiliates-store/trunk/KbAmazonStore.php

@@ -1418 +1418 @@
             $where .= " AND t1.meta_value NOT IN('".implode("','", $notAsins)."') ";
         }
-        // WHERE t.post_modified < '".date('Y-m-d H:i:s', $time)."'
-        // @TODO
+        
         $sql = "
            SELECT t1.meta_value AS asin
            FROM $wpdb->posts AS t
            JOIN $wpdb->postmeta AS t1 ON t.ID = t1.post_id AND t1.meta_key = 'KbAmzASIN'
-           $where
+           WHERE t.post_modified < '".date('Y-m-d H:i:s', $time)."'
            ORDER BY t.post_modified ASC
            $sqlLimit