All pastes #955293 Raw Edit

Something

public text v1 · immutable
#955293 ·published 2008-03-24 15:06 UTC
rendered paste body
2008-03-24 15:05:06.223 Query contains bind value ":NR3LIKEPHRASE" twice:
INSERT INTO recordmatch (recordid, chanid, starttime, manualid) SELECT record.recordid, program.chanid, program.starttime,  IF(search = 5, record.recordid, 0) FROM (record, program INNER JOIN channel       ON channel.chanid = program.chanid)  WHERE record.recordid = :NR3RECID AND program.manualid = 0 AND (program.title LIKE :NR3LIKEPHRASE OR program.subtitle LIKE :NR3LIKEPHRASE OR program.description LIKE :NR3LIKEPHRASE) AND (NOT ((record.dupin & 32) AND program.previouslyshown))  AND (NOT ((record.dupin & 64) AND program.generic > 0))  AND (NOT ((record.dupin & 128) AND (program.previouslyshown                                       OR program.first = 0)))  AND channel.visible = 1 AND ((record.type = 4 OR record.type = 6 OR record.type = 9 OR record.type = 10)  OR  ((record.station = channel.callsign)   AND   ((record.type = 3)    OR   ((TIME_TO_SEC(record.starttime) = TIME_TO_SEC(program.starttime))     AND     ((record.type = 2)      OR     ((DAYOFWEEK(record.startdate) = DAYOFWEEK(program.starttime)       AND       ((record.type = 5)        OR       ((TO_DAYS(record.startdate) = TO_DAYS(program.starttime))         )       )      )     )    )   )  ) ))