Error(s) encountered during statement execution: column index out of range，please help me ,thank you

liyany
Error(s) encountered during statement execution: column index out of range [QUERY: SELECT DISTINCT itemID
FROM itemDataValues
JOIN itemData USING (valueID)
JOIN items USING (itemID)
LEFT JOIN deletedItems USING (itemID)
WHERE deletedItems.itemID IS NULL
AND libraryID = ?
AND itemTypeID = ?
AND fieldID IN (?, ?, ?, ?)
AND SUBSTR(value, 1, 4) >= '?'
AND SUBSTR(value, 1, 4) <= '?'
AND itemID IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?);] [PARAMS: 1, 22, 48, 91, 109, 6, 2021, 2023, 1, 2, 3, 4, 5, 13, 17, 18, 19, 20, 21, 23, 24, 25, 26, 31, 36, 37, 39, 40, 41, 44, 45, 53, 55, 56, 57, 59, 62, 73, 82, 83, 84, 85, 88, 89, 90, 91, 92, 94, 97, 98, 99, 100, 102, 103, 105, 108, 253, 262, 263, 264, 265, 266, 267, 268, 269, 270, 271, 272, 273, 274, 275, 276, 277, 278, 279, 280, 281, 282, 283, 284, 285, 286, 287, 288, 289, 290, 291, 292, 293, 294, 295, 296, 297, 298, 299, 300, 301, 302, 352, 396, 439, 458, 521, 542, 544, 557, 565, 628, 632, 636, 653, 659, 662, 663, 664, 665, 666, 667, 668, 669, 679, 689, 690, 691, 692, 694, 727, 732, 734, 735, 739, 743, 744, 745, 746, 748, 749, 752, 755, 756, 759, 760, 762, 764, 766, 768, 770, 774, 775, 776, 777, 796, 803, 806, 808, 810, 812, 814, 920, 922, 924, 927, 929, 931, 932, 934, 935, 937, 1211, 1215, 1217, 1219, 1220, 1221, 1320, 1326, 1329, 1337, 1460, 1464, 1477, 1482, 1484, 1489, 1492, 1494, 1496, 1497, 1498, 1500, 1501, 1504, 1505, 1509, 1511, 1513, 1515, 1517, 1519, 1521, 1523, 1525, 1527, 1528, 1530, 1531, 1617, 1619, 1622, 1624, 1626, 1627, 1629, 1632, 1633, 1634, 1636, 1638, 1641, 1643, 1645, 1647, 1650, 1652, 1654] [ERROR: column index out of range]
This discussion has been closed.