SELECT DISTINCT 

J.quote_id, 
J.description, 
J.created_app_type, 
J.preferred_date, 
SE.section_id, 
SD.section_department_id, 
SA.asset_id, 
C.department_name, 
C.department_id, 
JCATR.test_reading_result, 
AT.asset_type_id, 
AT.asset_type_name, 
AV.value, 
CO.user_id, 
ASL.service_level_id,
ASL.service_level_name
      
      FROM quotes AS J

      LEFT JOIN user_contracts AS CO 
      ON J.user_contract_id = CO.user_contract_id

      LEFT JOIN quote_sections AS SE 
      ON J.quote_id = SE.quote_id 

      LEFT JOIN section_departments AS SD 
      ON SE.section_id = SD.section_id 

      LEFT JOIN departments AS C 
      ON SD.department_id = C.department_id

      LEFT JOIN department_assets AS JCA
      ON SD.section_department_id = JCA.section_department_id

      LEFT JOIN job_card_assets AS JCAA
      ON JCA.department_asset_id = JCAA.department_asset_id

      LEFT JOIN job_card_asset_test_readings AS JCATR
      ON JCA.department_asset_id = JCATR.department_asset_id

      LEFT JOIN location_assets AS SA
      ON JCA.asset_id = SA.asset_id

      LEFT JOIN asset_types AS AT
      ON SA.asset_type_id = AT.asset_type_id

      LEFT JOIN asset_fields AS ACF
      ON AT.asset_type_id = ACF.asset_type_id AND ACF.field_name = 'Visit 1'

      LEFT JOIN asset_values AS AV
      ON ACF.field_id = AV.field_id AND AV.asset_id = SA.asset_id

      LEFT JOIN asset_service_levels AS ASL
      ON JCA.service_level_id = ASL.service_level_id

      WHERE AT.asset_type_name NOT LIKE '%AssetSafe%' AND J.date_created >= (NOW() - INTERVAL '30 day')
      AND J.quote_id NOT IN (0,5757) LIMIT 30