SugarCRM default query

no limit query

SELECT accounts.* ,
       accounts_cstm.tax_jurisdiction_code_c,
       accounts_cstm.sap_business_partner_c,
       accounts_cstm.price_group_c,
       accounts_cstm.payment_terms_c,
       accounts_cstm.customer_group_c,
       accounts_cstm.tax_exempt_c,
       accounts_cstm.price_list_c ,
       LTRIM(RTRIM(CONCAT(IFNULL(jt0.first_name,''),' ',IFNULL(jt0.last_name,'')))) modified_by_name ,
       jt0.created_by modified_by_name_owner ,
       'Users' modified_by_name_mod ,
               LTRIM(RTRIM(CONCAT(IFNULL(jt1.first_name,''),' ',IFNULL(jt1.last_name,'')))) created_by_name ,
               jt1.created_by created_by_name_owner ,
               'Users' created_by_name_mod ,
                       LTRIM(RTRIM(CONCAT(IFNULL(jt2.first_name,''),' ',IFNULL(jt2.last_name,'')))) assigned_user_name ,
                       jt2.created_by assigned_user_name_owner ,
                       'Users' assigned_user_name_mod ,
                               jt3.name parent_name ,
                               jt3.assigned_user_id parent_name_owner ,
                               'Accounts' parent_name_mod ,
                                          jt4.name campaign_name ,
                                          jt4.assigned_user_id campaign_name_owner ,
                                          'Campaigns' campaign_name_mod ,
                                                      email_addresses.email_address email1
FROM accounts
LEFT JOIN accounts_cstm ON accounts.id = accounts_cstm.id_c
LEFT JOIN users jt0 ON accounts.modified_user_id=jt0.id
AND jt0.deleted=0
AND jt0.deleted=0
LEFT JOIN users jt1 ON accounts.created_by=jt1.id
AND jt1.deleted=0
AND jt1.deleted=0
LEFT JOIN users jt2 ON accounts.assigned_user_id=jt2.id
AND jt2.deleted=0
AND jt2.deleted=0
LEFT JOIN accounts jt3 ON accounts.parent_id=jt3.id
AND jt3.deleted=0
AND jt3.deleted=0
LEFT JOIN campaigns jt4 ON accounts.campaign_id=jt4.id
AND jt4.deleted=0
AND jt4.deleted=0
LEFT JOIN email_addr_bean_rel ON accounts.id = email_addr_bean_rel.bean_id
AND email_addr_bean_rel.bean_module='Accounts'
AND email_addr_bean_rel.deleted=0
AND email_addr_bean_rel.primary_address=1
LEFT JOIN email_addresses ON email_addresses.id = email_addr_bean_rel.email_address_id
WHERE accounts.deleted=0;