SELECT DISTINCT
  property0_.id AS id1_20_,
  propertyca2_.volume,
  propertyca2_.number,
  propertyca2_.artist_catalogue_raisonee_id,
  property0_.authentication AS authenti2_20_,
  property0_.certificate AS certific3_20_,
  property0_.signed AS signed4_20_,
  property0_.stamped AS stamped5_20_,
  property0_.category_id AS categor68_20_,
  property0_.created_by AS created69_20_,
  property0_.created_date AS created_6_20_,
  property0_.cast_year_circa AS cast_yea7_20_,
  property0_.cast_year_end AS cast_yea8_20_,
  property0_.cast_year_start AS cast_yea9_20_,
  property0_.year_circa AS year_ci10_20_,
  property0_.year_end AS year_en11_20_,
  property0_.year_start AS year_st12_20_,
  property0_.year_text AS year_te13_20_,
  property0_.depth AS depth14_20_,
  property0_.height AS height15_20_,
  property0_.weight AS weight16_20_,
  property0_.width AS width17_20_,
  property0_.edition_number AS edition18_20_,
  property0_.artist_proof_total AS artist_19_20_,
  property0_.bon_a_tirer_total AS bon_a_t20_20_,
  property0_.cancellation_proof_total AS cancell21_20_,
  property0_.color_trial_proof_total AS color_t22_20_,
  property0_.dedicated_proof_total AS dedicat23_20_,
  property0_.edition_override AS edition24_20_,
  property0_.edition_size_notes AS edition25_20_,
  property0_.edition_size_total AS edition26_20_,
  property0_.hors_commerce_proof_total AS hors_co27_20_,
  property0_.museum_proof_total AS museum_28_20_,
  property0_.printers_proof_total AS printer29_20_,
  property0_.progressive_proof_total AS progres30_20_,
  property0_.right_to_produce_proof_total AS right_t31_20_,
  property0_.series_total AS series_32_20_,
  property0_.trial_proof_total AS trial_p33_20_,
  property0_.unkown_edition_type_size AS unkown_34_20_,
  property0_.working_proof_total AS working35_20_,
  property0_.edition_size_type_id AS edition70_20_,
  property0_.edition_type_id AS edition71_20_,
  property0_.unique_edition AS unique_36_20_,
  property0_.external_id AS externa37_20_,
  property0_.flag_authenticity AS flag_au38_20_,
  property0_.flag_condition AS flag_co39_20_,
  property0_.flag_medium AS flag_me40_20_,
  property0_.flag_restitution AS flag_re41_20_,
  property0_.flag_sfs AS flag_sf42_20_,
  property0_.flags_country_id AS flags_c72_20_,
  property0_.foundry AS foundry43_20_,
  property0_.image_path AS image_p44_20_,
  property0_.medium AS medium45_20_,
  property0_.merged_to_id AS merged_46_20_,
  property0_.original_title AS origina47_20_,
  property0_.parts AS parts48_20_,
  property0_.posthumous AS posthum49_20_,
  property0_.presize_type_id AS presize73_20_,
  property0_.reminder_employee AS reminde50_20_,
  property0_.reminder_notes_text AS reminde51_20_,
  property0_.researcher_notes_date AS researc52_20_,
  property0_.researcher_name AS researc53_20_,
  property0_.researcher_notes_text AS researc54_20_,
  property0_.signature AS signatu55_20_,
  property0_.size_text AS size_te56_20_,
  property0_.sort_code AS sort_co57_20_,
  property0_.status AS status58_20_,
  property0_.auto_image AS auto_im59_20_,
  property0_.auto_orientation AS auto_or60_20_,
  property0_.auto_scale AS auto_sc61_20_,
  property0_.auto_volume AS auto_vo62_20_,
  property0_.expertise_location AS experti63_20_,
  property0_.image_figure_id AS image_f74_20_,
  property0_.image_text AS image_t64_20_,
  property0_.title AS title65_20_,
  property0_.updated_by AS updated75_20_,
  property0_.updated_date AS updated66_20_,
  property0_.upload_reference AS upload_67_20_
FROM property property0_
LEFT OUTER JOIN property_property_catalogue_raisonee propertyca1_
  ON property0_.id = propertyca1_.property_id
LEFT OUTER JOIN property_catalogue_raisonee propertyca2_
  ON propertyca1_.catalogue_raisonee_id = propertyca2_.id
  AND (propertyca2_.status = 'Active')
LEFT OUTER JOIN artist_catalogue_raisonee artistcata3_
  ON propertyca2_.artist_catalogue_raisonee_id = artistcata3_.id
LEFT OUTER JOIN property_artist artists4_
  ON property0_.id = artists4_.property_id
LEFT OUTER JOIN artist artist5_
  ON artists4_.artist_id = artist5_.id
WHERE (artist5_.external_id IN ('AA-00000BC4'))
AND (artistcata3_.id IN (4336) OR artistcata3_.id IS NULL)
AND property0_.status = 'Active'
ORDER BY ISNULL(NULLIF(propertyca2_.artist_catalogue_raisonee_id, '')) asc , propertyca2_.artist_catalogue_raisonee_id asc, ISNULL(NULLIF(propertyca2_.volume, '')) asc , UPPER(propertyca2_.volume) asc, ISNULL(NULLIF(propertyca2_.number, '')) asc, UPPER(propertyca2_.number) asc;