Powered By
tariff.php
select p.iPax, p.iPackageID, p.vName, i.fRate, p.vInclusion, i.iChips, i.iNNPC, i.iMPC, i.iInventory, p.vShortDesc, p.vChoiceOfLiquor, p.cType, i.dInv from package p left join inventory i on p.iPackageID = i.iPackageID where i.iPackageID = '126' and (p.cStatus = 'A' and i.cStatus = 'A') and p.iPackageID NOT IN(45, 46, 47, 48, 49, 50, 71, 70, 89, 81, 85, 82, 86, 84, 88, 90, 39, 6) and i.dInv = '2023-02-09' and p.cBookType NOT IN ('SNP', 'AGT') and i.iInventory > 0 order by i.dInv DESC LIMIT 1
select p.iPax, p.iPackageID, p.vName, i.fRate, p.vInclusion, i.iChips, i.iNNPC, i.iMPC, i.iInventory, p.vShortDesc, p.vChoiceOfLiquor, p.cType, i.dInv from package p left join inventory i on p.iPackageID = i.iPackageID where i.iPackageID = '97' and (p.cStatus = 'A' and i.cStatus = 'A') and p.iPackageID NOT IN(45, 46, 47, 48, 49, 50, 71, 70, 89, 81, 85, 82, 86, 84, 88, 90, 39, 6) and i.dInv = '2023-02-09' and p.cBookType NOT IN ('SNP', 'AGT') and i.iInventory > 0 order by i.dInv DESC LIMIT 1
select p.iPax, p.iPackageID, p.vName, i.fRate, p.vInclusion, i.iChips, i.iNNPC, i.iMPC, i.iInventory, p.vShortDesc, p.vChoiceOfLiquor, p.cType, i.dInv from package p left join inventory i on p.iPackageID = i.iPackageID where i.iPackageID = '95' and (p.cStatus = 'A' and i.cStatus = 'A') and p.iPackageID NOT IN(45, 46, 47, 48, 49, 50, 71, 70, 89, 81, 85, 82, 86, 84, 88, 90, 39, 6) and i.dInv = '2023-02-09' and p.cBookType NOT IN ('SNP', 'AGT') and i.iInventory > 0 order by i.dInv DESC LIMIT 1
select p.iPax, p.iPackageID, p.vName, i.fRate, p.vInclusion, i.iChips, i.iNNPC, i.iMPC, i.iInventory, p.vShortDesc, p.vChoiceOfLiquor, p.cType, i.dInv from package p left join inventory i on p.iPackageID = i.iPackageID where i.iPackageID = '127' and (p.cStatus = 'A' and i.cStatus = 'A') and p.iPackageID NOT IN(45, 46, 47, 48, 49, 50, 71, 70, 89, 81, 85, 82, 86, 84, 88, 90, 39, 6) and i.dInv = '2023-02-09' and p.cBookType NOT IN ('SNP', 'AGT') and i.iInventory > 0 order by i.dInv DESC LIMIT 1
select p.iPax, p.iPackageID, p.vName, i.fRate, p.vInclusion, i.iChips, i.iNNPC, i.iMPC, i.iInventory, p.vShortDesc, p.vChoiceOfLiquor, p.cType, i.dInv from package p left join inventory i on p.iPackageID = i.iPackageID where i.iPackageID = '98' and (p.cStatus = 'A' and i.cStatus = 'A') and p.iPackageID NOT IN(45, 46, 47, 48, 49, 50, 71, 70, 89, 81, 85, 82, 86, 84, 88, 90, 39, 6) and i.dInv = '2023-02-09' and p.cBookType NOT IN ('SNP', 'AGT') and i.iInventory > 0 order by i.dInv DESC LIMIT 1
select p.iPax, p.iPackageID, p.vName, i.fRate, p.vInclusion, i.iChips, i.iNNPC, i.iMPC, i.iInventory, p.vShortDesc, p.vChoiceOfLiquor, p.cType, i.dInv from package p left join inventory i on p.iPackageID = i.iPackageID where i.iPackageID = '96' and (p.cStatus = 'A' and i.cStatus = 'A') and p.iPackageID NOT IN(45, 46, 47, 48, 49, 50, 71, 70, 89, 81, 85, 82, 86, 84, 88, 90, 39, 6) and i.dInv = '2023-02-09' and p.cBookType NOT IN ('SNP', 'AGT') and i.iInventory > 0 order by i.dInv DESC LIMIT 1
select p.iPax, p.iPackageID, p.vName, i.fRate, p.vInclusion, i.iChips, i.iNNPC, i.iMPC, i.iInventory, p.vShortDesc, p.vChoiceOfLiquor, p.cType, i.dInv from package p left join inventory i on p.iPackageID = i.iPackageID where i.iPackageID = '128' and (p.cStatus = 'A' and i.cStatus = 'A') and p.iPackageID NOT IN(45, 46, 47, 48, 49, 50, 71, 70, 89, 81, 85, 82, 86, 84, 88, 90, 39, 6) and i.dInv = '2023-02-09' and p.cBookType NOT IN ('SNP', 'AGT') and i.iInventory > 0 order by i.dInv DESC LIMIT 1
select p.iPax, p.iPackageID, p.vName, i.fRate, p.vInclusion, i.iChips, i.iNNPC, i.iMPC, i.iInventory, p.vShortDesc, p.vChoiceOfLiquor, p.cType, i.dInv from package p left join inventory i on p.iPackageID = i.iPackageID where i.iPackageID = '99' and (p.cStatus = 'A' and i.cStatus = 'A') and p.iPackageID NOT IN(45, 46, 47, 48, 49, 50, 71, 70, 89, 81, 85, 82, 86, 84, 88, 90, 39, 6) and i.dInv = '2023-02-09' and p.cBookType NOT IN ('SNP', 'AGT') and i.iInventory > 0 order by i.dInv DESC LIMIT 1
select p.iPax, p.iPackageID, p.vName, i.fRate, p.vInclusion, i.iChips, i.iNNPC, i.iMPC, i.iInventory, p.vShortDesc, p.vChoiceOfLiquor, p.cType, i.dInv from package p left join inventory i on p.iPackageID = i.iPackageID where i.iPackageID = '93' and (p.cStatus = 'A' and i.cStatus = 'A') and p.iPackageID NOT IN(45, 46, 47, 48, 49, 50, 71, 70, 89, 81, 85, 82, 86, 84, 88, 90, 39, 6) and i.dInv = '2023-02-09' and p.cBookType NOT IN ('SNP', 'AGT') and i.iInventory > 0 order by i.dInv DESC LIMIT 1
select p.iPax, p.iPackageID, p.vName, i.fRate, p.vInclusion, i.iChips, i.iNNPC, i.iMPC, i.iInventory, p.vShortDesc, p.vChoiceOfLiquor, p.cType, i.dInv from package p left join inventory i on p.iPackageID = i.iPackageID where i.iPackageID = '105' and (p.cStatus = 'A' and i.cStatus = 'A') and p.iPackageID NOT IN(45, 46, 47, 48, 49, 50, 71, 70, 89, 81, 85, 82, 86, 84, 88, 90, 39, 6) and i.dInv = '2023-02-09' and p.cBookType NOT IN ('SNP', 'AGT') and i.iInventory > 0 order by i.dInv DESC LIMIT 1
select p.iPax, p.iPackageID, p.vName, i.fRate, p.vInclusion, i.iChips, i.iNNPC, i.iMPC, i.iInventory, p.vShortDesc, p.vChoiceOfLiquor, p.cType, i.dInv from package p left join inventory i on p.iPackageID = i.iPackageID where i.iPackageID = '70' and (p.cStatus = 'A' and i.cStatus = 'A') and p.iPackageID NOT IN(45, 46, 47, 48, 49, 50, 71, 70, 89, 81, 85, 82, 86, 84, 88, 90, 39, 6) and i.dInv = '2023-02-09' and p.cBookType NOT IN ('SNP', 'AGT') and i.iInventory > 0 order by i.dInv DESC LIMIT 1
select p.iPax, p.iPackageID, p.vName, i.fRate, p.vInclusion, i.iChips, i.iNNPC, i.iMPC, i.iInventory, p.vShortDesc, p.vChoiceOfLiquor, p.cType, i.dInv from package p left join inventory i on p.iPackageID = i.iPackageID where i.iPackageID = '100' and (p.cStatus = 'A' and i.cStatus = 'A') and p.iPackageID NOT IN(45, 46, 47, 48, 49, 50, 71, 70, 89, 81, 85, 82, 86, 84, 88, 90, 39, 6) and i.dInv = '2023-02-09' and p.cBookType NOT IN ('SNP', 'AGT') and i.iInventory > 0 order by i.dInv DESC LIMIT 1
select p.iPax, p.iPackageID, p.vName, i.fRate, p.vInclusion, i.iChips, i.iNNPC, i.iMPC, i.iInventory, p.vShortDesc, p.vChoiceOfLiquor, p.cType, i.dInv from package p left join inventory i on p.iPackageID = i.iPackageID where i.iPackageID = '134' and (p.cStatus = 'A' and i.cStatus = 'A') and p.iPackageID NOT IN(45, 46, 47, 48, 49, 50, 71, 70, 89, 81, 85, 82, 86, 84, 88, 90, 39, 6) and i.dInv = '2023-02-09' and p.cBookType NOT IN ('SNP', 'AGT') and i.iInventory > 0 order by i.dInv DESC LIMIT 1
select p.iPax, p.iPackageID, p.vName, i.fRate, p.vInclusion, i.iChips, i.iNNPC, i.iMPC, i.iInventory, p.vShortDesc, p.vChoiceOfLiquor, p.cType, i.dInv from package p left join inventory i on p.iPackageID = i.iPackageID where i.iPackageID = '106' and (p.cStatus = 'A' and i.cStatus = 'A') and p.iPackageID NOT IN(45, 46, 47, 48, 49, 50, 71, 70, 89, 81, 85, 82, 86, 84, 88, 90, 39, 6) and i.dInv = '2023-02-09' and p.cBookType NOT IN ('SNP', 'AGT') and i.iInventory > 0 order by i.dInv DESC LIMIT 1
select p.iPax, p.iPackageID, p.vName, i.fRate, p.vInclusion, i.iChips, i.iNNPC, i.iMPC, i.iInventory, p.vShortDesc, p.vChoiceOfLiquor, p.cType, i.dInv from package p left join inventory i on p.iPackageID = i.iPackageID where i.iPackageID = '101' and (p.cStatus = 'A' and i.cStatus = 'A') and p.iPackageID NOT IN(45, 46, 47, 48, 49, 50, 71, 70, 89, 81, 85, 82, 86, 84, 88, 90, 39, 6) and i.dInv = '2023-02-09' and p.cBookType NOT IN ('SNP', 'AGT') and i.iInventory > 0 order by i.dInv DESC LIMIT 1
select p.iPax, p.iPackageID, p.vName, i.fRate, p.vInclusion, i.iChips, i.iNNPC, i.iMPC, i.iInventory, p.vShortDesc, p.vChoiceOfLiquor, p.cType, i.dInv from package p left join inventory i on p.iPackageID = i.iPackageID where i.iPackageID = '94' and (p.cStatus = 'A' and i.cStatus = 'A') and p.iPackageID NOT IN(45, 46, 47, 48, 49, 50, 71, 70, 89, 81, 85, 82, 86, 84, 88, 90, 39, 6) and i.dInv = '2023-02-09' and p.cBookType NOT IN ('SNP', 'AGT') and i.iInventory > 0 order by i.dInv DESC LIMIT 1
select p.iPax, p.iPackageID, p.vName, i.fRate, p.vInclusion, i.iChips, i.iNNPC, i.iMPC, i.iInventory, p.vShortDesc, p.vChoiceOfLiquor, p.cType, i.dInv from package p left join inventory i on p.iPackageID = i.iPackageID where i.iPackageID = '135' and (p.cStatus = 'A' and i.cStatus = 'A') and p.iPackageID NOT IN(45, 46, 47, 48, 49, 50, 71, 70, 89, 81, 85, 82, 86, 84, 88, 90, 39, 6) and i.dInv = '2023-02-09' and p.cBookType NOT IN ('SNP', 'AGT') and i.iInventory > 0 order by i.dInv DESC LIMIT 1
select p.iPax, p.iPackageID, p.vName, i.fRate, p.vInclusion, i.iChips, i.iNNPC, i.iMPC, i.iInventory, p.vShortDesc, p.vChoiceOfLiquor, p.cType, i.dInv from package p left join inventory i on p.iPackageID = i.iPackageID where i.iPackageID = '136' and (p.cStatus = 'A' and i.cStatus = 'A') and p.iPackageID NOT IN(45, 46, 47, 48, 49, 50, 71, 70, 89, 81, 85, 82, 86, 84, 88, 90, 39, 6) and i.dInv = '2023-02-09' and p.cBookType NOT IN ('SNP', 'AGT') and i.iInventory > 0 order by i.dInv DESC LIMIT 1
select p.iPax, p.iPackageID, p.vName, i.fRate, p.vInclusion, i.iChips, i.iNNPC, i.iMPC, i.iInventory, p.vShortDesc, p.vChoiceOfLiquor, p.cType, i.dInv from package p left join inventory i on p.iPackageID = i.iPackageID where i.iPackageID = '107' and (p.cStatus = 'A' and i.cStatus = 'A') and p.iPackageID NOT IN(45, 46, 47, 48, 49, 50, 71, 70, 89, 81, 85, 82, 86, 84, 88, 90, 39, 6) and i.dInv = '2023-02-09' and p.cBookType NOT IN ('SNP', 'AGT') and i.iInventory > 0 order by i.dInv DESC LIMIT 1
select p.iPax, p.iPackageID, p.vName, i.fRate, p.vInclusion, i.iChips, i.iNNPC, i.iMPC, i.iInventory, p.vShortDesc, p.vChoiceOfLiquor, p.cType, i.dInv from package p left join inventory i on p.iPackageID = i.iPackageID where i.iPackageID = '71' and (p.cStatus = 'A' and i.cStatus = 'A') and p.iPackageID NOT IN(45, 46, 47, 48, 49, 50, 71, 70, 89, 81, 85, 82, 86, 84, 88, 90, 39, 6) and i.dInv = '2023-02-09' and p.cBookType NOT IN ('SNP', 'AGT') and i.iInventory > 0 order by i.dInv DESC LIMIT 1
select p.iPax, p.iPackageID, p.vName, i.fRate, p.vInclusion, i.iChips, i.iNNPC, i.iMPC, i.iInventory, p.vShortDesc, p.vChoiceOfLiquor, p.cType, i.dInv from package p left join inventory i on p.iPackageID = i.iPackageID where i.iPackageID = '102' and (p.cStatus = 'A' and i.cStatus = 'A') and p.iPackageID NOT IN(45, 46, 47, 48, 49, 50, 71, 70, 89, 81, 85, 82, 86, 84, 88, 90, 39, 6) and i.dInv = '2023-02-09' and p.cBookType NOT IN ('SNP', 'AGT') and i.iInventory > 0 order by i.dInv DESC LIMIT 1
select p.iPax, p.iPackageID, p.vName, i.fRate, p.vInclusion, i.iChips, i.iNNPC, i.iMPC, i.iInventory, p.vShortDesc, p.vChoiceOfLiquor, p.cType, i.dInv from package p left join inventory i on p.iPackageID = i.iPackageID where i.iPackageID = '131' and (p.cStatus = 'A' and i.cStatus = 'A') and p.iPackageID NOT IN(45, 46, 47, 48, 49, 50, 71, 70, 89, 81, 85, 82, 86, 84, 88, 90, 39, 6) and i.dInv = '2023-02-09' and p.cBookType NOT IN ('SNP', 'AGT') and i.iInventory > 0 order by i.dInv DESC LIMIT 1
select p.iPax, p.iPackageID, p.vName, i.fRate, p.vInclusion, i.iChips, i.iNNPC, i.iMPC, i.iInventory, p.vShortDesc, p.vChoiceOfLiquor, p.cType, i.dInv from package p left join inventory i on p.iPackageID = i.iPackageID where i.iPackageID = '132' and (p.cStatus = 'A' and i.cStatus = 'A') and p.iPackageID NOT IN(45, 46, 47, 48, 49, 50, 71, 70, 89, 81, 85, 82, 86, 84, 88, 90, 39, 6) and i.dInv = '2023-02-09' and p.cBookType NOT IN ('SNP', 'AGT') and i.iInventory > 0 order by i.dInv DESC LIMIT 1
select p.iPax, p.iPackageID, p.vName, i.fRate, p.vInclusion, i.iChips, i.iNNPC, i.iMPC, i.iInventory, p.vShortDesc, p.vChoiceOfLiquor, p.cType, i.dInv from package p left join inventory i on p.iPackageID = i.iPackageID where i.iPackageID = '125' and (p.cStatus = 'A' and i.cStatus = 'A') and p.iPackageID NOT IN(45, 46, 47, 48, 49, 50, 71, 70, 89, 81, 85, 82, 86, 84, 88, 90, 39, 6) and i.dInv = '2023-02-09' and p.cBookType NOT IN ('SNP', 'AGT') and i.iInventory > 0 order by i.dInv DESC LIMIT 1
select p.iPax, p.iPackageID, p.vName, i.fRate, p.vInclusion, i.iChips, i.iNNPC, i.iMPC, i.iInventory, p.vShortDesc, p.vChoiceOfLiquor, p.cType, i.dInv from package p left join inventory i on p.iPackageID = i.iPackageID where i.iPackageID = '103' and (p.cStatus = 'A' and i.cStatus = 'A') and p.iPackageID NOT IN(45, 46, 47, 48, 49, 50, 71, 70, 89, 81, 85, 82, 86, 84, 88, 90, 39, 6) and i.dInv = '2023-02-09' and p.cBookType NOT IN ('SNP', 'AGT') and i.iInventory > 0 order by i.dInv DESC LIMIT 1
select p.iPax, p.iPackageID, p.vName, i.fRate, p.vInclusion, i.iChips, i.iNNPC, i.iMPC, i.iInventory, p.vShortDesc, p.vChoiceOfLiquor, p.cType, i.dInv from package p left join inventory i on p.iPackageID = i.iPackageID where i.iPackageID = '133' and (p.cStatus = 'A' and i.cStatus = 'A') and p.iPackageID NOT IN(45, 46, 47, 48, 49, 50, 71, 70, 89, 81, 85, 82, 86, 84, 88, 90, 39, 6) and i.dInv = '2023-02-09' and p.cBookType NOT IN ('SNP', 'AGT') and i.iInventory > 0 order by i.dInv DESC LIMIT 1
select p.iPax, p.iPackageID, p.vName, i.fRate, p.vInclusion, i.iChips, i.iNNPC, i.iMPC, i.iInventory, p.vShortDesc, p.vChoiceOfLiquor, p.cType, i.dInv from package p left join inventory i on p.iPackageID = i.iPackageID where i.iPackageID = '104' and (p.cStatus = 'A' and i.cStatus = 'A') and p.iPackageID NOT IN(45, 46, 47, 48, 49, 50, 71, 70, 89, 81, 85, 82, 86, 84, 88, 90, 39, 6) and i.dInv = '2023-02-09' and p.cBookType NOT IN ('SNP', 'AGT') and i.iInventory > 0 order by i.dInv DESC LIMIT 1
select p.iPax, p.iPackageID, p.vName, i.fRate, p.vInclusion, i.iChips, i.iNNPC, i.iMPC, i.iInventory, p.vShortDesc, p.vChoiceOfLiquor, p.cType, i.dInv from package p left join inventory i on p.iPackageID = i.iPackageID where i.iPackageID = '137' and (p.cStatus = 'A' and i.cStatus = 'A') and p.iPackageID NOT IN(45, 46, 47, 48, 49, 50, 71, 70, 89, 81, 85, 82, 86, 84, 88, 90, 39, 6) and i.dInv = '2023-02-09' and p.cBookType NOT IN ('SNP', 'AGT') and i.iInventory > 0 order by i.dInv DESC LIMIT 1
select p.iPax, p.iPackageID, p.vName, i.fRate, p.vInclusion, i.iChips, i.iNNPC, i.iMPC, i.iInventory, p.vShortDesc, p.vChoiceOfLiquor, p.cType, i.dInv from package p left join inventory i on p.iPackageID = i.iPackageID where i.iPackageID = '138' and (p.cStatus = 'A' and i.cStatus = 'A') and p.iPackageID NOT IN(45, 46, 47, 48, 49, 50, 71, 70, 89, 81, 85, 82, 86, 84, 88, 90, 39, 6) and i.dInv = '2023-02-09' and p.cBookType NOT IN ('SNP', 'AGT') and i.iInventory > 0 order by i.dInv DESC LIMIT 1
select p.iPax, p.iPackageID, p.vName, i.fRate, p.vInclusion, i.iChips, i.iNNPC, i.iMPC, i.iInventory, p.vShortDesc, p.vChoiceOfLiquor, p.cType, i.dInv from package p left join inventory i on p.iPackageID = i.iPackageID where i.iPackageID = '139' and (p.cStatus = 'A' and i.cStatus = 'A') and p.iPackageID NOT IN(45, 46, 47, 48, 49, 50, 71, 70, 89, 81, 85, 82, 86, 84, 88, 90, 39, 6) and i.dInv = '2023-02-09' and p.cBookType NOT IN ('SNP', 'AGT') and i.iInventory > 0 order by i.dInv DESC LIMIT 1
select p.iPax, p.iPackageID, p.vName, i.fRate, p.vInclusion, i.iChips, i.iNNPC, i.iMPC, i.iInventory, p.vShortDesc, p.vChoiceOfLiquor, p.cType, i.dInv from package p left join inventory i on p.iPackageID = i.iPackageID where i.iPackageID = '113' and (p.cStatus = 'A' and i.cStatus = 'A') and p.iPackageID NOT IN(45, 46, 47, 48, 49, 50, 71, 70, 89, 81, 85, 82, 86, 84, 88, 90, 39, 6) and i.dInv = '2023-02-09' and p.cBookType NOT IN ('SNP', 'AGT') and i.iInventory > 0 order by i.dInv DESC LIMIT 1
select p.iPax, p.iPackageID, p.vName, i.fRate, p.vInclusion, i.iChips, i.iNNPC, i.iMPC, i.iInventory, p.vShortDesc, p.vChoiceOfLiquor, p.cType, i.dInv from package p left join inventory i on p.iPackageID = i.iPackageID where i.iPackageID = '118' and (p.cStatus = 'A' and i.cStatus = 'A') and p.iPackageID NOT IN(45, 46, 47, 48, 49, 50, 71, 70, 89, 81, 85, 82, 86, 84, 88, 90, 39, 6) and i.dInv = '2023-02-09' and p.cBookType NOT IN ('SNP', 'AGT') and i.iInventory > 0 order by i.dInv DESC LIMIT 1
select p.iPax, p.iPackageID, p.vName, i.fRate, p.vInclusion, i.iChips, i.iNNPC, i.iMPC, i.iInventory, p.vShortDesc, p.vChoiceOfLiquor, p.cType, i.dInv from package p left join inventory i on p.iPackageID = i.iPackageID where i.iPackageID = '119' and (p.cStatus = 'A' and i.cStatus = 'A') and p.iPackageID NOT IN(45, 46, 47, 48, 49, 50, 71, 70, 89, 81, 85, 82, 86, 84, 88, 90, 39, 6) and i.dInv = '2023-02-09' and p.cBookType NOT IN ('SNP', 'AGT') and i.iInventory > 0 order by i.dInv DESC LIMIT 1
select p.iPax, p.iPackageID, p.vName, i.fRate, p.vInclusion, i.iChips, i.iNNPC, i.iMPC, i.iInventory, p.vShortDesc, p.vChoiceOfLiquor, p.cType, i.dInv from package p left join inventory i on p.iPackageID = i.iPackageID where i.iPackageID = '161' and (p.cStatus = 'A' and i.cStatus = 'A') and p.iPackageID NOT IN(45, 46, 47, 48, 49, 50, 71, 70, 89, 81, 85, 82, 86, 84, 88, 90, 39, 6) and i.dInv = '2023-02-09' and p.cBookType NOT IN ('SNP', 'AGT') and i.iInventory > 0 order by i.dInv DESC LIMIT 1
select p.iPax, p.iPackageID, p.vName, i.fRate, p.vInclusion, i.iChips, i.iNNPC, i.iMPC, i.iInventory, p.vShortDesc, p.vChoiceOfLiquor, p.cType, i.dInv from package p left join inventory i on p.iPackageID = i.iPackageID where i.iPackageID = '120' and (p.cStatus = 'A' and i.cStatus = 'A') and p.iPackageID NOT IN(45, 46, 47, 48, 49, 50, 71, 70, 89, 81, 85, 82, 86, 84, 88, 90, 39, 6) and i.dInv = '2023-02-09' and p.cBookType NOT IN ('SNP', 'AGT') and i.iInventory > 0 order by i.dInv DESC LIMIT 1
select p.iPax, p.iPackageID, p.vName, i.fRate, p.vInclusion, i.iChips, i.iNNPC, i.iMPC, i.iInventory, p.vShortDesc, p.vChoiceOfLiquor, p.cType, i.dInv from package p left join inventory i on p.iPackageID = i.iPackageID where i.iPackageID = '140' and (p.cStatus = 'A' and i.cStatus = 'A') and p.iPackageID NOT IN(45, 46, 47, 48, 49, 50, 71, 70, 89, 81, 85, 82, 86, 84, 88, 90, 39, 6) and i.dInv = '2023-02-09' and p.cBookType NOT IN ('SNP', 'AGT') and i.iInventory > 0 order by i.dInv DESC LIMIT 1
select p.iPax, p.iPackageID, p.vName, i.fRate, p.vInclusion, i.iChips, i.iNNPC, i.iMPC, i.iInventory, p.vShortDesc, p.vChoiceOfLiquor, p.cType, i.dInv from package p left join inventory i on p.iPackageID = i.iPackageID where i.iPackageID = '142' and (p.cStatus = 'A' and i.cStatus = 'A') and p.iPackageID NOT IN(45, 46, 47, 48, 49, 50, 71, 70, 89, 81, 85, 82, 86, 84, 88, 90, 39, 6) and i.dInv = '2023-02-09' and p.cBookType NOT IN ('SNP', 'AGT') and i.iInventory > 0 order by i.dInv DESC LIMIT 1
select p.iPax, p.iPackageID, p.vName, i.fRate, p.vInclusion, i.iChips, i.iNNPC, i.iMPC, i.iInventory, p.vShortDesc, p.vChoiceOfLiquor, p.cType, i.dInv from package p left join inventory i on p.iPackageID = i.iPackageID where i.iPackageID = '153' and (p.cStatus = 'A' and i.cStatus = 'A') and p.iPackageID NOT IN(45, 46, 47, 48, 49, 50, 71, 70, 89, 81, 85, 82, 86, 84, 88, 90, 39, 6) and i.dInv = '2023-02-09' and p.cBookType NOT IN ('SNP', 'AGT') and i.iInventory > 0 order by i.dInv DESC LIMIT 1
select p.iPax, p.iPackageID, p.vName, i.fRate, p.vInclusion, i.iChips, i.iNNPC, i.iMPC, i.iInventory, p.vShortDesc, p.vChoiceOfLiquor, p.cType, i.dInv from package p left join inventory i on p.iPackageID = i.iPackageID where i.iPackageID = '155' and (p.cStatus = 'A' and i.cStatus = 'A') and p.iPackageID NOT IN(45, 46, 47, 48, 49, 50, 71, 70, 89, 81, 85, 82, 86, 84, 88, 90, 39, 6) and i.dInv = '2023-02-09' and p.cBookType NOT IN ('SNP', 'AGT') and i.iInventory > 0 order by i.dInv DESC LIMIT 1
select p.iPax, p.iPackageID, p.vName, i.fRate, p.vInclusion, i.iChips, i.iNNPC, i.iMPC, i.iInventory, p.vShortDesc, p.vChoiceOfLiquor, p.cType, i.dInv from package p left join inventory i on p.iPackageID = i.iPackageID where i.iPackageID = '157' and (p.cStatus = 'A' and i.cStatus = 'A') and p.iPackageID NOT IN(45, 46, 47, 48, 49, 50, 71, 70, 89, 81, 85, 82, 86, 84, 88, 90, 39, 6) and i.dInv = '2023-02-09' and p.cBookType NOT IN ('SNP', 'AGT') and i.iInventory > 0 order by i.dInv DESC LIMIT 1
select p.iPax, p.iPackageID, p.vName, i.fRate, p.vInclusion, i.iChips, i.iNNPC, i.iMPC, i.iInventory, p.vShortDesc, p.vChoiceOfLiquor, p.cType, i.dInv from package p left join inventory i on p.iPackageID = i.iPackageID where i.iPackageID = '159' and (p.cStatus = 'A' and i.cStatus = 'A') and p.iPackageID NOT IN(45, 46, 47, 48, 49, 50, 71, 70, 89, 81, 85, 82, 86, 84, 88, 90, 39, 6) and i.dInv = '2023-02-09' and p.cBookType NOT IN ('SNP', 'AGT') and i.iInventory > 0 order by i.dInv DESC LIMIT 1
select p.iPax, p.iPackageID, p.vName, i.fRate, p.vInclusion, i.iChips, i.iNNPC, i.iMPC, i.iInventory, p.vShortDesc, p.vChoiceOfLiquor, p.cType, i.dInv from package p left join inventory i on p.iPackageID = i.iPackageID where i.iPackageID = '145' and (p.cStatus = 'A' and i.cStatus = 'A') and p.iPackageID NOT IN(45, 46, 47, 48, 49, 50, 71, 70, 89, 81, 85, 82, 86, 84, 88, 90, 39, 6) and i.dInv = '2023-02-09' and p.cBookType NOT IN ('SNP', 'AGT') and i.iInventory > 0 order by i.dInv DESC LIMIT 1
select p.iPax, p.iPackageID, p.vName, i.fRate, p.vInclusion, i.iChips, i.iNNPC, i.iMPC, i.iInventory, p.vShortDesc, p.vChoiceOfLiquor, p.cType, i.dInv from package p left join inventory i on p.iPackageID = i.iPackageID where i.iPackageID = '147' and (p.cStatus = 'A' and i.cStatus = 'A') and p.iPackageID NOT IN(45, 46, 47, 48, 49, 50, 71, 70, 89, 81, 85, 82, 86, 84, 88, 90, 39, 6) and i.dInv = '2023-02-09' and p.cBookType NOT IN ('SNP', 'AGT') and i.iInventory > 0 order by i.dInv DESC LIMIT 1
select p.iPax, p.iPackageID, p.vName, i.fRate, p.vInclusion, i.iChips, i.iNNPC, i.iMPC, i.iInventory, p.vShortDesc, p.vChoiceOfLiquor, p.cType, i.dInv from package p left join inventory i on p.iPackageID = i.iPackageID where i.iPackageID = '69' and (p.cStatus = 'A' and i.cStatus = 'A') and p.iPackageID NOT IN(45, 46, 47, 48, 49, 50, 71, 70, 89, 81, 85, 82, 86, 84, 88, 90, 39, 6) and i.dInv = '2023-02-09' and p.cBookType NOT IN ('SNP', 'AGT') and i.iInventory > 0 order by i.dInv DESC LIMIT 1
select p.iPax, p.iPackageID, p.vName, i.fRate, p.vInclusion, i.iChips, i.iNNPC, i.iMPC, i.iInventory, p.vShortDesc, p.vChoiceOfLiquor, p.cType, i.dInv from package p left join inventory i on p.iPackageID = i.iPackageID where i.iPackageID = '76' and (p.cStatus = 'A' and i.cStatus = 'A') and p.iPackageID NOT IN(45, 46, 47, 48, 49, 50, 71, 70, 89, 81, 85, 82, 86, 84, 88, 90, 39, 6) and i.dInv = '2023-02-09' and p.cBookType NOT IN ('SNP', 'AGT') and i.iInventory > 0 order by i.dInv DESC LIMIT 1
select p.iPax, p.iPackageID, p.vName, i.fRate, p.vInclusion, i.iChips, i.iNNPC, i.iMPC, i.iInventory, p.vShortDesc, p.vChoiceOfLiquor, p.cType, i.dInv from package p left join inventory i on p.iPackageID = i.iPackageID where i.iPackageID = '78' and (p.cStatus = 'A' and i.cStatus = 'A') and p.iPackageID NOT IN(45, 46, 47, 48, 49, 50, 71, 70, 89, 81, 85, 82, 86, 84, 88, 90, 39, 6) and i.dInv = '2023-02-09' and p.cBookType NOT IN ('SNP', 'AGT') and i.iInventory > 0 order by i.dInv DESC LIMIT 1
select p.iPax, p.iPackageID, p.vName, i.fRate, p.vInclusion, i.iChips, i.iNNPC, i.iMPC, i.iInventory, p.vShortDesc, p.vChoiceOfLiquor, p.cType, i.dInv from package p left join inventory i on p.iPackageID = i.iPackageID where i.iPackageID = '79' and (p.cStatus = 'A' and i.cStatus = 'A') and p.iPackageID NOT IN(45, 46, 47, 48, 49, 50, 71, 70, 89, 81, 85, 82, 86, 84, 88, 90, 39, 6) and i.dInv = '2023-02-09' and p.cBookType NOT IN ('SNP', 'AGT') and i.iInventory > 0 order by i.dInv DESC LIMIT 1
select p.iPax, p.iPackageID, p.vName, i.fRate, p.vInclusion, i.iChips, i.iNNPC, i.iMPC, i.iInventory, p.vShortDesc, p.vChoiceOfLiquor, p.cType, i.dInv from package p left join inventory i on p.iPackageID = i.iPackageID where i.iPackageID = '80' and (p.cStatus = 'A' and i.cStatus = 'A') and p.iPackageID NOT IN(45, 46, 47, 48, 49, 50, 71, 70, 89, 81, 85, 82, 86, 84, 88, 90, 39, 6) and i.dInv = '2023-02-09' and p.cBookType NOT IN ('SNP', 'AGT') and i.iInventory > 0 order by i.dInv DESC LIMIT 1
select p.iPax, p.iPackageID, p.vName, i.fRate, p.vInclusion, i.iChips, i.iNNPC, i.iMPC, i.iInventory, p.vShortDesc, p.vChoiceOfLiquor, p.cType, i.dInv from package p left join inventory i on p.iPackageID = i.iPackageID where i.iPackageID = '85' and (p.cStatus = 'A' and i.cStatus = 'A') and p.iPackageID NOT IN(45, 46, 47, 48, 49, 50, 71, 70, 89, 81, 85, 82, 86, 84, 88, 90, 39, 6) and i.dInv = '2023-02-09' and p.cBookType NOT IN ('SNP', 'AGT') and i.iInventory > 0 order by i.dInv DESC LIMIT 1
select p.iPax, p.iPackageID, p.vName, i.fRate, p.vInclusion, i.iChips, i.iNNPC, i.iMPC, i.iInventory, p.vShortDesc, p.vChoiceOfLiquor, p.cType, i.dInv from package p left join inventory i on p.iPackageID = i.iPackageID where i.iPackageID = '81' and (p.cStatus = 'A' and i.cStatus = 'A') and p.iPackageID NOT IN(45, 46, 47, 48, 49, 50, 71, 70, 89, 81, 85, 82, 86, 84, 88, 90, 39, 6) and i.dInv = '2023-02-09' and p.cBookType NOT IN ('SNP', 'AGT') and i.iInventory > 0 order by i.dInv DESC LIMIT 1
select p.iPax, p.iPackageID, p.vName, i.fRate, p.vInclusion, i.iChips, i.iNNPC, i.iMPC, i.iInventory, p.vShortDesc, p.vChoiceOfLiquor, p.cType, i.dInv from package p left join inventory i on p.iPackageID = i.iPackageID where i.iPackageID = '86' and (p.cStatus = 'A' and i.cStatus = 'A') and p.iPackageID NOT IN(45, 46, 47, 48, 49, 50, 71, 70, 89, 81, 85, 82, 86, 84, 88, 90, 39, 6) and i.dInv = '2023-02-09' and p.cBookType NOT IN ('SNP', 'AGT') and i.iInventory > 0 order by i.dInv DESC LIMIT 1
select p.iPax, p.iPackageID, p.vName, i.fRate, p.vInclusion, i.iChips, i.iNNPC, i.iMPC, i.iInventory, p.vShortDesc, p.vChoiceOfLiquor, p.cType, i.dInv from package p left join inventory i on p.iPackageID = i.iPackageID where i.iPackageID = '82' and (p.cStatus = 'A' and i.cStatus = 'A') and p.iPackageID NOT IN(45, 46, 47, 48, 49, 50, 71, 70, 89, 81, 85, 82, 86, 84, 88, 90, 39, 6) and i.dInv = '2023-02-09' and p.cBookType NOT IN ('SNP', 'AGT') and i.iInventory > 0 order by i.dInv DESC LIMIT 1
select p.iPax, p.iPackageID, p.vName, i.fRate, p.vInclusion, i.iChips, i.iNNPC, i.iMPC, i.iInventory, p.vShortDesc, p.vChoiceOfLiquor, p.cType, i.dInv from package p left join inventory i on p.iPackageID = i.iPackageID where i.iPackageID = '39' and (p.cStatus = 'A' and i.cStatus = 'A') and p.iPackageID NOT IN(45, 46, 47, 48, 49, 50, 71, 70, 89, 81, 85, 82, 86, 84, 88, 90, 39, 6) and i.dInv = '2023-02-09' and p.cBookType NOT IN ('SNP', 'AGT') and i.iInventory > 0 order by i.dInv DESC LIMIT 1
select p.iPax, p.iPackageID, p.vName, i.fRate, p.vInclusion, i.iChips, i.iNNPC, i.iMPC, i.iInventory, p.vShortDesc, p.vChoiceOfLiquor, p.cType, i.dInv from package p left join inventory i on p.iPackageID = i.iPackageID where i.iPackageID = '6' and (p.cStatus = 'A' and i.cStatus = 'A') and p.iPackageID NOT IN(45, 46, 47, 48, 49, 50, 71, 70, 89, 81, 85, 82, 86, 84, 88, 90, 39, 6) and i.dInv = '2023-02-09' and p.cBookType NOT IN ('SNP', 'AGT') and i.iInventory > 0 order by i.dInv DESC LIMIT 1
select p.iPax, p.iPackageID, p.vName, i.fRate, p.vInclusion, i.iChips, i.iNNPC, i.iMPC, i.iInventory, p.vShortDesc, p.vChoiceOfLiquor, p.cType, i.dInv from package p left join inventory i on p.iPackageID = i.iPackageID where i.iPackageID = '121' and (p.cStatus = 'A' and i.cStatus = 'A') and p.iPackageID NOT IN(45, 46, 47, 48, 49, 50, 71, 70, 89, 81, 85, 82, 86, 84, 88, 90, 39, 6) and i.dInv = '2023-02-09' and p.cBookType NOT IN ('SNP', 'AGT') and i.iInventory > 0 order by i.dInv DESC LIMIT 1
select p.iPax, p.iPackageID, p.vName, i.fRate, p.vInclusion, i.iChips, i.iNNPC, i.iMPC, i.iInventory, p.vShortDesc, p.vChoiceOfLiquor, p.cType, i.dInv from package p left join inventory i on p.iPackageID = i.iPackageID where i.iPackageID = '123' and (p.cStatus = 'A' and i.cStatus = 'A') and p.iPackageID NOT IN(45, 46, 47, 48, 49, 50, 71, 70, 89, 81, 85, 82, 86, 84, 88, 90, 39, 6) and i.dInv = '2023-02-09' and p.cBookType NOT IN ('SNP', 'AGT') and i.iInventory > 0 order by i.dInv DESC LIMIT 1
select p.iPax, p.iPackageID, p.vName, i.fRate, p.vInclusion, i.iChips, i.iNNPC, i.iMPC, i.iInventory, p.vShortDesc, p.vChoiceOfLiquor, p.cType, i.dInv from package p left join inventory i on p.iPackageID = i.iPackageID where i.iPackageID = '108' and (p.cStatus = 'A' and i.cStatus = 'A') and p.iPackageID NOT IN(45, 46, 47, 48, 49, 50, 71, 70, 89, 81, 85, 82, 86, 84, 88, 90, 39, 6) and i.dInv = '2023-02-09' and p.cBookType NOT IN ('SNP', 'AGT') and i.iInventory > 0 order by i.dInv DESC LIMIT 1
select p.iPax, p.iPackageID, p.vName, i.fRate, p.vInclusion, i.iChips, i.iNNPC, i.iMPC, i.iInventory, p.vShortDesc, p.vChoiceOfLiquor, p.cType, i.dInv from package p left join inventory i on p.iPackageID = i.iPackageID where i.iPackageID = '110' and (p.cStatus = 'A' and i.cStatus = 'A') and p.iPackageID NOT IN(45, 46, 47, 48, 49, 50, 71, 70, 89, 81, 85, 82, 86, 84, 88, 90, 39, 6) and i.dInv = '2023-02-09' and p.cBookType NOT IN ('SNP', 'AGT') and i.iInventory > 0 order by i.dInv DESC LIMIT 1
select p.iPax, p.iPackageID, p.vName, i.fRate, p.vInclusion, i.iChips, i.iNNPC, i.iMPC, i.iInventory, p.vShortDesc, p.vChoiceOfLiquor, p.cType, i.dInv from package p left join inventory i on p.iPackageID = i.iPackageID where i.iPackageID = '115' and (p.cStatus = 'A' and i.cStatus = 'A') and p.iPackageID NOT IN(45, 46, 47, 48, 49, 50, 71, 70, 89, 81, 85, 82, 86, 84, 88, 90, 39, 6) and i.dInv = '2023-02-09' and p.cBookType NOT IN ('SNP', 'AGT') and i.iInventory > 0 order by i.dInv DESC LIMIT 1
select p.iPax, p.iPackageID, p.vName, i.fRate, p.vInclusion, i.iChips, i.iNNPC, i.iMPC, i.iInventory, p.vShortDesc, p.vChoiceOfLiquor, p.cType, i.dInv from package p left join inventory i on p.iPackageID = i.iPackageID where i.iPackageID = '150' and (p.cStatus = 'A' and i.cStatus = 'A') and p.iPackageID NOT IN(45, 46, 47, 48, 49, 50, 71, 70, 89, 81, 85, 82, 86, 84, 88, 90, 39, 6) and i.dInv = '2023-02-09' and p.cBookType NOT IN ('SNP', 'AGT') and i.iInventory > 0 order by i.dInv DESC LIMIT 1
select p.iPax, p.iPackageID, p.vName, i.fRate, p.vInclusion, i.iChips, i.iNNPC, i.iMPC, i.iInventory, p.vShortDesc, p.vChoiceOfLiquor, p.cType, i.dInv from package p left join inventory i on p.iPackageID = i.iPackageID where i.iPackageID = '151' and (p.cStatus = 'A' and i.cStatus = 'A') and p.iPackageID NOT IN(45, 46, 47, 48, 49, 50, 71, 70, 89, 81, 85, 82, 86, 84, 88, 90, 39, 6) and i.dInv = '2023-02-09' and p.cBookType NOT IN ('SNP', 'AGT') and i.iInventory > 0 order by i.dInv DESC LIMIT 1
select p.iPax, p.iPackageID, p.vName, i.fRate, p.vInclusion, i.iChips, i.iNNPC, i.iMPC, i.iInventory, p.vShortDesc, p.vChoiceOfLiquor, p.cType, i.dInv from package p left join inventory i on p.iPackageID = i.iPackageID where i.iPackageID = '152' and (p.cStatus = 'A' and i.cStatus = 'A') and p.iPackageID NOT IN(45, 46, 47, 48, 49, 50, 71, 70, 89, 81, 85, 82, 86, 84, 88, 90, 39, 6) and i.dInv = '2023-02-09' and p.cBookType NOT IN ('SNP', 'AGT') and i.iInventory > 0 order by i.dInv DESC LIMIT 1
select p.iPax, p.iPackageID, p.vName, i.fRate, p.vInclusion, i.iChips, i.iNNPC, i.iMPC, i.iInventory, p.vShortDesc, p.vChoiceOfLiquor, p.cType, i.dInv from package p left join inventory i on p.iPackageID = i.iPackageID where i.iPackageID = '92' and (p.cStatus = 'A' and i.cStatus = 'A') and p.iPackageID NOT IN(45, 46, 47, 48, 49, 50, 71, 70, 89, 81, 85, 82, 86, 84, 88, 90, 39, 6) and i.dInv = '2023-02-09' and p.cBookType NOT IN ('SNP', 'AGT') and i.iInventory > 0 order by i.dInv DESC LIMIT 1
select p.iPax, p.iPackageID, p.vName, i.fRate, p.vInclusion, i.iChips, i.iNNPC, i.iMPC, i.iInventory, p.vShortDesc, p.vChoiceOfLiquor, p.cType, i.dInv from package p left join inventory i on p.iPackageID = i.iPackageID where i.iPackageID = '129' and (p.cStatus = 'A' and i.cStatus = 'A') and p.iPackageID NOT IN(45, 46, 47, 48, 49, 50, 71, 70, 89, 81, 85, 82, 86, 84, 88, 90, 39, 6) and i.dInv = '2023-02-09' and p.cBookType NOT IN ('SNP', 'AGT') and i.iInventory > 0 order by i.dInv DESC LIMIT 1
select p.iPax, p.iPackageID, p.vName, i.fRate, p.vInclusion, i.iChips, i.iNNPC, i.iMPC, i.iInventory, p.vShortDesc, p.vChoiceOfLiquor, p.cType, i.dInv from package p left join inventory i on p.iPackageID = i.iPackageID where i.iPackageID = '130' and (p.cStatus = 'A' and i.cStatus = 'A') and p.iPackageID NOT IN(45, 46, 47, 48, 49, 50, 71, 70, 89, 81, 85, 82, 86, 84, 88, 90, 39, 6) and i.dInv = '2023-02-09' and p.cBookType NOT IN ('SNP', 'AGT') and i.iInventory > 0 order by i.dInv DESC LIMIT 1
select p.iPax, p.iPackageID, p.vName, i.fRate, p.vInclusion, i.iChips, i.iNNPC, i.iMPC, i.iInventory, p.vShortDesc, p.vChoiceOfLiquor, p.cType, i.dInv from package p left join inventory i on p.iPackageID = i.iPackageID where i.iPackageID = '77' and (p.cStatus = 'A' and i.cStatus = 'A') and p.iPackageID NOT IN(45, 46, 47, 48, 49, 50, 71, 70, 89, 81, 85, 82, 86, 84, 88, 90, 39, 6) and i.dInv = '2023-02-09' and p.cBookType NOT IN ('SNP', 'AGT') and i.iInventory > 0 order by i.dInv DESC LIMIT 1
select p.iPax, p.iPackageID, p.vName, i.fRate, p.vInclusion, i.iChips, i.iNNPC, i.iMPC, i.iInventory, p.vShortDesc, p.vChoiceOfLiquor, p.cType, i.dInv from package p left join inventory i on p.iPackageID = i.iPackageID where i.iPackageID = '91' and (p.cStatus = 'A' and i.cStatus = 'A') and p.iPackageID NOT IN(45, 46, 47, 48, 49, 50, 71, 70, 89, 81, 85, 82, 86, 84, 88, 90, 39, 6) and i.dInv = '2023-02-09' and p.cBookType NOT IN ('SNP', 'AGT') and i.iInventory > 0 order by i.dInv DESC LIMIT 1
select p.iPax, p.iPackageID, p.vName, i.fRate, p.vInclusion, i.iChips, i.iNNPC, i.iMPC, i.iInventory, p.vShortDesc, p.vChoiceOfLiquor, p.cType, i.dInv from package p left join inventory i on p.iPackageID = i.iPackageID where i.iPackageID = '117' and (p.cStatus = 'A' and i.cStatus = 'A') and p.iPackageID NOT IN(45, 46, 47, 48, 49, 50, 71, 70, 89, 81, 85, 82, 86, 84, 88, 90, 39, 6) and i.dInv = '2023-02-09' and p.cBookType NOT IN ('SNP', 'AGT') and i.iInventory > 0 order by i.dInv DESC LIMIT 1
select p.iPax, p.iPackageID, p.vName, i.fRate, p.vInclusion, i.iChips, i.iNNPC, i.iMPC, i.iInventory, p.vShortDesc, p.vChoiceOfLiquor, p.cType, i.dInv from package p left join inventory i on p.iPackageID = i.iPackageID where i.iPackageID = '144' and (p.cStatus = 'A' and i.cStatus = 'A') and p.iPackageID NOT IN(45, 46, 47, 48, 49, 50, 71, 70, 89, 81, 85, 82, 86, 84, 88, 90, 39, 6) and i.dInv = '2023-02-09' and p.cBookType NOT IN ('SNP', 'AGT') and i.iInventory > 0 order by i.dInv DESC LIMIT 1
select p.iPax, p.iPackageID, p.vName, i.fRate, p.vInclusion, i.iChips, i.iNNPC, i.iMPC, i.iInventory, p.vShortDesc, p.vChoiceOfLiquor, p.cType, i.dInv from package p left join inventory i on p.iPackageID = i.iPackageID where i.iPackageID = '149' and (p.cStatus = 'A' and i.cStatus = 'A') and p.iPackageID NOT IN(45, 46, 47, 48, 49, 50, 71, 70, 89, 81, 85, 82, 86, 84, 88, 90, 39, 6) and i.dInv = '2023-02-09' and p.cBookType NOT IN ('SNP', 'AGT') and i.iInventory > 0 order by i.dInv DESC LIMIT 1
select p.iPax, p.iPackageID, p.vName, i.fRate, p.vInclusion, i.iChips, i.iNNPC, i.iMPC, i.iInventory, p.vShortDesc, p.vChoiceOfLiquor, p.cType, i.dInv from package p left join inventory i on p.iPackageID = i.iPackageID where i.iPackageID = '8' and (p.cStatus = 'A' and i.cStatus = 'A') and p.iPackageID NOT IN(45, 46, 47, 48, 49, 50, 71, 70, 89, 81, 85, 82, 86, 84, 88, 90, 39, 6) and i.dInv = '2023-02-09' and p.cBookType NOT IN ('SNP', 'AGT') and i.iInventory > 0 order by i.dInv DESC LIMIT 1
select p.iPax, p.iPackageID, p.vName, i.fRate, p.vInclusion, i.iChips, i.iNNPC, i.iMPC, i.iInventory, p.vShortDesc, p.vChoiceOfLiquor, p.cType, i.dInv from package p left join inventory i on p.iPackageID = i.iPackageID where i.iPackageID = '25' and (p.cStatus = 'A' and i.cStatus = 'A') and p.iPackageID NOT IN(45, 46, 47, 48, 49, 50, 71, 70, 89, 81, 85, 82, 86, 84, 88, 90, 39, 6) and i.dInv = '2023-02-09' and p.cBookType NOT IN ('SNP', 'AGT') and i.iInventory > 0 order by i.dInv DESC LIMIT 1
select p.iPax, p.iPackageID, p.vName, i.fRate, p.vInclusion, i.iChips, i.iNNPC, i.iMPC, i.iInventory, p.vShortDesc, p.vChoiceOfLiquor, p.cType, i.dInv from package p left join inventory i on p.iPackageID = i.iPackageID where i.iPackageID = '24' and (p.cStatus = 'A' and i.cStatus = 'A') and p.iPackageID NOT IN(45, 46, 47, 48, 49, 50, 71, 70, 89, 81, 85, 82, 86, 84, 88, 90, 39, 6) and i.dInv = '2023-02-09' and p.cBookType NOT IN ('SNP', 'AGT') and i.iInventory > 0 order by i.dInv DESC LIMIT 1
select p.iPax, p.iPackageID, p.vName, i.fRate, p.vInclusion, i.iChips, i.iNNPC, i.iMPC, i.iInventory, p.vShortDesc, p.vChoiceOfLiquor, p.cType, i.dInv from package p left join inventory i on p.iPackageID = i.iPackageID where i.iPackageID = '90' and (p.cStatus = 'A' and i.cStatus = 'A') and p.iPackageID NOT IN(45, 46, 47, 48, 49, 50, 71, 70, 89, 81, 85, 82, 86, 84, 88, 90, 39, 6) and i.dInv = '2023-02-09' and p.cBookType NOT IN ('SNP', 'AGT') and i.iInventory > 0 order by i.dInv DESC LIMIT 1
select p.iPax, p.iPackageID, p.vName, i.fRate, p.vInclusion, i.iChips, i.iNNPC, i.iMPC, i.iInventory, p.vShortDesc, p.vChoiceOfLiquor, p.cType, i.dInv from package p left join inventory i on p.iPackageID = i.iPackageID where i.iPackageID = '89' and (p.cStatus = 'A' and i.cStatus = 'A') and p.iPackageID NOT IN(45, 46, 47, 48, 49, 50, 71, 70, 89, 81, 85, 82, 86, 84, 88, 90, 39, 6) and i.dInv = '2023-02-09' and p.cBookType NOT IN ('SNP', 'AGT') and i.iInventory > 0 order by i.dInv DESC LIMIT 1
select p.iPax, p.iPackageID, p.vName, i.fRate, p.vInclusion, i.iChips, i.iNNPC, i.iMPC, i.iInventory, p.vShortDesc, p.vChoiceOfLiquor, p.cType, i.dInv from package p left join inventory i on p.iPackageID = i.iPackageID where i.iPackageID = '112' and (p.cStatus = 'A' and i.cStatus = 'A') and p.iPackageID NOT IN(45, 46, 47, 48, 49, 50, 71, 70, 89, 81, 85, 82, 86, 84, 88, 90, 39, 6) and i.dInv = '2023-02-09' and p.cBookType NOT IN ('SNP', 'AGT') and i.iInventory > 0 order by i.dInv DESC LIMIT 1
Live
Entertainment
One time Play
Coupons
Unlimited Buffet
Imported Drinks
Access to Whisky’s
Lounge
Access to VIP
Gaming Floor
Avail this exclusive one-time GAMING OFFER and get a coupon of higher amount by paying less.
So, what’s the Gaming Offer?
DELTIN ROYALE, GOA: Pay ₹500 and get Non-negotiable Playing Coupons worth 2000 on online booking of Regular, Premium & VIP Package
DELTIN DENZONG, SIKKIM: Pay additional ₹500 and get Non-negotiable Playing Coupons worth 1500 on online booking of Regular, Premium & VIP Package
DELTIN SUITES HOTEL CASINO, GOA: Pay ₹500 and get Non-negotiable Playing Coupons worth 1000
DELTIN ZURI, GOA: Pay ₹500 and get non-negotiable playing coupons worth 2000 or choose the Double Dhamaka offers, where you not only pay less & get non-negotiable playing coupons of a higher amount but also receive Weekly & Mega Draw tickets.
DELTIN JAQK, GOA: Book online and get a 500 Non-negotiable Playing Coupon with each package (without paying any additional amount)
DELTIN GOLD, GOA: Pay ₹500 and get Non-negotiable Playing Coupons worth 1500 on online booking of Premium & VIP Package
This is an optional offer. Visit the Cashier's Desk at the casino to redeem the offer attached to your package.
Please Note: Non-negotiable coupons can be played on all games except Electronic Roulette Machine & Slots. Non-negotiable coupons can be played till the guest loses the wager (reusable). Non-negotiable coupons are non-cashable. Non-negotiable coupons will be in the denomination of 500 and cannot be broken down into lower denominations.
Catch the ultimate live entertainment starting 09:00 PM onwards, featuring Bollywood & International dance acts, talented line up of musicians, DJs and bands who play various genres. We also have a mix & mingle magician and an assortment of live acts to please any age group.
Dine at our restaurant and savour buffet dinner 08:00 PM onwards. A delicious start with delectable appetizers ends with desserts that round up your meal.
Enjoy unlimited rounds of alcoholic and non-alcoholic drinks. Our extensive drinks menu includes cocktail, beer, wine, whisky, vodka, rum and exquisite single malts. Choose a package with your choice of drinks.
LUCKY DRAW SEASON AT DELTIN ZURI
Get lucky every Sunday, starting with the first weekly draw on the 23rd of October till the 31st of December. We are giving away OTPCs worth 2 Lakhs every week.
Also, win a BMW Bike, iPhone 14, Tag Heuer watch, and Samsung A53 5G phones in the Mega Draw on the 31st of December.
Book your package online and visit the front desk at the casino to choose the Double Dhamaka offers, where you not only pay less & get non-negotiable playing coupons of a higher amount but also receive Weekly & Mega Draw tickets.
T&C apply.
Stay up to date with our latest offers, events, tournaments and much more.
Thank you for subscribing to our newsletter.