Select i.User_ID, 
       COALESCE(
    NULLIF(p.pNameStr, ''),
    NULLIF(p.Name_Str_First, ''),
    CONCAT(COALESCE(p.Photog_FN, ''), ' ', COALESCE(p.Photog_LN, ''))
) AS Name_Str_First,
       , i.Title, i.Medium, i.Mount, i.Image_Date, i.Print_Date,
            i.Period, i.Description, i.Price, s.Path, s.Name, s.Contact_Name, s.Contact_Email, s.URL,
            i.video_src, i.image0_src, i.image1_src, i.image2_src, i.image3_src, i.ID, p.Photog_CountryID,
            i.Country_ID, i.Size_Str, s.Add1, s.Add2, s.City, s.ZIP, ss.abbrv, sc.Name as SiteCnty,
            s.c_phone, i.Status_ID, s.Img_Append, s.ID as siteID
            FROM Image i
            LEFT JOIN I_Photographer p
              ON i.Photog_ID = p.ID
            LEFT JOIN Site s
              ON i.Site_ID = s.ID
            LEFT JOIN State ss
              On ss.ID = s.State
            LEFT JOIN S_Country sc
              On sc.ID= s.Cnty_ID
            WHERE i.User_ID = ? AND i.Site_ID = ? AND i.Is_Valid = 1