Dmitry Ban (Все сообщения пользователя)

$res = CIBlockElement::GetList(
    false,
    array(
        'IBLOCK_ID' => ...,
        'ACTIVE' => 'Y',
    ),
    array('PROPERTY_FIRST_LETTER')
);

select * from b_ticket T
right join (
    select distinct TICKET_ID 
    from b_ticket_message
    where CURRENT_RESPONSIBLE_USER_ID = 12345
) M on T.ID = M.TICKET_ID
order by T.DATE_CREATE desc

<form id="regForm">
   <input type="checkbox" id="accept" /> Я принимаю условия
   <input type="submit" value="Ok" />
</form>

$(document).ready(function() {
   if (!$('#accept').is(':checked'))
      $('#regForm input:submit').attr('disabled', 'disabled');
   $('#accept').change(function() {
      if ($(this).is(':checked'))
         $('#regForm input:submit').removeAttr('disabled');      
      else
         $('#regForm input:submit').attr('disabled', 'disabled');      
   });
});