An SQL command for extracting an individual record from the database
Can be set in: collection.cfg
This parameter specifies the SQL query to execute to fetch an individual record with a particular ID
from the database. The required ID is indicated by the
$item_key token, which is replaced with the
needed value during execution.
Funnelback uses this query to fetch records which have been marked as new or changed through a line in the update event table.
Please note that with most database drivers, a semicolon (;) should not be included at the end of the query.
db.single_item_sql=select * from main where id = $item_key