SELECT
                              TBL_DISMOVE.ID,
                              TBL_DISMOVE.IN_DATE,
                              TBL_DISMOVE.TAKIPNO,
                              td.MODEL,
                              td.PLACE,
                              ISNULL(tm.MAKINANAME, 'Aniqlanmagan') AS MAKINA,
                              TBL_DISMOVE.PERSONEL,
                              TBL_DISMOVE.TON,
                              td1.DURUMBILGISI,
                                (CASE TBL_DISMOVE.STATUS_
                                WHEN '0' THEN 'PASIF'
                                WHEN '1' THEN 'AKTIF'
                              END) AS STATUS
                                        FROM TBL_DISMOVE
                            LEFT JOIN TBL_DISKALIP td
                              ON TBL_DISMOVE.TAKIPNO = td.TAKIPNO
                            LEFT JOIN TBL_DURUMLAR td1
                              ON TBL_DISMOVE.STATION_ = td1.ID
                            LEFT JOIN TBL_MAKINA tm
                              ON TBL_DISMOVE.MAKINANUMBER = tm.ID ORDER BY TBL_DISMOVE.ID DESC