SELECT num \xd\xa\x9\x9\x9\x9\x9FROM ( \xd\xa\x9\x9\x9\x9\x9\x9SELECT '1' AS num \xd\xa\x9\x9\x9\x9\x9\x9UNION ALL \xd\xa\x9\x9\x9\x9\x9\x9SELECT '2' \xd\xa\x9\x9\x9\x9\x9\x9UNION ALL \xd\xa\x9\x9\x9\x9\x9\x9SELECT '3' \xd\xa\x9\x9\x9\x9\x9\x9UNION ALL \xd\xa\x9\x9\x9\x9\x9\x9SELECT '4' \xd\xa\x9\x9\x9\x9\x9\x9UNION ALL \xd\xa\x9\x9\x9\x9\x9\x9SELECT '5' \xd\xa\x9\x9\x9\x9\x9\x9UNION ALL \xd\xa\x9\x9\x9\x9\x9\x9SELECT '6' \xd\xa\x9\x9\x9\x9\x9) AS numbers \xd\xa\x9\x9\x9\x9\x9WHERE num NOT IN ( \xd\xa\x9\x9\x9\x9\x9\x9SELECT '1' WHERE EXISTS (SELECT 1 FROM bajikattuttate_kemuru WHERE ojana LIKE '%1%' AND (prakar = '9' OR prakar = '10' OR prakar = '4') AND byabaharkarta NOT IN (SELECT balakedara FROM `demo` WHERE `sthiti`='1') AND kalaparichaya = ".$samasyesreni['atadaaidi']."
) \xd\xa\x9\x9\x9\x9\x9\x9UNION ALL \xd\xa\x9\x9\x9\x9\x9\x9SELECT '2' WHERE EXISTS (SELECT 1 FROM bajikattuttate_kemuru WHERE ojana LIKE '%2%' AND (prakar = '9' OR prakar = '10' OR prakar = '4') AND byabaharkarta NOT IN (SELECT balakedara FROM `demo` WHERE `sthiti`='1') AND kalaparichaya = ".$samasyesreni['atadaaidi']."
) \xd\xa\x9\x9\x9\x9\x9\x9UNION ALL \xd\xa\x9\x9\x9\x9\x9\x9SELECT '3' WHERE EXISTS (SELECT 1 FROM bajikattuttate_kemuru WHERE ojana LIKE '%3%' AND (prakar = '9' OR prakar = '10' OR prakar = '4') AND byabaharkarta NOT IN (SELECT balakedara FROM `demo` WHERE `sthiti`='1') AND kalaparichaya = ".$samasyesreni['atadaaidi'].")
UNION ALL
SELECT '4' WHERE EXISTS (SELECT 1 FROM bajikattuttate_kemuru WHERE ojana LIKE '%4%' AND (prakar = '9' OR prakar = '10' OR prakar = '4') AND byabaharkarta NOT IN (SELECT balakedara FROM `demo` WHERE `sthiti`='1') AND kalaparichaya = ".$samasyesreni['atadaaidi'].")
UNION ALL
SELECT '5' WHERE EXISTS (SELECT 1 FROM bajikattuttate_kemuru WHERE ojana LIKE '%5%' AND (prakar = '9' OR prakar = '10' OR prakar = '4') AND byabaharkarta NOT IN (SELECT balakedara FROM `demo` WHERE `sthiti`='1') AND kalaparichaya = ".$samasyesreni['atadaaidi'].")
UNION ALL
SELECT '6' WHERE EXISTS (SELECT 1 FROM bajikattuttate_kemuru WHERE ojana LIKE '%6%' AND (prakar = '9' OR prakar = '10' OR prakar = '4') AND byabaharkarta NOT IN (SELECT balakedara FROM `demo` WHERE `sthiti`='1') AND kalaparichaya = ".$samasyesreni['atadaaidi'].")
)
SELECT num \xd\xa\x9\x9\x9\x9ROM ( \xd\xa\x9\x9\x9\x9\x9\x9SELECT '1' AS num \xd\xa\x9\x9\x9\x9\x9\x9UNION ALL \xd\xa\x9\x9\x9\x9\x9\x9SELECT '2' \xd\xa\x9\x9\x9\x9\x9\x9UNION ALL \xd\xa\x9\x9\x9\x9\x9\x9SELECT '3' \xd\xa\x9\x9\x9\x9\x9\x9UNION ALL \xd\xa\x9\x9\x9\x9\x9\x9SELECT '4' \xd\xa\x9\x9\x9\x9\x9\x9UNION ALL \xd\xa\x9\x9\x9\x9\x9\x9SELECT '5' \xd\xa\x9\x9\x9\x9\x9\x9UNION ALL \xd\xa\x9\x9\x9\x9\x9\x9SELECT '6' \xd\xa\x9\x9\x9\x9\x9) AS numbers \xd\xa\x9\x9\x9\x9\x9WHERE num NOT IN ( \xd\xa\x9\x9\x9\x9\x9\x9SELECT '1' WHERE EXISTS (SELECT 1 FROM bajikattuttate_kemuru WHERE ojana LIKE '%1%' AND (prakar = '9' OR prakar = '10' OR prakar = '4') AND byabaharkarta NOT IN (SELECT balakedara FROM `demo` WHERE `sthiti`='1') AND kalaparichaya = ".$samasyesreni['atadaaidi']."
) \xd\xa\x9\x9\x9\x9\x9\x9UNION ALL \xd\xa\x9\x9\x9\x9\x9\x9SELECT '2' WHERE EXISTS (SELECT 1 FROM bajikattuttate_kemuru WHERE ojana LIKE '%2%' AND (prakar = '9' OR prakar = '10' OR prakar = '4') AND byabaharkarta NOT IN (SELECT balakedara FROM `demo` WHERE `sthiti`='1') AND kalaparichaya = ".$samasyesreni['atadaaidi']."
) \xd\xa\x9\x9\x9\x9\x9\x9UNION ALL \xd\xa\x9\x9\x9\x9\x9\x9SELECT '3' WHERE EXISTS (SELECT 1 FROM bajikattuttate_kemuru WHERE ojana LIKE '%3%' AND (prakar = '9' OR prakar = '10' OR prakar = '4') AND byabaharkarta NOT IN (SELECT balakedara FROM `demo` WHERE `sthiti`='1') AND kalaparichaya = ".$samasyesreni['atadaaidi'].")
UNION ALL
SELECT '4' WHERE EXISTS (SELECT 1 FROM bajikattuttate_kemuru WHERE ojana LIKE '%4%' AND (prakar = '9' OR prakar = '10' OR prakar = '4') AND byabaharkarta NOT IN (SELECT balakedara FROM `demo` WHERE `sthiti`='1') AND kalaparichaya = ".$samasyesreni['atadaaidi'].")
UNION ALL
SELECT '5' WHERE EXISTS (SELECT 1 FROM bajikattuttate_kemuru WHERE ojana LIKE '%5%' AND (prakar = '9' OR prakar = '10' OR prakar = '4') AND byabaharkarta NOT IN (SELECT balakedara FROM `demo` WHERE `sthiti`='1') AND kalaparichaya = ".$samasyesreni['atadaaidi'].")
UNION ALL
SELECT '6' WHERE EXISTS (SELECT 1 FROM bajikattuttate_kemuru WHERE ojana LIKE '%6%' AND (prakar = '9' OR prakar = '10' OR prakar = '4') AND byabaharkarta NOT IN (SELECT balakedara FROM `demo` WHERE `sthiti`='1') AND kalaparichaya = ".$samasyesreni['atadaaidi'].")
)
© 2023 Quttera Ltd. All rights reserved.