@OnlyOneKenobi guideline on how you created this?
It's fairly straightforward, load the image into Automatic1111 IMG2IMG, denoising strength 0.9 set up multi-controlnet (depth model, weight 1 for the general shape), (Softedge HED, weight 0.9 for the linework, general fur details, and facial features)
Use a photorealistic model - in this case, RealisticVision
Prompt : analog photo of a (concrete statue:1.1) statue of a dog, Professional photo, Sony Alpha A9 II,Speedy shutter cycle,100mm, 8.8 million pixels, award winning photography by Erwin Blumenfeld
Negative prompt :
Digital Painting, Oils, Acrylics, Watercolors, Tempera, Fresco, Pencil, Charcoal, Pen and ink, Pastel, Colored pencil, Screen printing, Computer graphics, 3D model, Pixel art, CGI, Render, drawing, illustration, cartoon, anime, videogame, screenshot, painting, sketch, bad art, boring, blurred, unclear, speech bubbles, text, captions, subtitles, titles, writing, credits, artifacts, compression, mediocre, average, uninspiring, bland, flat, mundane, run of the mill, overexposure, cropped, watermark, logo, barcode, UI, signature, text, label, error, title, stickers, markings, speech bubbles, cropped, lowres, low quality, artifacts, bad_prompt, bad-hands-5, EasyNegative
Lastly,
Quick cleanup and composite in Photoshop.