Notes

SELECT U.ID AS id,
U.MODELID AS modelId,
U.MARKAID AS markaId,
U.STOKKODU AS stokKodu,
U.URUNADI AS urunAdi,
U.EN AS en,
U.BOY AS boy,
U.DERINLIK AS derinlik,
U.DESI AS desi,
U.FIYAT AS fiyat,
U.FIYAT_KDV_DAHIL AS kdvDahilFiyat,
U.HAVALE_EFT_INDIRIM_ORANI AS havaleEftIndirimOrani,
U.HAVALE_EFT_INDIRIM_AKTIF AS havaleEftIndirimAktif,
U.KDV_ORANI_ID AS kdvOraniId,
U.DOVIZID AS dovizId,
--U.ACIKLAMA AS aciklama,
U.KATEGORIID AS kategoriId,
U.YURT_DISINA_SATIS AS yurtDisinaSatis,
U.GARANTI_SURESI AS garantiSuresi,
U.GARANTI_ACIKLAMA AS garantiAciklama,
U.BIRIMID AS birimId,
U.META_KEYWORDS AS metaKeywords,
U.META_DESCRIPTION AS metaDescription,
U.YAYINLA AS yayinla,
U.YENI_URUN AS yeniUrun,
U.AYNI_GUN_KARGO AS aynigunKargo,
U.UCRETSIZ_KARGO AS ucretsizKargo,
U.LISTELE AS listele,
[kategoriAdi]= (SELECT K.KATEGORI),
stokHareket.ID as id,
stokHareket.ISLEM as islem,
stokHareket.ISLEM_SONU as islemSonu,
stokHareket.TARIH as tarih
FROM URUNLER U
INNER JOIN KATEGORI AS K ON K.ID = U.KATEGORIID
LEFT JOIN URUN_OZELLIKLERI AS urunOzellikleri ON urunOzellikleri.URUNID = U.ID AND urunOzellikleri.DELETED = 0
LEFT JOIN STOK_HAREKET AS stokHareket ON stokHareket.URUN_ID = U.ID
WHERE U.ID = 30906
FOR JSON AUTO, INCLUDE_NULL_VALUES