Error | Instrument Bibliometric National

Error

Error message

PDOException: SQLSTATE[42000]: Syntax error or access violation: 1066 Not unique table/alias: 'db': SELECT DISTINCT ij.id , `ij`.`title` , `ij`.`issnp`, `ij`.`issne` , `ij`.`image_fid` FROM ibn_journals ij LEFT JOIN ibn_journals_international_db db ON db.journal_id = ij.id LEFT JOIN ibn_journals_international_db db ON db.journal_id = ij.id INNER JOIN ibn_journals_categories ijc ON ijc.journal_id = ij.id INNER JOIN ibn_categories ic ON ijc.category_id = ic.id LEFT JOIN ibn_journal_numbers jn ON jn.journal_id = ij.id WHERE ic.id IN (1,2,3,5) AND ij.id IN (:nids_0, :nids_1, :nids_2, :nids_3, :nids_4, :nids_5, :nids_6, :nids_7, :nids_8, :nids_9, :nids_10, :nids_11, :nids_12, :nids_13, :nids_14, :nids_15, :nids_16, :nids_17, :nids_18, :nids_19, :nids_20, :nids_21, :nids_22, :nids_23, :nids_24, :nids_25, :nids_26, :nids_27, :nids_28, :nids_29, :nids_30, :nids_31, :nids_32, :nids_33, :nids_34, :nids_35, :nids_36, :nids_37, :nids_38, :nids_39, :nids_40, :nids_41, :nids_42, :nids_43, :nids_44, :nids_45, :nids_46, :nids_47, :nids_48, :nids_49, :nids_50, :nids_51, :nids_52, :nids_53, :nids_54, :nids_55, :nids_56, :nids_57, :nids_58, :nids_59, :nids_60, :nids_61, :nids_62, :nids_63, :nids_64, :nids_65, :nids_66, :nids_67, :nids_68, :nids_69, :nids_70, :nids_71, :nids_72, :nids_73, :nids_74, :nids_75, :nids_76, :nids_77, :nids_78, :nids_79, :nids_80, :nids_81, :nids_82, :nids_83, :nids_84, :nids_85, :nids_86) AND ij.title LIKE 'I%' AND db.international_db_id = 42 AND db.international_db_id = 45 ORDER BY title ASC; Array ( [:nids_0] => 58 [:nids_1] => 480 [:nids_2] => 299 [:nids_3] => 545 [:nids_4] => 550 [:nids_5] => 440 [:nids_6] => 424 [:nids_7] => 669 [:nids_8] => 782 [:nids_9] => 810 [:nids_10] => 817 [:nids_11] => 821 [:nids_12] => 866 [:nids_13] => 937 [:nids_14] => 1106 [:nids_15] => 1127 [:nids_16] => 293 [:nids_17] => 265 [:nids_18] => 234 [:nids_19] => 1257 [:nids_20] => 469 [:nids_21] => 879 [:nids_22] => 1271 [:nids_23] => 1283 [:nids_24] => 167 [:nids_25] => 1350 [:nids_26] => 1379 [:nids_27] => 1380 [:nids_28] => 1392 [:nids_29] => 1406 [:nids_30] => 1413 [:nids_31] => 755 [:nids_32] => 1219 [:nids_33] => 71 [:nids_34] => 159 [:nids_35] => 1441 [:nids_36] => 150 [:nids_37] => 251 [:nids_38] => 226 [:nids_39] => 244 [:nids_40] => 191 [:nids_41] => 238 [:nids_42] => 385 [:nids_43] => 1496 [:nids_44] => 1497 [:nids_45] => 971 [:nids_46] => 953 [:nids_47] => 1528 [:nids_48] => 1535 [:nids_49] => 1547 [:nids_50] => 1237 [:nids_51] => 1580 [:nids_52] => 1581 [:nids_53] => 1582 [:nids_54] => 1583 [:nids_55] => 1628 [:nids_56] => 147 [:nids_57] => 185 [:nids_58] => 1632 [:nids_59] => 998 [:nids_60] => 1644 [:nids_61] => 1188 [:nids_62] => 174 [:nids_63] => 787 [:nids_64] => 155 [:nids_65] => 289 [:nids_66] => 18 [:nids_67] => 452 [:nids_68] => 220 [:nids_69] => 1705 [:nids_70] => 181 [:nids_71] => 230 [:nids_72] => 639 [:nids_73] => 235 [:nids_74] => 1715 [:nids_75] => 170 [:nids_76] => 240 [:nids_77] => 249 [:nids_78] => 290 [:nids_79] => 1717 [:nids_80] => 1589 [:nids_81] => 353 [:nids_82] => 1371 [:nids_83] => 60 [:nids_84] => 1795 [:nids_85] => 1833 [:nids_86] => 1857 ) in journals_view_table_data() (line 616 of /var/www/sites/idsi/ibn2014/trunk/sites/all/modules/journals_view/journals_view.module).
The website encountered an unexpected error. Please try again later.