Notes

SELECT
w.ID,
s.ID AS site_id,
s.site_name,
w.created_date,
w.transaction_id,
concat ( P.first_name, P.middle_name, P.last_name ) AS customer_name_surname,
w.remaining_amount,
P.user_name,
b.ID AS bank_id,
b.bank_name,
b2.ID AS wd_bank_id,
b2.bank_name as wd_bank_name,
w.iban,
wd.ID AS withdraw_detail_id,
concat ( p2.first_name, p2.middle_name, p2.last_name ) AS wd_customer_name_surname,
p2.player_id,
wd.site_id AS _psite,
(SELECT SUM(amount) FROM withdraw_detail WHERE withdraw_id = w.ID AND is_deleted = FALSE) AS wd_amount,
wd.created_date,
wd.confirmed_date,
wd.confirmed_user_id,
u.full_name AS confirm_user,
wd.deleted_date,
wd.deleted_description,
wd.description,
wd.confirmed_date,
wd.deleted_user_id,
st.status_name,
st.ID AS _status,
pm.ID AS payment_method_id,
pm.payment_method_name,
( SELECT COUNT ( ID ) FROM withdraw_detail WHERE withdraw_id = w.ID AND is_deleted = FALSE ) AS eslesme_sayisi,
s2.site_name AS withdraw_detail_site_name,
wd.confirmed_user_id AS onaylayan_kisi
FROM
withdraws AS w
LEFT OUTER JOIN statuses AS st ON w.status_id = st.ID
LEFT OUTER JOIN withdraw_detail AS wd ON wd.withdraw_id = w.ID AND wd.is_deleted = FALSE AND wd.status_id = st.ID
LEFT OUTER JOIN banks AS b ON w.bank_id = b.ID
LEFT OUTER JOIN banks AS b2 ON wd.bank_id = b2.ID
LEFT OUTER JOIN sites AS s ON w.site_id = s.ID
LEFT OUTER JOIN payment_method AS pm ON wd.payment_method_id = pm.ID
LEFT OUTER JOIN users AS u ON wd.confirmed_user_id = u.ID
LEFT OUTER JOIN sites AS s2 ON wd.site_id = s2.ID
LEFT OUTER JOIN players AS P ON w.player_id = P.ID
LEFT OUTER JOIN players AS p2 ON wd.player_id = P2.ID
Where
w.is_deleted = false and
w.transaction_id LIKE 'M%'
and st.id=2 and (b.ID = 2 OR b2.ID = 2
ORDER BY
w.ID DESC


- Npgsql.PostgresException (0x80004005): 42601: syntax error at or near "ORDER"

POSITION: 2248
at Npgsql.Internal.NpgsqlConnector.<ReadMessage>g__ReadMessageLong|211_0(NpgsqlConnector connector, Boolean async, DataRowLoadingMode dataRowLoadingMode, Boolean readingNotifications, Boolean isReadingPrependedMessage)
at Npgsql.NpgsqlDataReader.NextResult(Boolean async, Boolean isConsuming, CancellationToken cancellationToken)
at Npgsql.NpgsqlDataReader.NextResult()
at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior behavior, Boolean async, CancellationToken cancellationToken)
at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior behavior, Boolean async, CancellationToken cancellationToken)
at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior behavior)
at Dapper.SqlMapper.ExecuteReaderWithFlagsFallback(IDbCommand cmd, Boolean wasClosed, CommandBehavior behavior) in /_/Dapper/SqlMapper.cs:line 1075
at Dapper.SqlMapper.QueryImpl[T](IDbConnection cnn, CommandDefinition command, Type effectiveType)+MoveNext() in /_/Dapper/SqlMapper.cs:line 1094
at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection)
at System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source)
at Dapper.SqlMapper.Query[T](IDbConnection cnn, String sql, Object param, IDbTransaction transaction, Boolean buffered, Nullable`1 commandTimeout, Nullable`1 commandType) in /_/Dapper/SqlMapper.cs:line 734
at EsPanel.Controllers.AraPanel.AraWithdrawController.list(RequestWithdrawAraPanel model) in C:UsersMonsterDocumentsGitHuballProjectsbackendes_panelControllersAraPanelAraWithdrawController.cs:line 280
Exception data:
Severity: ERROR
SqlState: 42601
MessageText: syntax error at or near "ORDER"
Position: 2248
File: scan.l
Line: 1180
Routine: scanner_yyerror