close ✕

Powered By

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 = '2022-10-07' 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 = '2022-10-07' 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 = '2022-10-07' 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 = '2022-10-07' 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 = '2022-10-07' 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 = '2022-10-07' 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 = '2022-10-07' 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 = '2022-10-07' 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 = '2022-10-07' 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 = '2022-10-07' 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 = '2022-10-07' 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 = '2022-10-07' 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 = '2022-10-07' 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 = '2022-10-07' 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 = '2022-10-07' 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 = '2022-10-07' 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 = '2022-10-07' 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 = '2022-10-07' 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 = '2022-10-07' 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 = '2022-10-07' 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 = '2022-10-07' 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 = '2022-10-07' 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 = '2022-10-07' 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 = '2022-10-07' 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 = '2022-10-07' 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 = '2022-10-07' 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 = '2022-10-07' 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 = '2022-10-07' 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 = '2022-10-07' 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 = '2022-10-07' 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 = '2022-10-07' 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 = '2022-10-07' 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 = '2022-10-07' 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 = '2022-10-07' 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 = '2022-10-07' 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 = '2022-10-07' 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 = '2022-10-07' 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 = '2022-10-07' 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 = '2022-10-07' 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 = '2022-10-07' 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 = '2022-10-07' 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 = '2022-10-07' 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 = '2022-10-07' 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 = '2022-10-07' 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 = '2022-10-07' 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 = '2022-10-07' 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 = '2022-10-07' 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 = '2022-10-07' 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 = '2022-10-07' 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 = '2022-10-07' 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 = '2022-10-07' 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 = '2022-10-07' 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 = '2022-10-07' 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 = '2022-10-07' 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 = '2022-10-07' 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 = '2022-10-07' 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 = '2022-10-07' 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 = '2022-10-07' 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 = '2022-10-07' 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 = '2022-10-07' 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 = '2022-10-07' 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 = '2022-10-07' 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

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 on online booking of packages

DELTIN JAQK, GOA: Book online and get a 500 Non-negotiable Playing Coupon with each package (without paying any additional amount)

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.

Stay up to date with our latest offers, events, tournaments and much more.

Thank you for subscribing to our newsletter.