SQL:select a.id,(SELECT count(id) FROM store_tnn_tw.StorePhoto WHERE sid=a.id) AS cnt from store_tnn_tw.StoreUserData as a where (( a.switch>0 && (a.cid=220) && ((hex(a.txt) like '%E4BD9BE8A1A3%')||(hex(a.txt) like '%E5AE97E69599%')||(hex(a.txt) like '%E69687E789A9%')||(hex(a.txt) like '%E4BD9BE585B7%')||(hex(a.txt) like '%E4BD9BE4BFB1%')))||( a.switch>0 && (a.cid=254||a.cid=220||a.cid=245) && ((hex(a.ta) like '%E99B95%')||(hex(a.ta) like '%E4BD9BE585B7%')||(hex(a.ta) like '%E9BE95%')||(hex(a.ta) like '%E4BD9BE4BFB1%')||(hex(a.ta) like '%E588BB%')||(hex(a.ta) like '%E4BD9BE5BA97%')))||( a.switch>0 && (a.cid=250||a.cid=220||a.cid=85) && ((hex(a.ta) like '%E7B693%')||(hex(a.ta) like '%E5AE97E69599E99FB3E6A882%')||(hex(a.ta) like '%E594B1E78987%')||(hex(a.ta) like '%E69BB8%')||(hex(a.ta) like '%E7A68FE99FB3%')))||( a.switch>0 && (a.cid=220) && ((hex(a.ta) like '%E6B395E5B8AB%')||(hex(a.ta) like '%E4B9A9%')))||( a.switch>0 && (a.cid=116||a.cid=220||a.cid=61) && ((hex(a.ta) like '%E6AD8CE4BB94E688B2%')||(hex(a.ta) like '%E7B69CE8979D%')||(hex(a.ta) like '%E8A28BE688B2%')||(hex(a.ta) like '%E58A87E59C98%')||(hex(a.ta) like '%E5BAB7E6A882%')))||( a.switch>0 && (a.cid=102))||( a.switch>0 && (a.cid=220) && ((hex(a.ta) like '%E4BD9BE585B7%')||(hex(a.ta) like '%E69687E789A9%')||(hex(a.ta) like '%E9968BE8B7AFE782AE%')||(hex(a.ta) like '%E4BD9BE4BFB1%')))||( a.switch>0 && (a.cid=220) && ((hex(a.ta) like '%E7A5AD%')||(hex(a.ta) like '%E7A580%')||(hex(a.ta) like '%E9A699%')||(hex(a.ta) like '%E7B499%')))||( a.switch>0 && (a.cid=168))||( a.switch>0 && (a.cid=250||a.cid=220) && ((hex(a.ta) like '%E591BD%')||(hex(a.ta) like '%E9A2A8E6B0B4%')||(hex(a.ta) like '%E5898DE4B896%')||(hex(a.ta) like '%E69687E69599%')))) && (a.adds1=6 || a.adds1=7) order by cnt desc limit 0,8
Unknown column 'a.txt' in 'where clause' SQL:select a.id,(SELECT count(id) FROM store_tnn_tw.StorePhoto WHERE sid=a.id) AS cnt from store_tnn_tw.StoreUserData as a where (( a.switch>0 && (a.cid=220) && ((hex(a.txt) like '%E4BD9BE8A1A3%')||(hex(a.txt) like '%E5AE97E69599%')||(hex(a.txt) like '%E69687E789A9%')||(hex(a.txt) like '%E4BD9BE585B7%')||(hex(a.txt) like '%E4BD9BE4BFB1%')))||( a.switch>0 && (a.cid=254||a.cid=220||a.cid=245) && ((hex(a.ta) like '%E99B95%')||(hex(a.ta) like '%E4BD9BE585B7%')||(hex(a.ta) like '%E9BE95%')||(hex(a.ta) like '%E4BD9BE4BFB1%')||(hex(a.ta) like '%E588BB%')||(hex(a.ta) like '%E4BD9BE5BA97%')))||( a.switch>0 && (a.cid=250||a.cid=220||a.cid=85) && ((hex(a.ta) like '%E7B693%')||(hex(a.ta) like '%E5AE97E69599E99FB3E6A882%')||(hex(a.ta) like '%E594B1E78987%')||(hex(a.ta) like '%E69BB8%')||(hex(a.ta) like '%E7A68FE99FB3%')))||( a.switch>0 && (a.cid=220) && ((hex(a.ta) like '%E6B395E5B8AB%')||(hex(a.ta) like '%E4B9A9%')))||( a.switch>0 && (a.cid=116||a.cid=220||a.cid=61) && ((hex(a.ta) like '%E6AD8CE4BB94E688B2%')||(hex(a.ta) like '%E7B69CE8979D%')||(hex(a.ta) like '%E8A28BE688B2%')||(hex(a.ta) like '%E58A87E59C98%')||(hex(a.ta) like '%E5BAB7E6A882%')))||( a.switch>0 && (a.cid=102))||( a.switch>0 && (a.cid=220) && ((hex(a.ta) like '%E4BD9BE585B7%')||(hex(a.ta) like '%E69687E789A9%')||(hex(a.ta) like '%E9968BE8B7AFE782AE%')||(hex(a.ta) like '%E4BD9BE4BFB1%')))||( a.switch>0 && (a.cid=220) && ((hex(a.ta) like '%E7A5AD%')||(hex(a.ta) like '%E7A580%')||(hex(a.ta) like '%E9A699%')||(hex(a.ta) like '%E7B499%')))||( a.switch>0 && (a.cid=168))||( a.switch>0 && (a.cid=250||a.cid=220) && ((hex(a.ta) like '%E591BD%')||(hex(a.ta) like '%E9A2A8E6B0B4%')||(hex(a.ta) like '%E5898DE4B896%')||(hex(a.ta) like '%E69687E69599%')))) && (a.adds1=6 || a.adds1=7) order by cnt desc limit 0,8
Unknown column 'a.txt' in 'where clause'
Warning: array_merge(): Argument #2 is not an array in /home/webtnnadmin/temple.tnn.tw/manager/class/ctemple.php on line 1358
Warning: Invalid argument supplied for foreach() in /home/webtnnadmin/temple.tnn.tw/manager/g_temple.php on line 1396
新竹寺廟,新竹神壇 - Tnn數位新竹寺廟通
