get("linked_with")."',main_faq.description AS '" . $translation->get("description") . "', from_unixtime(modified_date, '%d.%m.%Y %H:%i:%s') as '" . $translation->get("changed_on") . "', main_admin_user.name as '" . $translation->get("changed_by") . "' from main_faq LEFT JOIN main_admin_user ON main_admin_user.id = main_faq.modified_user LEFT JOIN main_faq_group_link ON main_faq_group_link.main_faq_id = main_faq.id LEFT JOIN main_faq_setup_group ON main_faq_setup_group.id = main_faq_group_link.main_faq_setup_group_id GROUP BY main_faq_group_link.main_faq_id ORDER BY main_faq.sorting asc"; $format = array('option', 'text', 'text', 'text', 'text'); if ($result = @mysqli_query($GLOBALS['mysql_con'], $query)) { linklist($result, $formname, $format, "input_id", "edit_faq_list", TRUE, 'update_sortorder_faq'); } ?>