Bug #23649 Bug Fixed

Searching content in the control panel.

Version: 4.1.3 Reporter: Brillon

Exception Caught

SQLSTATE[HY000]: General error: 1116 Too many tables; MySQL can only use 61 tables in a join:
SELECT COUNT(*) AS `numrows` FROM (`exp_channel_titles` as ChannelEntry_channel_titles, `exp_channel_data` as ChannelEntry_channel_data) LEFT JOIN `exp_channel_data_field_1` AS ChannelEntry_field_id_1 ON `ChannelEntry_field_id_1`.`entry_id` = `ChannelEntry_channel_data`.`entry_id` LEFT JOIN `exp_channel_data_field_2` AS ChannelEntry_field_id_2 ON `ChannelEntry_field_id_2`.`entry_id` = `ChannelEntry_channel_data`.`entry_id` LEFT JOIN `exp_channel_data_field_3` AS ChannelEntry_field_id_3 ON `ChannelEntry_field_id_3`.`entry_id` = `ChannelEntry_channel_data`.`entry_id` LEFT JOIN `exp_channel_data_field_4` AS ChannelEntry_field_id_4 ON `ChannelEntry_field_id_4`.`entry_id` = `ChannelEntry_channel_data`.`entry_id` LEFT JOIN `exp_channel_data_field_5` AS ChannelEntry_field_id_5 ON `ChannelEntry_field_id_5`.`entry_id` = `ChannelEntry_channel_data`.`entry_id` LEFT JOIN `exp_channel_data_field_6` AS ChannelEntry_field_id_6 ON `ChannelEntry_field_id_6`.`entry_id` = `ChannelEntry_channel_data`.`entry_id` LEFT JOIN `exp_channel_data_field_7` AS ChannelEntry_field_id_7 ON `ChannelEntry_field_id_7`.`entry_id` = `ChannelEntry_channel_data`.`entry_id` LEFT JOIN `exp_channel_data_field_8` AS ChannelEntry_field_id_8 ON `ChannelEntry_field_id_8`.`entry_id` = `ChannelEntry_channel_data`.`entry_id` LEFT JOIN `exp_channel_data_field_9` AS ChannelEntry_field_id_9 ON `ChannelEntry_field_id_9`.`entry_id` = `ChannelEntry_channel_data`.`entry_id` LEFT JOIN `exp_channel_data_field_10` AS ChannelEntry_field_id_10 ON `ChannelEntry_field_id_10`.`entry_id` = `ChannelEntry_channel_data`.`entry_id` LEFT JOIN `exp_channel_data_field_11` AS ChannelEntry_field_id_11 ON `ChannelEntry_field_id_11`.`entry_id` = `ChannelEntry_channel_data`.`entry_id` LEFT JOIN `exp_channel_data_field_12` AS ChannelEntry_field_id_12 ON `ChannelEntry_field_id_12`.`entry_id` = `ChannelEntry_channel_data`.`entry_id` LEFT JOIN `exp_channel_data_field_13` AS ChannelEntry_field_id_13 ON `ChannelEntry_field_id_13`.`entry_id` = `ChannelEntry_channel_data`.`entry_id` LEFT JOIN `exp_channel_data_field_14` AS ChannelEntry_field_id_14 ON `ChannelEntry_field_id_14`.`entry_id` = `ChannelEntry_channel_data`.`entry_id` LEFT JOIN `exp_channel_data_field_15` AS ChannelEntry_field_id_15 ON `ChannelEntry_field_id_15`.`entry_id` = `ChannelEntry_channel_data`.`entry_id` LEFT JOIN `exp_channel_data_field_16` AS ChannelEntry_field_id_16 ON `ChannelEntry_field_id_16`.`entry_id` = `ChannelEntry_channel_data`.`entry_id` LEFT JOIN `exp_channel_data_field_17` AS ChannelEntry_field_id_17 ON `ChannelEntry_field_id_17`.`entry_id` = `ChannelEntry_channel_data`.`entry_id` LEFT JOIN `exp_channel_data_field_18` AS ChannelEntry_field_id_18 ON `ChannelEntry_field_id_18`.`entry_id` = `ChannelEntry_channel_data`.`entry_id` LEFT JOIN `exp_channel_data_field_19` AS ChannelEntry_field_id_19 ON `ChannelEntry_field_id_19`.`entry_id` = `ChannelEntry_channel_data`.`entry_id` LEFT JOIN `exp_channel_data_field_20` AS ChannelEntry_field_id_20 ON `ChannelEntry_field_id_20`.`entry_id` = `ChannelEntry_channel_data`.`entry_id` LEFT JOIN `exp_channel_data_field_21` AS ChannelEntry_field_id_21 ON `ChannelEntry_field_id_21`.`entry_id` = `ChannelEntry_channel_data`.`entry_id` LEFT JOIN `exp_channel_data_field_22` AS ChannelEntry_field_id_22 ON `ChannelEntry_field_id_22`.`entry_id` = `ChannelEntry_channel_data`.`entry_id` LEFT JOIN `exp_channel_data_field_23` AS ChannelEntry_field_id_23 ON `ChannelEntry_field_id_23`.`entry_id` = `ChannelEntry_channel_data`.`entry_id` LEFT JOIN `exp_channel_data_field_24` AS ChannelEntry_field_id_24 ON `ChannelEntry_field_id_24`.`entry_id` = `ChannelEntry_channel_data`.`entry_id` LEFT JOIN `exp_channel_data_field_25` AS ChannelEntry_field_id_25 ON `ChannelEntry_field_id_25`.`entry_id` = `ChannelEntry_channel_data`.`entry_id` LEFT JOIN `exp_channel_data_field_26` AS ChannelEntry_field_id_26 ON `ChannelEntry_field_id_26`.`entry_id` = `ChannelEntry_channel_data`.`entry_id` LEFT JOIN `exp_channel_data_field_27` AS ChannelEntry_field_id_27 ON `ChannelEntry_field_id_27`.`entry_id` = `ChannelEntry_channel_data`.`entry_id` LEFT JOIN `exp_channel_data_field_28` AS ChannelEntry_field_id_28 ON `ChannelEntry_field_id_28`.`entry_id` = `ChannelEntry_channel_data`.`entry_id` LEFT JOIN `exp_channel_data_field_29` AS ChannelEntry_field_id_29 ON `ChannelEntry_field_id_29`.`entry_id` = `ChannelEntry_channel_data`.`entry_id` LEFT JOIN `exp_channel_data_field_30` AS ChannelEntry_field_id_30 ON `ChannelEntry_field_id_30`.`entry_id` = `ChannelEntry_channel_data`.`entry_id` LEFT JOIN `exp_channel_data_field_31` AS ChannelEntry_field_id_31 ON `ChannelEntry_field_id_31`.`entry_id` = `ChannelEntry_channel_data`.`entry_id` LEFT JOIN `exp_channel_data_field_32` AS ChannelEntry_field_id_32 ON `ChannelEntry_field_id_32`.`entry_id` = `ChannelEntry_channel_data`.`entry_id` LEFT JOIN `exp_channel_data_field_33` AS ChannelEntry_field_id_33 ON `ChannelEntry_field_id_33`.`entry_id` = `ChannelEntry_channel_data`.`entry_id` LEFT JOIN `exp_channel_data_field_34` AS ChannelEntry_field_id_34 ON `ChannelEntry_field_id_34`.`entry_id` = `ChannelEntry_channel_data`.`entry_id` LEFT JOIN `exp_channel_data_field_35` AS ChannelEntry_field_id_35 ON `ChannelEntry_field_id_35`.`entry_id` = `ChannelEntry_channel_data`.`entry_id` LEFT JOIN `exp_channel_data_field_36` AS ChannelEntry_field_id_36 ON `ChannelEntry_field_id_36`.`entry_id` = `ChannelEntry_channel_data`.`entry_id` LEFT JOIN `exp_channel_data_field_37` AS ChannelEntry_field_id_37 ON `ChannelEntry_field_id_37`.`entry_id` = `ChannelEntry_channel_data`.`entry_id` LEFT JOIN `exp_channel_data_field_38` AS ChannelEntry_field_id_38 ON `ChannelEntry_field_id_38`.`entry_id` = `ChannelEntry_channel_data`.`entry_id` LEFT JOIN `exp_channel_data_field_39` AS ChannelEntry_field_id_39 ON `ChannelEntry_field_id_39`.`entry_id` = `ChannelEntry_channel_data`.`entry_id` LEFT JOIN `exp_channel_data_field_40` AS ChannelEntry_field_id_40 ON `ChannelEntry_field_id_40`.`entry_id` = `ChannelEntry_channel_data`.`entry_id` LEFT JOIN `exp_channel_data_field_41` AS ChannelEntry_field_id_41 ON `ChannelEntry_field_id_41`.`entry_id` = `ChannelEntry_channel_data`.`entry_id` LEFT JOIN `exp_channel_data_field_42` AS ChannelEntry_field_id_42 ON `ChannelEntry_field_id_42`.`entry_id` = `ChannelEntry_channel_data`.`entry_id` LEFT JOIN `exp_channel_data_field_43` AS ChannelEntry_field_id_43 ON `ChannelEntry_field_id_43`.`entry_id` = `ChannelEntry_channel_data`.`entry_id` LEFT JOIN `exp_channel_data_field_44` AS ChannelEntry_field_id_44 ON `ChannelEntry_field_id_44`.`entry_id` = `ChannelEntry_channel_data`.`entry_id` LEFT JOIN `exp_channel_data_field_45` AS ChannelEntry_field_id_45 ON `ChannelEntry_field_id_45`.`entry_id` = `ChannelEntry_channel_data`.`entry_id` LEFT JOIN `exp_channel_data_field_46` AS ChannelEntry_field_id_46 ON `ChannelEntry_field_id_46`.`entry_id` = `ChannelEntry_channel_data`.`entry_id` LEFT JOIN `exp_channel_data_field_47` AS ChannelEntry_field_id_47 ON `ChannelEntry_field_id_47`.`entry_id` = `ChannelEntry_channel_data`.`entry_id` LEFT JOIN `exp_channel_data_field_48` AS ChannelEntry_field_id_48 ON `ChannelEntry_field_id_48`.`entry_id` = `ChannelEntry_channel_data`.`entry_id` LEFT JOIN `exp_channel_data_field_49` AS ChannelEntry_field_id_49 ON `ChannelEntry_field_id_49`.`entry_id` = `ChannelEntry_channel_data`.`entry_id` LEFT JOIN `exp_channel_data_field_50` AS ChannelEntry_field_id_50 ON `ChannelEntry_field_id_50`.`entry_id` = `ChannelEntry_channel_data`.`entry_id` LEFT JOIN `exp_channel_data_field_51` AS ChannelEntry_field_id_51 ON `ChannelEntry_field_id_51`.`entry_id` = `ChannelEntry_channel_data`.`entry_id` LEFT JOIN `exp_channel_data_field_52` AS ChannelEntry_field_id_52 ON `ChannelEntry_field_id_52`.`entry_id` = `ChannelEntry_channel_data`.`entry_id` LEFT JOIN `exp_channel_data_field_53` AS ChannelEntry_field_id_53 ON `ChannelEntry_field_id_53`.`entry_id` = `ChannelEntry_channel_data`.`entry_id` LEFT JOIN `exp_channel_data_field_54` AS ChannelEntry_field_id_54 ON `ChannelEntry_field_id_54`.`entry_id` = `ChannelEntry_channel_data`.`entry_id` LEFT JOIN `exp_channel_data_field_55` AS ChannelEntry_field_id_55 ON `ChannelEntry_field_id_55`.`entry_id` = `ChannelEntry_channel_data`.`entry_id` LEFT JOIN `exp_channel_data_field_56` AS ChannelEntry_field_id_56 ON `ChannelEntry_field_id_56`.`entry_id` = `ChannelEntry_channel_data`.`entry_id` LEFT JOIN `exp_channels` AS Channel_channels ON `Channel_channels`.`channel_id` = `ChannelEntry_channel_titles`.`channel_id` LEFT JOIN `exp_members` AS Author_members ON `Author_members`.`member_id` = `ChannelEntry_channel_titles`.`author_id` LEFT JOIN `exp_member_data` as Author_member_data ON `Author_member_data`.`member_id` = `Author_members`.`member_id` LEFT JOIN `exp_channel_entries_autosave` AS Autosaves_channel_entries_autosave ON `Autosaves_channel_entries_autosave`.`original_entry_id` = `ChannelEntry_channel_titles`.`entry_id` WHERE ChannelEntry_channel_data.entry_id = ChannelEntry_channel_titles.entry_id AND ( `ChannelEntry_channel_data`.`site_id` = 1 ) AND ( ( `ChannelEntry_channel_titles`.`title` LIKE '%printing%' AND `ChannelEntry_channel_titles`.`title` LIKE '%advances%' AND `ChannelEntry_channel_titles`.`title` LIKE '%design%' ) OR ( `ChannelEntry_field_id_1`.`field_id_1` LIKE '%printing%' AND `ChannelEntry_field_id_1`.`field_id_1` LIKE '%advances%' AND `ChannelEntry_field_id_1`.`field_id_1` LIKE '%design%' ) OR ( `ChannelEntry_field_id_2`.`field_id_2` LIKE '%printing%' AND `ChannelEntry_field_id_2`.`field_id_2` LIKE '%advances%' AND `ChannelEntry_field_id_2`.`field_id_2` LIKE '%design%' ) OR ( `ChannelEntry_field_id_3`.`field_id_3` LIKE '%printing%' AND `ChannelEntry_field_id_3`.`field_id_3` LIKE '%advances%' AND `ChannelEntry_field_id_3`.`field_id_3` LIKE '%design%' ) OR ( `ChannelEntry_field_id_8`.`field_id_8` LIKE '%printing%' AND `ChannelEntry_field_id_8`.`field_id_8` LIKE '%advances%' AND `ChannelEntry_field_id_8`.`field_id_8` LIKE '%design%' ) OR ( `ChannelEntry_field_id_11`.`field_id_11` LIKE '%printing%' AND `ChannelEntry_field_id_11`.`field_id_11` LIKE '%advances%' AND `ChannelEntry_field_id_11`.`field_id_11` LIKE '%design%' ) OR ( `ChannelEntry_field_id_15`.`field_id_15` LIKE '%printing%' AND `ChannelEntry_field_id_15`.`field_id_15` LIKE '%advances%' AND `ChannelEntry_field_id_15`.`field_id_15` LIKE '%design%' ) OR ( `ChannelEntry_field_id_19`.`field_id_19` LIKE '%printing%' AND `ChannelEntry_field_id_19`.`field_id_19` LIKE '%advances%' AND `ChannelEntry_field_id_19`.`field_id_19` LIKE '%design%' ) OR ( `ChannelEntry_field_id_38`.`field_id_38` LIKE '%printing%' AND `ChannelEntry_field_id_38`.`field_id_38` LIKE '%advances%' AND `ChannelEntry_field_id_38`.`field_id_38` LIKE '%design%' ) OR ( `ChannelEntry_field_id_51`.`field_id_51` LIKE '%printing%' AND `ChannelEntry_field_id_51`.`field_id_51` LIKE '%advances%' AND `ChannelEntry_field_id_51`.`field_id_51` LIKE '%design%' ) OR ( `ChannelEntry_field_id_55`.`field_id_55` LIKE '%printing%' AND `ChannelEntry_field_id_55`.`field_id_55` LIKE '%advances%' AND `ChannelEntry_field_id_55`.`field_id_55` LIKE '%design%' ) OR ( `ChannelEntry_field_id_4`.`field_id_4` LIKE '%printing%' AND `ChannelEntry_field_id_4`.`field_id_4` LIKE '%advances%' AND `ChannelEntry_field_id_4`.`field_id_4` LIKE '%design%' ) OR ( `ChannelEntry_field_id_6`.`field_id_6` LIKE '%printing%' AND `ChannelEntry_field_id_6`.`field_id_6` LIKE '%advances%' AND `ChannelEntry_field_id_6`.`field_id_6` LIKE '%design%' ) OR ( `ChannelEntry_field_id_17`.`field_id_17` LIKE '%printing%' AND `ChannelEntry_field_id_17`.`field_id_17` LIKE '%advances%' AND `ChannelEntry_field_id_17`.`field_id_17` LIKE '%design%' ) OR ( `ChannelEntry_field_id_20`.`field_id_20` LIKE '%printing%' AND `ChannelEntry_field_id_20`.`field_id_20` LIKE '%advances%' AND `ChannelEntry_field_id_20`.`field_id_20` LIKE '%design%' ) OR ( `ChannelEntry_field_id_21`.`field_id_21` LIKE '%printing%' AND `ChannelEntry_field_id_21`.`field_id_21` LIKE '%advances%' AND `ChannelEntry_field_id_21`.`field_id_21` LIKE '%design%' ) OR ( `ChannelEntry_field_id_22`.`field_id_22` LIKE '%printing%' AND `ChannelEntry_field_id_22`.`field_id_22` LIKE '%advances%' AND `ChannelEntry_field_id_22`.`field_id_22` LIKE '%design%' ) OR ( `ChannelEntry_field_id_23`.`field_id_23` LIKE '%printing%' AND `ChannelEntry_field_id_23`.`field_id_23` LIKE '%advances%' AND `ChannelEntry_field_id_23`.`field_id_23` LIKE '%design%' ) OR ( `ChannelEntry_field_id_24`.`field_id_24` LIKE '%printing%' AND `ChannelEntry_field_id_24`.`field_id_24` LIKE '%advances%' AND `ChannelEntry_field_id_24`.`field_id_24` LIKE '%design%' ) OR ( `ChannelEntry_field_id_25`.`field_id_25` LIKE '%printing%' AND `ChannelEntry_field_id_25`.`field_id_25` LIKE '%advances%' AND `ChannelEntry_field_id_25`.`field_id_25` LIKE '%design%' ) OR ( `ChannelEntry_field_id_26`.`field_id_26` LIKE '%printing%' AND `ChannelEntry_field_id_26`.`field_id_26` LIKE '%advances%' AND `ChannelEntry_field_id_26`.`field_id_26` LIKE '%design%' ) OR ( `ChannelEntry_field_id_27`.`field_id_27` LIKE '%printing%' AND `ChannelEntry_field_id_27`.`field_id_27` LIKE '%advances%' AND `ChannelEntry_field_id_27`.`field_id_27` LIKE '%design%' ) OR ( `ChannelEntry_field_id_28`.`field_id_28` LIKE '%printing%' AND `ChannelEntry_field_id_28`.`field_id_28` LIKE '%advances%' AND `ChannelEntry_field_id_28`.`field_id_28` LIKE '%design%' ) OR ( `ChannelEntry_field_id_29`.`field_id_29` LIKE '%printing%' AND `ChannelEntry_field_id_29`.`field_id_29` LIKE '%advances%' AND `ChannelEntry_field_id_29`.`field_id_29` LIKE '%design%' ) OR ( `ChannelEntry_field_id_30`.`field_id_30` LIKE '%printing%' AND `ChannelEntry_field_id_30`.`field_id_30` LIKE '%advances%' AND `ChannelEntry_field_id_30`.`field_id_30` LIKE '%design%' ) OR ( `ChannelEntry_field_id_31`.`field_id_31` LIKE '%printing%' AND `ChannelEntry_field_id_31`.`field_id_31` LIKE '%advances%' AND `ChannelEntry_field_id_31`.`field_id_31` LIKE '%design%' ) OR ( `ChannelEntry_field_id_39`.`field_id_39` LIKE '%printing%' AND `ChannelEntry_field_id_39`.`field_id_39` LIKE '%advances%' AND `ChannelEntry_field_id_39`.`field_id_39` LIKE '%design%' ) OR ( `ChannelEntry_field_id_56`.`field_id_56` LIKE '%printing%' AND `ChannelEntry_field_id_56`.`field_id_56` LIKE '%advances%' AND `ChannelEntry_field_id_56`.`field_id_56` LIKE '%design%' ) OR ( `ChannelEntry_field_id_32`.`field_id_32` LIKE '%printing%' AND `ChannelEntry_field_id_32`.`field_id_32` LIKE '%advances%' AND `ChannelEntry_field_id_32`.`field_id_32` LIKE '%design%' ) OR ( `ChannelEntry_field_id_33`.`field_id_33` LIKE '%printing%' AND `ChannelEntry_field_id_33`.`field_id_33` LIKE '%advances%' AND `ChannelEntry_field_id_33`.`field_id_33` LIKE '%design%' ) OR ( `ChannelEntry_field_id_34`.`field_id_34` LIKE '%printing%' AND `ChannelEntry_field_id_34`.`field_id_34` LIKE '%advances%' AND `ChannelEntry_field_id_34`.`field_id_34` LIKE '%design%' ) OR ( `ChannelEntry_field_id_35`.`field_id_35` LIKE '%printing%' AND `ChannelEntry_field_id_35`.`field_id_35` LIKE '%advances%' AND `ChannelEntry_field_id_35`.`field_id_35` LIKE '%design%' ) OR ( `ChannelEntry_field_id_36`.`field_id_36` LIKE '%printing%' AND `ChannelEntry_field_id_36`.`field_id_36` LIKE '%advances%' AND `ChannelEntry_field_id_36`.`field_id_36` LIKE '%design%' ) OR ( `ChannelEntry_field_id_37`.`field_id_37` LIKE '%printing%' AND `ChannelEntry_field_id_37`.`field_id_37` LIKE '%advances%' AND `ChannelEntry_field_id_37`.`field_id_37` LIKE '%design%' ) OR ( `ChannelEntry_field_id_5`.`field_id_5` LIKE '%printing%' AND `ChannelEntry_field_id_5`.`field_id_5` LIKE '%advances%' AND `ChannelEntry_field_id_5`.`field_id_5` LIKE '%design%' ) OR ( `ChannelEntry_field_id_7`.`field_id_7` LIKE '%printing%' AND `ChannelEntry_field_id_7`.`field_id_7` LIKE '%advances%' AND `ChannelEntry_field_id_7`.`field_id_7` LIKE '%design%' ) OR ( `ChannelEntry_field_id_9`.`field_id_9` LIKE '%printing%' AND `ChannelEntry_field_id_9`.`field_id_9` LIKE '%advances%' AND `ChannelEntry_field_id_9`.`field_id_9` LIKE '%design%' ) OR ( `ChannelEntry_field_id_10`.`field_id_10` LIKE '%printing%' AND `ChannelEntry_field_id_10`.`field_id_10` LIKE '%advances%' AND `ChannelEntry_field_id_10`.`field_id_10` LIKE '%design%' ) OR ( `ChannelEntry_field_id_12`.`field_id_12` LIKE '%printing%' AND `ChannelEntry_field_id_12`.`field_id_12` LIKE '%advances%' AND `ChannelEntry_field_id_12`.`field_id_12` LIKE '%design%' ) OR ( `ChannelEntry_field_id_13`.`field_id_13` LIKE '%printing%' AND `ChannelEntry_field_id_13`.`field_id_13` LIKE '%advances%' AND `ChannelEntry_field_id_13`.`field_id_13` LIKE '%design%' ) OR ( `ChannelEntry_field_id_14`.`field_id_14` LIKE '%printing%' AND `ChannelEntry_field_id_14`.`field_id_14` LIKE '%advances%' AND `ChannelEntry_field_id_14`.`field_id_14` LIKE '%design%' ) OR ( `ChannelEntry_field_id_45`.`field_id_45` LIKE '%printing%' AND `ChannelEntry_field_id_45`.`field_id_45` LIKE '%advances%' AND `ChannelEntry_field_id_45`.`field_id_45` LIKE '%design%' ) OR ( `ChannelEntry_field_id_52`.`field_id_52` LIKE '%printing%' AND `ChannelEntry_field_id_52`.`field_id_52` LIKE '%advances%' AND `ChannelEntry_field_id_52`.`field_id_52` LIKE '%design%' ) OR ( `ChannelEntry_field_id_53`.`field_id_53` LIKE '%printing%' AND `ChannelEntry_field_id_53`.`field_id_53` LIKE '%advances%' AND `ChannelEntry_field_id_53`.`field_id_53` LIKE '%design%' ) OR ( `ChannelEntry_field_id_16`.`field_id_16` LIKE '%printing%' AND `ChannelEntry_field_id_16`.`field_id_16` LIKE '%advances%' AND `ChannelEntry_field_id_16`.`field_id_16` LIKE '%design%' ) OR ( `ChannelEntry_field_id_54`.`field_id_54` LIKE '%printing%' AND `ChannelEntry_field_id_54`.`field_id_54` LIKE '%advances%' AND `ChannelEntry_field_id_54`.`field_id_54` LIKE '%design%' ) OR ( `ChannelEntry_field_id_18`.`field_id_18` LIKE '%printing%' AND `ChannelEntry_field_id_18`.`field_id_18` LIKE '%advances%' AND `ChannelEntry_field_id_18`.`field_id_18` LIKE '%design%' ) OR ( `ChannelEntry_field_id_47`.`field_id_47` LIKE '%printing%' AND `ChannelEntry_field_id_47`.`field_id_47` LIKE '%advances%' AND `ChannelEntry_field_id_47`.`field_id_47` LIKE '%design%' ) OR ( `ChannelEntry_field_id_48`.`field_id_48` LIKE '%printing%' AND `ChannelEntry_field_id_48`.`field_id_48` LIKE '%advances%' AND `ChannelEntry_field_id_48`.`field_id_48` LIKE '%design%' ) OR ( `ChannelEntry_field_id_49`.`field_id_49` LIKE '%printing%' AND `ChannelEntry_field_id_49`.`field_id_49` LIKE '%advances%' AND `ChannelEntry_field_id_49`.`field_id_49` LIKE '%design%' ) OR ( `ChannelEntry_field_id_50`.`field_id_50` LIKE '%printing%' AND `ChannelEntry_field_id_50`.`field_id_50` LIKE '%advances%' AND `ChannelEntry_field_id_50`.`field_id_50` LIKE '%design%' ) OR ( `ChannelEntry_field_id_40`.`field_id_40` LIKE '%printing%' AND `ChannelEntry_field_id_40`.`field_id_40` LIKE '%advances%' AND `ChannelEntry_field_id_40`.`field_id_40` LIKE '%design%' ) OR ( `ChannelEntry_field_id_41`.`field_id_41` LIKE '%printing%' AND `ChannelEntry_field_id_41`.`field_id_41` LIKE '%advances%' AND `ChannelEntry_field_id_41`.`field_id_41` LIKE '%design%' ) OR ( `ChannelEntry_field_id_42`.`field_id_42` LIKE '%printing%' AND `ChannelEntry_field_id_42`.`field_id_42` LIKE '%advances%' AND `ChannelEntry_field_id_42`.`field_id_42` LIKE '%design%' ) OR ( `ChannelEntry_field_id_43`.`field_id_43` LIKE '%printing%' AND `ChannelEntry_field_id_43`.`field_id_43` LIKE '%advances%' AND `ChannelEntry_field_id_43`.`field_id_43` LIKE '%design%' ) OR ( `ChannelEntry_field_id_44`.`field_id_44` LIKE '%printing%' AND `ChannelEntry_field_id_44`.`field_id_44` LIKE '%advances%' AND `ChannelEntry_field_id_44`.`field_id_44` LIKE '%design%' ) OR ( `ChannelEntry_field_id_46`.`field_id_46` LIKE '%printing%' AND `ChannelEntry_field_id_46`.`field_id_46` LIKE '%advances%' AND `ChannelEntry_field_id_46`.`field_id_46` LIKE '%design%' ) ) LIMIT 18446744073709551615

