SELECT\xd\xa\x9\x9\x9\x9SUM(CASE WHEN INSTR(ojana, '3') AND INSTR(prakar, '1') THEN ketebida ELSE 0 END) AS ojana_3_misana,\xd\xa\x9\x9\x9\x9SUM(CASE WHEN INSTR(ojana, '4') AND INSTR(prakar, '1') THEN ketebida ELSE 0 END) AS ojana_4_misana,\xd\xa\x9\x9\x9\x9SUM(CASE WHEN INSTR(ojana, '5') AND INSTR(prakar, '1') THEN ketebida ELSE 0 END) AS ojana_5_misana,\xd\xa\x9\x9\x9\x9SUM(CASE WHEN INSTR(ojana, '6') AND INSTR(prakar, '1') THEN ketebida ELSE 0 END) AS ojana_6_misana,\xd\xa\x9\x9\x9\x9SUM(CASE WHEN INSTR(ojana, '7') AND INSTR(prakar, '1') THEN ketebida ELSE 0 END) AS ojana_7_misana,\xd\xa\x9\x9\x9\x9SUM(CASE WHEN INSTR(ojana, '8') AND INSTR(prakar, '1') THEN ketebida ELSE 0 END) AS ojana_8_misana,\xd\xa\x9\x9\x9\x9SUM(CASE WHEN INSTR(ojana, '9') AND INSTR(prakar, '1') THEN ketebida ELSE 0 END) AS ojana_9_misana,\xd\xa\x9\x9\x9\x9SUM(CASE WHEN INSTR(ojana, '10') AND INSTR(prakar, '1') THEN ketebida ELSE 0 END) AS ojana_10_misana,\xd\xa\x9\x9\x9\x9SUM(CASE WHEN INSTR(ojana, '11') AND INSTR(prakar, '1') THEN ketebida ELSE 0 END) AS ojana_11_misana,\xd\xa\x9\x9\x9\x9SUM(CASE WHEN INSTR(ojana, '12') AND INSTR(prakar, '1') THEN ketebida ELSE 0 END) AS ojana_12_misana,\xd\xa\x9\x9\x9\x9SUM(CASE WHEN INSTR(ojana, '13') AND INSTR(prakar, '1') THEN ketebida ELSE 0 END) AS ojana_13_misana,\xd\xa\x9\x9\x9\x9SUM(CASE WHEN INSTR(ojana, '14') AND INSTR(prakar, '1') THEN ketebida ELSE 0 END) AS ojana_14_misana,\xd\xa\x9\x9\x9\x9SUM(CASE WHEN INSTR(ojana, '15') AND INSTR(prakar, '1') THEN ketebida ELSE 0 END) AS ojana_15_misana,\xd\xa\x9\x9\x9\x9SUM(CASE WHEN INSTR(ojana, '16') AND INSTR(prakar, '1') THEN ketebida ELSE 0 END) AS ojana_16_misana,\xd\xa\x9\x9\x9\x9SUM(CASE WHEN INSTR(ojana, '17') AND INSTR(prakar, '1') THEN ketebida ELSE 0 END) AS ojana_17_misana,\xd\xa\x9\x9\x9\x9SUM(CASE WHEN INSTR(ojana, '18') AND INSTR(prakar, '1') THEN ketebida ELSE 0 END) AS ojana_18_misana,\xd\xa\x9\x9\x9\x9SUM(CASE WHEN INSTR(ojana, 'H') AND INSTR(prakar, '2') THEN ketebida ELSE 0 END) AS ojana_H_misana,\xd\xa\x9\x9\x9\x9SUM(CASE WHEN INSTR(ojana, 'L') AND INSTR(prakar, '2') THEN ketebida ELSE 0 END) AS ojana_L_misana,\xd\xa\x9\x9\x9\x9SUM(CASE WHEN INSTR(ojana, 'O') AND INSTR(prakar, '3') THEN ketebida ELSE 0 END) AS ojana_O_misana,\xd\xa\x9\x9\x9\x9SUM(CASE WHEN INSTR(ojana, 'E') AND INSTR(prakar, '3') THEN ketebida ELSE 0 END) AS ojana_E_misana,\xd\xa\x9\x9\x9\x9SUM(CASE WHEN prakar = 9 THEN ketebida ELSE 0 END) AS prakar_9_misana,\xd\xa\x9\x9\x9\x9SUM(CASE WHEN prakar = 10 THEN ketebida ELSE 0 END) AS prakar_10_misana,\xd\xa\x9\x9\x9\x9SUM(CASE WHEN prakar = 4 THEN ketebida ELSE 0 END) AS prakar_4_misana,\xd\xa\x9\x9\x9\x9SUM(CASE WHEN prakar = 7 THEN ketebida ELSE 0 END) AS prakar_7_misana,\xd\xa\x9\x9\x9\x9SUM(CASE WHEN prakar = 8 THEN ketebida ELSE 0 END) AS prakar_8_misana,\xd\xa\x9\x9\x9\x9SUM(CASE WHEN prakar = 6 THEN ketebida ELSE 0 END) AS prakar_6_misana,\xd\xa\x9\x9\x9\x9SUM(CASE WHEN prakar = 5 THEN ketebida ELSE 0 END) AS prakar_5_misana\xd\xa\x9\x9\x9\x9FROM bajikattuttate_kemuru_drei WHERE byabaharkarta NOT IN (SELECT balakedara FROM `demo` WHERE `sthiti`='1') AND kalaparichaya = ".$samasyesreni['atadaaidi']
SELECT\xd\xa\x9\x9\x9\x9SUM(CASE WHEN INSTR(ojana, '3') AND INSTR(prakar, '1') THEN ketebida ELSE 0 END) AS ojana_3_misana,\xd\xa\x9\x9\x9\x9SUM(CASE WHEN INSTR(ojana, '4') AND INSTR(prakar, '1') THEN ketebida ELSE 0 END) AS ojana_4_misana,\xd\xa\x9\x9\x9\x9SUM(CASE WHEN INSTR(ojana, '5') AND INSTR(prakar, '1') THEN ketebida ELSE 0 END) AS ojana_5_misana,\xd\xa\x9\x9\x9\x9SUM(CASE WHEN INSTR(ojana, '6') AND INSTR(prakar, '1') THEN ketebida ELSE 0 END) AS ojana_6_misana,\xd\xa\x9\x9\x9\x9SUM(CASE WHEN INSTR(ojana, '7') AND INSTR(prakar, '1') THEN ketebida ELSE 0 END) AS ojana_7_misana,\xd\xa\x9\x9\x9\x9SUM(CASE WHEN INSTR(ojana, '8') AND INSTR(prakar, '1') THEN ketebida ELSE 0 END) AS ojana_8_misana,\xd\xa\x9\x9\x9\x9SUM(CASE WHEN INSTR(ojana, '9') AND INSTR(prakar, '1') THEN ketebida ELSE 0 END) AS ojana_9_misana,\xd\xa\x9\x9\x9\x9SUM(CASE WHEN INSTR(ojana, '10') AND INSTR(prakar, '1') THEN ketebida ELSE 0 END) AS ojana_10_misana,\xd\xa\x9\x9\x9\x9SUM(CASE WHEN INSTR(ojana, '11') AND INSTR(prakar, '1') THEN ketebida ELSE 0 END) AS ojana_11_misana,\xd\xa\x9\x9\x9\x9SUM(CASE WHEN INSTR(ojana, '12') AND INSTR(prakar, '1') THEN ketebida ELSE 0 END) AS ojana_12_misana,\xd\xa\x9\x9\x9\x9SUM(CASE WHEN INSTR(ojana, '13') AND INSTR(prakar, '1') THEN ketebida ELSE 0 END) AS ojana_13_misana,\xd\xa\x9\x9\x9\x9SUM(CASE WHEN INSTR(ojana, '14') AND INSTR(prakar, '1') THEN ketebida ELSE 0 END) AS ojana_14_misana,\xd\xa\x9\x9\x9\x9SUM(CASE WHEN INSTR(ojana, '15') AND INSTR(prakar, '1') THEN ketebida ELSE 0 END) AS ojana_15_misana,\xd\xa\x9\x9\x9\x9SUM(CASE WHEN INSTR(ojana, '16') AND INSTR(prakar, '1') THEN ketebida ELSE 0 END) AS ojana_16_misana,\xd\xa\x9\x9\x9\x9SUM(CASE WHEN INSTR(ojana, '17') AND INSTR(prakar, '1') THEN ketebida ELSE 0 END) AS ojana_17_misana,\xd\xa\x9\x9\x9\x9SUM(CASE WHEN INSTR(ojana, '18') AND INSTR(prakar, '1') THEN ketebida ELSE 0 END) AS ojana_18_misana,\xd\xa\x9\x9\x9\x9SUM(CASE WHEN INSTR(ojana, 'H') AND INSTR(prakar, '2') THEN ketebida ELSE 0 END) AS ojana_H_misana,\xd\xa\x9\x9\x9\x9SUM(CASE WHEN INSTR(ojana, 'L') AND INSTR(prakar, '2') THEN ketebida ELSE 0 END) AS ojana_L_misana,\xd\xa\x9\x9\x9\x9SUM(CASE WHEN INSTR(ojana, 'O') AND INSTR(prakar, '3') THEN ketebida ELSE 0 END) AS ojana_O_misana,\xd\xa\x9\x9\x9\x9SUM(CASE WHEN INSTR(ojana, 'E') AND INSTR(prakar, '3') THEN ketebida ELSE 0 END) AS ojana_E_misana,\xd\xa\x9\x9\x9\x9SUM(CASE WHEN prakar = 9 THEN ketebida ELSE 0 END) AS prakar_9_misana,\xd\xa\x9\x9\x9\x9SUM(CASE WHEN prakar = 10 THEN ketebida ELSE 0 END) AS prakar_10_misana,\xd\xa\x9\x9\x9\x9SUM(CASE WHEN prakar = 4 THEN ketebida ELSE 0 END) AS prakar_4_misana,\xd\xa\x9\x9\x9\x9SUM(CASE WHEN prakar = 7 THEN ketebida ELSE 0 END) AS prakar_7_misana,\xd\xa\x9\x9\x9\x9SUM(CASE WHEN prakar = 8 THEN ketebida ELSE 0 END) AS prakar_8_misana,\xd\xa\x9\x9\x9\x9SUM(CASE WHEN prakar = 6 THEN ketebida ELSE 0 END) AS prakar_6_misana,\xd\xa\x9\x9\x9\x9SUM(CASE WHEN prakar = 5 THEN ketebida ELSE 0 END) AS prakar_5_misana\xd\xa\x9\x9\x9ROM bajikattuttate_kemuru_drei WHERE byabaharkarta NOT IN (SELECT balakedara FROM `demo` WHERE `sthiti`='1') AND kalaparichaya = ".$samasyesreni['atadaaidi']
© 2023 Quttera Ltd. All rights reserved.