SELECT SQL_CALC_FOUND_ROWS 
    organization.*, 
    parent_organization.name as parent_organization_name 
FROM organization  
    LEFT JOIN organization AS parent_organization 
        ON (parent_organization.organization_id=organization.parent_organization_id)
WHERE ( organization.organization_id='2' )    
ORDER BY organization.name asc
LIMIT 1 
OFFSET 0

SELECT SQL_CALC_FOUND_ROWS 
    vehicle.*, 
    manuf_organization.name AS organization_name, 
    owner_organization.name AS owner_organization_name, 
    operator_organization.name AS operator_organization_name 
FROM vehicle 
    LEFT JOIN organization AS manuf_organization 
        ON (manuf_organization.organization_id=vehicle.manuf_organization_id)  
    LEFT JOIN organization AS owner_organization 
        ON (owner_organization.organization_id=vehicle.owner_organization_id)  
    LEFT JOIN organization AS operator_organization 
        ON (operator_organization.organization_id=vehicle.operator_organization_id)      
LIMIT 25 
OFFSET 0