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 = '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
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 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.
LOG IN WITH FACEBOOK
LOG IN WITH GOOGLE
