db.single_item_sql (collection.cfg setting)
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