close ✕

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

- Age – 0 to 4 years – Not Available
- Includes Feeder Boat Services, Unlimited Food, Unlimited Soft Beverages & Live Entertainment
- Special Gaming Offer is not applicable on this package
- No access to Gaming floor and SkyBar

AVAILABLE

4000

₹ 9,000

Live

Entertainment

One time Play

Coupons

Unlimited Buffet

Imported Drinks

Access to Whisky’s

Lounge

Access to VIP

Gaming Floor

- Single Malt*
- Sante Rita I20 Wine
- Baileys Irish Cream
- Black Label
- Yellow Tail Wine
- Kahlua
- Zampa Brut Soiree
- Energy Drink
- Ketel One
- Chandon Brut
- Grey Goose
- St Remy VSOP
- Dewar’s True Scotch 15 years
- House & Premium Brand Alcohol.

- Single Malt*
- Sante Rita I20 Wine
- Baileys Irish Cream
- Black Label
- Yellow Tail Wine
- Kahlua
- Zampa Brut Soiree
- Energy Drink
- Ketel One
- Chandon Brut
- Grey Goose
- St Remy VSOP
- Dewar’s True Scotch 15 years
- House & Premium Brand Alcohol.

- Single Malt*
- Sante Rita I20 Wine
- Baileys Irish Cream
- Black Label
- Yellow Tail Wine
- Kahlua
- Zampa Brut Soiree
- Energy Drink
- Ketel One
- Chandon Brut
- Grey Goose
- St Remy VSOP
- Dewar’s True Scotch 15 years
- House & Premium Brand Alcohol.

**Monday, Wednesday, Thursday:**₹7000 per adult with 6000 OTPC (Age: 21+)**Tuesday:**₹7000 per adult with 7000 OTPC (Age: 21+)**Friday, Saturday, Sunday:**₹8000 per adult with 7000 OTPC (Age: 21+)

- All bookings made through the Call Centre and Website are non – refundable.
- No change of booking date or cancellation is allowed within 24 hours of the visit date.
- One date change is allowed for a future date with applicable difference amount payable depending on weekday & weekend pricing and can only be done 24 hours before the booking date.
- If the booking is done for a weekend, but the reschedule date is a weekday refund will not be processed for the difference amount.
- Medical emergency will be considered for full refund and same has to be justified with relevant documents.
- For entry booked online or through the call center, no cancellations/refunds are allowed on blackout dates and special rates.
- No Cancellations/Refund or transfer of ticket will be processed in case of a no show.
- Refunds shall be processed in the same form of payment used to purchase the original ticket/package. Once an online refund request is generated, the same will be processed within 10 working days
- No refund can be processed if a guest utilizes their One-time play coupons or Match play coupons offered to them as part of their package.

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 23^{rd} of October till the 31^{st} 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 31^{st} 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.