培训机构|培训班|培训网-91搜课网 - www.91soker.com

直接访问

培训机构

百度权重：

1
移动权重：

1
360权重：

2
搜狗权重：

1
百度收录：2120707
浏览热度：
站点URL： https://www.91soker.com
备案号：赣ICP备18008108号
备案方：江西搜课文化传播有限公司
网站编号：79896
最后点入：2024-09-09 07:01:31
加入时间：2024-09-09 07:01:29

上一篇:劳动教育云平台

下一篇:热爱生活，分享生活

网站LOGO

网站关键词(12个字符)

培训机构、培训班、培训网、

网站描述(81个字符)

培训网汇集了多家培训学校,培训班，培训课程，为学员提供英语培训,IT培训,建筑培训,中小学辅导,小语种培训等培训课程的最新动态,学习资讯,学费报价,以及选课指导。

关于www.91soker.com说明

www.91soker.com由网友主动性提交被星月导航网整理收录的，星月导航网仅提供www.91soker.com的基础信息并免费向大众网友展示，www.91soker.com的是IP地址：123.60.68.193 [中国上海上海华为云]，www.91soker.com的百度权重为1、百度手机权重为1、百度收录为2120707条、360收录为4750条、搜狗收录为0条、谷歌收录为0条、百度来访流量大约在28之间、百度手机端来访流量大约在80之间、www.91soker.com的备案号是赣ICP备18008108号、备案人叫江西搜课文化传播有限公司、被百度收录的关键词有79个、手机端关键词有16个、迄今为止已经创建10年5个月16天。

下载地址: txt下载、docx下载、pdf下载、rar下载、zip下载

本页地址: https://www.988g.cn/links/f633fd88b1b3550502ad.html

SEO综合查询

SEO信息	百度来访IP：28 \| 移动端来访IP：80 \| 出站链接：7 \| 站内链接：490
IP网速：	IP地址：123.60.68.193 [中国上海上海华为云] \| 网速：642毫秒
ALEXA排名	世界排名：980,965 \| 预估IP：- \| 预估PV：-
备案信息	赣ICP备18008108号 \| 名称：江西搜课文化传播有限公司 \| 已创建：10年5个月16天

收录	百度	360	搜狗	谷歌
查询	2120707	4750	0	0

电脑关键词	手机关键词	页面友好	首页位置	索引	近期收录
79	16	电脑端优秀	1	0	0

协议类型HTTP/1.1 200 OK 页面类型text/html; charset=utf-8 服务器类型nginx 是否压缩是原网页大小222817 压缩后大小31561 压缩比85.84%

网页快照

