%Full%

$ignore_cc = true;

$ignore_sub = true;

if(!$inside_admin && $action!='full') $query_join = "LEFT JOIN `Subdivision` AS sub ON sub.`Subdivision_ID` = $sub LEFT JOIN `Sub_Class` AS cc ON cc.`Sub_Class_ID` = a.`Sub_Class_ID`";

if (!$ignore_all) {

         $message_select = "SELECT".(!$ignore_calc ? " SQL_CALC_FOUND_ROWS" : "")." ".$cond_distinct." ".$field_names.$cond_select." 

                       FROM (".($user_table_mode ? "`User`" : "`Message".$classID."`")." AS a ".( $query_from ? ", ".$query_from : "").")

                       ".($ignore_sub && $ignore_cc && $query_join ? NULL:$component->get_joins())." ".$query_join." 

                       WHERE 1 ".$cond_parent.$cond_where.$cond_catalogue.$cond_sub.$cond_cc.$cond_user.$cond_mod.$cond_search.$cond_date.

                $cond_group.

                $cond_having.

                ($sort_by ? " ORDER BY ".$sort_by : "").

                (!$ignore_limit ? " LIMIT ".( isset($cc_env['cur_cc']) && $cc_env['cur_cc'] == $cur_cc ? $curPos : (!isset($cc_env['cur_cc']) ? $curPos : "0") ).",".$maxRows : ($query_limit ? " LIMIT ".$query_limit : "") );

    } elseif ($query_select && $query_from) {

        $message_select = "SELECT".(!$ignore_calc ? " SQL_CALC_FOUND_ROWS" : "")." ".$query_select." FROM ".$query_from.

                ($query_join ? " ".$query_join : "").

                ($query_where ? " WHERE ".$query_where : "").

                ($query_group ? " GROUP BY ".$query_group : "").

                ($query_having ? " HAVING  ".$query_having : "").

                ($query_order ? " ORDER BY ".$query_order : "").

                ($query_limit ? " LIMIT ".$query_limit : "");

    }