SQL:
SELECT F.ID as CAMPAIGNID, PR.STOCKPRICE
FROM STOCKPRICE PR
LEFT JOIN STOCKPRICEFROMBETWEENDATE F
ON
PR.STOCKID = F.STOCKID AND
F.ISDELETED = "Hayır" AND
F.FINISHDATE > "2024-11-01" AND
F.ID = (
SELECT MAX(s.ID)
FROM STOCKPRICEFROMBETWEENDATE s
WHERE s.STOCKID=F.STOCKID)
WHERE
-- PR.MONEYUNIT = "TL" AND
PR.STOCKID = AND
PR.ISDELETED = "Hayır" AND
PRICEKIND = "Satış" AND
(CASE WHEN F.PRICENAME IS NULL THEN PR.PRICENAME = "SatisDoviz1" ELSE PR.PRICENAME = F.PRICENAME END)
LIMIT 1
SQL Error: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AND PR.ISDELETED = "Hayır" AND PRICEKIND ...' at line 15
SQL Error: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AND PR.ISDELETED = "Hayır" AND PRICEKIND ...' at line 15
$0.00
Kodu :
Bakiye : 0
Daha önce yorum yazılmamış, ilk yorum yazan sen ol!
Yorum Yaz
Önerilen Ürünler
-
ADET $6.50
ADET $2.00
-
ADET $2.75
Sayfalar
Hesabım
E-Bülten
| Döviz Adı | Satış | Alış |
|---|---|---|
| Euro | 37.19TL | 37.12TL |
| Dolar | 34.49TL | 34.18TL |
