MySQLisms File Line Problem or idiom to look at C4/Barcodes/annual.pm 41 substring_index() C4/Creators/Lib.pm 359 CONCAT_WS() C4/Reports/Guided.pm 178 "SHOW TABLES" C4/Reports/Guided.pm 214 "show columns from $tablename" C4/Reports/Guided.pm 569ff DATE() C4/Accounts.pm 606 TIMESTAMP() C4/Auth.pm 141 FROM_UNIXTIME() C4/AuthoritiesMarc.pm 1256 "UPDATE IGNORE auth_header set ..." C4/Biblio.pm 2760 "LOCK TABLES nozebra WRITE, ..." C4/Biblio.pm 2786 "UNLOCK TABLES" C4/Biblio.pm 3831 "... OR datecancellationprinted='0000-00-00')" C4/Bookseller.pm 110 "DATE_SUB(CURDATE() ..." C4/Calendar.pm 95 "ISNULL(weekday) ..." C4/Calendar.pm 504 "WEEKDAY(CONCAT(...))" C4/Circulation.pm 2161ff TO_DAYS() C4/Circulation.pm 3007 "TRUNCATE TABLE ..." C4/Context.pm 530 ON DUPLICATE KEY UPDATE C4/ImportExportFramework.pm 269 SHOW COLUMNS FROM C4/ImportExportFramework.pm 308 SHOW COLUMNS FROM C4/ImportExportFramework.pm 364 SHOW COLUMNS FROM C4/ImportExportFramework.pm 430 SHOW COLUMNS FROM C4/ImportExportFramework.pm 953 SHOW COLUMNS FROM C4/ImportExportFramework.pm 1007 SHOW COLUMNS FROM C4/ImportExportFramework.pm 1047 ON DUPLICATE KEY UPDATE C4/Installer.pm 428 "INSERT IGNORE INTO `systempreferences` ..." C4/Items.pm 2064ff "INSERT INTO item SET ..." C4/Items.pm 2285 "INSERT INTO deleteditems SET " C4/Letters.pm 543 SHOW COLUMNS FROM C4/Log.pm 215ff DATE_FORMAT() C4/Members.pm 688 SHOW COLUMNS FROM C4/Members.pm 862 substring(str, from, to) C4/Members.pm 1806 INSERT INTO ... ON DUPLICATE KEY UPDATE ..." C4/NewsChannels.pm 144ff CURRENT_DATE() C4/Overdues.pm 127 CURDATE() C4/Overdues.pm 135 CURDATE() C4/Overdues.pm 140ff TO_DAYS() C4/Overdues.pm 1221 CURDATE() C4/Reserves.pm 269 CURRENT_DATE() C4/Reserves.pm 335 CURRENT_DATE() C4/Reserves.pm 865 DATE(), DATE(CURDATE()) C4/Reserves.pm 1601 CURRENT_DATE() C4/Reserves.pm 1631 CURRENT_DATE() C4/Reserves.pm 1662 CURRENT_DATE() C4/Search.pm 1462 SHOW COLUMNS FROM items C4/Search.pm 1899 "WHERE ... LIKE CONCAT(.., '%')" C4/Serials.pm 382 IF(serial.publisheddate=00-00-0000", ...) C4/Serials.pm 524 year(IF(... C4/Serials.pm 544 IF(...) C4/Serials.pm 657 ORDER BY IF(a, b, c) C4/Serials.pm 678 ORDER BY IF() C4/SQLHelper.pm 252 SHOW COLUMNS FROM $tablename C4/Suggestions.pm 157 format_date_in_iso C4/Suggestions.pm 456 ADDDATE(NOW(), ...) C4/Tags.pm 144ff DELETE ... LIMIT 1