ee/legacy/database/drivers/mysqli/mysqli_connection.php:116

Stack Trace: Please include when reporting this error

#0 ee/legacy/database/drivers/mysqli/mysqli_driver.php(111): CI_DB_mysqli_connection->query('SELECT COUNT(*)...')
#1 ee/legacy/database/DB_driver.php(269): CI_DB_mysqli_driver->_execute('SELECT COUNT(*)...')
#2 ee/legacy/database/DB_driver.php(179): CI_DB_driver->simple_query('SELECT COUNT(*)...')
#3 ee/legacy/database/DB_active_rec.php(1162): CI_DB_driver->query('SELECT COUNT(*)...')
#4 ee/EllisLab/ExpressionEngine/Service/Model/Query/Count.php(23): CI_DB_active_record->count_all_results()
#5 ee/EllisLab/ExpressionEngine/Service/Model/DataStore.php(281): EllisLab\ExpressionEngine\Service\Model\Query\Count->run()
#6 ee/EllisLab/ExpressionEngine/Service/Model/DataStore.php(267): EllisLab\ExpressionEngine\Service\Model\DataStore->runQuery('Count', Object(EllisLab\ExpressionEngine\Service\Model\Query\Builder))
#7 ee/EllisLab/ExpressionEngine/Service/Model/Query/Builder.php(99): EllisLab\ExpressionEngine\Service\Model\DataStore->countQuery(Object(EllisLab\ExpressionEngine\Service\Model\Query\Builder))
#8 ee/EllisLab/ExpressionEngine/Service/EntryListing/EntryListing.php(130): EllisLab\ExpressionEngine\Service\Model\Query\Builder->count()
#9 ee/EllisLab/ExpressionEngine/Service/EntryListing/EntryListing.php(116): EllisLab\ExpressionEngine\Service\EntryListing\EntryListing->getEntryCount()
#10 ee/EllisLab/ExpressionEngine/Controller/Publish/Edit.php(53): EllisLab\ExpressionEngine\Service\EntryListing\EntryListing->getFilters()
#11 [internal function]: EllisLab\ExpressionEngine\Controller\Publish\Edit->index()
#12 ee/EllisLab/ExpressionEngine/Core/Core.php(240): call_user_func_array(Array, Array)
#13 ee/EllisLab/ExpressionEngine/Core/Core.php(109): EllisLab\ExpressionEngine\Core\Core->runController(Array)
#14 ee/EllisLab/ExpressionEngine/Boot/boot.php(146): EllisLab\ExpressionEngine\Core\Core->run(Object(EllisLab\ExpressionEngine\Core\Request))
#15 public_html/phoenix.php(147): require_once('...')
#15 public_html/phoenix.php(147): require_once('...')
.(JavaScript must be enabled to view this email address)

ExpressionEngine News!

#eecms, #events, #releases