SELECT sid.id, sid.indentno,sid.issueinvoiceno,  sm12.state FromState,  sl1.location FromLocation , sm121.state toState,  sl2.location ToLocation, cat.CategoryTypeName,subcat.SubCategoryTypeName,itemcat.Name itemgroupName,TypeName ItemName,im.hsncode, barcodeno, (SELECT DATE_FORMAT(`ExpiryDate`,'%d-%b-%Y') FROM st_nmstock WHERE stockid=sid.stockid)ExpiryDate, (SELECT Quantity FROM st_nmsalesdetails WHERE stockid = sid.stockid LIMIT 1) ReceiveQuantity,(SELECT  rate FROM st_nmstock WHERE stockid = sid.stockid) Rate,   (SELECT taxper FROM st_nmstock WHERE stockid = sid.stockid) taxper, (SELECT BatchNumber FROM st_nmstock WHERE stockid=sid.stockid)BatchNumber, sendqty IssueQty,sendqty*(SELECT unitprice FROM st_nmstock WHERE stockid=sid.stockid) IssueAmount, (sid.receiveqty)ReceiveQty,  (sid.receiveqty)*(SELECT unitprice FROM st_nmstock WHERE stockid=sid.stockid) ReceiveAmt, (sid.consumeqty)ConsumeqtyFromPending,  (sid.consumeqty)*(SELECT unitprice FROM st_nmstock WHERE stockid=sid.stockid) ConsumeAmountFromPending, (sid.stockinqty)StockInQty,  (sid.stockinqty)*(SELECT unitprice FROM st_nmstock WHERE stockid=sid.stockid) StockInAmount, (sendqty-(sid.receiveqty+consumeqty+stockinqty)) InTransitQty, (sendqty-(sid.receiveqty+consumeqty+stockinqty))*(SELECT unitprice FROM st_nmstock WHERE stockid=sid.stockid) InTransitAmount, DATE_FORMAT(sid.datetime,'%b-%Y') IssueMonth,  DATE_FORMAT(sid.datetime,'%d-%m-%Y') IssueDateTime, pendingremarks, DATE_FORMAT(sid.dispatchdate,'%d-%m-%Y') DispatchDate,dispatchbyusername DispatchBy, DATE_FORMAT(sid.ReceiveDate,'%d-%m-%Y') BatchReceiveDate,ReceiveByUserName BatchReceiveBy  FROM st_indentissuedetail sid  INNER JOIN (SELECT indentno,tolocationid,fromlocationid FROM st_indent_detail sttd  GROUP BY indentno ) sttd ON sttd.indentno=sid.indentno  INNER JOIN st_locationmaster sl1 ON sl1.locationid=sttd.tolocationid  and sl1.locationid in (25) INNER JOIN st_locationmaster sl2 ON sl2.locationid=sttd.fromlocationid   inner join state_master sm12 on   sm12.id=sl1.StateID   inner join state_master sm121 on   sm121.id=sl2.StateID  INNER JOIN st_itemmaster im ON sid.itemid=im.itemid  and im.itemid in (1365,1639,1438,116,1611,1194,1070,686,1083,1281,1583,1325,8,1356,1584,1327,9,1026,1155,1156,1157,1158,1285,1586,1282,10,1283,1326,1585,1286,11,1392,877,186,1619,1302,1005,1623,1642,1643,734,903,1555,1507,1479,156,1404,736,177,908,1500,1556,1508,1578,1081,135,162,138,1534,610,1320,1214,872,875,1473,1311,1580,1206,1127,1110,1312,1581,1207,1128,1111,927,1665,1313,1208,956,1130,1112,1490,1582,1268,1621,719,1487,1341,41,959,960,1222,140,604,848,1493,1663,515,1484,1631,1388,1387,1354,1411,1651,1669,1599,1253,1251,215,1039,900,1557,1509,739,193,740,901,1510,1558,1415,1210,1632,99,100,101,549,1163,781,620,1073,1451,3,1080,1330,1620,860,1453,868,1454,859,1501,874,1452,1648,1048,1554,1316,1457,950,928,1458,893,1455,865,741,178,1498,896,1568,1511,1429,190,1310,946,912,1425,1650,1524,918,1433,1435,1434,1394,920,1298,1574,763,759,1565,1296,1297,1076,898,1295,1573,1315,121,1161,1625,1136,1478,1638,164,631,602,1089,136,526,146,1446,1426,984,1469,1481,1482,1475,914,916,1628,1199,1618,1538,913,1444,904,232,1192,742,1512,834,137,1370,1541,1614,924,677,52,516,1655,1097,1521,873,1371,1366,1503,1332,1150,1317,1144,1201,1202,1372,1348,1345,1344,1271,1346,124,1589,1094,1086,86,87,1299,696,697,761,1309,1587,1092,1084,1188,1189,1187,1093,1085,1588,1526,1525,1258,1259,1622,1465,1439,1489,1075,555,218,1181,809,1323,1164,149,1220,1219,194,889,1466,1559,745,1514,1640,936,1549,1551,1612,744,1506,1168,1385,1342,878,768,1131,1418,35,1118,606,1318,1355,1352,1653,1462,869,861,1497,1461,1463,1464,1654,1504,1539,1223,1100,72,1314,603,1179,1068,23,211,1667,1666,1334,1331,1213,1235,1274,637,1146,1088,40,723,724,187,1036,1082,1427,1456,915,919,1077,170,1142,1629,1307,1173,1308,59,1172,1224,1337,883,154,155,1079,851,1548,1340,1668,1443,1598,1633,1126,578,576,577,1236,1069,1171,1238,148,1121,1441,1641,1304,1132,1647,1600,1389,944,856,846,1553,53,1560,196,836,60,525,1488,1528,1420,1263,1169,899,197,1561,1515,746,1447,1421,1170,1,841,1135,1610,601,1609,1241,1477,1495,1430,1436,1252,1590,1264,1432,1148,1386,1398,1242,1591,1306,1265,891,1552,233,743,1533,189,1321,1358,1147,92,1414,1419,1652,244,1410,531,1405,1494,1228,1431,1149,1243,90,1357,1592,1267,1662,1658,38,982,1291,1065,1064,71,1095,854,582,1546,1467,1468,1480,1485,169,1165,1607,1604,1605,1606,551,1233,1577,1300,1529,751,1373,1090,1367,1374,1091,1368,1375,1369,1376,1445,1287,1634,1531,1502,678,988,1245,1117,1232,1290,168,852,1532,1293,1626,780,892,1448,611,816,975,1018,1226,1547,1505,967,987,1646,85,1349,1275,1324,1119,1012,1003,1644,1166,1143,17,167,250,1120,1422,1162,1396,1397,1292,1395,766,1072,1656,1319,748,574,1572,1197,1014,27,1543,1635,1617,1459,1460,1615,862,863,864,514,129,1204,1114,813,1664,144,947,590,165,698,630,1630,1198,619,1339,1078,1176,972,973,1177,1178,1412,996,932,1343,1231,628,1019,1288,1216,1550,141,1193,1353,1067,29,153,1409,1576,179,1499,749,1519,935,166,1174,1399,1234,634,1182,1246,1217,1247,1218,98,1637,1636,1289,1140,1492,1305,1535,853,173,1569,1256,926,1046,938,937,943,940,941,942,1491,1211,1530,750,235,1001,1659,1175,1191,231,1593,1294,1540,1377,933,62,63,876,1152,1250,1101,161,1284,160,1486,127,1661,1212,1624,1470,1471,1472,1060,1061,1333,249,1423,1160,1378,1379,1184,880,1360,1413,1440,1613,1660,1138,1167,206,1424,613,882,737,909,198,1567,1517,735,910,199,1566,1516,1262,1209,1244,150,1196,24,25,26,1393,1124,1123,1183,1248,1400,1025,1151,1225,1229,1154,1496,1017,180,980,1016,645,1579,1134,125,1002,1215,1279,1594,176,1380,1180,1523,1336,67,66,13,12,1322,1115,1303,1649,566,733,1071,731,728,564,729,565,1260,1381,1272,847,1616,666,1273,850,1601,174,1595,1442,1013,1417,592,1190,1255,1125,1254,1301,1074,593,1221,1407,1542,1239,548,1195,1627,752,145,527,622,1261,635,1102,1277,636,1205,1103,1278,1185,1186,1104,224,1087,772,1240,890,1483,1562,1518,753,1066,1139,1230,1603,234,905,1513,754,524,1608,849,1537,175,1596,1570,845,1544,1545,76,1057,1109,37,1359,1098,1351,1350,1390,902,201,1449,1563,1527,756,202,1450,897,1564,1520,755,1011,640,21,1099,1391,884,838,1145,726,1276,1122,229,1406,1361,1105,1428,1106,36,1416,69,1203,1108,568,1401,1107,1362,207,1200,1402,1257,1347,1575,1237,1363,1113,1657,1133,1063,1364,539,19,522,1536,857,1474,1602,858,182,183,1269,1270,1571,1597,1280,1382,758,757,612,1383,881,1522,1384,1408,1476,1153,1338,1403,115,805,1249,1116,804,1645,1227,1437,65,64) and im.MachineID in (82,72,50,81,51,69,80,86,87,73,83,78,52,53,77,88,54,1,89,55,71,56,90,91,57,85,84,67,79,66,58,59,68,92,70,60,61,65,76,62) INNER JOIN st_categorytypemaster cat ON cat.CategoryTypeID=im.CategoryTypeID   and cat.CategoryTypeID in (1,2) INNER JOIN st_subcategorytypemaster subcat ON subcat.SubCategoryTypeID=im.SubCategoryTypeID   and subcat.SubCategoryTypeID in (1,2,3,4,5,6,7,8,9,10,11) INNER JOIN st_subcategorymaster itemcat ON itemcat.SubCategoryID=im.SubCategoryID    and itemcat.SubCategoryTypeID in (1,2,3,4,5) where sid.datetime>='2025-02-24 00:00:00' AND sid.datetime<='2025-02-25 23:59:59'  ORDER BY id