培训机构 | 培训班 | 培训网 9 1 搜课网您好，欢迎来到 9 1 搜课网！网站地图注册入驻登录微信咨询关注 9 1 搜课微信客服为您解答收藏本站关于我们北京热门城市北京长沙重庆沧州东莞佛山杭州南京宁波青岛苏州沈阳天津武汉西安郑州 A 安顺安阳安庆安康鞍山 B 北京保定北海宝鸡毕节百色滨州亳州蚌埠本溪巴彦淖尔包头 C 成都朝阳常德长春承德长沙重庆潮州郴州滁州常州赤峰长治沧州 D 大连东莞达州德阳德州东营大庆丹东大同 E 鄂州鄂尔多斯 F 抚州福州抚顺佛山阜阳 G 广州桂林贵阳赣州固原广安广元贵港 H 杭州哈尔滨合肥衡水怀化衡阳黄冈汉中海口河池贺州河源惠州黄石鹤壁菏泽淮南湖州淮安葫芦岛呼伦贝尔呼和浩特邯郸 J 济南嘉兴景德镇吉安金华九江荆州荆门揭阳江门焦作济宁吉林锦州晋中晋城 K 开封昆明 L 洛阳廊坊兰州乐山连云港临汾陇南六盘水泸州来宾柳州娄底漯河聊城临沂龙岩六安丽水辽阳吕梁 M 绵阳马鞍山眉山梅州茂名牡丹江 N 南京宁波南充内江南宁南阳南昌宁德南平南通 P 莆田萍乡平顶山攀枝花普洱濮阳盘锦 Q 泉州清远青岛曲靖琼海潜江庆阳钦州衢州秦皇岛 R 日照 S 上海深圳苏州沈阳三亚石家庄绍兴上饶十堰昭通石嘴山商洛遂宁汕头韶关邵阳随州商丘三门峡三明宿州宿迁松原四平朔州 T 天津天水泰安铜陵台州泰州通化通辽太原唐山 W 无锡温州潍坊芜湖武汉乌鲁木齐吴忠武威渭南梧州威海乌兰察布乌海 X 西宁孝感西安仙桃咸阳湘潭咸宁襄阳信阳许昌新乡厦门宣城徐州忻州邢台 Y 扬州盐城宜昌宜春烟台银川延安宜宾玉溪榆林玉林阳江永州益阳岳阳营口运城阳泉 Z 遵义珠海舟山郑州中山中卫张掖资阳自贡肇庆湛江株洲驻马店周口枣庄淄博漳州镇江张家口课程课程学校攻略动态热门搜索：四六级数学大学预科专转本幼师资格 4 0 0 0 0 0 9 1 9 2 课程导航语言培训德语俄语其他对外汉语小语种德语俄语法语韩语日语西班牙语小语种其他意大利语职称日语英语商务英语四六级考试英语专四专八职业技能 I T 培训办公应用 I T / 互联网 I T 培训办公应用产品经理大数据分析师电商运营华为认证软件制图思科认证网页设计网站运营新媒体运营游戏开发运营其他财会 / 金融 A C C A C M A 会计实操培训会计职称金融分析师经济师理财规划师美国注册会计师审计师培训税务师信用管理师银行从业资格注册会计师资产评估师餐饮技能西式面点中式面点建筑工程 B I M 工程师安全工程师环境评价师监理工程师建造师建筑九大员消防师造价师注册消防工程师美容美发化妆造型美发美容微整形纹绣美甲母婴 / 家政催乳师月嫂培训设计培训 U I / U E 培训工业设计广告设计景观设计平面设计室内设计摄影培训摄影培训营销培训营销培训影视动漫编导策划动画制作动漫设计影视后期影视制作职场技能管理咨询其他职场技能人力资源管理师项目管理职业规划师其他职业技能应急救援员其他职业技能教育院校国际初中国际高中初中院校国际初中高中院校国际高中小学国际小学留学服务 A C T A E A S 留学考试 / 培训 A C T A E A S G M A T G R E P T E S A T S S A T 托福雅思留学申请爱尔兰留学澳大利亚留学本科留学德国留学法国留学韩国留学加拿大留学马来西亚留学美国留学欧洲留学其他留学申请日本留学西班牙留学香港留学新加坡留学新西兰留学亚洲留学艺术留学意大利留学英国留学留学综合服务背景提升国际游学留学后服务留学中介兴趣爱好插花茶艺花艺茶艺花艺插花茶艺花艺茶艺师礼仪口才礼仪口才普通话美术书法插画美术其他少儿美术手绘书法其他水彩棋牌围棋手工制作手工制作素质训练国学模型竞技情商训练体能培训音乐培训笛箫二胡古琴古筝葫芦丝琵琶影视戏剧影视戏剧运动舞蹈芭蕾舞棒球古典舞国标舞健身街舞爵士舞拉丁舞篮球民族舞球类其他网球舞蹈其他羽毛球足球学历教育 M B A 考试 M P A 考试研究生 M B A 考试 M P A 考试博士法学考研管理学考研会计考研计算机考研教育学考研金融硕士考研经济学考研考研其他考研数学考研英语考研政治心理学考研新闻学考研医学考研艺术考研在职研究生专科高起专专科自学考试专科成人高考专科网络教育学前教育感统训练亲子教育学前教育感统训练亲子教育特殊儿童教育早教自闭症医教及事业单位公考公务员事业单位公务员考试公务员事业单位教师从业教师资格证医疗护理按摩保健健康管理师医疗护理其他营养师中医针灸医疗卫生公卫医师护士资格其他执业医师心理咨询师执业药师中医医师首页精品课程精选学校品牌机构学习攻略机构动态正规学校 1 8 0 0 + 品牌学校，双证齐全确保低价有限的资金投入无限的提升自我优质保障点评请教，学校更重视你在线客服专业平台客服实时在线精品课程 m o r e 语言培训北京西班牙语中外教小班课 2 0 个教学点 ¥ 面议预约试听北京斯洛文尼亚语体验课 2 0 个教学点 ¥ 面议预约试听北京英语培训零基础小班课 2 0 个教学点 ¥ 面议预约试听北京土耳其语体验课 2 0 个教学点 ¥ 面议预约试听北京学习粤语体验课 2 0 个教学点 ¥ 面议预约试听北京土库曼语培训体验课 2 0 个教学点 ¥ 面议预约试听北京维吾尔语体验课 2 0 个教学点 ¥ 面议预约试听北京乌尔都语体验课 2 0 个教学点 ¥ 面议预约试听职业技能北京消防设施操作员 2 4 0 个教学点 ¥ 1 0 0 / 课时预约试听北京薪税师培训 2 4 0 个教学点 ¥ 1 0 0 / 课时预约试听北京环境影响评价师培训 2 4 0 个教学点 ¥ 1 0 0 / 课时预约试听北京注册会计师培训 2 1 1 个教学点 ¥ 面议预约试听北京初级会计考证培训 3 2 5 个教学点 ¥ 面议预约试听北京会计实操培训 2 1 1 个教学点 ¥ 面议预约试听北京中级注册安全工程师 2 4 0 个教学点 ¥ 1 0 0 / 课时预约试听北京会计真帐实操培训 3 2 5 个教学点 ¥ 面议预约试听教育院校北京 O S S D 一年制 1 个教学点 ¥ 面议预约试听北京 O S S D 三年制课程 1 个教学点 ¥ 面议预约试听北京 O S S D 二年制 1 个教学点 ¥ 面议预约试听北京少儿艺术教育课程 1 3 个教学点 ¥ 面议预约试听北京小学辅导课 1 个教学点 ¥ 面议预约试听北京中学辅导课 1 个教学点 ¥ 面议预约试听北京国际初中培训 1 个教学点 ¥ 面议预约试听北京高中国际培训 1 个教学点 ¥ 面议预约试听医教及事业单位公考北京国考致胜协议全程班 2 1 个教学点 ¥ 面议预约试听北京中医专长医师 2 4 0 个教学点 ¥ 1 0 0 / 课时预约试听北京乡村全科医生培训 2 4 0 个教学点 ¥ 1 0 0 / 课时预约试听北京护士资格证 2 4 0 个教学点 ¥ 1 0 0 / 课时预约试听北京教师资格证 2 4 0 个教学点 ¥ 1 0 0 / 课时预约试听北京 S A T 训练 6 2 个教学点 ¥ 面议预约试听北京心理咨询师实践技能 1 个教学点 ¥ 面议预约试听北京心理咨询师精修班 1 个教学点 ¥ 面议预约试听学前教育北京亲子关系训练营 4 1 个教学点 ¥ 面议预约试听北京儿童教育指导师课程 1 个教学点 ¥ 面议预约试听北京 O T 职能训练 4 8 个教学点 ¥ 面议预约试听北京 S T 言语康复 4 8 个教学点 ¥ 面议预约试听北京 A B A 行为训练 4 8 个教学点 ¥ 面议预约试听北京 A B A P l u s 4 8 个教学点 ¥ 面议预约试听北京 O S T 居家训练课程 4 8 个教学点 ¥ 面议预约试听北京家庭心理干预服务 4 8 个教学点 ¥ 面议预约试听学历教育北京考研留学双保险 2 4 4 个教学点 ¥ 面议预约试听北京法考暑期精英班 2 4 4 个教学点 ¥ 面议预约试听北京暑期集训营 2 4 4 个教学点 ¥ 面议预约试听北京国家开放大学招生 6 6 个教学点 ¥ 面议预约试听北京金融硕士考研培训 2 6 个教学点 ¥ 1 0 0 / 课时预约试听北京英语考研辅导体验课 2 0 个教学点 ¥ 面议预约试听北京在职研 M B A 笔试 1 个教学点 ¥ 面议预约试听北京在职研 M B A 面试 1 个教学点 ¥ 面议预约试听兴趣爱好北京传统手工课程 5 5 个教学点 ¥ 面议预约试听北京中国文化课程 5 5 个教学点 ¥ 面议预约试听北京二胡学习班 6 7 个教学点 ¥ 面议预约试听北京竹笛辅导班 6 7 个教学点 ¥ 面议预约试听北京琴棋书画暑假班 6 7 个教学点 ¥ 面议预约试听北京润笔（妙笔天成）课程 6 7 个教学点 ¥ 面议预约试听北京古琴入门培训 6 7 个教学点 ¥ 面议预约试听北京葫芦丝教学班 6 7 个教学点 ¥ 面议预约试听留学服务北京韩国留学课程 2 4 4 个教学点 ¥ 面议预约试听北京澳大利亚新西兰留学 2 4 4 个教学点 ¥ 面议预约试听北京英国留学课程 2 4 4 个教学点 ¥ 面议预约试听北京雅思试听体验课 2 0 个教学点 ¥ 面议预约试听北京托福英语课程专业培训 2 0 个教学点 ¥ 面议预约试听北京香港澳门留学 2 4 4 个教学点 ¥ 面议预约试听北京精品雅思课程 1 个教学点 ¥ 面议预约试听北京精品托福课程 1 个教学点 ¥ 面议预约试听学员评论（共 1 2 6 2 条评论）风 * * 上 ( * * * * ) 2 0 2 4 0 5 1 0 1 0 : 1 7 朋友推荐的，说仁和是会计培训的老品牌，不管是教学质量还是服务都做得很好，而且报了课可以终身免费学习。来校区了解之后发现确实是这样的，校区环境宽敞明亮，授课老师专业又有责任心，非常热情，经常关心我。我是零基础，刚开始听课有点懵，老师会不厌其烦地给我们讲解，鼓励我们，感谢仁和的老师。请教 T A 枫 * ( * * * * ) 2 0 2 4 0 5 1 0 1 0 : 1 7 质量 : 课程多，可以上课的时间很灵活，老师师资和团队都很有保障服务 : 线上线下配套都有教学，有问题找校区老师都会及时回复感受 : 总体感受很好，准备继续跟进，系统化学习专业知识价格 : 价格合理，同类型培训机构价位差不多，服务很好就坚持在这里了，又很方便请教 T A 幼 * * * * * * 鬼 ( * * * * ) 2 0 2 4 0 5 1 0 1 0 : 1 6 我是做设计的，经常加班，孩子也大了，就想找个双休，有节假日的工作，可以管孩子，家人推荐学习会计，就在网上搜索了会计培训，第一家就出来了仁和会计，已经学习几周了，确实不错，老师也很负责请教 T A 浮 * 子 ( * * * * ) 2 0 2 4 0 5 1 0 1 0 : 1 6 在网上看了很多会计培训机构，最终选择了这家。很专业只做会计培训。前台老师很热情服务很好。老师也很专业，听不懂老师都会耐心的解答。第一遍没听懂，还可以在来听。对于我们没有基础的特别好。请教 T A ╭ * * * 笑 ( * * * * ) 2 0 2 4 0 5 1 0 1 0 : 1 6 前期一直是从事会计基础岗位，然后自我觉得职业遇到了瓶颈，想财务转行，但又没有方向，然后偶然的机会听了一次仁和会计的体验课，瞬间觉得对财务有了一个新的认识。感谢仁和让我有了方向请教 T A 发 * * * 姐 ( * * * * ) 2 0 2 4 0 5 1 0 1 0 : 1 6 教室环境干净明亮，同学们也很好相处，前台老师很负责，每天提醒上课，督促我学习，讲课的老师很有耐心，零基础小白也完全听得懂，很多学姐已经就业了，希望自己能早点学完找到工作！请教 T A 清 * * * 挽 ( * * * * ) 2 0 2 4 0 5 1 0 1 0 : 1 6 质量 : 杠杠的服务 : 贴心茶水，介绍，纸巾感觉不错感受 : 感觉聊天很愉快，也不逼迫，分析得很现实透彻价格 : 价格还是稍微贵些的，但是只要能够达到效果我觉得还是很值得请教 T A 枕 * * * * * 醒 ( * * * * ) 2 0 2 4 0 5 1 0 1 0 : 1 6 预约了一节实操试听课，校区有点旧，但布置的挺温馨，授课老师讲的通俗易懂，会通过案例来让我们理解，不枯燥，听说他们还有推荐就业服务，整体还是比较专业的。请教 T A 萌 * ( * * * * ) 2 0 2 4 0 5 1 0 1 0 : 1 6 现是两个娃儿的宝妈，以前几年前做过内账会计，考过会计证，现在重新抓起学习，系统性过一下实战课，打算今年去考中级，然后等娃儿大点了出去找工作，加油加油。请教 T A 余 * 兮 ( * * * * ) 2 0 2 4 0 5 1 0 1 0 : 1 5 我觉得实操都是工作中能够用到的，老师上课通俗易懂，挺好的服务 : 前台老师很热情，很有耐心感受 : 校区环境干净整洁，学习氛围很融洽物流 : 满意价格 : 满意请教 T A 战 * 罪 ( * * * * ) 2 0 2 4 0 5 1 0 1 0 : 1 5 价格也实惠，性价比超高服务 : 校区所有老师都很负责任，我是零基础的，老师讲的通俗易懂的感受 : 我学习起来很松气，学习氛围很好的请教 T A 春 * * 杏 ( * * * * ) 2 0 2 4 0 5 1 0 1 0 : 1 5 符老师讲的实操课讲的太好了，我一个小白都听的懂，老师举例讲的很好，很容易懂，所以没有基础的同学不要担心，只要每节课认真学很快的时间就学会了请教 T A 品牌学校 m o r e 语言培训职业技能教育院校医教及事业单位公考学前教育学历教育兴趣爱好留学服务学习攻略 m o r e 教育院校树枝在林中互相碰触着仿写拟人句 1 、雪花在空中跳着舞，枯叶在地上仰望着，大地伸开她那宽广的怀抱。 2 、花朵在园中彼此依偎着，粉瓣在骤雨中凄凄地落，闪电吼着高音。 3 、石头在奔跑中你推我搡，发出哐哐的声响，泥石流疯狂地俯冲下来。 4 、小雨滴 2 0 2 4 0 9 0 8 1 8 : 0 8 升学辅导人无精神不立下一句是什么人无精神则不立，国无精神则不强。相关名人名言： 1 、路曼曼其修远兮，吾将上下而求索。 — 屈原《离骚》 2 、日日行，不怕千万里；常常做，不怕千万事。 — 《格言联璧 · 处事》 3 、志当存高远。 — 诸葛亮《诫外生书》。 2 0 2 4 0 9 0 8 0 9 : 4 2 教育院校秋夕 . ( 唐 ) 杜牧是坐看还是卧看是 “ 坐看 ” ，原文如下：《秋夕》银烛秋光冷画屏，轻罗小扇扑流萤。天阶夜色凉如水，坐看牵牛织女星。译文：银烛的烛光映着冷清的画屏，手执绫罗小扇扑打萤火虫。夜色里的石阶清凉如冷水，静坐凝视天河两旁的牛郎织女 2 0 2 4 0 9 0 6 2 1 : 0 6 机构动态 m o r e 医疗卫生管理学位样本克莱蒙高等商学院（海淀校区） 5 分 2 0 2 4 0 7 1 4 1 9 : 4 8 学习芭蕾舞的好处练耐性，意志及自信芭蕾舞的学习结果不如绘画及唱歌般快捷，要跳得好，不是一朝一夕的事，学员需要一段时间揣摩动作技巧及感受音乐动作的关系，从而表达动作及带出自己所思所想，可训练耐性和意志．由于确定自己表达方针，习惯与人沟通，更可提高自信心。舞蹈表现及欣赏学校定期举办舞蹈表演及舞蹈欣赏，增强学员勇气及自信，亦可客观地学习欣赏事物，扩阔思维。兴趣多元化现今芭蕾舞揉合古典芭蕾舞，现代舞及土风舞，这中芭艺蕾（中央芭蕾舞团北苑分校） 0 分 2 0 2 3 0 7 1 9 2 0 : 0 9 寒假雅思集训营开班时间： ★ 1 . 2 当周开课，最晚 1 . 4 （ 1 月 2 1 日除夕） ★ 1 . 3 0 （计划开课时间）时间周期： 1 4 天， 1 2 天正课（ 8 小时 / 天 * 1 2 天 = 9 6 小时）， 1 天休息， 1 天模考精讲招生对象：突破或者精品阶段学生，目标雅思 6 6 . 5 分班型： 8 1 5 人， 8 人开班， 1 5 人封班上课地址：市南校区优惠： 1 1 月， 1 2 月报名立减 1 0 0 0 元。课程特色与优势：全天候监督，陪伴式学习，社群式打卡，青岛朗阁智美（黄岛校区） 5 分 2 0 2 3 0 7 1 9 1 9 : 2 5 欢迎来到 9 1 搜课网，请选择合适的学习所在地猜你所在北京前往该城市按拼音首字母选择： A B C D E F G H J K L M N P Q R S T W X Y Z A 安顺安阳安庆安康鞍山 B 北京保定北海宝鸡毕节百色滨州亳州蚌埠本溪巴彦淖尔包头 C 成都朝阳常德长春承德长沙重庆潮州郴州滁州常州赤峰长治沧州 D 大连东莞达州德阳德州东营大庆丹东大同 E 鄂州鄂尔多斯 F 抚州福州抚顺佛山阜阳 G 广州桂林贵阳赣州固原广安广元贵港 H 杭州哈尔滨合肥衡水怀化衡阳黄冈汉中海口河池贺州河源惠州黄石鹤壁菏泽淮南湖州淮安葫芦岛呼伦贝尔呼和浩特邯郸 J 济南嘉兴景德镇吉安金华九江荆州荆门揭阳江门焦作济宁吉林锦州晋中晋城 K 开封昆明 L 洛阳廊坊兰州乐山连云港临汾陇南六盘水泸州来宾柳州娄底漯河聊城临沂龙岩六安丽水辽阳吕梁 M 绵阳马鞍山眉山梅州茂名牡丹江 N 南京宁波南充内江南宁南阳南昌宁德南平南通 P 莆田萍乡平顶山攀枝花普洱濮阳盘锦 Q 泉州清远青岛曲靖琼海潜江庆阳钦州衢州秦皇岛 R 日照 S 上海深圳苏州沈阳三亚石家庄绍兴上饶十堰昭通石嘴山商洛遂宁汕头韶关邵阳随州商丘三门峡三明宿州宿迁松原四平朔州 T 天津天水泰安铜陵台州泰州通化通辽太原唐山 W 无锡温州潍坊芜湖武汉乌鲁木齐吴忠武威渭南梧州威海乌兰察布乌海 X 西宁孝感西安仙桃咸阳湘潭咸宁襄阳信阳许昌新乡厦门宣城徐州忻州邢台 Y 扬州盐城宜昌宜春烟台银川延安宜宾玉溪榆林玉林阳江永州益阳岳阳营口运城阳泉 Z 遵义珠海舟山郑州中山中卫张掖资阳自贡肇庆湛江株洲驻马店周口枣庄淄博漳州镇江张家口友情链接：培训机构 P M P 培训化妆学校 9 1 求学网小语种培训建造师培训本页信息由注册用户（机构和个人）自行发布或提供，所有内容仅供参考，终以该用户官方信息为准，任何关于对该用户的推荐都不能替代您的考察核实，本站不承担该用户发布 / 提供信息的行为或内容所引起的法律责任。当您认为您的知识产权或其他合法权益被侵犯，请立即向我们发出权利通知书，我们将根据中国法律法规和政府规范性文件采取相应的措施予以处理，切实维护您的合法权利。 4 0 0 0 0 0 9 1 9 2 快速导航网站地图精品课程精选学校品牌学校平台资讯校区动态学习攻略关于我们平台简介免责声明服务条款联系我们战略合作 9 1 求学网 9 1 优培网申请入驻 9 1 搜课移动端 9 1 搜课微信公众号 C o p y r i g h t © 2 0 1 3 江西搜课文化传播有限公司 A l l R i g h t s R e s e r v e d 版权所有： 9 1 搜课网赣 I C P 备 1 8 0 0 8 1 0 8 号 3 赣公网安备 3 6 1 0 0 2 0 2 0 0 0 5 0 2 在线客服平台热线 4 0 0 0 0 0 9 1 9 2 扫码咨询关注 9 1 搜课微信客服为您解答预约试听预约试听填写您的个人信息稍后将有平台客服联系您确认 4 0 0 0 0 0 9 1 9 2 欢迎拨打平台热线主动联系我们登录成功欢迎您加入 9 1 搜课网以下为您提供我们后台链接、账号、密码后台链接： w w w . 9 1 s o k e r . c o m / s o k e r _ i n s t i t u t i o n / 后台密码： 1 2 3 4 5 6 温馨提示：请保存好、后台链接、账号、密码。登录后台链接提供入驻所需的资料信息。 4 0 0 0 0 0 9 1 9 2 欢迎拨打平台热线主动联系我们基本文件流程错误 S Q L 调试请求信息 : 2 0 2 4 0 9 0 9 0 7 : 0 1 : 2 7 H T T P / 1 . 1 G E T : h t t p s : / / w w w . 9 1 s o k e r . c o m / 运行时间 : 1 . 3 6 7 1 3 4 s [ 吞吐率： 0 . 7 3 r e q / s ] 内存消耗： 7 , 2 1 1 . 8 1 k b 文件加载： 1 9 8 查询信息 : 2 3 6 q u e r i e s 缓存信息 : 0 r e a d s , 0 w r i t e s / w w w / w w w r o o t / s o k e r _ p r o / p u b l i c / i n d e x . p h p ( 2 . 8 1 K B ) / w w w / w w w r o o t / s o k e r _ p r o / v e n d o r / a u t o l o a d . p h p ( 0 . 1 7 K B ) / w w w / w w w r o o t / s o k e r _ p r o / v e n d o r / c o m p o s e r / a u t o l o a d _ r e a l . p h p ( 2 . 4 9 K B ) / w w w / w w w r o o t / s o k e r _ p r o / v e n d o r / c o m p o s e r / p l a t f o r m _ c h e c k . p h p ( 0 . 9 0 K B ) / w w w / w w w r o o t / s o k e r _ p r o / v e n d o r / c o m p o s e r / C l a s s L o a d e r . p h p ( 1 5 . 6 9 K B ) / w w w / w w w r o o t / s o k e r _ p r o / v e n d o r / c o m p o s e r / a u t o l o a d _ s t a t i c . p h p ( 7 . 8 4 K B ) / w w w / w w w r o o t / s o k e r _ p r o / v e n d o r / t o p t h i n k / t h i n k h e l p e r / s r c / h e l p e r . p h p ( 7 . 3 5 K B ) / w w w / w w w r o o t / s o k e r _ p r o / v e n d o r / r a l o u p h i e / g e t a l l h e a d e r s / s r c / g e t a l l h e a d e r s . p h p ( 1 . 6 0 K B ) / w w w / w w w r o o t / s o k e r _ p r o / v e n d o r / t o p t h i n k / t h i n k o r m / s t u b s / l o a d _ s t u b s . p h p ( 0 . 1 6 K B ) / w w w / w w w r o o t / s o k e r _ p r o / v e n d o r / t o p t h i n k / f r a m e w o r k / s r c / t h i n k / E x c e p t i o n . p h p ( 1 . 6 9 K B ) / w w w / w w w r o o t / s o k e r _ p r o / v e n d o r / t o p t h i n k / f r a m e w o r k / s r c / t h i n k / F a c a d e . p h p ( 2 . 7 1 K B ) / w w w / w w w r o o t / s o k e r _ p r o / v e n d o r / g u z z l e h t t p / p r o m i s e s / s r c / f u n c t i o n s _ i n c l u d e . p h p ( 0 . 1 6 K B ) / w w w / w w w r o o t / s o k e r _ p r o / v e n d o r / g u z z l e h t t p / p r o m i s e s / s r c / f u n c t i o n s . p h p ( 9 . 8 9 K B ) / w w w / w w w r o o t / s o k e r _ p r o / v e n d o r / s y m f o n y / d e p r e c a t i o n c o n t r a c t s / f u n c t i o n . p h p ( 0 . 9 8 K B ) / w w w / w w w r o o t / s o k e r _ p r o / v e n d o r / g u z z l e h t t p / g u z z l e / s r c / f u n c t i o n s _ i n c l u d e . p h p ( 0 . 1 6 K B ) / w w w / w w w r o o t / s o k e r _ p r o / v e n d o r / g u z z l e h t t p / g u z z l e / s r c / f u n c t i o n s . p h p ( 5 . 5 6 K B ) / w w w / w w w r o o t / s o k e r _ p r o / v e n d o r / q i n i u / p h p s d k / s r c / Q i n i u / f u n c t i o n s . p h p ( 8 . 2 0 K B ) / w w w / w w w r o o t / s o k e r _ p r o / v e n d o r / q i n i u / p h p s d k / s r c / Q i n i u / C o n f i g . p h p ( 3 . 5 6 K B ) / w w w / w w w r o o t / s o k e r _ p r o / v e n d o r / s y m f o n y / p o l y f i l l m b s t r i n g / b o o t s t r a p . p h p ( 7 . 0 7 K B ) / w w w / w w w r o o t / s o k e r _ p r o / v e n d o r / s y m f o n y / p o l y f i l l p h p 7 2 / b o o t s t r a p . p h p ( 1 . 8 9 K B ) / w w w / w w w r o o t / s o k e r _ p r o / v e n d o r / s y m f o n y / p o l y f i l l p h p 8 0 / b o o t s t r a p . p h p ( 1 . 5 0 K B ) / w w w / w w w r o o t / s o k e r _ p r o / v e n d o r / l c o b u c c i / j w t / c o m p a t / c l a s s a l i a s e s . p h p ( 0 . 2 8 K B ) / w w w / w w w r o o t / s o k e r _ p r o / v e n d o r / l c o b u c c i / j w t / s r c / T o k e n . p h p ( 9 . 9 7 K B ) / w w w / w w w r o o t / s o k e r _ p r o / v e n d o r / l c o b u c c i / j w t / s r c / S i g n a t u r e . p h p ( 1 . 7 2 K B ) / w w w / w w w r o o t / s o k e r _ p r o / v e n d o r / l c o b u c c i / j w t / c o m p a t / j s o n e x c e p t i o n p o l y f i l l . p h p ( 0 . 1 3 K B ) / w w w / w w w r o o t / s o k e r _ p r o / v e n d o r / l c o b u c c i / j w t / c o m p a t / l c o b u c c i c l o c k p o l y f i l l . p h p ( 1 . 4 9 K B ) / w w w / w w w r o o t / s o k e r _ p r o / v e n d o r / s y m f o n y / v a r d u m p e r / R e s o u r c e s / f u n c t i o n s / d u m p . p h p ( 0 . 7 9 K B ) / w w w / w w w r o o t / s o k e r _ p r o / v e n d o r / t o p t h i n k / f r a m e w o r k / s r c / t h i n k / A p p . p h p ( 1 4 . 2 6 K B ) / w w w / w w w r o o t / s o k e r _ p r o / v e n d o r / t o p t h i n k / f r a m e w o r k / s r c / t h i n k / C o n t a i n e r . p h p ( 1 5 . 1 3 K B ) / w w w / w w w r o o t / s o k e r _ p r o / v e n d o r / p s r / c o n t a i n e r / s r c / C o n t a i n e r I n t e r f a c e . p h p ( 1 . 0 2 K B ) / w w w / w w w r o o t / s o k e r _ p r o / a p p / p r o v i d e r . p h p ( 0 . 2 5 K B ) / w w w / w w w r o o t / s o k e r _ p r o / v e n d o r / t o p t h i n k / f r a m e w o r k / s r c / t h i n k / H t t p . p h p ( 6 . 1 2 K B ) / w w w / w w w r o o t / s o k e r _ p r o / v e n d o r / t o p t h i n k / t h i n k h e l p e r / s r c / h e l p e r / S t r . p h p ( 7 . 2 8 K B ) / w w w / w w w r o o t / s o k e r _ p r o / v e n d o r / t o p t h i n k / f r a m e w o r k / s r c / t h i n k / E n v . p h p ( 4 . 6 3 K B ) / w w w / w w w r o o t / s o k e r _ p r o / a p p / c o m m o n . p h p ( 1 1 0 . 7 5 K B ) / w w w / w w w r o o t / s o k e r _ p r o / v e n d o r / t o p t h i n k / f r a m e w o r k / s r c / h e l p e r . p h p ( 1 8 . 3 7 K B ) / w w w / w w w r o o t / s o k e r _ p r o / v e n d o r / t o p t h i n k / f r a m e w o r k / s r c / t h i n k / C o n f i g . p h p ( 5 . 0 3 K B ) / w w w / w w w r o o t / s o k e r _ p r o / c o n f i g / a p p . p h p ( 5 . 7 8 K B ) / w w w / w w w r o o t / s o k e r _ p r o / v e n d o r / t o p t h i n k / f r a m e w o r k / s r c / t h i n k / f a c a d e / E n v . p h p ( 1 . 6 7 K B ) / w w w / w w w r o o t / s o k e r _ p r o / v e n d o r / t o p t h i n k / f r a m e w o r k / s r c / t h i n k / f a c a d e / A p p . p h p ( 2 . 7 3 K B ) / w w w / w w w r o o t / s o k e r _ p r o / c o n f i g / c a c h e . p h p ( 1 . 3 0 K B ) / w w w / w w w r o o t / s o k e r _ p r o / c o n f i g / c o n s o l e . p h p ( 0 . 2 3 K B ) / w w w / w w w r o o t / s o k e r _ p r o / c o n f i g / c o o k i e . p h p ( 0 . 5 6 K B ) / w w w / w w w r o o t / s o k e r _ p r o / c o n f i g / d a t a b a s e . p h p ( 2 . 2 2 K B ) / w w w / w w w r o o t / s o k e r _ p r o / c o n f i g / f i l e s y s t e m . p h p ( 0 . 9 6 K B ) / w w w / w w w r o o t / s o k e r _ p r o / c o n f i g / l a n g . p h p ( 0 . 8 1 K B ) / w w w / w w w r o o t / s o k e r _ p r o / c o n f i g / l o g . p h p ( 1 . 4 2 K B ) / w w w / w w w r o o t / s o k e r _ p r o / c o n f i g / m i d d l e w a r e . p h p ( 0 . 1 9 K B ) / w w w / w w w r o o t / s o k e r _ p r o / c o n f i g / r o u t e . p h p ( 1 . 5 4 K B ) / w w w / w w w r o o t / s o k e r _ p r o / c o n f i g / s e s s i o n . p h p ( 0 . 5 7 K B ) / w w w / w w w r o o t / s o k e r _ p r o / c o n f i g / t r a c e . p h p ( 0 . 3 4 K B ) / w w w / w w w r o o t / s o k e r _ p r o / c o n f i g / v i e w . p h p ( 1 . 0 1 K B ) / w w w / w w w r o o t / s o k e r _ p r o / a p p / e v e n t . p h p ( 0 . 2 5 K B ) / w w w / w w w r o o t / s o k e r _ p r o / v e n d o r / t o p t h i n k / f r a m e w o r k / s r c / t h i n k / E v e n t . p h p ( 6 . 9 6 K B ) / w w w / w w w r o o t / s o k e r _ p r o / a p p / s e r v i c e . p h p ( 0 . 1 3 K B ) / w w w / w w w r o o t / s o k e r _ p r o / a p p / A p p S e r v i c e . p h p ( 0 . 2 6 K B ) / w w w / w w w r o o t / s o k e r _ p r o / v e n d o r / t o p t h i n k / f r a m e w o r k / s r c / t h i n k / S e r v i c e . p h p ( 1 . 6 7 K B ) / w w w / w w w r o o t / s o k e r _ p r o / v e n d o r / t o p t h i n k / f r a m e w o r k / s r c / t h i n k / L a n g . p h p ( 9 . 4 1 K B ) / w w w / w w w r o o t / s o k e r _ p r o / v e n d o r / t o p t h i n k / f r a m e w o r k / s r c / l a n g / z h c n . p h p ( 1 2 . 8 8 K B ) / w w w / w w w r o o t / s o k e r _ p r o / v e n d o r / t o p t h i n k / f r a m e w o r k / s r c / t h i n k / i n i t i a l i z e r / E r r o r . p h p ( 3 . 1 9 K B ) / w w w / w w w r o o t / s o k e r _ p r o / v e n d o r / t o p t h i n k / f r a m e w o r k / s r c / t h i n k / i n i t i a l i z e r / R e g i s t e r S e r v i c e . p h p ( 1 . 3 3 K B ) / w w w / w w w r o o t / s o k e r _ p r o / v e n d o r / s e r v i c e s . p h p ( 0 . 1 7 K B ) / w w w / w w w r o o t / s o k e r _ p r o / v e n d o r / t o p t h i n k / f r a m e w o r k / s r c / t h i n k / s e r v i c e / P a g i n a t o r S e r v i c e . p h p ( 1 . 5 2 K B ) / w w w / w w w r o o t / s o k e r _ p r o / v e n d o r / t o p t h i n k / f r a m e w o r k / s r c / t h i n k / s e r v i c e / V a l i d a t e S e r v i c e . p h p ( 0 . 9 9 K B ) / w w w / w w w r o o t / s o k e r _ p r o / v e n d o r / t o p t h i n k / f r a m e w o r k / s r c / t h i n k / s e r v i c e / M o d e l S e r v i c e . p h p ( 1 . 7 6 K B ) / w w w / w w w r o o t / s o k e r _ p r o / v e n d o r / t o p t h i n k / t h i n k m u l t i a p p / s r c / S e r v i c e . p h p ( 1 . 0 8 K B ) / w w w / w w w r o o t / s o k e r _ p r o / v e n d o r / t o p t h i n k / t h i n k t r a c e / s r c / S e r v i c e . p h p ( 0 . 7 7 K B ) / w w w / w w w r o o t / s o k e r _ p r o / v e n d o r / t o p t h i n k / f r a m e w o r k / s r c / t h i n k / M i d d l e w a r e . p h p ( 6 . 7 8 K B ) / w w w / w w w r o o t / s o k e r _ p r o / v e n d o r / t o p t h i n k / f r a m e w o r k / s r c / t h i n k / i n i t i a l i z e r / B o o t S e r v i c e . p h p ( 0 . 7 7 K B ) / w w w / w w w r o o t / s o k e r _ p r o / v e n d o r / t o p t h i n k / t h i n k o r m / s r c / P a g i n a t o r . p h p ( 1 1 . 9 7 K B ) / w w w / w w w r o o t / s o k e r _ p r o / v e n d o r / t o p t h i n k / f r a m e w o r k / s r c / t h i n k / V a l i d a t e . p h p ( 4 6 . 1 0 K B ) / w w w / w w w r o o t / s o k e r _ p r o / v e n d o r / t o p t h i n k / t h i n k o r m / s r c / M o d e l . p h p ( 2 6 . 1 6 K B ) / w w w / w w w r o o t / s o k e r _ p r o / v e n d o r / t o p t h i n k / t h i n k h e l p e r / s r c / c o n t r a c t / A r r a y a b l e . p h p ( 0 . 0 9 K B ) / w w w / w w w r o o t / s o k e r _ p r o / v e n d o r / t o p t h i n k / t h i n k h e l p e r / s r c / c o n t r a c t / J s o n a b l e . p h p ( 0 . 1 3 K B ) / w w w / w w w r o o t / s o k e r _ p r o / v e n d o r / t o p t h i n k / t h i n k o r m / s r c / m o d e l / c o n c e r n / A t t r i b u t e . p h p ( 1 7 . 2 7 K B ) / w w w / w w w r o o t / s o k e r _ p r o / v e n d o r / t o p t h i n k / t h i n k o r m / s r c / m o d e l / c o n c e r n / R e l a t i o n S h i p . p h p ( 2 6 . 0 6 K B ) / w w w / w w w r o o t / s o k e r _ p r o / v e n d o r / t o p t h i n k / t h i n k o r m / s r c / m o d e l / c o n c e r n / M o d e l E v e n t . p h p ( 2 . 2 7 K B ) / w w w / w w w r o o t / s o k e r _ p r o / v e n d o r / t o p t h i n k / t h i n k o r m / s r c / m o d e l / c o n c e r n / T i m e S t a m p . p h p ( 5 . 7 0 K B ) / w w w / w w w r o o t / s o k e r _ p r o / v e n d o r / t o p t h i n k / t h i n k o r m / s r c / m o d e l / c o n c e r n / C o n v e r s i o n . p h p ( 9 . 5 6 K B ) / w w w / w w w r o o t / s o k e r _ p r o / v e n d o r / t o p t h i n k / f r a m e w o r k / s r c / t h i n k / D b . p h p ( 2 . 8 7 K B ) / w w w / w w w r o o t / s o k e r _ p r o / v e n d o r / t o p t h i n k / t h i n k o r m / s r c / D b M a n a g e r . p h p ( 8 . 3 1 K B ) / w w w / w w w r o o t / s o k e r _ p r o / v e n d o r / t o p t h i n k / f r a m e w o r k / s r c / t h i n k / L o g . p h p ( 8 . 5 0 K B ) / w w w / w w w r o o t / s o k e r _ p r o / v e n d o r / t o p t h i n k / f r a m e w o r k / s r c / t h i n k / M a n a g e r . p h p ( 3 . 9 8 K B ) / w w w / w w w r o o t / s o k e r _ p r o / v e n d o r / p s r / l o g / P s r / L o g / L o g g e r I n t e r f a c e . p h p ( 3 . 0 4 K B ) / w w w / w w w r o o t / s o k e r _ p r o / v e n d o r / t o p t h i n k / f r a m e w o r k / s r c / t h i n k / C a c h e . p h p ( 4 . 7 9 K B ) / w w w / w w w r o o t / s o k e r _ p r o / v e n d o r / p s r / s i m p l e c a c h e / s r c / C a c h e I n t e r f a c e . p h p ( 4 . 5 0 K B ) / w w w / w w w r o o t / s o k e r _ p r o / v e n d o r / t o p t h i n k / t h i n k h e l p e r / s r c / h e l p e r / A r r . p h p ( 1 5 . 5 4 K B ) / w w w / w w w r o o t / s o k e r _ p r o / v e n d o r / t o p t h i n k / f r a m e w o r k / s r c / t h i n k / c a c h e / d r i v e r / F i l e . p h p ( 7 . 4 1 K B ) / w w w / w w w r o o t / s o k e r _ p r o / v e n d o r / t o p t h i n k / f r a m e w o r k / s r c / t h i n k / c a c h e / D r i v e r . p h p ( 8 . 0 1 K B ) / w w w / w w w r o o t / s o k e r _ p r o / v e n d o r / t o p t h i n k / f r a m e w o r k / s r c / t h i n k / c o n t r a c t / C a c h e H a n d l e r I n t e r f a c e . p h p ( 2 . 2 5 K B ) / w w w / w w w r o o t / s o k e r _ p r o / v e n d o r / t o p t h i n k / f r a m e w o r k / s r c / t h i n k / C o n s o l e . p h p ( 2 2 . 6 3 K B ) / w w w / w w w r o o t / s o k e r _ p r o / a p p / R e q u e s t . p h p ( 0 . 0 9 K B ) / w w w / w w w r o o t / s o k e r _ p r o / v e n d o r / t o p t h i n k / f r a m e w o r k / s r c / t h i n k / R e q u e s t . p h p ( 5 3 . 9 4 K B ) / w w w / w w w r o o t / s o k e r _ p r o / a p p / m i d d l e w a r e . p h p ( 0 . 2 6 K B ) / w w w / w w w r o o t / s o k e r _ p r o / v e n d o r / t o p t h i n k / f r a m e w o r k / s r c / t h i n k / P i p e l i n e . p h p ( 2 . 6 1 K B ) / w w w / w w w r o o t / s o k e r _ p r o / v e n d o r / t o p t h i n k / t h i n k t r a c e / s r c / T r a c e D e b u g . p h p ( 2 . 9 4 K B ) / w w w / w w w r o o t / s o k e r _ p r o / v e n d o r / t o p t h i n k / t h i n k m u l t i a p p / s r c / M u l t i A p p . p h p ( 7 . 3 9 K B ) / w w w / w w w r o o t / s o k e r _ p r o / a p p / i n d e x / c o m m o n . p h p ( 0 . 0 5 K B ) / w w w / w w w r o o t / s o k e r _ p r o / a p p / i n d e x / e v e n t . p h p ( 0 . 0 7 K B ) / w w w / w w w r o o t / s o k e r _ p r o / a p p / i n d e x / m i d d l e w a r e . p h p ( 0 . 0 8 K B ) / w w w / w w w r o o t / s o k e r _ p r o / v e n d o r / t o p t h i n k / f r a m e w o r k / s r c / t h i n k / R o u t e . p h p ( 2 3 . 4 5 K B ) / w w w / w w w r o o t / s o k e r _ p r o / v e n d o r / t o p t h i n k / f r a m e w o r k / s r c / t h i n k / r o u t e / R u l e N a m e . p h p ( 5 . 3 0 K B ) / w w w / w w w r o o t / s o k e r _ p r o / v e n d o r / t o p t h i n k / f r a m e w o r k / s r c / t h i n k / r o u t e / D o m a i n . p h p ( 5 . 4 1 K B ) / w w w / w w w r o o t / s o k e r _ p r o / v e n d o r / t o p t h i n k / f r a m e w o r k / s r c / t h i n k / r o u t e / R u l e G r o u p . p h p ( 1 3 . 9 1 K B ) / w w w / w w w r o o t / s o k e r _ p r o / v e n d o r / t o p t h i n k / f r a m e w o r k / s r c / t h i n k / r o u t e / R u l e . p h p ( 2 2 . 5 2 K B ) / w w w / w w w r o o t / s o k e r _ p r o / v e n d o r / t o p t h i n k / f r a m e w o r k / s r c / t h i n k / r o u t e / d i s p a t c h / U r l . p h p ( 3 . 4 2 K B ) / w w w / w w w r o o t / s o k e r _ p r o / v e n d o r / t o p t h i n k / f r a m e w o r k / s r c / t h i n k / r o u t e / d i s p a t c h / C o n t r o l l e r . p h p ( 6 . 6 1 K B ) / w w w / w w w r o o t / s o k e r _ p r o / v e n d o r / t o p t h i n k / f r a m e w o r k / s r c / t h i n k / r o u t e / D i s p a t c h . p h p ( 6 . 9 3 K B ) / w w w / w w w r o o t / s o k e r _ p r o / a p p / i n d e x / c o n t r o l l e r / I n d e x . p h p ( 2 . 6 1 K B ) / w w w / w w w r o o t / s o k e r _ p r o / a p p / i n d e x / c o n t r o l l e r / I n d e x b a s e . p h p ( 3 . 3 2 K B ) / w w w / w w w r o o t / s o k e r _ p r o / a p p / B a s e C o n t r o l l e r . p h p ( 2 . 0 3 K B ) / w w w / w w w r o o t / s o k e r _ p r o / a p p / i n d e x / c o m m o n / F u n c t i o n C o m m o n . p h p ( 4 1 . 1 9 K B ) / w w w / w w w r o o t / s o k e r _ p r o / v e n d o r / t o p t h i n k / f r a m e w o r k / s r c / t h i n k / f a c a d e / C a c h e . p h p ( 2 . 0 2 K B ) / w w w / w w w r o o t / s o k e r _ p r o / v e n d o r / t o p t h i n k / f r a m e w o r k / s r c / t h i n k / c a c h e / d r i v e r / R e d i s . p h p ( 6 . 7 2 K B ) / w w w / w w w r o o t / s o k e r _ p r o / v e n d o r / t o p t h i n k / t h i n k a p i / s r c / C l i e n t . p h p ( 0 . 5 4 K B ) / w w w / w w w r o o t / s o k e r _ p r o / v e n d o r / t o p t h i n k / t h i n k a p i / s r c / r e q u e s t / d e f a u l t . p h p ( 6 1 . 7 7 K B ) / w w w / w w w r o o t / s o k e r _ p r o / v e n d o r / t o p t h i n k / t h i n k a p i / s r c / R e q u e s t . p h p ( 2 . 1 2 K B ) / w w w / w w w r o o t / s o k e r _ p r o / v e n d o r / t o p t h i n k / t h i n k a p i / s r c / c o n c e r n s / O b j e c t A c c e s s . p h p ( 0 . 7 7 K B ) / w w w / w w w r o o t / s o k e r _ p r o / v e n d o r / t o p t h i n k / t h i n k a p i / s r c / c o n c e r n s / I n t e r a c t s W i t h H t t p . p h p ( 1 . 3 3 K B ) / w w w / w w w r o o t / s o k e r _ p r o / v e n d o r / t o p t h i n k / t h i n k a p i / s r c / c o n c e r n s / I n t e r a c t s W i t h R e q u e s t . p h p ( 0 . 2 2 K B ) / w w w / w w w r o o t / s o k e r _ p r o / v e n d o r / g u z z l e h t t p / g u z z l e / s r c / H a n d l e r S t a c k . p h p ( 8 . 5 2 K B ) / w w w / w w w r o o t / s o k e r _ p r o / v e n d o r / g u z z l e h t t p / g u z z l e / s r c / U t i l s . p h p ( 1 2 . 7 1 K B ) / w w w / w w w r o o t / s o k e r _ p r o / v e n d o r / g u z z l e h t t p / g u z z l e / s r c / H a n d l e r / P r o x y . p h p ( 2 . 2 3 K B ) / w w w / w w w r o o t / s o k e r _ p r o / v e n d o r / g u z z l e h t t p / g u z z l e / s r c / H a n d l e r / C u r l M u l t i H a n d l e r . p h p ( 7 . 7 5 K B ) / w w w / w w w r o o t / s o k e r _ p r o / v e n d o r / g u z z l e h t t p / g u z z l e / s r c / H a n d l e r / C u r l F a c t o r y . p h p ( 2 2 . 1 6 K B ) / w w w / w w w r o o t / s o k e r _ p r o / v e n d o r / g u z z l e h t t p / g u z z l e / s r c / H a n d l e r / C u r l F a c t o r y I n t e r f a c e . p h p ( 0 . 6 4 K B ) / w w w / w w w r o o t / s o k e r _ p r o / v e n d o r / g u z z l e h t t p / g u z z l e / s r c / H a n d l e r / C u r l H a n d l e r . p h p ( 1 . 3 0 K B ) / w w w / w w w r o o t / s o k e r _ p r o / v e n d o r / g u z z l e h t t p / g u z z l e / s r c / H a n d l e r / S t r e a m H a n d l e r . p h p ( 1 9 . 8 7 K B ) / w w w / w w w r o o t / s o k e r _ p r o / v e n d o r / g u z z l e h t t p / g u z z l e / s r c / M i d d l e w a r e . p h p ( 1 0 . 9 0 K B ) / w w w / w w w r o o t / s o k e r _ p r o / v e n d o r / t o p t h i n k / t h i n k a p i / s r c / G r o u p . p h p ( 1 . 0 0 K B ) / w w w / w w w r o o t / s o k e r _ p r o / v e n d o r / g u z z l e h t t p / g u z z l e / s r c / C l i e n t . p h p ( 1 7 . 9 4 K B ) / w w w / w w w r o o t / s o k e r _ p r o / v e n d o r / g u z z l e h t t p / g u z z l e / s r c / C l i e n t I n t e r f a c e . p h p ( 2 . 8 3 K B ) / w w w / w w w r o o t / s o k e r _ p r o / v e n d o r / p s r / h t t p c l i e n t / s r c / C l i e n t I n t e r f a c e . p h p ( 0 . 4 9 K B ) / w w w / w w w r o o t / s o k e r _ p r o / v e n d o r / g u z z l e h t t p / g u z z l e / s r c / C l i e n t T r a i t . p h p ( 8 . 7 9 K B ) / w w w / w w w r o o t / s o k e r _ p r o / v e n d o r / g u z z l e h t t p / p s r 7 / s r c / U t i l s . p h p ( 1 3 . 9 1 K B ) / w w w / w w w r o o t / s o k e r _ p r o / v e n d o r / g u z z l e h t t p / p s r 7 / s r c / U r i . p h p ( 2 1 . 3 3 K B ) / w w w / w w w r o o t / s o k e r _ p r o / v e n d o r / p s r / h t t p m e s s a g e / s r c / U r i I n t e r f a c e . p h p ( 1 2 . 3 1 K B ) / w w w / w w w r o o t / s o k e r _ p r o / v e n d o r / g u z z l e h t t p / g u z z l e / s r c / R e d i r e c t M i d d l e w a r e . p h p ( 7 . 5 0 K B ) / w w w / w w w r o o t / s o k e r _ p r o / v e n d o r / g u z z l e h t t p / g u z z l e / s r c / R e q u e s t O p t i o n s . p h p ( 1 0 . 3 2 K B ) / w w w / w w w r o o t / s o k e r _ p r o / v e n d o r / g u z z l e h t t p / p s r 7 / s r c / U r i R e s o l v e r . p h p ( 8 . 3 6 K B ) / w w w / w w w r o o t / s o k e r _ p r o / v e n d o r / g u z z l e h t t p / p s r 7 / s r c / R e q u e s t . p h p ( 3 . 8 1 K B ) / w w w / w w w r o o t / s o k e r _ p r o / v e n d o r / p s r / h t t p m e s s a g e / s r c / R e q u e s t I n t e r f a c e . p h p ( 4 . 7 0 K B ) / w w w / w w w r o o t / s o k e r _ p r o / v e n d o r / p s r / h t t p m e s s a g e / s r c / M e s s a g e I n t e r f a c e . p h p ( 6 . 7 5 K B ) / w w w / w w w r o o t / s o k e r _ p r o / v e n d o r / g u z z l e h t t p / p s r 7 / s r c / M e s s a g e T r a i t . p h p ( 6 . 4 6 K B ) / w w w / w w w r o o t / s o k e r _ p r o / v e n d o r / g u z z l e h t t p / p s r 7 / s r c / S t r e a m . p h p ( 7 . 1 2 K B ) / w w w / w w w r o o t / s o k e r _ p r o / v e n d o r / p s r / h t t p m e s s a g e / s r c / S t r e a m I n t e r f a c e . p h p ( 4 . 6 3 K B ) / w w w / w w w r o o t / s o k e r _ p r o / v e n d o r / g u z z l e h t t p / p r o m i s e s / s r c / C r e a t e . p h p ( 2 . 0 6 K B ) / w w w / w w w r o o t / s o k e r _ p r o / v e n d o r / g u z z l e h t t p / g u z z l e / s r c / P r e p a r e B o d y M i d d l e w a r e . p h p ( 3 . 0 7 K B ) / w w w / w w w r o o t / s o k e r _ p r o / v e n d o r / g u z z l e h t t p / g u z z l e / s r c / H a n d l e r / E a s y H a n d l e . p h p ( 2 . 8 3 K B ) / w w w / w w w r o o t / s o k e r _ p r o / v e n d o r / g u z z l e h t t p / g u z z l e / s r c / H a n d l e r / H e a d e r P r o c e s s o r . p h p ( 1 . 0 3 K B ) / w w w / w w w r o o t / s o k e r _ p r o / v e n d o r / g u z z l e h t t p / p s r 7 / s r c / R e s p o n s e . p h p ( 4 . 7 9 K B ) / w w w / w w w r o o t / s o k e r _ p r o / v e n d o r / p s r / h t t p m e s s a g e / s r c / R e s p o n s e I n t e r f a c e . p h p ( 2 . 5 3 K B ) / w w w / w w w r o o t / s o k e r _ p r o / v e n d o r / g u z z l e h t t p / p r o m i s e s / s r c / F u l f i l l e d P r o m i s e . p h p ( 1 . 9 4 K B ) / w w w / w w w r o o t / s o k e r _ p r o / v e n d o r / g u z z l e h t t p / p r o m i s e s / s r c / P r o m i s e I n t e r f a c e . p h p ( 2 . 7 9 K B ) / w w w / w w w r o o t / s o k e r _ p r o / v e n d o r / g u z z l e h t t p / p r o m i s e s / s r c / U t i l s . p h p ( 8 . 5 0 K B ) / w w w / w w w r o o t / s o k e r _ p r o / v e n d o r / g u z z l e h t t p / p r o m i s e s / s r c / T a s k Q u e u e . p h p ( 1 . 8 9 K B ) / w w w / w w w r o o t / s o k e r _ p r o / v e n d o r / g u z z l e h t t p / p r o m i s e s / s r c / T a s k Q u e u e I n t e r f a c e . p h p ( 0 . 4 2 K B ) / w w w / w w w r o o t / s o k e r _ p r o / v e n d o r / g u z z l e h t t p / p r o m i s e s / s r c / P r o m i s e . p h p ( 8 . 7 3 K B ) / w w w / w w w r o o t / s o k e r _ p r o / v e n d o r / g u z z l e h t t p / p r o m i s e s / s r c / I s . p h p ( 0 . 9 8 K B ) / w w w / w w w r o o t / s o k e r _ p r o / v e n d o r / t o p t h i n k / t h i n k o r m / s r c / f a c a d e / D b . p h p ( 0 . 9 4 K B ) / w w w / w w w r o o t / s o k e r _ p r o / v e n d o r / t o p t h i n k / t h i n k o r m / s r c / d b / c o n n e c t o r / M y s q l . p h p ( 4 . 3 9 K B ) / w w w / w w w r o o t / s o k e r _ p r o / v e n d o r / t o p t h i n k / t h i n k o r m / s r c / d b / P D O C o n n e c t i o n . p h p ( 5 0 . 6 8 K B ) / w w w / w w w r o o t / s o k e r _ p r o / v e n d o r / t o p t h i n k / t h i n k o r m / s r c / d b / C o n n e c t i o n . p h p ( 7 . 6 7 K B ) / w w w / w w w r o o t / s o k e r _ p r o / v e n d o r / t o p t h i n k / t h i n k o r m / s r c / d b / C o n n e c t i o n I n t e r f a c e . p h p ( 4 . 5 6 K B ) / w w w / w w w r o o t / s o k e r _ p r o / v e n d o r / t o p t h i n k / t h i n k o r m / s r c / d b / b u i l d e r / M y s q l . p h p ( 1 4 . 2 2 K B ) / w w w / w w w r o o t / s o k e r _ p r o / v e n d o r / t o p t h i n k / t h i n k o r m / s r c / d b / B u i l d e r . p h p ( 3 9 . 5 2 K B ) / w w w / w w w r o o t / s o k e r _ p r o / v e n d o r / t o p t h i n k / t h i n k o r m / s r c / d b / Q u e r y . p h p ( 1 1 . 1 0 K B ) / w w w / w w w r o o t / s o k e r _ p r o / v e n d o r / t o p t h i n k / t h i n k o r m / s r c / d b / B a s e Q u e r y . p h p ( 3 6 . 2 4 K B ) / w w w / w w w r o o t / s o k e r _ p r o / v e n d o r / t o p t h i n k / t h i n k o r m / s r c / d b / c o n c e r n / T i m e F i e l d Q u e r y . p h p ( 7 . 5 0 K B ) / w w w / w w w r o o t / s o k e r _ p r o / v e n d o r / t o p t h i n k / t h i n k o r m / s r c / d b / c o n c e r n / A g g r e g a t e Q u e r y . p h p ( 2 . 8 3 K B ) / w w w / w w w r o o t / s o k e r _ p r o / v e n d o r / t o p t h i n k / t h i n k o r m / s r c / d b / c o n c e r n / M o d e l R e l a t i o n Q u e r y . p h p ( 1 6 . 4 7 K B ) / w w w / w w w r o o t / s o k e r _ p r o / v e n d o r / t o p t h i n k / t h i n k o r m / s r c / d b / c o n c e r n / R e s u l t O p e r a t i o n . p h p ( 6 . 2 9 K B ) / w w w / w w w r o o t / s o k e r _ p r o / v e n d o r / t o p t h i n k / t h i n k o r m / s r c / d b / c o n c e r n / T r a n s a c t i o n . p h p ( 2 . 8 5 K B ) / w w w / w w w r o o t / s o k e r _ p r o / v e n d o r / t o p t h i n k / t h i n k o r m / s r c / d b / c o n c e r n / W h e r e Q u e r y . p h p ( 1 6 . 2 5 K B ) / w w w / w w w r o o t / s o k e r _ p r o / v e n d o r / t o p t h i n k / t h i n k o r m / s r c / d b / c o n c e r n / J o i n A n d V i e w Q u e r y . p h p ( 6 . 8 8 K B ) / w w w / w w w r o o t / s o k e r _ p r o / v e n d o r / t o p t h i n k / t h i n k o r m / s r c / d b / c o n c e r n / P a r a m s B i n d . p h p ( 2 . 7 5 K B ) / w w w / w w w r o o t / s o k e r _ p r o / v e n d o r / t o p t h i n k / t h i n k o r m / s r c / d b / c o n c e r n / T a b l e F i e l d I n f o . p h p ( 2 . 5 1 K B ) / w w w / w w w r o o t / s o k e r _ p r o / v e n d o r / t o p t h i n k / f r a m e w o r k / s r c / t h i n k / l o g / d r i v e r / F i l e . p h p ( 6 . 1 7 K B ) / w w w / w w w r o o t / s o k e r _ p r o / v e n d o r / t o p t h i n k / f r a m e w o r k / s r c / t h i n k / c o n t r a c t / L o g H a n d l e r I n t e r f a c e . p h p ( 0 . 8 6 K B ) / w w w / w w w r o o t / s o k e r _ p r o / v e n d o r / t o p t h i n k / f r a m e w o r k / s r c / t h i n k / l o g / C h a n n e l . p h p ( 6 . 5 4 K B ) / w w w / w w w r o o t / s o k e r _ p r o / v e n d o r / t o p t h i n k / f r a m e w o r k / s r c / t h i n k / e v e n t / L o g R e c o r d . p h p ( 0 . 8 6 K B ) / w w w / w w w r o o t / s o k e r _ p r o / v e n d o r / t o p t h i n k / t h i n k h e l p e r / s r c / C o l l e c t i o n . p h p ( 1 6 . 1 0 K B ) / w w w / w w w r o o t / s o k e r _ p r o / a p p / i n d e x / m o d e l / I n d e x . p h p ( 1 2 . 8 3 K B ) / w w w / w w w r o o t / s o k e r _ p r o / a p p / s o k e r H o m e / c o m m o n / F u n c t i o n C o m m o n . p h p ( 3 . 5 2 K B ) / w w w / w w w r o o t / s o k e r _ p r o / v e n d o r / t o p t h i n k / t h i n k o r m / s r c / d b / R a w . p h p ( 1 . 4 7 K B ) / w w w / w w w r o o t / s o k e r _ p r o / v e n d o r / t o p t h i n k / t h i n k o r m / s r c / d b / F e t c h . p h p ( 1 2 . 9 0 K B ) / w w w / w w w r o o t / s o k e r _ p r o / a p p / d r i v e r / M y P a g i n a t o r . p h p ( 5 . 9 9 K B ) / w w w / w w w r o o t / s o k e r _ p r o / a p p / i n d e x / c o m m o n / C l a s s F u n c t i o n . p h p ( 3 2 . 7 3 K B ) / w w w / w w w r o o t / s o k e r _ p r o / v e n d o r / t o p t h i n k / f r a m e w o r k / s r c / t h i n k / f a c a d e / V i e w . p h p ( 1 . 7 1 K B ) / w w w / w w w r o o t / s o k e r _ p r o / v e n d o r / t o p t h i n k / f r a m e w o r k / s r c / t h i n k / V i e w . p h p ( 4 . 4 1 K B ) / w w w / w w w r o o t / s o k e r _ p r o / v e n d o r / t o p t h i n k / t h i n k v i e w / s r c / T h i n k . p h p ( 8 . 4 2 K B ) / w w w / w w w r o o t / s o k e r _ p r o / v e n d o r / t o p t h i n k / t h i n k t e m p l a t e / s r c / T e m p l a t e . p h p ( 4 6 . 8 2 K B ) / w w w / w w w r o o t / s o k e r _ p r o / v e n d o r / t o p t h i n k / t h i n k t e m p l a t e / s r c / t e m p l a t e / d r i v e r / F i l e . p h p ( 2 . 3 3 K B ) / w w w / w w w r o o t / s o k e r _ p r o / r u n t i m e / i n d e x / t e m p / 9 1 d c b 2 c 0 3 7 4 f 4 f 4 a 9 0 0 3 f 9 1 8 8 4 8 b 3 f e 6 . p h p ( 4 0 . 1 4 K B ) / w w w / w w w r o o t / s o k e r _ p r o / v e n d o r / t o p t h i n k / f r a m e w o r k / s r c / t h i n k / R e s p o n s e . p h p ( 8 . 6 0 K B ) / w w w / w w w r o o t / s o k e r _ p r o / v e n d o r / t o p t h i n k / f r a m e w o r k / s r c / t h i n k / r e s p o n s e / H t m l . p h p ( 0 . 9 8 K B ) / w w w / w w w r o o t / s o k e r _ p r o / v e n d o r / t o p t h i n k / f r a m e w o r k / s r c / t h i n k / C o o k i e . p h p ( 6 . 2 8 K B ) / w w w / w w w r o o t / s o k e r _ p r o / v e n d o r / t o p t h i n k / t h i n k t r a c e / s r c / H t m l . p h p ( 4 . 4 9 K B ) C O N N E C T : [ U s e T i m e : 0 . 0 0 0 3 6 8 s ] m y s q l : h o s t = 1 2 7 . 0 . 0 . 1 ; p o r t = 3 3 0 6 ; d b n a m e = s o k e r _ p r o ; c h a r s e t = u t f 8 m b 4 S H O W F U L L C O L U M N S F R O M ` s o k e r _ c i t y _ p r o v i n c e ` [ R u n T i m e : 0 . 0 0 0 9 3 9 s ] S E L E C T ` i d ` , ` p r o v i n c e _ n a m e ` , ` p r o v i n c e _ c a p i t a l i d ` , ` p r o v i n c e _ i s d e l e t e ` F R O M ` s o k e r _ c i t y _ p r o v i n c e ` W H E R E ` p r o v i n c e _ n a m e ` = 北京 A N D ` p r o v i n c e _ i s d e l e t e ` = 0 L I M I T 1 [ R u n T i m e : 0 . 0 0 0 2 5 2 s ] S H O W F U L L C O L U M N S F R O M ` s o k e r _ c i t y ` [ R u n T i m e : 0 . 0 0 0 9 7 4 s ] S E L E C T ` i d ` , ` c i t y _ n a m e ` , ` c i t y _ p i d ` , ` c i t y _ d i r e c t o r y ` F R O M ` s o k e r _ c i t y ` W H E R E ` c i t y _ n a m e ` = 北京 L I M I T 1 [ R u n T i m e : 0 . 0 0 0 2 5 5 s ] S H O W F U L L C O L U M N S F R O M ` s o k e r _ a d v ` [ R u n T i m e : 0 . 0 0 0 8 1 9 s ] S E L E C T ` i d ` , ` a d v _ t y p e ` F R O M ` s o k e r _ a d v ` W H E R E ` i d ` = 1 A N D ` a d v _ i s D e l e t e ` = 0 L I M I T 1 [ R u n T i m e : 0 . 0 0 0 2 2 2 s ] S H O W F U L L C O L U M N S F R O M ` s o k e r _ a d v _ d a t a ` [ R u n T i m e : 0 . 0 0 0 7 8 9 s ] S E L E C T ` d a t a _ t i t l e ` , ` d a t a _ i m a g e s ` , ` d a t a _ u r l ` F R O M ` s o k e r _ a d v _ d a t a ` W H E R E ` d a t a _ p i d ` = 1 A N D ` d a t a _ c i t y i d ` = 1 A N D ` d a t a _ i s D e l e t e ` = 0 O R D E R B Y ` d a t a _ o r d e r i d ` A S C , ` i d ` D E S C [ R u n T i m e : 0 . 0 0 0 2 4 4 s ] S E L E C T ` d a t a _ t i t l e ` , ` d a t a _ i m a g e s ` , ` d a t a _ u r l ` F R O M ` s o k e r _ a d v _ d a t a ` W H E R E ` d a t a _ p i d ` = 1 A N D ` d a t a _ c i t y i d ` = 0 A N D ` d a t a _ i s D e l e t e ` = 0 O R D E R B Y ` d a t a _ o r d e r i d ` A S C , ` i d ` D E S C [ R u n T i m e : 0 . 0 0 0 2 4 4 s ] S H O W F U L L C O L U M N S F R O M ` s o k e r _ s c h o o l ` [ R u n T i m e : 0 . 0 0 1 0 5 3 s ] S E L E C T a . ` i d ` , a . ` s c h o o l _ n a m e ` , a . ` s c h o o l _ l o g o ` , a . ` s c h o o l _ c a m p u s N u m s ` F R O M ` s o k e r _ s c h o o l ` ` a ` L E F T J O I N ` s o k e r _ s c h o o l _ m a t e r i a l s _ c o u r s e ` ` b ` O N a . ` i d ` = b . ` s c h o o l _ i d ` L E F T J O I N ` s o k e r _ s c h o o l _ m a t e r i a l s ` ` c ` O N b . ` c o u r s e _ i d ` = c . ` i d ` W H E R E ` b ` . ` c a t i d _ o n e ` = 3 1 2 A N D ` a ` . ` i s D e l e t e ` = 0 A N D ` a ` . ` i s T r u e ` = 2 A N D ` c ` . ` m a t e r i a l _ i s d e l e t e ` = 0 G R O U P B Y ` a ` . ` i d ` H A V I N G a . s c h o o l _ c a m p u s N u m s > = 5 O R D E R B Y ` a ` . ` o r d e r i d ` A S C , ` a ` . ` i d ` A S C L I M I T 1 2 [ R u n T i m e : 0 . 0 0 5 3 1 2 s ] S E L E C T a . ` i d ` , a . ` s c h o o l _ n a m e ` , a . ` s c h o o l _ l o g o ` , a . ` s c h o o l _ c a m p u s N u m s ` F R O M ` s o k e r _ s c h o o l ` ` a ` L E F T J O I N ` s o k e r _ s c h o o l _ m a t e r i a l s _ c o u r s e ` ` b ` O N a . ` i d ` = b . ` s c h o o l _ i d ` L E F T J O I N ` s o k e r _ s c h o o l _ m a t e r i a l s ` ` c ` O N b . ` c o u r s e _ i d ` = c . ` i d ` W H E R E ` b ` . ` c a t i d _ o n e ` = 3 3 7 A N D ` a ` . ` i s D e l e t e ` = 0 A N D ` a ` . ` i s T r u e ` = 2 A N D ` c ` . ` m a t e r i a l _ i s d e l e t e ` = 0 G R O U P B Y ` a ` . ` i d ` H A V I N G a . s c h o o l _ c a m p u s N u m s > = 5 O R D E R B Y ` a ` . ` o r d e r i d ` A S C , ` a ` . ` i d ` A S C L I M I T 1 2 [ R u n T i m e : 0 . 0 0 8 9 8 9 s ] S E L E C T a . ` i d ` , a . ` s c h o o l _ n a m e ` , a . ` s c h o o l _ l o g o ` , a . ` s c h o o l _ c a m p u s N u m s ` F R O M ` s o k e r _ s c h o o l ` ` a ` L E F T J O I N ` s o k e r _ s c h o o l _ m a t e r i a l s _ c o u r s e ` ` b ` O N a . ` i d ` = b . ` s c h o o l _ i d ` L E F T J O I N ` s o k e r _ s c h o o l _ m a t e r i a l s ` ` c ` O N b . ` c o u r s e _ i d ` = c . ` i d ` W H E R E ` b ` . ` c a t i d _ o n e ` = 1 A N D ` a ` . ` i s D e l e t e ` = 0 A N D ` a ` . ` i s T r u e ` = 2 A N D ` c ` . ` m a t e r i a l _ i s d e l e t e ` = 0 G R O U P B Y ` a ` . ` i d ` H A V I N G a . s c h o o l _ c a m p u s N u m s > = 5 O R D E R B Y ` a ` . ` o r d e r i d ` A S C , ` a ` . ` i d ` A S C L I M I T 1 2 [ R u n T i m e : 0 . 0 0 5 3 0 8 s ] S E L E C T a . ` i d ` , a . ` s c h o o l _ n a m e ` , a . ` s c h o o l _ l o g o ` , a . ` s c h o o l _ c a m p u s N u m s ` F R O M ` s o k e r _ s c h o o l ` ` a ` L E F T J O I N ` s o k e r _ s c h o o l _ m a t e r i a l s _ c o u r s e ` ` b ` O N a . ` i d ` = b . ` s c h o o l _ i d ` L E F T J O I N ` s o k e r _ s c h o o l _ m a t e r i a l s ` ` c ` O N b . ` c o u r s e _ i d ` = c . ` i d ` W H E R E ` b ` . ` c a t i d _ o n e ` = 5 5 2 A N D ` a ` . ` i s D e l e t e ` = 0 A N D ` a ` . ` i s T r u e ` = 2 A N D ` c ` . ` m a t e r i a l _ i s d e l e t e ` = 0 G R O U P B Y ` a ` . ` i d ` H A V I N G a . s c h o o l _ c a m p u s N u m s > = 5 O R D E R B Y ` a ` . ` o r d e r i d ` A S C , ` a ` . ` i d ` A S C L I M I T 1 2 [ R u n T i m e : 0 . 0 0 4 1 7 5 s ] S E L E C T a . ` i d ` , a . ` s c h o o l _ n a m e ` , a . ` s c h o o l _ l o g o ` , a . ` s c h o o l _ c a m p u s N u m s ` F R O M ` s o k e r _ s c h o o l ` ` a ` L E F T J O I N ` s o k e r _ s c h o o l _ m a t e r i a l s _ c o u r s e ` ` b ` O N a . ` i d ` = b . ` s c h o o l _ i d ` L E F T J O I N ` s o k e r _ s c h o o l _ m a t e r i a l s ` ` c ` O N b . ` c o u r s e _ i d ` = c . ` i d ` W H E R E ` b ` . ` c a t i d _ o n e ` = 3 0 0 A N D ` a ` . ` i s D e l e t e ` = 0 A N D ` a ` . ` i s T r u e ` = 2 A N D ` c ` . ` m a t e r i a l _ i s d e l e t e ` = 0 G R O U P B Y ` a ` . ` i d ` H A V I N G a . s c h o o l _ c a m p u s N u m s > = 5 O R D E R B Y ` a ` . ` o r d e r i d ` A S C , ` a ` . ` i d ` A S C L I M I T 1 2 [ R u n T i m e : 0 . 0 0 3 9 7 4 s ] S E L E C T a . ` i d ` , a . ` s c h o o l _ n a m e ` , a . ` s c h o o l _ l o g o ` , a . ` s c h o o l _ c a m p u s N u m s ` F R O M ` s o k e r _ s c h o o l ` ` a ` L E F T J O I N ` s o k e r _ s c h o o l _ m a t e r i a l s _ c o u r s e ` ` b ` O N a . ` i d ` = b . ` s c h o o l _ i d ` L E F T J O I N ` s o k e r _ s c h o o l _ m a t e r i a l s ` ` c ` O N b . ` c o u r s e _ i d ` = c . ` i d ` W H E R E ` b ` . ` c a t i d _ o n e ` = 2 6 1 A N D ` a ` . ` i s D e l e t e ` = 0 A N D ` a ` . ` i s T r u e ` = 2 A N D ` c ` . ` m a t e r i a l _ i s d e l e t e ` = 0 G R O U P B Y ` a ` . ` i d ` H A V I N G a . s c h o o l _ c a m p u s N u m s > = 5 O R D E R B Y ` a ` . ` o r d e r i d ` A S C , ` a ` . ` i d ` A S C L I M I T 1 2 [ R u n T i m e : 0 . 0 0 4 8 8 5 s ] S E L E C T a . ` i d ` , a . ` s c h o o l _ n a m e ` , a . ` s c h o o l _ l o g o ` , a . ` s c h o o l _ c a m p u s N u m s ` F R O M ` s o k e r _ s c h o o l ` ` a ` L E F T J O I N ` s o k e r _ s c h o o l _ m a t e r i a l s _ c o u r s e ` ` b ` O N a . ` i d ` = b . ` s c h o o l _ i d ` L E F T J O I N ` s o k e r _ s c h o o l _ m a t e r i a l s ` ` c ` O N b . ` c o u r s e _ i d ` = c . ` i d ` W H E R E ` b ` . ` c a t i d _ o n e ` = 1 4 6 A N D ` a ` . ` i s D e l e t e ` = 0 A N D ` a ` . ` i s T r u e ` = 2 A N D ` c ` . ` m a t e r i a l _ i s d e l e t e ` = 0 G R O U P B Y ` a ` . ` i d ` H A V I N G a . s c h o o l _ c a m p u s N u m s > = 5 O R D E R B Y ` a ` . ` o r d e r i d ` A S C , ` a ` . ` i d ` A S C L I M I T 1 2 [ R u n T i m e : 0 . 0 0 4 5 1 3 s ] S E L E C T a . ` i d ` , a . ` s c h o o l _ n a m e ` , a . ` s c h o o l _ l o g o ` , a . ` s c h o o l _ c a m p u s N u m s ` F R O M ` s o k e r _ s c h o o l ` ` a ` L E F T J O I N ` s o k e r _ s c h o o l _ m a t e r i a l s _ c o u r s e ` ` b ` O N a . ` i d ` = b . ` s c h o o l _ i d ` L E F T J O I N ` s o k e r _ s c h o o l _ m a t e r i a l s ` ` c ` O N b . ` c o u r s e _ i d ` = c . ` i d ` W H E R E ` b ` . ` c a t i d _ o n e ` = 2 3 A N D ` a ` . ` i s D e l e t e ` = 0 A N D ` a ` . ` i s T r u e ` = 2 A N D ` c ` . ` m a t e r i a l _ i s d e l e t e ` = 0 G R O U P B Y ` a ` . ` i d ` H A V I N G a . s c h o o l _ c a m p u s N u m s > = 5 O R D E R B Y ` a ` . ` o r d e r i d ` A S C , ` a ` . ` i d ` A S C L I M I T 1 2 [ R u n T i m e : 0 . 0 0 4 5 8 1 s ] S E L E C T ` i d ` , ` c i t y _ n a m e ` , ` c i t y _ d i r e c t o r y ` F R O M ` s o k e r _ c i t y ` W H E R E ` c i t y _ d i r e c t o r y ` = b j L I M I T 1 [ R u n T i m e : 0 . 0 0 0 2 3 5 s ] S H O W F U L L C O L U M N S F R O M ` s o k e r _ s c h o o l _ m a t e r i a l s ` [ R u n T i m e : 0 . 0 0 1 0 0 7 s ] S E L E C T a . ` i d ` , a . ` m a t e r i a l _ t i t l e ` , a . ` m a t e r i a l _ i m a g e s ` , a . ` m a t e r i a l _ p r i c e ` , b . ` c a m p u s _ i d ` , b . ` c a t i d _ t h r e e ` F R O M ` s o k e r _ s c h o o l _ m a t e r i a l s ` ` a ` L E F T J O I N ` s o k e r _ s c h o o l _ c a m p u s _ c o u r s e ` ` b ` O N a . ` i d ` = b . ` c o u r s e _ i d ` W H E R E ` b ` . ` c a t i d _ o n e ` = 3 1 2 A N D ` b ` . ` c i t y i d ` = 1 A N D ` b ` . ` c o u r s e _ s t a t u s ` = 1 A N D ` a ` . ` m a t e r i a l _ i s d e l e t e ` = 0 G R O U P B Y ` a ` . ` i d ` O R D E R B Y ` a ` . ` m a t e r i a l _ o r d e r T i m e ` D E S C , ` a ` . ` m a t e r i a l _ o r d e r i d ` A S C , ` a ` . ` i d ` A S C L I M I T 8 [ R u n T i m e : 0 . 0 1 0 4 3 8 s ] S H O W F U L L C O L U M N S F R O M ` s o k e r _ c a t e g o r y ` [ R u n T i m e : 0 . 0 0 0 9 6 5 s ] S E L E C T ` i d ` , ` c a t _ n a m e ` , ` c a t _ d i r e c t o r y ` F R O M ` s o k e r _ c a t e g o r y ` W H E R E ` i d ` = 3 2 1 L I M I T 1 [ R u n T i m e : 0 . 0 0 0 2 2 1 s ] S H O W F U L L C O L U M N S F R O M ` s o k e r _ s c h o o l _ c a m p u s _ c o u r s e ` [ R u n T i m e : 0 . 0 0 0 9 1 9 s ] S E L E C T C O U N T ( D I S T I N C T ` c a m p u s _ i d ` ) A S t h i n k _ c o u n t F R O M ` s o k e r _ s c h o o l _ c a m p u s _ c o u r s e ` W H E R E ` c o u r s e _ i d ` = 2 6 1 0 2 A N D ` c o u r s e _ s t a t u s ` = 1 L I M I T 1 [ R u n T i m e : 0 . 0 0 0 3 1 7 s ] S E L E C T a . ` i d ` , a . ` s c h o o l _ n a m e ` , a . ` s c h o o l _ l o g o ` F R O M ` s o k e r _ s c h o o l ` ` a ` L E F T J O I N ` s o k e r _ s c h o o l _ c a m p u s ` ` b ` O N a . ` i d ` = b . ` s c h o o l _ i d ` W H E R E ` b ` . ` c a m p u s _ s t a t u s ` = 1 A N D ` b ` . ` c a m p u s _ i s d e l e t e ` = 0 A N D ` b ` . ` i d ` = 8 5 9 8 L I M I T 1 [ R u n T i m e : 0 . 0 0 0 2 3 4 s ] S E L E C T ` i d ` , ` c a t _ n a m e ` , ` c a t _ d i r e c t o r y ` F R O M ` s o k e r _ c a t e g o r y ` W H E R E ` i d ` = 3 2 2 L I M I T 1 [ R u n T i m e : 0 . 0 0 0 1 8 6 s ] S E L E C T C O U N T ( D I S T I N C T ` c a m p u s _ i d ` ) A S t h i n k _ c o u n t F R O M ` s o k e r _ s c h o o l _ c a m p u s _ c o u r s e ` W H E R E ` c o u r s e _ i d ` = 2 6 1 0 7 A N D ` c o u r s e _ s t a t u s ` = 1 L I M I T 1 [ R u n T i m e : 0 . 0 0 0 2 6 4 s ] S E L E C T a . ` i d ` , a . ` s c h o o l _ n a m e ` , a . ` s c h o o l _ l o g o ` F R O M ` s o k e r _ s c h o o l ` ` a ` L E F T J O I N ` s o k e r _ s c h o o l _ c a m p u s ` ` b ` O N a . ` i d ` = b . ` s c h o o l _ i d ` W H E R E ` b ` . ` c a m p u s _ s t a t u s ` = 1 A N D ` b ` . ` c a m p u s _ i s d e l e t e ` = 0 A N D ` b ` . ` i d ` = 8 5 9 8 L I M I T 1 [ R u n T i m e : 0 . 0 0 0 2 0 2 s ] S E L E C T ` i d ` , ` c a t _ n a m e ` , ` c a t _ d i r e c t o r y ` F R O M ` s o k e r _ c a t e g o r y ` W H E R E ` i d ` = 3 3 3 L I M I T 1 [ R u n T i m e : 0 . 0 0 0 1 7 3 s ] S E L E C T C O U N T ( D I S T I N C T ` c a m p u s _ i d ` ) A S t h i n k _ c o u n t F R O M ` s o k e r _ s c h o o l _ c a m p u s _ c o u r s e ` W H E R E ` c o u r s e _ i d ` = 2 6 1 0 8 A N D ` c o u r s e _ s t a t u s ` = 1 L I M I T 1 [ R u n T i m e : 0 . 0 0 0 2 4 8 s ] S E L E C T a . ` i d ` , a . ` s c h o o l _ n a m e ` , a . ` s c h o o l _ l o g o ` F R O M ` s o k e r _ s c h o o l ` ` a ` L E F T J O I N ` s o k e r _ s c h o o l _ c a m p u s ` ` b ` O N a . ` i d ` = b . ` s c h o o l _ i d ` W H E R E ` b ` . ` c a m p u s _ s t a t u s ` = 1 A N D ` b ` . ` c a m p u s _ i s d e l e t e ` = 0 A N D ` b ` . ` i d ` = 8 5 9 8 L I M I T 1 [ R u n T i m e : 0 . 0 0 0 2 0 8 s ] S E L E C T ` i d ` , ` c a t _ n a m e ` , ` c a t _ d i r e c t o r y ` F R O M ` s o k e r _ c a t e g o r y ` W H E R E ` i d ` = 3 2 2 L I M I T 1 [ R u n T i m e : 0 . 0 0 0 1 6 8 s ] S E L E C T C O U N T ( D I S T I N C T ` c a m p u s _ i d ` ) A S t h i n k _ c o u n t F R O M ` s o k e r _ s c h o o l _ c a m p u s _ c o u r s e ` W H E R E ` c o u r s e _ i d ` = 2 6 1 0 6 A N D ` c o u r s e _ s t a t u s ` = 1 L I M I T 1 [ R u n T i m e : 0 . 0 0 0 2 6 5 s ] S E L E C T a . ` i d ` , a . ` s c h o o l _ n a m e ` , a . ` s c h o o l _ l o g o ` F R O M ` s o k e r _ s c h o o l ` ` a ` L E F T J O I N ` s o k e r _ s c h o o l _ c a m p u s ` ` b ` O N a . ` i d ` = b . ` s c h o o l _ i d ` W H E R E ` b ` . ` c a m p u s _ s t a t u s ` = 1 A N D ` b ` . ` c a m p u s _ i s d e l e t e ` = 0 A N D ` b ` . ` i d ` = 8 5 9 8 L I M I T 1 [ R u n T i m e : 0 . 0 0 0 2 1 1 s ] S E L E C T ` i d ` , ` c a t _ n a m e ` , ` c a t _ d i r e c t o r y ` F R O M ` s o k e r _ c a t e g o r y ` W H E R E ` i d ` = 5 8 9 L I M I T 1 [ R u n T i m e : 0 . 0 0 0 1 6 9 s ] S E L E C T C O U N T ( D I S T I N C T ` c a m p u s _ i d ` ) A S t h i n k _ c o u n t F R O M ` s o k e r _ s c h o o l _ c a m p u s _ c o u r s e ` W H E R E ` c o u r s e _ i d ` = 2 6 1 0 5 A N D ` c o u r s e _ s t a t u s ` = 1 L I M I T 1 [ R u n T i m e : 0 . 0 0 0 2 6 1 s ] S E L E C T a . ` i d ` , a . ` s c h o o l _ n a m e ` , a . ` s c h o o l _ l o g o ` F R O M ` s o k e r _ s c h o o l ` ` a ` L E F T J O I N ` s o k e r _ s c h o o l _ c a m p u s ` ` b ` O N a . ` i d ` = b . ` s c h o o l _ i d ` W H E R E ` b ` . ` c a m p u s _ s t a t u s ` = 1 A N D ` b ` . ` c a m p u s _ i s d e l e t e ` = 0 A N D ` b ` . ` i d ` = 8 5 9 8 L I M I T 1 [ R u n T i m e : 0 . 0 0 0 2 0 1 s ] S E L E C T ` i d ` , ` c a t _ n a m e ` , ` c a t _ d i r e c t o r y ` F R O M ` s o k e r _ c a t e g o r y ` W H E R E ` i d ` = 3 2 2 L I M I T 1 [ R u n T i m e : 0 . 0 0 0 1 6 7 s ] S E L E C T C O U N T ( D I S T I N C T ` c a m p u s _ i d ` ) A S t h i n k _ c o u n t F R O M ` s o k e r _ s c h o o l _ c a m p u s _ c o u r s e ` W H E R E ` c o u r s e _ i d ` = 2 6 1 0 4 A N D ` c o u r s e _ s t a t u s ` = 1 L I M I T 1 [ R u n T i m e : 0 . 0 0 0 2 5 5 s ] S E L E C T a . ` i d ` , a . ` s c h o o l _ n a m e ` , a . ` s c h o o l _ l o g o ` F R O M ` s o k e r _ s c h o o l ` ` a ` L E F T J O I N ` s o k e r _ s c h o o l _ c a m p u s ` ` b ` O N a . ` i d ` = b . ` s c h o o l _ i d ` W H E R E ` b ` . ` c a m p u s _ s t a t u s ` = 1 A N D ` b ` . ` c a m p u s _ i s d e l e t e ` = 0 A N D ` b ` . ` i d ` = 8 5 9 8 L I M I T 1 [ R u n T i m e : 0 . 0 0 0 2 0 0 s ] S E L E C T ` i d ` , ` c a t _ n a m e ` , ` c a t _ d i r e c t o r y ` F R O M ` s o k e r _ c a t e g o r y ` W H E R E ` i d ` = 5 8 9 L I M I T 1 [ R u n T i m e : 0 . 0 0 0 1 6 8 s ] S E L E C T C O U N T ( D I S T I N C T ` c a m p u s _ i d ` ) A S t h i n k _ c o u n t F R O M ` s o k e r _ s c h o o l _ c a m p u s _ c o u r s e ` W H E R E ` c o u r s e _ i d ` = 2 6 1 0 3 A N D ` c o u r s e _ s t a t u s ` = 1 L I M I T 1 [ R u n T i m e : 0 . 0 0 0 2 6 2 s ] S E L E C T a . ` i d ` , a . ` s c h o o l _ n a m e ` , a . ` s c h o o l _ l o g o ` F R O M ` s o k e r _ s c h o o l ` ` a ` L E F T J O I N ` s o k e r _ s c h o o l _ c a m p u s ` ` b ` O N a . ` i d ` = b . ` s c h o o l _ i d ` W H E R E ` b ` . ` c a m p u s _ s t a t u s ` = 1 A N D ` b ` . ` c a m p u s _ i s d e l e t e ` = 0 A N D ` b ` . ` i d ` = 8 5 9 8 L I M I T 1 [ R u n T i m e : 0 . 0 0 0 1 9 7 s ] S E L E C T ` i d ` , ` c a t _ n a m e ` , ` c a t _ d i r e c t o r y ` F R O M ` s o k e r _ c a t e g o r y ` W H E R E ` i d ` = 3 2 2 L I M I T 1 [ R u n T i m e : 0 . 0 0 0 1 8 4 s ] S E L E C T C O U N T ( D I S T I N C T ` c a m p u s _ i d ` ) A S t h i n k _ c o u n t F R O M ` s o k e r _ s c h o o l _ c a m p u s _ c o u r s e ` W H E R E ` c o u r s e _ i d ` = 2 6 1 0 1 A N D ` c o u r s e _ s t a t u s ` = 1 L I M I T 1 [ R u n T i m e : 0 . 0 0 0 2 5 8 s ] S E L E C T a . ` i d ` , a . ` s c h o o l _ n a m e ` , a . ` s c h o o l _ l o g o ` F R O M ` s o k e r _ s c h o o l ` ` a ` L E F T J O I N ` s o k e r _ s c h o o l _ c a m p u s ` ` b ` O N a . ` i d ` = b . ` s c h o o l _ i d ` W H E R E ` b ` . ` c a m p u s _ s t a t u s ` = 1 A N D ` b ` . ` c a m p u s _ i s d e l e t e ` = 0 A N D ` b ` . ` i d ` = 8 5 9 8 L I M I T 1 [ R u n T i m e : 0 . 0 0 0 1 9 7 s ] S E L E C T a . ` i d ` , a . ` m a t e r i a l _ t i t l e ` , a . ` m a t e r i a l _ i m a g e s ` , a . ` m a t e r i a l _ p r i c e ` , b . ` c a m p u s _ i d ` , b . ` c a t i d _ t h r e e ` F R O M ` s o k e r _ s c h o o l _ m a t e r i a l s ` ` a ` L E F T J O I N ` s o k e r _ s c h o o l _ c a m p u s _ c o u r s e ` ` b ` O N a . ` i d ` = b . ` c o u r s e _ i d ` W H E R E ` b ` . ` c a t i d _ o n e ` = 3 3 7 A N D ` b ` . ` c i t y i d ` = 1 A N D ` b ` . ` c o u r s e _ s t a t u s ` = 1 A N D ` a ` . ` m a t e r i a l _ i s d e l e t e ` = 0 G R O U P B Y ` a ` . ` i d ` O R D E R B Y ` a ` . ` m a t e r i a l _ o r d e r T i m e ` D E S C , ` a ` . ` m a t e r i a l _ o r d e r i d ` A S C , ` a ` . ` i d ` A S C L I M I T 8 [ R u n T i m e : 0 . 0 6 8 2 7 6 s ] S E L E C T ` i d ` , ` c a t _ n a m e ` , ` c a t _ d i r e c t o r y ` F R O M ` s o k e r _ c a t e g o r y ` W H E R E ` i d ` = 4 5 3 L I M I T 1 [ R u n T i m e : 0 . 0 0 0 3 1 0 s ] S E L E C T C O U N T ( D I S T I N C T ` c a m p u s _ i d ` ) A S t h i n k _ c o u n t F R O M ` s o k e r _ s c h o o l _ c a m p u s _ c o u r s e ` W H E R E ` c o u r s e _ i d ` = 2 1 7 2 A N D ` c o u r s e _ s t a t u s ` = 1 L I M I T 1 [ R u n T i m e : 0 . 0 0 0 5 8 7 s ] S E L E C T a . ` i d ` , a . ` s c h o o l _ n a m e ` , a . ` s c h o o l _ l o g o ` F R O M ` s o k e r _ s c h o o l ` ` a ` L E F T J O I N ` s o k e r _ s c h o o l _ c a m p u s ` ` b ` O N a . ` i d ` = b . ` s c h o o l _ i d ` W H E R E ` b ` . ` c a m p u s _ s t a t u s ` = 1 A N D ` b ` . ` c a m p u s _ i s d e l e t e ` = 0 A N D ` b ` . ` i d ` = 1 7 7 0 L I M I T 1 [ R u n T i m e : 0 . 0 0 0 2 4 4 s ] S E L E C T ` i d ` , ` c a t _ n a m e ` , ` c a t _ d i r e c t o r y ` F R O M ` s o k e r _ c a t e g o r y ` W H E R E ` i d ` = 3 7 9 L I M I T 1 [ R u n T i m e : 0 . 0 0 0 1 9 5 s ] S E L E C T C O U N T ( D I S T I N C T ` c a m p u s _ i d ` ) A S t h i n k _ c o u n t F R O M ` s o k e r _ s c h o o l _ c a m p u s _ c o u r s e ` W H E R E ` c o u r s e _ i d ` = 2 2 6 2 A N D ` c o u r s e _ s t a t u s ` = 1 L I M I T 1 [ R u n T i m e : 0 . 0 0 0 5 3 7 s ] S E L E C T a . ` i d ` , a . ` s c h o o l _ n a m e ` , a . ` s c h o o l _ l o g o ` F R O M ` s o k e r _ s c h o o l ` ` a ` L E F T J O I N ` s o k e r _ s c h o o l _ c a m p u s ` ` b ` O N a . ` i d ` = b . ` s c h o o l _ i d ` W H E R E ` b ` . ` c a m p u s _ s t a t u s ` = 1 A N D ` b ` . ` c a m p u s _ i s d e l e t e ` = 0 A N D ` b ` . ` i d ` = 1 7 7 0 L I M I T 1 [ R u n T i m e : 0 . 0 0 0 2 2 5 s ] S E L E C T ` i d ` , ` c a t _ n a m e ` , ` c a t _ d i r e c t o r y ` F R O M ` s o k e r _ c a t e g o r y ` W H E R E ` i d ` = 4 3 8 L I M I T 1 [ R u n T i m e : 0 . 0 0 0 1 8 7 s ] S E L E C T C O U N T ( D I S T I N C T ` c a m p u s _ i d ` ) A S t h i n k _ c o u n t F R O M ` s o k e r _ s c h o o l _ c a m p u s _ c o u r s e ` W H E R E ` c o u r s e _ i d ` = 2 2 1 2 A N D ` c o u r s e _ s t a t u s ` = 1 L I M I T 1 [ R u n T i m e : 0 . 0 0 0 5 5 0 s ] S E L E C T a . ` i d ` , a . ` s c h o o l _ n a m e ` , a . ` s c h o o l _ l o g o ` F R O M ` s o k e r _ s c h o o l ` ` a ` L E F T J O I N ` s o k e r _ s c h o o l _ c a m p u s ` ` b ` O N a . ` i d ` = b . ` s c h o o l _ i d ` W H E R E ` b ` . ` c a m p u s _ s t a t u s ` = 1 A N D ` b ` . ` c a m p u s _ i s d e l e t e ` = 0 A N D ` b ` . ` i d ` = 1 7 7 0 L I M I T 1 [ R u n T i m e : 0 . 0 0 0 2 3 9 s ] S E L E C T ` i d ` , ` c a t _ n a m e ` , ` c a t _ d i r e c t o r y ` F R O M ` s o k e r _ c a t e g o r y ` W H E R E ` i d ` = 3 8 6 L I M I T 1 [ R u n T i m e : 0 . 0 0 0 1 9 9 s ] S E L E C T C O U N T ( D I S T I N C T ` c a m p u s _ i d ` ) A S t h i n k _ c o u n t F R O M ` s o k e r _ s c h o o l _ c a m p u s _ c o u r s e ` W H E R E ` c o u r s e _ i d ` = 9 9 2 0 A N D ` c o u r s e _ s t a t u s ` = 1 L I M I T 1 [ R u n T i m e : 0 . 0 0 0 4 8 9 s ] S E L E C T a . ` i d ` , a . ` s c h o o l _ n a m e ` , a . ` s c h o o l _ l o g o ` F R O M ` s o k e r _ s c h o o l ` ` a ` L E F T J O I N ` s o k e r _ s c h o o l _ c a m p u s ` ` b ` O N a . ` i d ` = b . ` s c h o o l _ i d ` W H E R E ` b ` . ` c a m p u s _ s t a t u s ` = 1 A N D ` b ` . ` c a m p u s _ i s d e l e t e ` = 0 A N D ` b ` . ` i d ` = 4 1 8 5 L I M I T 1 [ R u n T i m e : 0 . 0 0 0 2 2 1 s ] S E L E C T ` i d ` , ` c a t _ n a m e ` , ` c a t _ d i r e c t o r y ` F R O M ` s o k e r _ c a t e g o r y ` W H E R E ` i d ` = 3 6 9 L I M I T 1 [ R u n T i m e : 0 . 0 0 0 1 7 0 s ] S E L E C T C O U N T ( D I S T I N C T ` c a m p u s _ i d ` ) A S t h i n k _ c o u n t F R O M ` s o k e r _ s c h o o l _ c a m p u s _ c o u r s e ` W H E R E ` c o u r s e _ i d ` = 2 1 2 4 2 A N D ` c o u r s e _ s t a t u s ` = 1 L I M I T 1 [ R u n T i m e : 0 . 0 0 0 6 6 5 s ] S E L E C T a . ` i d ` , a . ` s c h o o l _ n a m e ` , a . ` s c h o o l _ l o g o ` F R O M ` s o k e r _ s c h o o l ` ` a ` L E F T J O I N ` s o k e r _ s c h o o l _ c a m p u s ` ` b ` O N a . ` i d ` = b . ` s c h o o l _ i d ` W H E R E ` b ` . ` c a m p u s _ s t a t u s ` = 1 A N D ` b ` . ` c a m p u s _ i s d e l e t e ` = 0 A N D ` b ` . ` i d ` = 3 9 9 1 L I M I T 1 [ R u n T i m e : 0 . 0 0 0 2 2 1 s ] S E L E C T ` i d ` , ` c a t _ n a m e ` , ` c a t _ d i r e c t o r y ` F R O M ` s o k e r _ c a t e g o r y ` W H E R E ` i d ` = 3 6 8 L I M I T 1 [ R u n T i m e : 0 . 0 0 0 1 8 9 s ] S E L E C T C O U N T ( D I S T I N C T ` c a m p u s _ i d ` ) A S t h i n k _ c o u n t F R O M ` s o k e r _ s c h o o l _ c a m p u s _ c o u r s e ` W H E R E ` c o u r s e _ i d ` = 9 9 0 7 A N D ` c o u r s e _ s t a t u s ` = 1 L I M I T 1 [ R u n T i m e : 0 . 0 0 0 5 2 9 s ] S E L E C T a . ` i d ` , a . ` s c h o o l _ n a m e ` , a . ` s c h o o l _ l o g o ` F R O M ` s o k e r _ s c h o o l ` ` a ` L E F T J O I N ` s o k e r _ s c h o o l _ c a m p u s ` ` b ` O N a . ` i d ` = b . ` s c h o o l _ i d ` W H E R E ` b ` . ` c a m p u s _ s t a t u s ` = 1 A N D ` b ` . ` c a m p u s _ i s d e l e t e ` = 0 A N D ` b ` . ` i d ` = 4 1 8 5 L I M I T 1 [ R u n T i m e : 0 . 0 0 0 2 9 0 s ] S E L E C T ` i d ` , ` c a t _ n a m e ` , ` c a t _ d i r e c t o r y ` F R O M ` s o k e r _ c a t e g o r y ` W H E R E ` i d ` = 4 2 6 L I M I T 1 [ R u n T i m e : 0 . 0 0 0 2 2 1 s ] S E L E C T C O U N T ( D I S T I N C T ` c a m p u s _ i d ` ) A S t h i n k _ c o u n t F R O M ` s o k e r _ s c h o o l _ c a m p u s _ c o u r s e ` W H E R E ` c o u r s e _ i d ` = 2 1 7 3 A N D ` c o u r s e _ s t a t u s ` = 1 L I M I T 1 [ R u n T i m e : 0 . 0 0 0 6 5 7 s ] S E L E C T a . ` i d ` , a . ` s c h o o l _ n a m e ` , a . ` s c h o o l _ l o g o ` F R O M ` s o k e r _ s c h o o l ` ` a ` L E F T J O I N ` s o k e r _ s c h o o l _ c a m p u s ` ` b ` O N a . ` i d ` = b . ` s c h o o l _ i d ` W H E R E ` b ` . ` c a m p u s _ s t a t u s ` = 1 A N D ` b ` . ` c a m p u s _ i s d e l e t e ` = 0 A N D ` b ` . ` i d ` = 1 7 7 0 L I M I T 1 [ R u n T i m e : 0 . 0 0 0 2 2 9 s ] S E L E C T ` i d ` , ` c a t _ n a m e ` , ` c a t _ d i r e c t o r y ` F R O M ` s o k e r _ c a t e g o r y ` W H E R E ` i d ` = 3 6 8 L I M I T 1 [ R u n T i m e : 0 . 0 0 0 2 0 0 s ] S E L E C T C O U N T ( D I S T I N C T ` c a m p u s _ i d ` ) A S t h i n k _ c o u n t F R O M ` s o k e r _ s c h o o l _ c a m p u s _ c o u r s e ` W H E R E ` c o u r s e _ i d ` = 2 1 2 4 4 A N D ` c o u r s e _ s t a t u s ` = 1 L I M I T 1 [ R u n T i m e : 0 . 0 0 0 6 6 3 s ] S E L E C T a . ` i d ` , a . ` s c h o o l _ n a m e ` , a . ` s c h o o l _ l o g o ` F R O M ` s o k e r _ s c h o o l ` ` a ` L E F T J O I N ` s o k e r _ s c h o o l _ c a m p u s ` ` b ` O N a . ` i d ` = b . ` s c h o o l _ i d ` W H E R E ` b ` . ` c a m p u s _ s t a t u s ` = 1 A N D ` b ` . ` c a m p u s _ i s d e l e t e ` = 0 A N D ` b ` . ` i d ` = 3 9 9 1 L I M I T 1 [ R u n T i m e : 0 . 0 0 0 2 2 1 s ] S E L E C T a . ` i d ` , a . ` m a t e r i a l _ t i t l e ` , a . ` m a t e r i a l _ i m a g e s ` , a . ` m a t e r i a l _ p r i c e ` , b . ` c a m p u s _ i d ` , b . ` c a t i d _ t h r e e ` F R O M ` s o k e r _ s c h o o l _ m a t e r i a l s ` ` a ` L E F T J O I N ` s o k e r _ s c h o o l _ c a m p u s _ c o u r s e ` ` b ` O N a . ` i d ` = b . ` c o u r s e _ i d ` W H E R E ` b ` . ` c a t i d _ o n e ` = 1 A N D ` b ` . ` c i t y i d ` = 1 A N D ` b ` . ` c o u r s e _ s t a t u s ` = 1 A N D ` a ` . ` m a t e r i a l _ i s d e l e t e ` = 0 G R O U P B Y ` a ` . ` i d ` O R D E R B Y ` a ` . ` m a t e r i a l _ o r d e r T i m e ` D E S C , ` a ` . ` m a t e r i a l _ o r d e r i d ` A S C , ` a ` . ` i d ` A S C L I M I T 8 [ R u n T i m e : 0 . 0 0 0 5 7 5 s ] S E L E C T ` i d ` , ` c a t _ n a m e ` , ` c a t _ d i r e c t o r y ` F R O M ` s o k e r _ c a t e g o r y ` W H E R E ` i d ` = 1 0 L I M I T 1 [ R u n T i m e : 0 . 0 0 0 2 0 5 s ] S E L E C T C O U N T ( D I S T I N C T ` c a m p u s _ i d ` ) A S t h i n k _ c o u n t F R O M ` s o k e r _ s c h o o l _ c a m p u s _ c o u r s e ` W H E R E ` c o u r s e _ i d ` = 2 4 8 2 8 A N D ` c o u r s e _ s t a t u s ` = 1 L I M I T 1 [ R u n T i m e : 0 . 0 0 0 2 5 4 s ] S E L E C T a . ` i d ` , a . ` s c h o o l _ n a m e ` , a . ` s c h o o l _ l o g o ` F R O M ` s o k e r _ s c h o o l ` ` a ` L E F T J O I N ` s o k e r _ s c h o o l _ c a m p u s ` ` b ` O N a . ` i d ` = b . ` s c h o o l _ i d ` W H E R E ` b ` . ` c a m p u s _ s t a t u s ` = 1 A N D ` b ` . ` c a m p u s _ i s d e l e t e ` = 0 A N D ` b ` . ` i d ` = 8 3 2 4 L I M I T 1 [ R u n T i m e : 0 . 0 0 0 2 0 4 s ] S E L E C T ` i d ` , ` c a t _ n a m e ` , ` c a t _ d i r e c t o r y ` F R O M ` s o k e r _ c a t e g o r y ` W H E R E ` i d ` = 1 0 L I M I T 1 [ R u n T i m e : 0 . 0 0 0 1 7 0 s ] S E L E C T C O U N T ( D I S T I N C T ` c a m p u s _ i d ` ) A S t h i n k _ c o u n t F R O M ` s o k e r _ s c h o o l _ c a m p u s _ c o u r s e ` W H E R E ` c o u r s e _ i d ` = 2 4 8 2 9 A N D ` c o u r s e _ s t a t u s ` = 1 L I M I T 1 [ R u n T i m e : 0 . 0 0 0 2 4 0 s ] S E L E C T a . ` i d ` , a . ` s c h o o l _ n a m e ` , a . ` s c h o o l _ l o g o ` F R O M ` s o k e r _ s c h o o l ` ` a ` L E F T J O I N ` s o k e r _ s c h o o l _ c a m p u s ` ` b ` O N a . ` i d ` = b . ` s c h o o l _ i d ` W H E R E ` b ` . ` c a m p u s _ s t a t u s ` = 1 A N D ` b ` . ` c a m p u s _ i s d e l e t e ` = 0 A N D ` b ` . ` i d ` = 8 3 2 4 L I M I T 1 [ R u n T i m e : 0 . 0 0 0 2 0 0 s ] S E L E C T ` i d ` , ` c a t _ n a m e ` , ` c a t _ d i r e c t o r y ` F R O M ` s o k e r _ c a t e g o r y ` W H E R E ` i d ` = 1 0 L I M I T 1 [ R u n T i m e : 0 . 0 0 0 1 9 6 s ] S E L E C T C O U N T ( D I S T I N C T ` c a m p u s _ i d ` ) A S t h i n k _ c o u n t F R O M ` s o k e r _ s c h o o l _ c a m p u s _ c o u r s e ` W H E R E ` c o u r s e _ i d ` = 2 4 8 3 0 A N D ` c o u r s e _ s t a t u s ` = 1 L I M I T 1 [ R u n T i m e : 0 . 0 0 0 3 0 9 s ] S E L E C T a . ` i d ` , a . ` s c h o o l _ n a m e ` , a . ` s c h o o l _ l o g o ` F R O M ` s o k e r _ s c h o o l ` ` a ` L E F T J O I N ` s o k e r _ s c h o o l _ c a m p u s ` ` b ` O N a . ` i d ` = b . ` s c h o o l _ i d ` W H E R E ` b ` . ` c a m p u s _ s t a t u s ` = 1 A N D ` b ` . ` c a m p u s _ i s d e l e t e ` = 0 A N D ` b ` . ` i d ` = 8 3 2 4 L I M I T 1 [ R u n T i m e : 0 . 0 0 0 2 3 2 s ] S E L E C T ` i d ` , ` c a t _ n a m e ` , ` c a t _ d i r e c t o r y ` F R O M ` s o k e r _ c a t e g o r y ` W H E R E ` i d ` = 1 5 L I M I T 1 [ R u n T i m e : 0 . 0 0 0 2 0 6 s ] S E L E C T C O U N T ( D I S T I N C T ` c a m p u s _ i d ` ) A S t h i n k _ c o u n t F R O M ` s o k e r _ s c h o o l _ c a m p u s _ c o u r s e ` W H E R E ` c o u r s e _ i d ` = 1 7 1 4 3 A N D ` c o u r s e _ s t a t u s ` = 1 L I M I T 1 [ R u n T i m e : 0 . 0 0 0 2 6 9 s ] S E L E C T a . ` i d ` , a . ` s c h o o l _ n a m e ` , a . ` s c h o o l _ l o g o ` F R O M ` s o k e r _ s c h o o l ` ` a ` L E F T J O I N ` s o k e r _ s c h o o l _ c a m p u s ` ` b ` O N a . ` i d ` = b . ` s c h o o l _ i d ` W H E R E ` b ` . ` c a m p u s _ s t a t u s ` = 1 A N D ` b ` . ` c a m p u s _ i s d e l e t e ` = 0 A N D ` b ` . ` i d ` = 3 3 5 2 L I M I T 1 [ R u n T i m e : 0 . 0 0 0 1 9 9 s ] S E L E C T ` i d ` , ` c a t _ n a m e ` , ` c a t _ d i r e c t o r y ` F R O M ` s o k e r _ c a t e g o r y ` W H E R E ` i d ` = 1 5 L I M I T 1 [ R u n T i m e : 0 . 0 0 0 1 6 9 s ] S E L E C T C O U N T ( D I S T I N C T ` c a m p u s _ i d ` ) A S t h i n k _ c o u n t F R O M ` s o k e r _ s c h o o l _ c a m p u s _ c o u r s e ` W H E R E ` c o u r s e _ i d ` = 7 8 5 2 A N D ` c o u r s e _ s t a t u s ` = 1 L I M I T 1 [ R u n T i m e : 0 . 0 0 0 2 3 1 s ] S E L E C T a . ` i d ` , a . ` s c h o o l _ n a m e ` , a . ` s c h o o l _ l o g o ` F R O M ` s o k e r _ s c h o o l ` ` a ` L E F T J O I N ` s o k e r _ s c h o o l _ c a m p u s ` ` b ` O N a . ` i d ` = b . ` s c h o o l _ i d ` W H E R E ` b ` . ` c a m p u s _ s t a t u s ` = 1 A N D ` b ` . ` c a m p u s _ i s d e l e t e ` = 0 A N D ` b ` . ` i d ` = 3 6 9 9 L I M I T 1 [ R u n T i m e : 0 . 0 0 0 2 0 7 s ] S E L E C T ` i d ` , ` c a t _ n a m e ` , ` c a t _ d i r e c t o r y ` F R O M ` s o k e r _ c a t e g o r y ` W H E R E ` i d ` = 1 0 L I M I T 1 [ R u n T i m e : 0 . 0 0 0 1 8 0 s ] S E L E C T C O U N T ( D I S T I N C T ` c a m p u s _ i d ` ) A S t h i n k _ c o u n t F R O M ` s o k e r _ s c h o o l _ c a m p u s _ c o u r s e ` W H E R E ` c o u r s e _ i d ` = 7 8 5 5 A N D ` c o u r s e _ s t a t u s ` = 1 L I M I T 1 [ R u n T i m e : 0 . 0 0 0 2 2 4 s ] S E L E C T a . ` i d ` , a . ` s c h o o l _ n a m e ` , a . ` s c h o o l _ l o g o ` F R O M ` s o k e r _ s c h o o l ` ` a ` L E F T J O I N ` s o k e r _ s c h o o l _ c a m p u s ` ` b ` O N a . ` i d ` = b . ` s c h o o l _ i d ` W H E R E ` b ` . ` c a m p u s _ s t a t u s ` = 1 A N D ` b ` . ` c a m p u s _ i s d e l e t e ` = 0 A N D ` b ` . ` i d ` = 3 6 9 9 L I M I T 1 [ R u n T i m e : 0 . 0 0 0 2 0 9 s ] S E L E C T ` i d ` , ` c a t _ n a m e ` , ` c a t _ d i r e c t o r y ` F R O M ` s o k e r _ c a t e g o r y ` W H E R E ` i d ` = 4 L I M I T 1 [ R u n T i m e : 0 . 0 0 0 1 8 2 s ] S E L E C T C O U N T ( D I S T I N C T ` c a m p u s _ i d ` ) A S t h i n k _ c o u n t F R O M ` s o k e r _ s c h o o l _ c a m p u s _ c o u r s e ` W H E R E ` c o u r s e _ i d ` = 7 8 9 0 A N D ` c o u r s e _ s t a t u s ` = 1 L I M I T 1 [ R u n T i m e : 0 . 0 0 0 2 2 2 s ] S E L E C T a . ` i d ` , a . ` s c h o o l _ n a m e ` , a . ` s c h o o l _ l o g o ` F R O M ` s o k e r _ s c h o o l ` ` a ` L E F T J O I N ` s o k e r _ s c h o o l _ c a m p u s ` ` b ` O N a . ` i d ` = b . ` s c h o o l _ i d ` W H E R E ` b ` . ` c a m p u s _ s t a t u s ` = 1 A N D ` b ` . ` c a m p u s _ i s d e l e t e ` = 0 A N D ` b ` . ` i d ` = 3 6 9 9 L I M I T 1 [ R u n T i m e : 0 . 0 0 0 2 0 8 s ] S E L E C T ` i d ` , ` c a t _ n a m e ` , ` c a t _ d i r e c t o r y ` F R O M ` s o k e r _ c a t e g o r y ` W H E R E ` i d ` = 1 0 L I M I T 1 [ R u n T i m e : 0 . 0 0 0 1 7 1 s ] S E L E C T C O U N T ( D I S T I N C T ` c a m p u s _ i d ` ) A S t h i n k _ c o u n t F R O M ` s o k e r _ s c h o o l _ c a m p u s _ c o u r s e ` W H E R E ` c o u r s e _ i d ` = 7 8 7 3 A N D ` c o u r s e _ s t a t u s ` = 1 L I M I T 1 [ R u n T i m e : 0 . 0 0 0 2 2 0 s ] S E L E C T a . ` i d ` , a . ` s c h o o l _ n a m e ` , a . ` s c h o o l _ l o g o ` F R O M ` s o k e r _ s c h o o l ` ` a ` L E F T J O I N ` s o k e r _ s c h o o l _ c a m p u s ` ` b ` O N a . ` i d ` = b . ` s c h o o l _ i d ` W H E R E ` b ` . ` c a m p u s _ s t a t u s ` = 1 A N D ` b ` . ` c a m p u s _ i s d e l e t e ` = 0 A N D ` b ` . ` i d ` = 3 6 9 9 L I M I T 1 [ R u n T i m e : 0 . 0 0 0 1 9 5 s ] S E L E C T a . ` i d ` , a . ` m a t e r i a l _ t i t l e ` , a . ` m a t e r i a l _ i m a g e s ` , a . ` m a t e r i a l _ p r i c e ` , b . ` c a m p u s _ i d ` , b . ` c a t i d _ t h r e e ` F R O M ` s o k e r _ s c h o o l _ m a t e r i a l s ` ` a ` L E F T J O I N ` s o k e r _ s c h o o l _ c a m p u s _ c o u r s e ` ` b ` O N a . ` i d ` = b . ` c o u r s e _ i d ` W H E R E ` b ` . ` c a t i d _ o n e ` = 5 5 2 A N D ` b ` . ` c i t y i d ` = 1 A N D ` b ` . ` c o u r s e _ s t a t u s ` = 1 A N D ` a ` . ` m a t e r i a l _ i s d e l e t e ` = 0 G R O U P B Y ` a ` . ` i d ` O R D E R B Y ` a ` . ` m a t e r i a l _ o r d e r T i m e ` D E S C , ` a ` . ` m a t e r i a l _ o r d e r i d ` A S C , ` a ` . ` i d ` A S C L I M I T 8 [ R u n T i m e : 0 . 0 0 6 2 2 1 s ] S E L E C T ` i d ` , ` c a t _ n a m e ` , ` c a t _ d i r e c t o r y ` F R O M ` s o k e r _ c a t e g o r y ` W H E R E ` i d ` = 5 5 4 L I M I T 1 [ R u n T i m e : 0 . 0 0 0 2 3 1 s ] S E L E C T C O U N T ( D I S T I N C T ` c a m p u s _ i d ` ) A S t h i n k _ c o u n t F R O M ` s o k e r _ s c h o o l _ c a m p u s _ c o u r s e ` W H E R E ` c o u r s e _ i d ` = 1 8 4 1 3 A N D ` c o u r s e _ s t a t u s ` = 1 L I M I T 1 [ R u n T i m e : 0 . 0 0 0 2 9 5 s ] S E L E C T a . ` i d ` , a . ` s c h o o l _ n a m e ` , a . ` s c h o o l _ l o g o ` F R O M ` s o k e r _ s c h o o l ` ` a ` L E F T J O I N ` s o k e r _ s c h o o l _ c a m p u s ` ` b ` O N a . ` i d ` = b . ` s c h o o l _ i d ` W H E R E ` b ` . ` c a m p u s _ s t a t u s ` = 1 A N D ` b ` . ` c a m p u s _ i s d e l e t e ` = 0 A N D ` b ` . ` i d ` = 7 1 1 6 L I M I T 1 [ R u n T i m e : 0 . 0 0 0 2 0 3 s ] S E L E C T ` i d ` , ` c a t _ n a m e ` , ` c a t _ d i r e c t o r y ` F R O M ` s o k e r _ c a t e g o r y ` W H E R E ` i d ` = 5 8 6 L I M I T 1 [ R u n T i m e : 0 . 0 0 0 1 7 9 s ] S E L E C T C O U N T ( D I S T I N C T ` c a m p u s _ i d ` ) A S t h i n k _ c o u n t F R O M ` s o k e r _ s c h o o l _ c a m p u s _ c o u r s e ` W H E R E ` c o u r s e _ i d ` = 2 2 1 8 A N D ` c o u r s e _ s t a t u s ` = 1 L I M I T 1 [ R u n T i m e : 0 . 0 0 0 5 0 3 s ] S E L E C T a . ` i d ` , a . ` s c h o o l _ n a m e ` , a . ` s c h o o l _ l o g o ` F R O M ` s o k e r _ s c h o o l ` ` a ` L E F T J O I N ` s o k e r _ s c h o o l _ c a m p u s ` ` b ` O N a . ` i d ` = b . ` s c h o o l _ i d ` W H E R E ` b ` . ` c a m p u s _ s t a t u s ` = 1 A N D ` b ` . ` c a m p u s _ i s d e l e t e ` = 0 A N D ` b ` . ` i d ` = 1 7 7 0 L I M I T 1 [ R u n T i m e : 0 . 0 0 0 2 0 5 s ] S E L E C T ` i d ` , ` c a t _ n a m e ` , ` c a t _ d i r e c t o r y ` F R O M ` s o k e r _ c a t e g o r y ` W H E R E ` i d ` = 5 7 5 L I M I T 1 [ R u n T i m e : 0 . 0 0 0 1 7 4 s ] S E L E C T C O U N T ( D I S T I N C T ` c a m p u s _ i d ` ) A S t h i n k _ c o u n t F R O M ` s o k e r _ s c h o o l _ c a m p u s _ c o u r s e ` W H E R E ` c o u r s e _ i d ` = 2 1 7 1 A N D ` c o u r s e _ s t a t u s ` = 1 L I M I T 1 [ R u n T i m e : 0 . 0 0 0 5 2 2 s ] S E L E C T a . ` i d ` , a . ` s c h o o l _ n a m e ` , a . ` s c h o o l _ l o g o ` F R O M ` s o k e r _ s c h o o l ` ` a ` L E F T J O I N ` s o k e r _ s c h o o l _ c a m p u s ` ` b ` O N a . ` i d ` = b . ` s c h o o l _ i d ` W H E R E ` b ` . ` c a m p u s _ s t a t u s ` = 1 A N D ` b ` . ` c a m p u s _ i s d e l e t e ` = 0 A N D ` b ` . ` i d ` = 1 7 7 0 L I M I T 1 [ R u n T i m e : 0 . 0 0 0 2 2 0 s ] S E L E C T ` i d ` , ` c a t _ n a m e ` , ` c a t _ d i r e c t o r y ` F R O M ` s o k e r _ c a t e g o r y ` W H E R E ` i d ` = 5 7 6 L I M I T 1 [ R u n T i m e : 0 . 0 0 0 1 8 3 s ] S E L E C T C O U N T ( D I S T I N C T ` c a m p u s _ i d ` ) A S t h i n k _ c o u n t F R O M ` s o k e r _ s c h o o l _ c a m p u s _ c o u r s e ` W H E R E ` c o u r s e _ i d ` = 2 1 8 2 A N D ` c o u r s e _ s t a t u s ` = 1 L I M I T 1 [ R u n T i m e : 0 . 0 0 0 5 0 4 s ] S E L E C T a . ` i d ` , a . ` s c h o o l _ n a m e ` , a . ` s c h o o l _ l o g o ` F R O M ` s o k e r _ s c h o o l ` ` a ` L E F T J O I N ` s o k e r _ s c h o o l _ c a m p u s ` ` b ` O N a . ` i d ` = b . ` s c h o o l _ i d ` W H E R E ` b ` . ` c a m p u s _ s t a t u s ` = 1 A N D ` b ` . ` c a m p u s _ i s d e l e t e ` = 0 A N D ` b ` . ` i d ` = 1 7 7 0 L I M I T 1 [ R u n T i m e : 0 . 0 0 0 2 1 2 s ] S E L E C T ` i d ` , ` c a t _ n a m e ` , ` c a t _ d i r e c t o r y ` F R O M ` s o k e r _ c a t e g o r y ` W H E R E ` i d ` = 5 6 1 L I M I T 1 [ R u n T i m e : 0 . 0 0 0 1 8 6 s ] S E L E C T C O U N T ( D I S T I N C T ` c a m p u s _ i d ` ) A S t h i n k _ c o u n t F R O M ` s o k e r _ s c h o o l _ c a m p u s _ c o u r s e ` W H E R E ` c o u r s e _ i d ` = 2 2 6 8 A N D ` c o u r s e _ s t a t u s ` = 1 L I M I T 1 [ R u n T i m e : 0 . 0 0 0 4 8 9 s ] S E L E C T a . ` i d ` , a . ` s c h o o l _ n a m e ` , a . ` s c h o o l _ l o g o ` F R O M ` s o k e r _ s c h o o l ` ` a ` L E F T J O I N ` s o k e r _ s c h o o l _ c a m p u s ` ` b ` O N a . ` i d ` = b . ` s c h o o l _ i d ` W H E R E ` b ` . ` c a m p u s _ s t a t u s ` = 1 A N D ` b ` . ` c a m p u s _ i s d e l e t e ` = 0 A N D ` b ` . ` i d ` = 1 7 7 0 L I M I T 1 [ R u n T i m e : 0 . 0 0 0 2 1 9 s ] S E L E C T ` i d ` , ` c a t _ n a m e ` , ` c a t _ d i r e c t o r y ` F R O M ` s o k e r _ c a t e g o r y ` W H E R E ` i d ` = 5 8 3 L I M I T 1 [ R u n T i m e : 0 . 0 0 0 1 7 0 s ] S E L E C T C O U N T ( D I S T I N C T ` c a m p u s _ i d ` ) A S t h i n k _ c o u n t F R O M ` s o k e r _ s c h o o l _ c a m p u s _ c o u r s e ` W H E R E ` c o u r s e _ i d ` = 1 5 8 1 0 A N D ` c o u r s e _ s t a t u s ` = 1 L I M I T 1 [ R u n T i m e : 0 . 0 0 0 3 0 7 s ] S E L E C T a . ` i d ` , a . ` s c h o o l _ n a m e ` , a . ` s c h o o l _ l o g o ` F R O M ` s o k e r _ s c h o o l ` ` a ` L E F T J O I N ` s o k e r _ s c h o o l _ c a m p u s ` ` b ` O N a . ` i d ` = b . ` s c h o o l _ i d ` W H E R E ` b ` . ` c a m p u s _ s t a t u s ` = 1 A N D ` b ` . ` c a m p u s _ i s d e l e t e ` = 0 A N D ` b ` . ` i d ` = 3 0 2 6 L I M I T 1 [ R u n T i m e : 0 . 0 0 0 2 0 4 s ] S E L E C T ` i d ` , ` c a t _ n a m e ` , ` c a t _ d i r e c t o r y ` F R O M ` s o k e r _ c a t e g o r y ` W H E R E ` i d ` = 5 8 3 L I M I T 1 [ R u n T i m e : 0 . 0 0 0 1 6 8 s ] S E L E C T C O U N T ( D I S T I N C T ` c a m p u s _ i d ` ) A S t h i n k _ c o u n t F R O M ` s o k e r _ s c h o o l _ c a m p u s _ c o u r s e ` W H E R E ` c o u r s e _ i d ` = 2 0 6 8 9 A N D ` c o u r s e _ s t a t u s ` = 1 L I M I T 1 [ R u n T i m e : 0 . 0 0 0 2 3 8 s ] S E L E C T a . ` i d ` , a . ` s c h o o l _ n a m e ` , a . ` s c h o o l _ l o g o ` F R O M ` s o k e r _ s c h o o l ` ` a ` L E F T J O I N ` s o k e r _ s c h o o l _ c a m p u s ` ` b ` O N a . ` i d ` = b . ` s c h o o l _ i d ` W H E R E ` b ` . ` c a m p u s _ s t a t u s ` = 1 A N D ` b ` . ` c a m p u s _ i s d e l e t e ` = 0 A N D ` b ` . ` i d ` = 7 6 8 9 L I M I T 1 [ R u n T i m e : 0 . 0 0 0 1 9 9 s ] S E L E C T ` i d ` , ` c a t _ n a m e ` , ` c a t _ d i r e c t o r y ` F R O M ` s o k e r _ c a t e g o r y ` W H E R E ` i d ` = 5 8 3 L I M I T 1 [ R u n T i m e : 0 . 0 0 0 1 6 7 s ] S E L E C T C O U N T ( D I S T I N C T ` c a m p u s _ i d ` ) A S t h i n k _ c o u n t F R O M ` s o k e r _ s c h o o l _ c a m p u s _ c o u r s e ` W H E R E ` c o u r s e _ i d ` = 2 3 8 6 7 A N D ` c o u r s e _ s t a t u s ` = 1 L I M I T 1 [ R u n T i m e : 0 . 0 0 0 2 2 9 s ] S E L E C T a . ` i d ` , a . ` s c h o o l _ n a m e ` , a . ` s c h o o l _ l o g o ` F R O M ` s o k e r _ s c h o o l ` ` a ` L E F T J O I N ` s o k e r _ s c h o o l _ c a m p u s ` ` b ` O N a . ` i d ` = b . ` s c h o o l _ i d ` W H E R E ` b ` . ` c a m p u s _ s t a t u s ` = 1 A N D ` b ` . ` c a m p u s _ i s d e l e t e ` = 0 A N D ` b ` . ` i d ` = 8 1 6 6 L I M I T 1 [ R u n T i m e : 0 . 0 0 0 1 9 7 s ] S E L E C T a . ` i d ` , a . ` m a t e r i a l _ t i t l e ` , a . ` m a t e r i a l _ i m a g e s ` , a . ` m a t e r i a l _ p r i c e ` , b . ` c a m p u s _ i d ` , b . ` c a t i d _ t h r e e ` F R O M ` s o k e r _ s c h o o l _ m a t e r i a l s ` ` a ` L E F T J O I N ` s o k e r _ s c h o o l _ c a m p u s _ c o u r s e ` ` b ` O N a . ` i d ` = b . ` c o u r s e _ i d ` W H E R E ` b ` . ` c a t i d _ o n e ` = 3 0 0 A N D ` b ` . ` c i t y i d ` = 1 A N D ` b ` . ` c o u r s e _ s t a t u s ` = 1 A N D ` a ` . ` m a t e r i a l _ i s d e l e t e ` = 0 G R O U P B Y ` a ` . ` i d ` O R D E R B Y ` a ` . ` m a t e r i a l _ o r d e r T i m e ` D E S C , ` a ` . ` m a t e r i a l _ o r d e r i d ` A S C , ` a ` . ` i d ` A S C L I M I T 8 [ R u n T i m e : 0 . 0 0 1 8 6 8 s ] S E L E C T ` i d ` , ` c a t _ n a m e ` , ` c a t _ d i r e c t o r y ` F R O M ` s o k e r _ c a t e g o r y ` W H E R E ` i d ` = 3 0 5 L I M I T 1 [ R u n T i m e : 0 . 0 0 0 2 1 7 s ] S E L E C T C O U N T ( D I S T I N C T ` c a m p u s _ i d ` ) A S t h i n k _ c o u n t F R O M ` s o k e r _ s c h o o l _ c a m p u s _ c o u r s e ` W H E R E ` c o u r s e _ i d ` = 1 2 5 8 2 A N D ` c o u r s e _ s t a t u s ` = 1 L I M I T 1 [ R u n T i m e : 0 . 0 0 0 2 9 6 s ] S E L E C T a . ` i d ` , a . ` s c h o o l _ n a m e ` , a . ` s c h o o l _ l o g o ` F R O M ` s o k e r _ s c h o o l ` ` a ` L E F T J O I N ` s o k e r _ s c h o o l _ c a m p u s ` ` b ` O N a . ` i d ` = b . ` s c h o o l _ i d ` W H E R E ` b ` . ` c a m p u s _ s t a t u s ` = 1 A N D ` b ` . ` c a m p u s _ i s d e l e t e ` = 0 A N D ` b ` . ` i d ` = 5 0 1 5 L I M I T 1 [ R u n T i m e : 0 . 0 0 0 2 0 0 s ] S E L E C T ` i d ` , ` c a t _ n a m e ` , ` c a t _ d i r e c t o r y ` F R O M ` s o k e r _ c a t e g o r y ` W H E R E ` i d ` = 3 0 5 L I M I T 1 [ R u n T i m e : 0 . 0 0 0 1 8 1 s ] S E L E C T C O U N T ( D I S T I N C T ` c a m p u s _ i d ` ) A S t h i n k _ c o u n t F R O M ` s o k e r _ s c h o o l _ c a m p u s _ c o u r s e ` W H E R E ` c o u r s e _ i d ` = 2 0 6 9 3 A N D ` c o u r s e _ s t a t u s ` = 1 L I M I T 1 [ R u n T i m e : 0 . 0 0 0 2 3 5 s ] S E L E C T a . ` i d ` , a . ` s c h o o l _ n a m e ` , a . ` s c h o o l _ l o g o ` F R O M ` s o k e r _ s c h o o l ` ` a ` L E F T J O I N ` s o k e r _ s c h o o l _ c a m p u s ` ` b ` O N a . ` i d ` = b . ` s c h o o l _ i d ` W H E R E ` b ` . ` c a m p u s _ s t a t u s ` = 1 A N D ` b ` . ` c a m p u s _ i s d e l e t e ` = 0 A N D ` b ` . ` i d ` = 7 6 8 9 L I M I T 1 [ R u n T i m e : 0 . 0 0 0 2 0 5 s ] S E L E C T ` i d ` , ` c a t _ n a m e ` , ` c a t _ d i r e c t o r y ` F R O M ` s o k e r _ c a t e g o r y ` W H E R E ` i d ` = 3 0 7 L I M I T 1 [ R u n T i m e : 0 . 0 0 0 1 8 1 s ] S E L E C T C O U N T ( D I S T I N C T ` c a m p u s _ i d ` ) A S t h i n k _ c o u n t F R O M ` s o k e r _ s c h o o l _ c a m p u s _ c o u r s e ` W H E R E ` c o u r s e _ i d ` = 1 6 2 5 5 A N D ` c o u r s e _ s t a t u s ` = 1 L I M I T 1 [ R u n T i m e : 0 . 0 0 0 2 9 1 s ] S E L E C T a . ` i d ` , a . ` s c h o o l _ n a m e ` , a . ` s c h o o l _ l o g o ` F R O M ` s o k e r _ s c h o o l ` ` a ` L E F T J O I N ` s o k e r _ s c h o o l _ c a m p u s ` ` b ` O N a . ` i d ` = b . ` s c h o o l _ i d ` W H E R E ` b ` . ` c a m p u s _ s t a t u s ` = 1 A N D ` b ` . ` c a m p u s _ i s d e l e t e ` = 0 A N D ` b ` . ` i d ` = 3 4 1 3 L I M I T 1 [ R u n T i m e : 0 . 0 0 0 2 1 4 s ] S E L E C T ` i d ` , ` c a t _ n a m e ` , ` c a t _ d i r e c t o r y ` F R O M ` s o k e r _ c a t e g o r y ` W H E R E ` i d ` = 3 0 7 L I M I T 1 [ R u n T i m e : 0 . 0 0 0 1 7 2 s ] S E L E C T C O U N T ( D I S T I N C T ` c a m p u s _ i d ` ) A S t h i n k _ c o u n t F R O M ` s o k e r _ s c h o o l _ c a m p u s _ c o u r s e ` W H E R E ` c o u r s e _ i d ` = 1 6 2 6 4 A N D ` c o u r s e _ s t a t u s ` = 1 L I M I T 1 [ R u n T i m e : 0 . 0 0 0 2 8 8 s ] S E L E C T a . ` i d ` , a . ` s c h o o l _ n a m e ` , a . ` s c h o o l _ l o g o ` F R O M ` s o k e r _ s c h o o l ` ` a ` L E F T J O I N ` s o k e r _ s c h o o l _ c a m p u s ` ` b ` O N a . ` i d ` = b . ` s c h o o l _ i d ` W H E R E ` b ` . ` c a m p u s _ s t a t u s ` = 1 A N D ` b ` . ` c a m p u s _ i s d e l e t e ` = 0 A N D ` b ` . ` i d ` = 3 4 1 3 L I M I T 1 [ R u n T i m e : 0 . 0 0 0 2 1 1 s ] S E L E C T ` i d ` , ` c a t _ n a m e ` , ` c a t _ d i r e c t o r y ` F R O M ` s o k e r _ c a t e g o r y ` W H E R E ` i d ` = 3 1 1 L I M I T 1 [ R u n T i m e : 0 . 0 0 0 1 7 0 s ] S E L E C T C O U N T ( D I S T I N C T ` c a m p u s _ i d ` ) A S t h i n k _ c o u n t F R O M ` s o k e r _ s c h o o l _ c a m p u s _ c o u r s e ` W H E R E ` c o u r s e _ i d ` = 1 6 2 6 1 A N D ` c o u r s e _ s t a t u s ` = 1 L I M I T 1 [ R u n T i m e : 0 . 0 0 0 2 8 7 s ] S E L E C T a . ` i d ` , a . ` s c h o o l _ n a m e ` , a . ` s c h o o l _ l o g o ` F R O M ` s o k e r _ s c h o o l ` ` a ` L E F T J O I N ` s o k e r _ s c h o o l _ c a m p u s ` ` b ` O N a . ` i d ` = b . ` s c h o o l _ i d ` W H E R E ` b ` . ` c a m p u s _ s t a t u s ` = 1 A N D ` b ` . ` c a m p u s _ i s d e l e t e ` = 0 A N D ` b ` . ` i d ` = 3 4 1 3 L I M I T 1 [ R u n T i m e : 0 . 0 0 0 2 1 1 s ] S E L E C T ` i d ` , ` c a t _ n a m e ` , ` c a t _ d i r e c t o r y ` F R O M ` s o k e r _ c a t e g o r y ` W H E R E ` i d ` = 3 0 7 L I M I T 1 [ R u n T i m e : 0 . 0 0 0 1 6 9 s ] S E L E C T C O U N T ( D I S T I N C T ` c a m p u s _ i d ` ) A S t h i n k _ c o u n t F R O M ` s o k e r _ s c h o o l _ c a m p u s _ c o u r s e ` W H E R E ` c o u r s e _ i d ` = 1 6 2 5 1 A N D ` c o u r s e _ s t a t u s ` = 1 L I M I T 1 [ R u n T i m e : 0 . 0 0 0 2 8 5 s ] S E L E C T a . ` i d ` , a . ` s c h o o l _ n a m e ` , a . ` s c h o o l _ l o g o ` F R O M ` s o k e r _ s c h o o l ` ` a ` L E F T J O I N ` s o k e r _ s c h o o l _ c a m p u s ` ` b ` O N a . ` i d ` = b . ` s c h o o l _ i d ` W H E R E ` b ` . ` c a m p u s _ s t a t u s ` = 1 A N D ` b ` . ` c a m p u s _ i s d e l e t e ` = 0 A N D ` b ` . ` i d ` = 3 4 1 3 L I M I T 1 [ R u n T i m e : 0 . 0 0 0 2 0 0 s ] S E L E C T ` i d ` , ` c a t _ n a m e ` , ` c a t _ d i r e c t o r y ` F R O M ` s o k e r _ c a t e g o r y ` W H E R E ` i d ` = 3 0 7 L I M I T 1 [ R u n T i m e : 0 . 0 0 0 1 6 8 s ] S E L E C T C O U N T ( D I S T I N C T ` c a m p u s _ i d ` ) A S t h i n k _ c o u n t F R O M ` s o k e r _ s c h o o l _ c a m p u s _ c o u r s e ` W H E R E ` c o u r s e _ i d ` = 1 6 2 4 9 A N D ` c o u r s e _ s t a t u s ` = 1 L I M I T 1 [ R u n T i m e : 0 . 0 0 0 3 0 9 s ] S E L E C T a . ` i d ` , a . ` s c h o o l _ n a m e ` , a . ` s c h o o l _ l o g o ` F R O M ` s o k e r _ s c h o o l ` ` a ` L E F T J O I N ` s o k e r _ s c h o o l _ c a m p u s ` ` b ` O N a . ` i d ` = b . ` s c h o o l _ i d ` W H E R E ` b ` . ` c a m p u s _ s t a t u s ` = 1 A N D ` b ` . ` c a m p u s _ i s d e l e t e ` = 0 A N D ` b ` . ` i d ` = 3 4 1 3 L I M I T 1 [ R u n T i m e : 0 . 0 0 0 2 0 1 s ] S E L E C T ` i d ` , ` c a t _ n a m e ` , ` c a t _ d i r e c t o r y ` F R O M ` s o k e r _ c a t e g o r y ` W H E R E ` i d ` = 3 0 7 L I M I T 1 [ R u n T i m e : 0 . 0 0 0 1 8 4 s ] S E L E C T C O U N T ( D I S T I N C T ` c a m p u s _ i d ` ) A S t h i n k _ c o u n t F R O M ` s o k e r _ s c h o o l _ c a m p u s _ c o u r s e ` W H E R E ` c o u r s e _ i d ` = 1 6 2 4 1 A N D ` c o u r s e _ s t a t u s ` = 1 L I M I T 1 [ R u n T i m e : 0 . 0 0 0 2 9 0 s ] S E L E C T a . ` i d ` , a . ` s c h o o l _ n a m e ` , a . ` s c h o o l _ l o g o ` F R O M ` s o k e r _ s c h o o l ` ` a ` L E F T J O I N ` s o k e r _ s c h o o l _ c a m p u s ` ` b ` O N a . ` i d ` = b . ` s c h o o l _ i d ` W H E R E ` b ` . ` c a m p u s _ s t a t u s ` = 1 A N D ` b ` . ` c a m p u s _ i s d e l e t e ` = 0 A N D ` b ` . ` i d ` = 3 4 1 3 L I M I T 1 [ R u n T i m e : 0 . 0 0 0 2 0 0 s ] S E L E C T a . ` i d ` , a . ` m a t e r i a l _ t i t l e ` , a . ` m a t e r i a l _ i m a g e s ` , a . ` m a t e r i a l _ p r i c e ` , b . ` c a m p u s _ i d ` , b . ` c a t i d _ t h r e e ` F R O M ` s o k e r _ s c h o o l _ m a t e r i a l s ` ` a ` L E F T J O I N ` s o k e r _ s c h o o l _ c a m p u s _ c o u r s e ` ` b ` O N a . ` i d ` = b . ` c o u r s e _ i d ` W H E R E ` b ` . ` c a t i d _ o n e ` = 2 6 1 A N D ` b ` . ` c i t y i d ` = 1 A N D ` b ` . ` c o u r s e _ s t a t u s ` = 1 A N D ` a ` . ` m a t e r i a l _ i s d e l e t e ` = 0 G R O U P B Y ` a ` . ` i d ` O R D E R B Y ` a ` . ` m a t e r i a l _ o r d e r T i m e ` D E S C , ` a ` . ` m a t e r i a l _ o r d e r i d ` A S C , ` a ` . ` i d ` A S C L I M I T 8 [ R u n T i m e : 0 . 0 1 2 4 3 1 s ] S E L E C T ` i d ` , ` c a t _ n a m e ` , ` c a t _ d i r e c t o r y ` F R O M ` s o k e r _ c a t e g o r y ` W H E R E ` i d ` = 2 8 1 L I M I T 1 [ R u n T i m e : 0 . 0 0 0 2 1 9 s ] S E L E C T C O U N T ( D I S T I N C T ` c a m p u s _ i d ` ) A S t h i n k _ c o u n t F R O M ` s o k e r _ s c h o o l _ c a m p u s _ c o u r s e ` W H E R E ` c o u r s e _ i d ` = 1 9 7 4 8 A N D ` c o u r s e _ s t a t u s ` = 1 L I M I T 1 [ R u n T i m e : 0 . 0 0 0 5 2 6 s ] S E L E C T a . ` i d ` , a . ` s c h o o l _ n a m e ` , a . ` s c h o o l _ l o g o ` F R O M ` s o k e r _ s c h o o l ` ` a ` L E F T J O I N ` s o k e r _ s c h o o l _ c a m p u s ` ` b ` O N a . ` i d ` = b . ` s c h o o l _ i d ` W H E R E ` b ` . ` c a m p u s _ s t a t u s ` = 1 A N D ` b ` . ` c a m p u s _ i s d e l e t e ` = 0 A N D ` b ` . ` i d ` = 7 3 3 3 L I M I T 1 [ R u n T i m e : 0 . 0 0 0 2 3 6 s ] S E L E C T ` i d ` , ` c a t _ n a m e ` , ` c a t _ d i r e c t o r y ` F R O M ` s o k e r _ c a t e g o r y ` W H E R E ` i d ` = 2 7 4 L I M I T 1 [ R u n T i m e : 0 . 0 0 0 2 0 0 s ] S E L E C T C O U N T ( D I S T I N C T ` c a m p u s _ i d ` ) A S t h i n k _ c o u n t F R O M ` s o k e r _ s c h o o l _ c a m p u s _ c o u r s e ` W H E R E ` c o u r s e _ i d ` = 1 9 7 4 4 A N D ` c o u r s e _ s t a t u s ` = 1 L I M I T 1 [ R u n T i m e : 0 . 0 0 0 5 1 4 s ] S E L E C T a . ` i d ` , a . ` s c h o o l _ n a m e ` , a . ` s c h o o l _ l o g o ` F R O M ` s o k e r _ s c h o o l ` ` a ` L E F T J O I N ` s o k e r _ s c h o o l _ c a m p u s ` ` b ` O N a . ` i d ` = b . ` s c h o o l _ i d ` W H E R E ` b ` . ` c a m p u s _ s t a t u s ` = 1 A N D ` b ` . ` c a m p u s _ i s d e l e t e ` = 0 A N D ` b ` . ` i d ` = 7 3 3 3 L I M I T 1 [ R u n T i m e : 0 . 0 0 0 2 2 7 s ] S E L E C T ` i d ` , ` c a t _ n a m e ` , ` c a t _ d i r e c t o r y ` F R O M ` s o k e r _ c a t e g o r y ` W H E R E ` i d ` = 2 7 4 L I M I T 1 [ R u n T i m e : 0 . 0 0 0 1 8 2 s ] S E L E C T C O U N T ( D I S T I N C T ` c a m p u s _ i d ` ) A S t h i n k _ c o u n t F R O M ` s o k e r _ s c h o o l _ c a m p u s _ c o u r s e ` W H E R E ` c o u r s e _ i d ` = 1 9 7 6 4 A N D ` c o u r s e _ s t a t u s ` = 1 L I M I T 1 [ R u n T i m e : 0 . 0 0 0 5 1 9 s ] S E L E C T a . ` i d ` , a . ` s c h o o l _ n a m e ` , a . ` s c h o o l _ l o g o ` F R O M ` s o k e r _ s c h o o l ` ` a ` L E F T J O I N ` s o k e r _ s c h o o l _ c a m p u s ` ` b ` O N a . ` i d ` = b . ` s c h o o l _ i d ` W H E R E ` b ` . ` c a m p u s _ s t a t u s ` = 1 A N D ` b ` . ` c a m p u s _ i s d e l e t e ` = 0 A N D ` b ` . ` i d ` = 7 3 3 3 L I M I T 1 [ R u n T i m e : 0 . 0 0 0 2 1 8 s ] S E L E C T ` i d ` , ` c a t _ n a m e ` , ` c a t _ d i r e c t o r y ` F R O M ` s o k e r _ c a t e g o r y ` W H E R E ` i d ` = 2 9 5 L I M I T 1 [ R u n T i m e : 0 . 0 0 0 1 9 1 s ] S E L E C T C O U N T ( D I S T I N C T ` c a m p u s _ i d ` ) A S t h i n k _ c o u n t F R O M ` s o k e r _ s c h o o l _ c a m p u s _ c o u r s e ` W H E R E ` c o u r s e _ i d ` = 1 9 9 0 2 A N D ` c o u r s e _ s t a t u s ` = 1 L I M I T 1 [ R u n T i m e : 0 . 0 0 0 3 0 6 s ] S E L E C T a . ` i d ` , a . ` s c h o o l _ n a m e ` , a . ` s c h o o l _ l o g o ` F R O M ` s o k e r _ s c h o o l ` ` a ` L E F T J O I N ` s o k e r _ s c h o o l _ c a m p u s ` ` b ` O N a . ` i d ` = b . ` s c h o o l _ i d ` W H E R E ` b ` . ` c a m p u s _ s t a t u s ` = 1 A N D ` b ` . ` c a m p u s _ i s d e l e t e ` = 0 A N D ` b ` . ` i d ` = 9 2 7 L I M I T 1 [ R u n T i m e : 0 . 0 0 0 2 0 1 s ] S E L E C T ` i d ` , ` c a t _ n a m e ` , ` c a t _ d i r e c t o r y ` F R O M ` s o k e r _ c a t e g o r y ` W H E R E ` i d ` = 2 7 9 L I M I T 1 [ R u n T i m e : 0 . 0 0 0 1 7 9 s ] S E L E C T C O U N T ( D I S T I N C T ` c a m p u s _ i d ` ) A S t h i n k _ c o u n t F R O M ` s o k e r _ s c h o o l _ c a m p u s _ c o u r s e ` W H E R E ` c o u r s e _ i d ` = 1 7 6 1 A N D ` c o u r s e _ s t a t u s ` = 1 L I M I T 1 [ R u n T i m e : 0 . 0 0 0 2 5 5 s ] S E L E C T a . ` i d ` , a . ` s c h o o l _ n a m e ` , a . ` s c h o o l _ l o g o ` F R O M ` s o k e r _ s c h o o l ` ` a ` L E F T J O I N ` s o k e r _ s c h o o l _ c a m p u s ` ` b ` O N a . ` i d ` = b . ` s c h o o l _ i d ` W H E R E ` b ` . ` c a m p u s _ s t a t u s ` = 1 A N D ` b ` . ` c a m p u s _ i s d e l e t e ` = 0 A N D ` b ` . ` i d ` = 6 9 3 4 L I M I T 1 [ R u n T i m e : 0 . 0 0 0 2 0 3 s ] S E L E C T ` i d ` , ` c a t _ n a m e ` , ` c a t _ d i r e c t o r y ` F R O M ` s o k e r _ c a t e g o r y ` W H E R E ` i d ` = 2 8 3 L I M I T 1 [ R u n T i m e : 0 . 0 0 0 1 8 3 s ] S E L E C T C O U N T ( D I S T I N C T ` c a m p u s _ i d ` ) A S t h i n k _ c o u n t F R O M ` s o k e r _ s c h o o l _ c a m p u s _ c o u r s e ` W H E R E ` c o u r s e _ i d ` = 2 6 1 0 9 A N D ` c o u r s e _ s t a t u s ` = 1 L I M I T 1 [ R u n T i m e : 0 . 0 0 0 2 5 2 s ] S E L E C T a . ` i d ` , a . ` s c h o o l _ n a m e ` , a . ` s c h o o l _ l o g o ` F R O M ` s o k e r _ s c h o o l ` ` a ` L E F T J O I N ` s o k e r _ s c h o o l _ c a m p u s ` ` b ` O N a . ` i d ` = b . ` s c h o o l _ i d ` W H E R E ` b ` . ` c a m p u s _ s t a t u s ` = 1 A N D ` b ` . ` c a m p u s _ i s d e l e t e ` = 0 A N D ` b ` . ` i d ` = 8 5 9 8 L I M I T 1 [ R u n T i m e : 0 . 0 0 0 1 9 8 s ] S E L E C T ` i d ` , ` c a t _ n a m e ` , ` c a t _ d i r e c t o r y ` F R O M ` s o k e r _ c a t e g o r y ` W H E R E ` i d ` = 2 8 9 L I M I T 1 [ R u n T i m e : 0 . 0 0 0 1 7 5 s ] S E L E C T C O U N T ( D I S T I N C T ` c a m p u s _ i d ` ) A S t h i n k _ c o u n t F R O M ` s o k e r _ s c h o o l _ c a m p u s _ c o u r s e ` W H E R E ` c o u r s e _ i d ` = 2 6 0 1 6 A N D ` c o u r s e _ s t a t u s ` = 1 L I M I T 1 [ R u n T i m e : 0 . 0 0 0 2 2 6 s ] S E L E C T a . ` i d ` , a . ` s c h o o l _ n a m e ` , a . ` s c h o o l _ l o g o ` F R O M ` s o k e r _ s c h o o l ` ` a ` L E F T J O I N ` s o k e r _ s c h o o l _ c a m p u s ` ` b ` O N a . ` i d ` = b . ` s c h o o l _ i d ` W H E R E ` b ` . ` c a m p u s _ s t a t u s ` = 1 A N D ` b ` . ` c a m p u s _ i s d e l e t e ` = 0 A N D ` b ` . ` i d ` = 3 7 2 9 L I M I T 1 [ R u n T i m e : 0 . 0 0 0 1 9 9 s ] S E L E C T ` i d ` , ` c a t _ n a m e ` , ` c a t _ d i r e c t o r y ` F R O M ` s o k e r _ c a t e g o r y ` W H E R E ` i d ` = 2 8 9 L I M I T 1 [ R u n T i m e : 0 . 0 0 0 1 7 1 s ] S E L E C T C O U N T ( D I S T I N C T ` c a m p u s _ i d ` ) A S t h i n k _ c o u n t F R O M ` s o k e r _ s c h o o l _ c a m p u s _ c o u r s e ` W H E R E ` c o u r s e _ i d ` = 2 6 0 1 5 A N D ` c o u r s e _ s t a t u s ` = 1 L I M I T 1 [ R u n T i m e : 0 . 0 0 0 2 2 2 s ] S E L E C T a . ` i d ` , a . ` s c h o o l _ n a m e ` , a . ` s c h o o l _ l o g o ` F R O M ` s o k e r _ s c h o o l ` ` a ` L E F T J O I N ` s o k e r _ s c h o o l _ c a m p u s ` ` b ` O N a . ` i d ` = b . ` s c h o o l _ i d ` W H E R E ` b ` . ` c a m p u s _ s t a t u s ` = 1 A N D ` b ` . ` c a m p u s _ i s d e l e t e ` = 0 A N D ` b ` . ` i d ` = 3 7 2 9 L I M I T 1 [ R u n T i m e : 0 . 0 0 0 2 1 3 s ] S E L E C T a . ` i d ` , a . ` m a t e r i a l _ t i t l e ` , a . ` m a t e r i a l _ i m a g e s ` , a . ` m a t e r i a l _ p r i c e ` , b . ` c a m p u s _ i d ` , b . ` c a t i d _ t h r e e ` F R O M ` s o k e r _ s c h o o l _ m a t e r i a l s ` ` a ` L E F T J O I N ` s o k e r _ s c h o o l _ c a m p u s _ c o u r s e ` ` b ` O N a . ` i d ` = b . ` c o u r s e _ i d ` W H E R E ` b ` . ` c a t i d _ o n e ` = 1 4 6 A N D ` b ` . ` c i t y i d ` = 1 A N D ` b ` . ` c o u r s e _ s t a t u s ` = 1 A N D ` a ` . ` m a t e r i a l _ i s d e l e t e ` = 0 G R O U P B Y ` a ` . ` i d ` O R D E R B Y ` a ` . ` m a t e r i a l _ o r d e r T i m e ` D E S C , ` a ` . ` m a t e r i a l _ o r d e r i d ` A S C , ` a ` . ` i d ` A S C L I M I T 8 [ R u n T i m e : 0 . 0 1 3 2 2 3 s ] S E L E C T ` i d ` , ` c a t _ n a m e ` , ` c a t _ d i r e c t o r y ` F R O M ` s o k e r _ c a t e g o r y ` W H E R E ` i d ` = 1 8 2 L I M I T 1 [ R u n T i m e : 0 . 0 0 0 2 2 5 s ] S E L E C T C O U N T ( D I S T I N C T ` c a m p u s _ i d ` ) A S t h i n k _ c o u n t F R O M ` s o k e r _ s c h o o l _ c a m p u s _ c o u r s e ` W H E R E ` c o u r s e _ i d ` = 1 4 7 0 3 A N D ` c o u r s e _ s t a t u s ` = 1 L I M I T 1 [ R u n T i m e : 0 . 0 0 0 3 1 9 s ] S E L E C T a . ` i d ` , a . ` s c h o o l _ n a m e ` , a . ` s c h o o l _ l o g o ` F R O M ` s o k e r _ s c h o o l ` ` a ` L E F T J O I N ` s o k e r _ s c h o o l _ c a m p u s ` ` b ` O N a . ` i d ` = b . ` s c h o o l _ i d ` W H E R E ` b ` . ` c a m p u s _ s t a t u s ` = 1 A N D ` b ` . ` c a m p u s _ i s d e l e t e ` = 0 A N D ` b ` . ` i d ` = 5 4 4 5 L I M I T 1 [ R u n T i m e : 0 . 0 0 0 2 2 8 s ] S E L E C T ` i d ` , ` c a t _ n a m e ` , ` c a t _ d i r e c t o r y ` F R O M ` s o k e r _ c a t e g o r y ` W H E R E ` i d ` = 1 8 5 L I M I T 1 [ R u n T i m e : 0 . 0 0 0 2 0 1 s ] S E L E C T C O U N T ( D I S T I N C T ` c a m p u s _ i d ` ) A S t h i n k _ c o u n t F R O M ` s o k e r _ s c h o o l _ c a m p u s _ c o u r s e ` W H E R E ` c o u r s e _ i d ` = 1 3 5 2 8 A N D ` c o u r s e _ s t a t u s ` = 1 L I M I T 1 [ R u n T i m e : 0 . 0 0 0 2 9 6 s ] S E L E C T a . ` i d ` , a . ` s c h o o l _ n a m e ` , a . ` s c h o o l _ l o g o ` F R O M ` s o k e r _ s c h o o l ` ` a ` L E F T J O I N ` s o k e r _ s c h o o l _ c a m p u s ` ` b ` O N a . ` i d ` = b . ` s c h o o l _ i d ` W H E R E ` b ` . ` c a m p u s _ s t a t u s ` = 1 A N D ` b ` . ` c a m p u s _ i s d e l e t e ` = 0 A N D ` b ` . ` i d ` = 5 4 4 5 L I M I T 1 [ R u n T i m e : 0 . 0 0 0 2 1 2 s ] S E L E C T ` i d ` , ` c a t _ n a m e ` , ` c a t _ d i r e c t o r y ` F R O M ` s o k e r _ c a t e g o r y ` W H E R E ` i d ` = 1 9 8 L I M I T 1 [ R u n T i m e : 0 . 0 0 0 1 7 2 s ] S E L E C T C O U N T ( D I S T I N C T ` c a m p u s _ i d ` ) A S t h i n k _ c o u n t F R O M ` s o k e r _ s c h o o l _ c a m p u s _ c o u r s e ` W H E R E ` c o u r s e _ i d ` = 1 0 6 4 0 A N D ` c o u r s e _ s t a t u s ` = 1 L I M I T 1 [ R u n T i m e : 0 . 0 0 0 3 2 4 s ] S E L E C T a . ` i d ` , a . ` s c h o o l _ n a m e ` , a . ` s c h o o l _ l o g o ` F R O M ` s o k e r _ s c h o o l ` ` a ` L E F T J O I N ` s o k e r _ s c h o o l _ c a m p u s ` ` b ` O N a . ` i d ` = b . ` s c h o o l _ i d ` W H E R E ` b ` . ` c a m p u s _ s t a t u s ` = 1 A N D ` b ` . ` c a m p u s _ i s d e l e t e ` = 0 A N D ` b ` . ` i d ` = 4 8 0 7 L I M I T 1 [ R u n T i m e : 0 . 0 0 0 2 1 9 s ] S E L E C T ` i d ` , ` c a t _ n a m e ` , ` c a t _ d i r e c t o r y ` F R O M ` s o k e r _ c a t e g o r y ` W H E R E ` i d ` = 1 9 6 L I M I T 1 [ R u n T i m e : 0 . 0 0 0 1 6 9 s ] S E L E C T C O U N T ( D I S T I N C T ` c a m p u s _ i d ` ) A S t h i n k _ c o u n t F R O M ` s o k e r _ s c h o o l _ c a m p u s _ c o u r s e ` W H E R E ` c o u r s e _ i d ` = 1 0 6 3 7 A N D ` c o u r s e _ s t a t u s ` = 1 L I M I T 1 [ R u n T i m e : 0 . 0 0 0 3 9 3 s ] S E L E C T a . ` i d ` , a . ` s c h o o l _ n a m e ` , a . ` s c h o o l _ l o g o ` F R O M ` s o k e r _ s c h o o l ` ` a ` L E F T J O I N ` s o k e r _ s c h o o l _ c a m p u s ` ` b ` O N a . ` i d ` = b . ` s c h o o l _ i d ` W H E R E ` b ` . ` c a m p u s _ s t a t u s ` = 1 A N D ` b ` . ` c a m p u s _ i s d e l e t e ` = 0 A N D ` b ` . ` i d ` = 4 8 0 7 L I M I T 1 [ R u n T i m e : 0 . 0 0 0 2 2 2 s ] S E L E C T ` i d ` , ` c a t _ n a m e ` , ` c a t _ d i r e c t o r y ` F R O M ` s o k e r _ c a t e g o r y ` W H E R E ` i d ` = 1 7 8 L I M I T 1 [ R u n T i m e : 0 . 0 0 0 1 9 5 s ] S E L E C T C O U N T ( D I S T I N C T ` c a m p u s _ i d ` ) A S t h i n k _ c o u n t F R O M ` s o k e r _ s c h o o l _ c a m p u s _ c o u r s e ` W H E R E ` c o u r s e _ i d ` = 2 6 1 4 4 A N D ` c o u r s e _ s t a t u s ` = 1 L I M I T 1 [ R u n T i m e : 0 . 0 0 0 3 2 5 s ] S E L E C T a . ` i d ` , a . ` s c h o o l _ n a m e ` , a . ` s c h o o l _ l o g o ` F R O M ` s o k e r _ s c h o o l ` ` a ` L E F T J O I N ` s o k e r _ s c h o o l _ c a m p u s ` ` b ` O N a . ` i d ` = b . ` s c h o o l _ i d ` W H E R E ` b ` . ` c a m p u s _ s t a t u s ` = 1 A N D ` b ` . ` c a m p u s _ i s d e l e t e ` = 0 A N D ` b ` . ` i d ` = 4 8 0 7 L I M I T 1 [ R u n T i m e : 0 . 0 0 0 2 1 1 s ] S E L E C T ` i d ` , ` c a t _ n a m e ` , ` c a t _ d i r e c t o r y ` F R O M ` s o k e r _ c a t e g o r y ` W H E R E ` i d ` = 1 6 9 L I M I T 1 [ R u n T i m e : 0 . 0 0 0 1 7 1 s ] S E L E C T C O U N T ( D I S T I N C T ` c a m p u s _ i d ` ) A S t h i n k _ c o u n t F R O M ` s o k e r _ s c h o o l _ c a m p u s _ c o u r s e ` W H E R E ` c o u r s e _ i d ` = 2 6 1 4 3 A N D ` c o u r s e _ s t a t u s ` = 1 L I M I T 1 [ R u n T i m e : 0 . 0 0 0 3 0 7 s ] S E L E C T a . ` i d ` , a . ` s c h o o l _ n a m e ` , a . ` s c h o o l _ l o g o ` F R O M ` s o k e r _ s c h o o l ` ` a ` L E F T J O I N ` s o k e r _ s c h o o l _ c a m p u s ` ` b ` O N a . ` i d ` = b . ` s c h o o l _ i d ` W H E R E ` b ` . ` c a m p u s _ s t a t u s ` = 1 A N D ` b ` . ` c a m p u s _ i s d e l e t e ` = 0 A N D ` b ` . ` i d ` = 4 8 0 7 L I M I T 1 [ R u n T i m e : 0 . 0 0 0 2 2 0 s ] S E L E C T ` i d ` , ` c a t _ n a m e ` , ` c a t _ d i r e c t o r y ` F R O M ` s o k e r _ c a t e g o r y ` W H E R E ` i d ` = 2 0 0 L I M I T 1 [ R u n T i m e : 0 . 0 0 0 1 8 4 s ] S E L E C T C O U N T ( D I S T I N C T ` c a m p u s _ i d ` ) A S t h i n k _ c o u n t F R O M ` s o k e r _ s c h o o l _ c a m p u s _ c o u r s e ` W H E R E ` c o u r s e _ i d ` = 1 0 6 3 1 A N D ` c o u r s e _ s t a t u s ` = 1 L I M I T 1 [ R u n T i m e : 0 . 0 0 0 2 9 8 s ] S E L E C T a . ` i d ` , a . ` s c h o o l _ n a m e ` , a . ` s c h o o l _ l o g o ` F R O M ` s o k e r _ s c h o o l ` ` a ` L E F T J O I N ` s o k e r _ s c h o o l _ c a m p u s ` ` b ` O N a . ` i d ` = b . ` s c h o o l _ i d ` W H E R E ` b ` . ` c a m p u s _ s t a t u s ` = 1 A N D ` b ` . ` c a m p u s _ i s d e l e t e ` = 0 A N D ` b ` . ` i d ` = 4 8 0 7 L I M I T 1 [ R u n T i m e : 0 . 0 0 0 1 9 6 s ] S E L E C T ` i d ` , ` c a t _ n a m e ` , ` c a t _ d i r e c t o r y ` F R O M ` s o k e r _ c a t e g o r y ` W H E R E ` i d ` = 2 0 2 L I M I T 1 [ R u n T i m e : 0 . 0 0 0 1 7 2 s ] S E L E C T C O U N T ( D I S T I N C T ` c a m p u s _ i d ` ) A S t h i n k _ c o u n t F R O M ` s o k e r _ s c h o o l _ c a m p u s _ c o u r s e ` W H E R E ` c o u r s e _ i d ` = 1 0 6 3 0 A N D ` c o u r s e _ s t a t u s ` = 1 L I M I T 1 [ R u n T i m e : 0 . 0 0 0 3 2 5 s ] S E L E C T a . ` i d ` , a . ` s c h o o l _ n a m e ` , a . ` s c h o o l _ l o g o ` F R O M ` s o k e r _ s c h o o l ` ` a ` L E F T J O I N ` s o k e r _ s c h o o l _ c a m p u s ` ` b ` O N a . ` i d ` = b . ` s c h o o l _ i d ` W H E R E ` b ` . ` c a m p u s _ s t a t u s ` = 1 A N D ` b ` . ` c a m p u s _ i s d e l e t e ` = 0 A N D ` b ` . ` i d ` = 4 8 0 7 L I M I T 1 [ R u n T i m e : 0 . 0 0 0 2 1 1 s ] S E L E C T a . ` i d ` , a . ` m a t e r i a l _ t i t l e ` , a . ` m a t e r i a l _ i m a g e s ` , a . ` m a t e r i a l _ p r i c e ` , b . ` c a m p u s _ i d ` , b . ` c a t i d _ t h r e e ` F R O M ` s o k e r _ s c h o o l _ m a t e r i a l s ` ` a ` L E F T J O I N ` s o k e r _ s c h o o l _ c a m p u s _ c o u r s e ` ` b ` O N a . ` i d ` = b . ` c o u r s e _ i d ` W H E R E ` b ` . ` c a t i d _ o n e ` = 2 3 A N D ` b ` . ` c i t y i d ` = 1 A N D ` b ` . ` c o u r s e _ s t a t u s ` = 1 A N D ` a ` . ` m a t e r i a l _ i s d e l e t e ` = 0 G R O U P B Y ` a ` . ` i d ` O R D E R B Y ` a ` . ` m a t e r i a l _ o r d e r T i m e ` D E S C , ` a ` . ` m a t e r i a l _ o r d e r i d ` A S C , ` a ` . ` i d ` A S C L I M I T 8 [ R u n T i m e : 0 . 0 0 8 6 8 9 s ] S E L E C T ` i d ` , ` c a t _ n a m e ` , ` c a t _ d i r e c t o r y ` F R O M ` s o k e r _ c a t e g o r y ` W H E R E ` i d ` = 6 0 L I M I T 1 [ R u n T i m e : 0 . 0 0 0 2 1 0 s ] S E L E C T C O U N T ( D I S T I N C T ` c a m p u s _ i d ` ) A S t h i n k _ c o u n t F R O M ` s o k e r _ s c h o o l _ c a m p u s _ c o u r s e ` W H E R E ` c o u r s e _ i d ` = 1 9 7 5 0 A N D ` c o u r s e _ s t a t u s ` = 1 L I M I T 1 [ R u n T i m e : 0 . 0 0 0 5 3 4 s ] S E L E C T a . ` i d ` , a . ` s c h o o l _ n a m e ` , a . ` s c h o o l _ l o g o ` F R O M ` s o k e r _ s c h o o l ` ` a ` L E F T J O I N ` s o k e r _ s c h o o l _ c a m p u s ` ` b ` O N a . ` i d ` = b . ` s c h o o l _ i d ` W H E R E ` b ` . ` c a m p u s _ s t a t u s ` = 1 A N D ` b ` . ` c a m p u s _ i s d e l e t e ` = 0 A N D ` b ` . ` i d ` = 7 3 3 3 L I M I T 1 [ R u n T i m e : 0 . 0 0 0 2 1 7 s ] S E L E C T ` i d ` , ` c a t _ n a m e ` , ` c a t _ d i r e c t o r y ` F R O M ` s o k e r _ c a t e g o r y ` W H E R E ` i d ` = 5 3 L I M I T 1 [ R u n T i m e : 0 . 0 0 0 1 8 6 s ] S E L E C T C O U N T ( D I S T I N C T ` c a m p u s _ i d ` ) A S t h i n k _ c o u n t F R O M ` s o k e r _ s c h o o l _ c a m p u s _ c o u r s e ` W H E R E ` c o u r s e _ i d ` = 1 9 7 5 2 A N D ` c o u r s e _ s t a t u s ` = 1 L I M I T 1 [ R u n T i m e : 0 . 0 0 0 5 0 2 s ] S E L E C T a . ` i d ` , a . ` s c h o o l _ n a m e ` , a . ` s c h o o l _ l o g o ` F R O M ` s o k e r _ s c h o o l ` ` a ` L E F T J O I N ` s o k e r _ s c h o o l _ c a m p u s ` ` b ` O N a . ` i d ` = b . ` s c h o o l _ i d ` W H E R E ` b ` . ` c a m p u s _ s t a t u s ` = 1 A N D ` b ` . ` c a m p u s _ i s d e l e t e ` = 0 A N D ` b ` . ` i d ` = 7 3 3 3 L I M I T 1 [ R u n T i m e : 0 . 0 0 0 2 1 0 s ] S E L E C T ` i d ` , ` c a t _ n a m e ` , ` c a t _ d i r e c t o r y ` F R O M ` s o k e r _ c a t e g o r y ` W H E R E ` i d ` = 7 8 L I M I T 1 [ R u n T i m e : 0 . 0 0 0 1 7 0 s ] S E L E C T C O U N T ( D I S T I N C T ` c a m p u s _ i d ` ) A S t h i n k _ c o u n t F R O M ` s o k e r _ s c h o o l _ c a m p u s _ c o u r s e ` W H E R E ` c o u r s e _ i d ` = 1 9 7 4 5 A N D ` c o u r s e _ s t a t u s ` = 1 L I M I T 1 [ R u n T i m e : 0 . 0 0 0 5 0 7 s ] S E L E C T a . ` i d ` , a . ` s c h o o l _ n a m e ` , a . ` s c h o o l _ l o g o ` F R O M ` s o k e r _ s c h o o l ` ` a ` L E F T J O I N ` s o k e r _ s c h o o l _ c a m p u s ` ` b ` O N a . ` i d ` = b . ` s c h o o l _ i d ` W H E R E ` b ` . ` c a m p u s _ s t a t u s ` = 1 A N D ` b ` . ` c a m p u s _ i s d e l e t e ` = 0 A N D ` b ` . ` i d ` = 7 3 3 3 L I M I T 1 [ R u n T i m e : 0 . 0 0 0 2 1 6 s ] S E L E C T ` i d ` , ` c a t _ n a m e ` , ` c a t _ d i r e c t o r y ` F R O M ` s o k e r _ c a t e g o r y ` W H E R E ` i d ` = 5 0 L I M I T 1 [ R u n T i m e : 0 . 0 0 0 1 8 0 s ] S E L E C T C O U N T ( D I S T I N C T ` c a m p u s _ i d ` ) A S t h i n k _ c o u n t F R O M ` s o k e r _ s c h o o l _ c a m p u s _ c o u r s e ` W H E R E ` c o u r s e _ i d ` = 2 6 0 8 4 A N D ` c o u r s e _ s t a t u s ` = 1 L I M I T 1 [ R u n T i m e : 0 . 0 0 0 2 7 1 s ] S E L E C T a . ` i d ` , a . ` s c h o o l _ n a m e ` , a . ` s c h o o l _ l o g o ` F R O M ` s o k e r _ s c h o o l ` ` a ` L E F T J O I N ` s o k e r _ s c h o o l _ c a m p u s ` ` b ` O N a . ` i d ` = b . ` s c h o o l _ i d ` W H E R E ` b ` . ` c a m p u s _ s t a t u s ` = 1 A N D ` b ` . ` c a m p u s _ i s d e l e t e ` = 0 A N D ` b ` . ` i d ` = 8 5 9 8 L I M I T 1 [ R u n T i m e : 0 . 0 0 0 2 0 3 s ] S E L E C T ` i d ` , ` c a t _ n a m e ` , ` c a t _ d i r e c t o r y ` F R O M ` s o k e r _ c a t e g o r y ` W H E R E ` i d ` = 4 8 L I M I T 1 [ R u n T i m e : 0 . 0 0 0 1 7 0 s ] S E L E C T C O U N T ( D I S T I N C T ` c a m p u s _ i d ` ) A S t h i n k _ c o u n t F R O M ` s o k e r _ s c h o o l _ c a m p u s _ c o u r s e ` W H E R E ` c o u r s e _ i d ` = 2 5 9 8 2 A N D ` c o u r s e _ s t a t u s ` = 1 L I M I T 1 [ R u n T i m e : 0 . 0 0 0 2 6 5 s ] S E L E C T a . ` i d ` , a . ` s c h o o l _ n a m e ` , a . ` s c h o o l _ l o g o ` F R O M ` s o k e r _ s c h o o l ` ` a ` L E F T J O I N ` s o k e r _ s c h o o l _ c a m p u s ` ` b ` O N a . ` i d ` = b . ` s c h o o l _ i d ` W H E R E ` b ` . ` c a m p u s _ s t a t u s ` = 1 A N D ` b ` . ` c a m p u s _ i s d e l e t e ` = 0 A N D ` b ` . ` i d ` = 8 5 9 8 L I M I T 1 [ R u n T i m e : 0 . 0 0 0 1 9 3 s ] S E L E C T ` i d ` , ` c a t _ n a m e ` , ` c a t _ d i r e c t o r y ` F R O M ` s o k e r _ c a t e g o r y ` W H E R E ` i d ` = 7 1 L I M I T 1 [ R u n T i m e : 0 . 0 0 0 1 7 3 s ] S E L E C T C O U N T ( D I S T I N C T ` c a m p u s _ i d ` ) A S t h i n k _ c o u n t F R O M ` s o k e r _ s c h o o l _ c a m p u s _ c o u r s e ` W H E R E ` c o u r s e _ i d ` = 1 9 7 5 1 A N D ` c o u r s e _ s t a t u s ` = 1 L I M I T 1 [ R u n T i m e : 0 . 0 0 0 4 9 3 s ] S E L E C T a . ` i d ` , a . ` s c h o o l _ n a m e ` , a . ` s c h o o l _ l o g o ` F R O M ` s o k e r _ s c h o o l ` ` a ` L E F T J O I N ` s o k e r _ s c h o o l _ c a m p u s ` ` b ` O N a . ` i d ` = b . ` s c h o o l _ i d ` W H E R E ` b ` . ` c a m p u s _ s t a t u s ` = 1 A N D ` b ` . ` c a m p u s _ i s d e l e t e ` = 0 A N D ` b ` . ` i d ` = 7 3 3 3 L I M I T 1 [ R u n T i m e : 0 . 0 0 0 2 1 9 s ] S E L E C T ` i d ` , ` c a t _ n a m e ` , ` c a t _ d i r e c t o r y ` F R O M ` s o k e r _ c a t e g o r y ` W H E R E ` i d ` = 5 0 L I M I T 1 [ R u n T i m e : 0 . 0 0 0 1 8 9 s ] S E L E C T C O U N T ( D I S T I N C T ` c a m p u s _ i d ` ) A S t h i n k _ c o u n t F R O M ` s o k e r _ s c h o o l _ c a m p u s _ c o u r s e ` W H E R E ` c o u r s e _ i d ` = 2 4 8 2 4 A N D ` c o u r s e _ s t a t u s ` = 1 L I M I T 1 [ R u n T i m e : 0 . 0 0 0 2 2 4 s ] S E L E C T a . ` i d ` , a . ` s c h o o l _ n a m e ` , a . ` s c h o o l _ l o g o ` F R O M ` s o k e r _ s c h o o l ` ` a ` L E F T J O I N ` s o k e r _ s c h o o l _ c a m p u s ` ` b ` O N a . ` i d ` = b . ` s c h o o l _ i d ` W H E R E ` b ` . ` c a m p u s _ s t a t u s ` = 1 A N D ` b ` . ` c a m p u s _ i s d e l e t e ` = 0 A N D ` b ` . ` i d ` = 8 3 2 4 L I M I T 1 [ R u n T i m e : 0 . 0 0 0 2 1 2 s ] S E L E C T ` i d ` , ` c a t _ n a m e ` , ` c a t _ d i r e c t o r y ` F R O M ` s o k e r _ c a t e g o r y ` W H E R E ` i d ` = 4 8 L I M I T 1 [ R u n T i m e : 0 . 0 0 0 1 7 1 s ] S E L E C T C O U N T ( D I S T I N C T ` c a m p u s _ i d ` ) A S t h i n k _ c o u n t F R O M ` s o k e r _ s c h o o l _ c a m p u s _ c o u r s e ` W H E R E ` c o u r s e _ i d ` = 2 4 8 2 3 A N D ` c o u r s e _ s t a t u s ` = 1 L I M I T 1 [ R u n T i m e : 0 . 0 0 0 2 2 1 s ] S E L E C T a . ` i d ` , a . ` s c h o o l _ n a m e ` , a . ` s c h o o l _ l o g o ` F R O M ` s o k e r _ s c h o o l ` ` a ` L E F T J O I N ` s o k e r _ s c h o o l _ c a m p u s ` ` b ` O N a . ` i d ` = b . ` s c h o o l _ i d ` W H E R E ` b ` . ` c a m p u s _ s t a t u s ` = 1 A N D ` b ` . ` c a m p u s _ i s d e l e t e ` = 0 A N D ` b ` . ` i d ` = 8 3 2 4 L I M I T 1 [ R u n T i m e : 0 . 0 0 0 2 0 1 s ] S E L E C T ` i d ` , ` c i t y _ n a m e ` , ` c i t y _ d i r e c t o r y ` F R O M ` s o k e r _ c i t y ` W H E R E ` c i t y _ d i r e c t o r y ` = b j L I M I T 1 [ R u n T i m e : 0 . 0 0 0 1 8 4 s ] S H O W F U L L C O L U M N S F R O M ` s o k e r _ s y s t e m _ c o n t e n t ` [ R u n T i m e : 0 . 0 0 1 0 7 6 s ] S E L E C T ` i d ` , ` c o n _ t i t l e ` , ` c o n _ i m a g e s ` , ` c a t i d _ o n e n a m e ` , ` c o n _ i n t r o d u c t i o n ` , ` c o n _ c r e a t e T i m e ` , ` c o n _ o r d e r T i m e ` F R O M ` s o k e r _ s y s t e m _ c o n t e n t ` W H E R E ` c o n _ t y p e ` = 7 A N D ` c o n _ i s D e l e t e ` = 0 O R D E R B Y ` c o n _ o r d e r T i m e ` D E S C , ` c o n _ o r d e r i d ` A S C , ` i d ` D E S C L I M I T 3 [ R u n T i m e : 0 . 0 1 7 6 8 0 s ] S E L E C T a . ` i d ` , a . ` m a t e r i a l _ t i t l e ` , a . ` m a t e r i a l _ i m a g e s ` , a . ` m a t e r i a l _ i n t r o d u c t i o n ` , a . ` m a t e r i a l _ c r e a t e T i m e ` , a . ` m a t e r i a l _ o r d e r T i m e ` , c . ` i d ` A S ` c a m p u s _ i d ` , c . ` c a m p u s _ n a m e ` , d . ` i d ` A S ` s c h o o l _ i d ` , d . ` s c h o o l _ n a m e ` , d . ` s c h o o l _ l o g o ` F R O M ` s o k e r _ s c h o o l _ m a t e r i a l s ` ` a ` L E F T J O I N ` s o k e r _ s c h o o l _ c a m p u s _ d o c u ` ` b ` O N a . ` i d ` = b . ` d o c u _ i d ` L E F T J O I N ` s o k e r _ s c h o o l _ c a m p u s ` ` c ` O N c . ` i d ` = b . ` c a m p u s _ i d ` L E F T J O I N ` s o k e r _ s c h o o l ` ` d ` O N d . ` i d ` = a . ` s c h o o l _ i d ` W H E R E ` b ` . ` c i t y i d ` = 1 A N D ` a ` . ` m a t e r i a l _ s t a t u s ` = 1 A N D ` a ` . ` m a t e r i a l _ i s d e l e t e ` = 0 A N D ` c ` . ` c a m p u s _ i s d e l e t e ` = 0 A N D ` c ` . ` c a m p u s _ s t a t u s ` = 1 A N D ` d ` . ` i s D e l e t e ` = 0 G R O U P B Y ` a ` . ` i d ` O R D E R B Y ` a ` . ` m a t e r i a l _ o r d e r T i m e ` D E S C , ` a ` . ` m a t e r i a l _ o r d e r i d ` A S C , ` a ` . ` i d ` D E S C L I M I T 3 [ R u n T i m e : 0 . 0 0 0 6 0 2 s ] S H O W F U L L C O L U M N S F R O M ` s o k e r _ s c h o o l _ c o u r s e _ s c o r e ` [ R u n T i m e : 0 . 0 0 0 8 6 5 s ] S E L E C T A V G ( ` s c o r e ` ) A S t h i n k _ a v g F R O M ` s o k e r _ s c h o o l _ c o u r s e _ s c o r e ` W H E R E ` c a m p u s _ i d ` = 3 7 4 1 L I M I T 1 [ R u n T i m e : 0 . 0 3 6 0 8 5 s ] S E L E C T A V G ( ` s c o r e ` ) A S t h i n k _ a v g F R O M ` s o k e r _ s c h o o l _ c o u r s e _ s c o r e ` W H E R E ` c a m p u s _ i d ` = 7 6 3 3 L I M I T 1 [ R u n T i m e : 0 . 0 3 5 9 6 4 s ] S E L E C T A V G ( ` s c o r e ` ) A S t h i n k _ a v g F R O M ` s o k e r _ s c h o o l _ c o u r s e _ s c o r e ` W H E R E ` c a m p u s _ i d ` = 3 3 9 6 L I M I T 1 [ R u n T i m e : 0 . 0 3 6 0 3 2 s ] S E L E C T ` i d ` , ` c i t y _ n a m e ` , ` c i t y _ d i r e c t o r y ` F R O M ` s o k e r _ c i t y ` W H E R E ` c i t y _ d i r e c t o r y ` = b j L I M I T 1 [ R u n T i m e : 0 . 0 0 0 2 6 4 s ] S H O W F U L L C O L U M N S F R O M ` s o k e r _ e a c h _ c i t y _ c m s ` [ R u n T i m e : 0 . 0 0 0 9 8 5 s ] S E L E C T ` i d ` , ` c m s _ i d ` , ` c m s _ n a m e ` , ` c m s _ c o d e ` , ` c m s _ p i d ` , ` t y p e i d ` , ` d a t a _ i d ` , ` d a t a _ n a m e ` F R O M ` s o k e r _ e a c h _ c i t y _ c m s ` W H E R E ` d a t a _ i d ` = 1 A N D ` t y p e i d ` = 2 L I M I T 1 [ R u n T i m e : 0 . 0 0 0 3 7 6 s ] S E L E C T C O U N T ( * ) A S t h i n k _ c o u n t F R O M ( S E L E C T c o u n t ( * ) A S t h i n k _ c o u n t F R O M ` s o k e r _ s c h o o l _ c o u r s e _ s c o r e ` ` a ` L E F T J O I N ` s o k e r _ s c h o o l _ c a m p u s ` ` b ` O N a . ` c a m p u s _ i d ` = b . ` i d ` L E F T J O I N ` s o k e r _ s c h o o l _ m a t e r i a l s ` ` c ` O N a . ` c o m m e n t _ i d ` = c . ` i d ` W H E R E ( ` b ` . ` c a m p u s _ c i t y i d ` = 1 A N D ` b ` . ` c a m p u s _ i s d e l e t e ` = 0 A N D ` b ` . ` c a m p u s _ s t a t u s ` = 1 A N D ` c ` . ` m a t e r i a l _ i s d e l e t e ` = 0 ) G R O U P B Y ` c ` . ` i d ` ) ` _ g r o u p _ c o u n t _ ` L I M I T 1 [ R u n T i m e : 0 . 2 2 7 8 7 5 s ] S E L E C T c . ` i d ` , c . ` m a t e r i a l _ t i t l e ` , c . ` m a t e r i a l _ i m a g e s ` , c . ` m a t e r i a l _ i n t r o d u c t i o n ` , R E P L A C E ( j s o n _ e x t r a c t ( c . ` m a t e r i a l _ c o n t e n t ` , $ . c o m m e n t s _ m o b i l e ) , , ) A S ` m a t e r i a l _ m o b i l e ` , c . ` m a t e r i a l _ c o n t e n t ` , c . ` m a t e r i a l _ o r d e r T i m e ` , c . ` m a t e r i a l _ c r e a t e T i m e ` F R O M ` s o k e r _ s c h o o l _ c o u r s e _ s c o r e ` ` a ` L E F T J O I N ` s o k e r _ s c h o o l _ c a m p u s ` ` b ` O N a . ` c a m p u s _ i d ` = b . ` i d ` L E F T J O I N ` s o k e r _ s c h o o l _ m a t e r i a l s ` ` c ` O N a . ` c o m m e n t _ i d ` = c . ` i d ` W H E R E ( ` b ` . ` c a m p u s _ c i t y i d ` = 1 A N D ` b ` . ` c a m p u s _ i s d e l e t e ` = 0 A N D ` b ` . ` c a m p u s _ s t a t u s ` = 1 A N D ` c ` . ` m a t e r i a l _ i s d e l e t e ` = 0 ) G R O U P B Y ` c ` . ` i d ` O R D E R B Y ` c ` . ` m a t e r i a l _ o r d e r T i m e ` D E S C , ` c ` . ` m a t e r i a l _ o r d e r i d ` A S C , ` c ` . ` i d ` D E S C L I M I T 0 , 1 2 [ R u n T i m e : 0 . 5 4 6 0 4 4 s ] S E L E C T ` i n v i t a t i o n _ b o x ` , ` i n v i t a t i o n _ b o x _ w a p ` , ` i n v i t a t i o n _ b o x _ c l i c k ` , ` s e o _ t i t l e ` , ` s e o _ k e y w o r d s ` , ` s e o _ d e s c r i p t i o n ` F R O M ` s o k e r _ c i t y ` W H E R E ` i d ` = 1 L I M I T 1 [ R u n T i m e : 0 . 0 0 0 3 5 9 s ] 1 . 3 7 5 0 2 8 s

发表评论

温馨提示

做上本站友情链接,在您站上点击一次,即可自动秒收录并自动排在本站第一位！
<a href="https://www.988g.cn/" target="_blank">星月导航网</a>