Wrong SQL patterns in amazon_item_lookup_from_db

The wrong sql patterns used.

Need to be like
amazon.module, line 472
$result = db_query('SELECT * from {amazon_item} WHERE asin IN (:asins) AND timestamp > :timestamp',
array(':asins' => $item_ids, ':timestamp' => $timestamp),
array(':fetch' => PDO::FETCH_ASSOC));

I wanted to say that. There is not used the Drupal 7 database posibilities. Yes, It works like in Drupal 6.
But you pass parameters in to query in a wrong way. Keys of parameters should be the same as in the query.
So we shoud use ":" like array(':asins' => .
There is a like "array('asins' => " It is wrong.

I hae ported the module amazon_import to D7.
http://drupal.org/node/1437028#comment-5811614
It does not want to work until, I have not fixed it.
amazon_lookup .

Hello.
I try to work as Drupal professional.
Please, correct me if I am wrong.
-----------------------------------------------------
In my own code I use this.

//We try to check existed items.  
  if ($lookup) {
    $products = amazon_item_lookup($items);
  }

And I receive this.

PDOException: SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens: SELECT * from {amazon_item} WHERE asin IN (:asins_1590207238, asins_B0007XLNWY) AND timestamp > :timestamp; Array ( [timestamp] => 1334070552 [asins_1590207238] => 1590207238 [asins_B0007XLNWY] => B0007XLNWY ) in amazon_item_lookup_from_db() (line 474 of /var/www/d7/drupal-7.12/sites/all/modules/amazon/amazon.module).

I have attached a git patch.

This is your variant.

$timestamp = REQUEST_TIME - variable_get('amazon_refresh_schedule', 86400);
    $result = db_query('SELECT * from {amazon_item} WHERE asin IN (:asins) AND timestamp > :timestamp',
      array('asins' => $item_ids, 'timestamp' => $timestamp),
      array('fetch' => PDO::FETCH_ASSOC));

Make the attention on ":". It does not determine the sql parameter. We can use any pointer to(@ - for an example).

Sorry.

I propose to use this construction in this part.
We work under Drupal 7, we need use the db_select.

Ok, you are right.
Look over that articles, look how to use parameters right.
Try to find a difference between your code and the snippets in that article.