Python 爬虫 数据提取

一下子运行 七八十个  select 将会是什么样的体验呢?

业务部门提供了一个需要,要求从爬虫数据中提取出88家的数据,

并且也提供了一个excel表格,如下图:

这个时候我们可以通过拍卖行,拍卖时间,拍卖会专场写SQL语句,单个SQL是这样写的。其中数据库表格的数据是540万,我们在建表的时候已经为 item_auct_time ,session_name 

,aucr_name_spider ,添加了索引。所以SQL的执行速度很快。

SELECT * FROM `guonei_artron_items_core__qingxi` WHERE item_auct_time = "20171218" AND aucr_name_spider ="中国嘉德国际拍卖有限公司" 
and session_name ="大观——四海崇誉庆典之夜·古代"

但是面对的是 88 行,我们总不能写88 个SQL语句吧,这样效率太低了,

这个时候我们可以用代码直接生成SQL语句

首先去复制这三行的数据,然后封装一个列表。如下

ccc= [{"data1":"佳士得伦敦有限公司","data2":"中国瓷器及工艺精品","data3":"2017/5/9"},
{"data1":"佳士得香港有限公司","data2":"瑰丽珠宝及翡翠首饰","data3":"2017/11/28"},
{"data1":"邦瀚斯拍卖行","data2":"中国瓷器及工艺精品专场","data3":"2017/11/28"},
{"data1":"保利华谊","data2":"中国书画","data3":"2017/12/8"},
{"data1":"保利香港拍卖有限公司","data2":"璀璨珠宝专场","data3":"2017/4/3"},
{"data1":"保利香港拍卖有限公司","data2":"璀璨珠宝专场","data3":"2017/4/3"},
{"data1":"保利香港拍卖有限公司","data2":"中国及亚洲现当代艺术专场","data3":"2017/4/3"},
{"data1":"保利香港拍卖有限公司","data2":"璀璨珠宝专场","data3":"2017/10/2"},
{"data1":"保利香港拍卖有限公司","data2":"清净广严—重要藏家珍藏永乐宫廷造像","data3":"2017/10/2"},
{"data1":"保利香港拍卖有限公司","data2":"清净广严—重要藏家珍藏永乐宫廷造像","data3":"2017/10/2"},
{"data1":"保利香港拍卖有限公司","data2":"清净广严—重要藏家珍藏永乐宫廷造像","data3":"2017/10/2"},
{"data1":"保利香港拍卖有限公司","data2":"现当代艺术专场","data3":"2017/10/2"},
{"data1":"保利香港拍卖有限公司","data2":"尤伦斯男爵藏中国重要金器专场","data3":"2017/10/2"},
{"data1":"保利香港拍卖有限公司","data2":"璀璨珠宝专场","data3":"  2017/10/2"},
{"data1":"北京保利国际拍卖有限公司","data2":"瓷器 玉器 工艺品(二)","data3":"2017/4/17"},
{"data1":"北京保利国际拍卖有限公司","data2":"中国古代书画夜场","data3":"2017/6/5"},
{"data1":"北京保利国际拍卖有限公司","data2":"中国古代书画夜场","data3":"2017/6/5"},
{"data1":"北京保利国际拍卖有限公司","data2":"中国古代书画夜场","data3":"2017/6/5"},
{"data1":"北京保利国际拍卖有限公司","data2":"中国近现代书画夜场","data3":"2017/6/5"},
{"data1":"北京保利国际拍卖有限公司","data2":"泉韵古今——纸币、机制币、金银锭 王觐彤旧藏古钱","data3":"2017/6/6"},
{"data1":"北京保利国际拍卖有限公司","data2":"自在菩提——中国金铜佛造像、唐卡","data3":"2017/6/7"},
{"data1":"北京保利国际拍卖有限公司","data2":"仰之弥高—中国古代书画夜场","data3":"2017/12/17"},
{"data1":"北京保利国际拍卖有限公司","data2":"震古烁今——从北宋到当代的中国书画","data3":"2017/12/17"},
{"data1":"北京保利国际拍卖有限公司","data2":"震古烁今——从北宋到当代的中国书画","data3":"2017/12/17"},
{"data1":"北京保利国际拍卖有限公司","data2":"震古烁今——从北宋到当代的中国书画","data3":"2017/12/17"},
{"data1":"北京保利国际拍卖有限公司","data2":"中国近现代书画夜场","data3":"2017/12/17"},
{"data1":"北京保利国际拍卖有限公司","data2":"中国近现代书画夜场","data3":"2017/12/17"},
{"data1":"北京保利国际拍卖有限公司","data2":"瑰映如茵Ⅱ——玫茵堂暨欧美名藏盛清五朝御窑隽品","data3":"2017/12/18"},
{"data1":"北京保利国际拍卖有限公司","data2":"佞宋——宋元巷陌间的“色·声·香·味·触”","data3":"2017/12/18"},
{"data1":"北京保利国际拍卖有限公司","data2":"禹贡(二)——康熙御制黄花梨大四件柜 唐英督陶与大清的辉煌时刻","data3":"2017/12/18"},
{"data1":"北京保利国际拍卖有限公司","data2":"禹贡(二)——康熙御制黄花梨大四件柜 唐英督陶与大清的辉煌时刻","data3":"2017/12/18"},
{"data1":"北京保利国际拍卖有限公司","data2":"禹贡(二)——康熙御制黄花梨大四件柜 唐英督陶与大清的辉煌时刻","data3":"2017/12/18"},
{"data1":"北京保利国际拍卖有限公司","data2":"禹贡(二)——康熙御制黄花梨大四件柜 唐英督陶与大清的辉煌时刻","data3":"2017/12/18"},
{"data1":"北京保利国际拍卖有限公司","data2":"方寸聚九州——邮品专场","data3":"2017/12/22"},
{"data1":"北京保利国际拍卖有限公司","data2":"方寸聚九州——名家旧藏华东解放区专场","data3":"2017/12/23"},
{"data1":"北京保利国际拍卖有限公司","data2":"禹贡——敬勝怠者吉 古董珍玩之夜","data3":"  2017/6/6"},
{"data1":"北京诚轩拍卖有限公司","data2":"古钱 银锭 机制币","data3":"2017/12/20"},
{"data1":"北京诚轩拍卖有限公司","data2":"古钱 银锭 机制币","data3":"2017/12/20"},
{"data1":"北京诚轩拍卖有限公司","data2":"古钱 银锭 机制币","data3":"  2017/12/20"},
{"data1":"北京诚轩拍卖有限公司","data2":"古钱 银锭 机制币","data3":"  2017-6-21"},
{"data1":"北京东正拍卖有限公司","data2":"皇家长物","data3":"2017/6/8"},
{"data1":"北京东正拍卖有限公司","data2":"乾坤荟萃—旦暮清供","data3":"2017/6/8"},
{"data1":"北京东正拍卖有限公司","data2":"皇家长物","data3":"2017/12/9"},
{"data1":"北京华辰拍卖有限公司","data2":"瓷器玉器工艺品","data3":"2017/12/17"},
{"data1":"北京匡时国际拍卖有限公司","data2":"畅怀——古代书法夜场","data3":"2017/6/4"},
{"data1":"北京匡时国际拍卖有限公司","data2":"神工妙造——瓷玉工艺品专场","data3":"2017/6/4"},
{"data1":"北京匡时国际拍卖有限公司","data2":"天工开物——瓷器工艺品精品夜场","data3":"2017/6/4"},
{"data1":"北京匡时国际拍卖有限公司","data2":"田帝玄黄——田黄石专场","data3":"2017/12/3"},
{"data1":"北京匡时国际拍卖有限公司","data2":"田帝玄黄——田黄石专场","data3":"2017/12/3"},
{"data1":"北京匡时国际拍卖有限公司","data2":"天工开物——瓷器工艺品夜场","data3":"  2017/12/3"},
{"data1":"北京匡时国际拍卖有限公司","data2":"田帝玄黄——田黄石专场","data3":"  2017/12/3"},
{"data1":"北京匡时国际拍卖有限公司","data2":"田帝玄黄——田黄石专场","data3":"  2017/12/3"},
{"data1":"北京伍伦国际拍卖有限公司","data2":"写经书画外国手迹专场","data3":"2017/11/15"},
{"data1":"北京印千山国际拍卖有限公司","data2":"潜龙邸——明清家具专场","data3":"2017/7/9"},
{"data1":"广州华艺国际拍卖有限公司","data2":"中国书画","data3":"2017/11/25"},
{"data1":"佳士得伦敦有限公司","data2":"中国瓷器及工艺精品","data3":"2017/5/9"},
{"data1":"佳士得伦敦有限公司","data2":"中国瓷器及工艺精品","data3":"2017/5/9"},
{"data1":"佳士得伦敦有限公司","data2":"中国瓷器及工艺精品","data3":"  2017/5/9"},
{"data1":"佳士得纽约有限公司","data2":"宗器宝绘—藤田美术馆藏中国古代艺术珍品","data3":"2017/3/15"},
{"data1":"佳士得纽约有限公司","data2":"宗器宝绘—藤田美术馆藏中国古代艺术珍品","data3":"2017/3/15"},
{"data1":"佳士得纽约有限公司","data2":"宗器寶繪 ─ 藤田美術館藏中國古代藝術珍品","data3":"2017/3/15"},
{"data1":"佳士得纽约有限公司","data2":"宗器寶繪 ─ 藤田美術館藏中國古代藝術珍品","data3":"2017/3/15"},
{"data1":"佳士得纽约有限公司","data2":"宗器寶繪 ─ 藤田美術館藏中國古代藝術珍品","data3":"2017/3/15"},
{"data1":"佳士得纽约有限公司","data2":"宗器寶繪 ─ 藤田美術館藏中國古代藝術珍品","data3":"2017/3/15"},
{"data1":"佳士得纽约有限公司","data2":"家族遗珍:玛丽·泰瑞莎·L·维勒泰亚洲艺术珍藏","data3":"2017/3/16"},
{"data1":"佳士得纽约有限公司","data2":"家族遗珍:玛丽·泰瑞莎·L·维勒泰亚洲艺术珍藏","data3":"2017/3/16"},
{"data1":"佳士得纽约有限公司","data2":"中国瓷器及工艺精品","data3":"2017/9/14"},
{"data1":"佳士得纽约有限公司","data2":"  宗器宝绘—藤田美术馆藏中国古代艺术珍品","data3":"  2017/3/15"},
{"data1":"佳士得香港有限公司","data2":"融艺/ 亚洲二十世纪及当代艺术(晚间拍卖)","data3":"2017/5/27"},
{"data1":"佳士得香港有限公司","data2":"融艺/ 亚洲二十世纪及当代艺术(晚间拍卖)","data3":"2017/5/27"},
{"data1":"佳士得香港有限公司","data2":"瑰丽珠宝及翡翠首饰","data3":"2017/5/30"},
{"data1":"佳士得香港有限公司","data2":"雍正粉青釉双龙尊","data3":"2017/5/31"},
{"data1":"佳士得香港有限公司","data2":"妙相圆明–佛教艺术精品","data3":"2017/5/31"},
{"data1":"佳士得香港有限公司","data2":"亚洲二十世纪及当代艺术(晚间拍卖)","data3":"2017/11/25"},
{"data1":"佳士得香港有限公司","data2":"瑰丽珠宝及翡翠首饰","data3":"2017/11/28"},
{"data1":"佳士得香港有限公司","data2":"瑰丽珠宝及翡翠首饰","data3":"2017/11/28"},
{"data1":"佳士得香港有限公司","data2":"千秋名韵—孔祥熙家族旧藏傅抱石《琵琶行》","data3":"2017/11/28"},
{"data1":"佳士得香港有限公司","data2":"重要中国瓷器及工艺精品","data3":"2017/11/29"},
{"data1":"佳士得香港有限公司","data2":"养德堂珍藏中国古玉器","data3":"2017/11/29"},
{"data1":"佳士得香港有限公司","data2":"养德堂珍藏中国古玉器","data3":"2017/11/29"},
{"data1":"佳士得香港有限公司","data2":"养德堂珍藏中国古玉器","data3":"2017/11/29"},
{"data1":"佳士得香港有限公司","data2":"重要中国瓷器及工艺精品","data3":"2017/11/29"},
{"data1":"佳士得香港有限公司","data2":"重要中国瓷器及工艺精品","data3":"2017/11/29"},
{"data1":"佳士得香港有限公司","data2":"乐从堂藏明代宫廷珍器晚间拍卖","data3":"  2017/11/27"},
{"data1":"佳士得香港有限公司","data2":"乐从堂藏明代宫廷珍器晚间拍卖","data3":"  2017-11-27"},
{"data1":"羅芙奧股份有限公司","data2":"亚洲现当代艺术专场","data3":"2017/6/4"},
{"data1":"纽约蘇富比有限公司","data2":"明·国风","data3":"2017/3/14"},
{"data1":"上海嘉禾拍卖有限公司","data2":"《禾风》—中国书画夜场","data3":"2017/12/30"},
{"data1":"上海匡时拍卖有限公司","data2":"大器——古代空间夜场","data3":"2017/11/5"},
{"data1":"上海匡时拍卖有限公司","data2":"文玩雅集专场","data3":"2017/11/5"},
{"data1":"苏富比巴黎","data2":"亚洲艺术","data3":"2017/6/22"},
{"data1":"天成国际拍卖有限公司","data2":"珠宝及翡翠","data3":"2017/12/3"},
{"data1":"西泠印社拍卖有限公司","data2":"登昆仑兮—中国首届和田玉籽料原石专场","data3":"2017/7/15"},
{"data1":"西泠印社拍卖有限公司","data2":"南宋宫廷旧藏西周重器国宝兮甲盘专拍暨中国青铜器专场","data3":"2017/7/15"},
{"data1":"西泠印社拍卖有限公司","data2":"中国历代钱币专场","data3":"2017/7/17"},
{"data1":"香港蘇富比拍卖有限公司","data2":"玲珑雅趣:明清掌上御瓷珍翫","data3":"2017/4/5"},
{"data1":"香港蘇富比拍卖有限公司","data2":"轻巧袖珍宝:攻玉山房藏明式家具","data3":"2017/4/5"},
{"data1":"香港蘇富比拍卖有限公司","data2":"鱼豫幽蓝:明宣德青花鱼藻纹十棱菱口大盌","data3":"2017/4/5"},
{"data1":"香港蘇富比拍卖有限公司","data2":"中国艺术珍品","data3":"2017/4/5"},
{"data1":"香港蘇富比拍卖有限公司","data2":"中国艺术珍品","data3":"2017/4/5"},
{"data1":"香港蘇富比拍卖有限公司","data2":"中国艺术珍品","data3":"2017/4/5"},
{"data1":"香港蘇富比拍卖有限公司","data2":"中国艺术珍品","data3":"2017/4/5"},
{"data1":"香港蘇富比拍卖有限公司","data2":"现当代艺术晚间拍卖","data3":"2017/9/30"},
{"data1":"香港蘇富比拍卖有限公司","data2":"现当代艺术晚间拍卖","data3":"2017/9/30"},
{"data1":"香港蘇富比拍卖有限公司","data2":"现当代艺术晚间拍卖","data3":"2017/9/30"},
{"data1":"香港蘇富比拍卖有限公司","data2":"中国古代书画","data3":"2017/10/1"},
{"data1":"香港蘇富比拍卖有限公司","data2":"八宝吉祥 — 仇焱之旧藏明宣德合盌","data3":"2017/10/3"},
{"data1":"香港蘇富比拍卖有限公司","data2":"俊雅清凝 — 乐从堂藏宋瓷粹珍","data3":"2017/10/3"},
{"data1":"香港蘇富比拍卖有限公司","data2":"密慧禅心:菩萨道珍藏及其他佛教艺术精品","data3":"2017/10/3"},
{"data1":"香港蘇富比拍卖有限公司","data2":"中国艺术珍品","data3":"2017/10/3"},
{"data1":"香港蘇富比拍卖有限公司","data2":"中国艺术珍品","data3":"2017/10/3"},
{"data1":"香港蘇富比拍卖有限公司","data2":"粉红之星:大自然的瑰宝","data3":"  2017/4/4"},
{"data1":"香港蘇富比拍卖有限公司","data2":"中国艺术珍品","data3":"  2017/4/5"},
{"data1":"中古陶(北京)拍卖行有限公司","data2":"华廷雅集·一带一路中国瓷器","data3":"2017/12/20"},
{"data1":"中国嘉德国际拍卖有限公司","data2":"大观——中国书画珍品之夜·古代","data3":"2017/6/19"},
{"data1":"中国嘉德国际拍卖有限公司","data2":"大观——中国书画珍品之夜·古代","data3":"2017/6/19"},
{"data1":"中国嘉德国际拍卖有限公司","data2":"大观——中国书画珍品之夜·近现代","data3":"2017/6/19"},
{"data1":"中国嘉德国际拍卖有限公司","data2":"大观——中国书画珍品之夜·近现代","data3":"2017/6/19"},
{"data1":"中国嘉德国际拍卖有限公司","data2":"旃檀林——佛教艺术集萃","data3":"2017/6/20"},
{"data1":"中国嘉德国际拍卖有限公司","data2":"见微知著——金银珍玩","data3":"2017/6/20"},
{"data1":"中国嘉德国际拍卖有限公司","data2":"见微知著——金银珍玩","data3":"2017/6/20"},
{"data1":"中国嘉德国际拍卖有限公司","data2":"见微知著——金银珍玩","data3":"2017/6/20"},
{"data1":"中国嘉德国际拍卖有限公司","data2":"清隽明朗——明清古典家具精品","data3":"2017/6/20"},
{"data1":"中国嘉德国际拍卖有限公司","data2":"古籍善本 金石碑帖","data3":"2017/6/21"},
{"data1":"中国嘉德国际拍卖有限公司","data2":"哲匠斤墨—名家藏明式家具精品及雅玩","data3":"2017/10/2"},
{"data1":"中国嘉德国际拍卖有限公司","data2":"大观——四海崇誉庆典之夜·古代","data3":"2017/12/18"},
{"data1":"中国嘉德国际拍卖有限公司","data2":"大观——四海崇誉庆典之夜·古代","data3":"2017/12/18"},
{"data1":"中国嘉德国际拍卖有限公司","data2":"大观——四海崇誉庆典之夜·古代","data3":"2017/12/18"},
{"data1":"中国嘉德国际拍卖有限公司","data2":"当代艺术夜场","data3":"2017/12/19"},
{"data1":"中国嘉德国际拍卖有限公司","data2":"古籍善本 金石碑帖","data3":"2017/12/20"},
{"data1":"中国嘉德国际拍卖有限公司","data2":"清隽明朗——明清古典家具精品","data3":"2017/12/21"},
{"data1":"中国嘉德国际拍卖有限公司","data2":"玉映壶光——明清玉器鼻烟壶","data3":"2017/12/21"},
{"data1":"中国嘉德国际拍卖有限公司","data2":"清宁——国石篆刻艺术","data3":"  2017/12/20"},
{"data1":"中国嘉德国际拍卖有限公司","data2":"锡文藏泉 古钱 金银币 金银锭","data3":"2017/12/22"},
{"data1":"中国嘉德国际拍卖有限公司","data2":"大观——中国书画珍品之夜·古代","data3":"2017-6-19"},
{"data1":"中国嘉德国际拍卖有限公司","data2":"大观——中国书画珍品之夜·古代","data3":"2017-6-19"},
{"data1":"中贸圣佳国际拍卖有限公司","data2":"璀璨——中国古代艺术珍品及宫廷器物夜场","data3":"2017/6/18"},
{"data1":"中贸圣佳国际拍卖有限公司","data2":"璀璨——中国古代艺术珍品及宫廷器物夜场","data3":"2017/6/18"},
{"data1":"中贸圣佳国际拍卖有限公司","data2":"集萃——古董珍玩","data3":"2017/6/18"},

]

下面是生成SQL语句的代码:

MySQL中使用了   union all   ,不会的同学请百度

#-*-coding:utf-8-*-

from common.contest import *



ccc= [{"data1":"佳士得伦敦有限公司","data2":"中国瓷器及工艺精品","data3":"2017/5/9"},
{"data1":"佳士得香港有限公司","data2":"瑰丽珠宝及翡翠首饰","data3":"2017/11/28"},
{"data1":"邦瀚斯拍卖行","data2":"中国瓷器及工艺精品专场","data3":"2017/11/28"},
{"data1":"保利华谊","data2":"中国书画","data3":"2017/12/8"},
{"data1":"保利香港拍卖有限公司","data2":"璀璨珠宝专场","data3":"2017/4/3"},
{"data1":"保利香港拍卖有限公司","data2":"璀璨珠宝专场","data3":"2017/4/3"},
{"data1":"保利香港拍卖有限公司","data2":"中国及亚洲现当代艺术专场","data3":"2017/4/3"},
{"data1":"保利香港拍卖有限公司","data2":"璀璨珠宝专场","data3":"2017/10/2"},
{"data1":"保利香港拍卖有限公司","data2":"清净广严—重要藏家珍藏永乐宫廷造像","data3":"2017/10/2"},
{"data1":"保利香港拍卖有限公司","data2":"清净广严—重要藏家珍藏永乐宫廷造像","data3":"2017/10/2"},
{"data1":"保利香港拍卖有限公司","data2":"清净广严—重要藏家珍藏永乐宫廷造像","data3":"2017/10/2"},
{"data1":"保利香港拍卖有限公司","data2":"现当代艺术专场","data3":"2017/10/2"},
{"data1":"保利香港拍卖有限公司","data2":"尤伦斯男爵藏中国重要金器专场","data3":"2017/10/2"},
{"data1":"保利香港拍卖有限公司","data2":"璀璨珠宝专场","data3":"  2017/10/2"},
{"data1":"北京保利国际拍卖有限公司","data2":"瓷器 玉器 工艺品(二)","data3":"2017/4/17"},
{"data1":"北京保利国际拍卖有限公司","data2":"中国古代书画夜场","data3":"2017/6/5"},
{"data1":"北京保利国际拍卖有限公司","data2":"中国古代书画夜场","data3":"2017/6/5"},
{"data1":"北京保利国际拍卖有限公司","data2":"中国古代书画夜场","data3":"2017/6/5"},
{"data1":"北京保利国际拍卖有限公司","data2":"中国近现代书画夜场","data3":"2017/6/5"},
{"data1":"北京保利国际拍卖有限公司","data2":"泉韵古今——纸币、机制币、金银锭 王觐彤旧藏古钱","data3":"2017/6/6"},
{"data1":"北京保利国际拍卖有限公司","data2":"自在菩提——中国金铜佛造像、唐卡","data3":"2017/6/7"},
{"data1":"北京保利国际拍卖有限公司","data2":"仰之弥高—中国古代书画夜场","data3":"2017/12/17"},
{"data1":"北京保利国际拍卖有限公司","data2":"震古烁今——从北宋到当代的中国书画","data3":"2017/12/17"},
{"data1":"北京保利国际拍卖有限公司","data2":"震古烁今——从北宋到当代的中国书画","data3":"2017/12/17"},
{"data1":"北京保利国际拍卖有限公司","data2":"震古烁今——从北宋到当代的中国书画","data3":"2017/12/17"},
{"data1":"北京保利国际拍卖有限公司","data2":"中国近现代书画夜场","data3":"2017/12/17"},
{"data1":"北京保利国际拍卖有限公司","data2":"中国近现代书画夜场","data3":"2017/12/17"},
{"data1":"北京保利国际拍卖有限公司","data2":"瑰映如茵Ⅱ——玫茵堂暨欧美名藏盛清五朝御窑隽品","data3":"2017/12/18"},
{"data1":"北京保利国际拍卖有限公司","data2":"佞宋——宋元巷陌间的“色·声·香·味·触”","data3":"2017/12/18"},
{"data1":"北京保利国际拍卖有限公司","data2":"禹贡(二)——康熙御制黄花梨大四件柜 唐英督陶与大清的辉煌时刻","data3":"2017/12/18"},
{"data1":"北京保利国际拍卖有限公司","data2":"禹贡(二)——康熙御制黄花梨大四件柜 唐英督陶与大清的辉煌时刻","data3":"2017/12/18"},
{"data1":"北京保利国际拍卖有限公司","data2":"禹贡(二)——康熙御制黄花梨大四件柜 唐英督陶与大清的辉煌时刻","data3":"2017/12/18"},
{"data1":"北京保利国际拍卖有限公司","data2":"禹贡(二)——康熙御制黄花梨大四件柜 唐英督陶与大清的辉煌时刻","data3":"2017/12/18"},
{"data1":"北京保利国际拍卖有限公司","data2":"方寸聚九州——邮品专场","data3":"2017/12/22"},
{"data1":"北京保利国际拍卖有限公司","data2":"方寸聚九州——名家旧藏华东解放区专场","data3":"2017/12/23"},
{"data1":"北京保利国际拍卖有限公司","data2":"禹贡——敬勝怠者吉 古董珍玩之夜","data3":"  2017/6/6"},
{"data1":"北京诚轩拍卖有限公司","data2":"古钱 银锭 机制币","data3":"2017/12/20"},
{"data1":"北京诚轩拍卖有限公司","data2":"古钱 银锭 机制币","data3":"2017/12/20"},
{"data1":"北京诚轩拍卖有限公司","data2":"古钱 银锭 机制币","data3":"  2017/12/20"},
{"data1":"北京诚轩拍卖有限公司","data2":"古钱 银锭 机制币","data3":"  2017-6-21"},
{"data1":"北京东正拍卖有限公司","data2":"皇家长物","data3":"2017/6/8"},
{"data1":"北京东正拍卖有限公司","data2":"乾坤荟萃—旦暮清供","data3":"2017/6/8"},
{"data1":"北京东正拍卖有限公司","data2":"皇家长物","data3":"2017/12/9"},
{"data1":"北京华辰拍卖有限公司","data2":"瓷器玉器工艺品","data3":"2017/12/17"},
{"data1":"北京匡时国际拍卖有限公司","data2":"畅怀——古代书法夜场","data3":"2017/6/4"},
{"data1":"北京匡时国际拍卖有限公司","data2":"神工妙造——瓷玉工艺品专场","data3":"2017/6/4"},
{"data1":"北京匡时国际拍卖有限公司","data2":"天工开物——瓷器工艺品精品夜场","data3":"2017/6/4"},
{"data1":"北京匡时国际拍卖有限公司","data2":"田帝玄黄——田黄石专场","data3":"2017/12/3"},
{"data1":"北京匡时国际拍卖有限公司","data2":"田帝玄黄——田黄石专场","data3":"2017/12/3"},
{"data1":"北京匡时国际拍卖有限公司","data2":"天工开物——瓷器工艺品夜场","data3":"  2017/12/3"},
{"data1":"北京匡时国际拍卖有限公司","data2":"田帝玄黄——田黄石专场","data3":"  2017/12/3"},
{"data1":"北京匡时国际拍卖有限公司","data2":"田帝玄黄——田黄石专场","data3":"  2017/12/3"},
{"data1":"北京伍伦国际拍卖有限公司","data2":"写经书画外国手迹专场","data3":"2017/11/15"},
{"data1":"北京印千山国际拍卖有限公司","data2":"潜龙邸——明清家具专场","data3":"2017/7/9"},
{"data1":"广州华艺国际拍卖有限公司","data2":"中国书画","data3":"2017/11/25"},
{"data1":"佳士得伦敦有限公司","data2":"中国瓷器及工艺精品","data3":"2017/5/9"},
{"data1":"佳士得伦敦有限公司","data2":"中国瓷器及工艺精品","data3":"2017/5/9"},
{"data1":"佳士得伦敦有限公司","data2":"中国瓷器及工艺精品","data3":"  2017/5/9"},
{"data1":"佳士得纽约有限公司","data2":"宗器宝绘—藤田美术馆藏中国古代艺术珍品","data3":"2017/3/15"},
{"data1":"佳士得纽约有限公司","data2":"宗器宝绘—藤田美术馆藏中国古代艺术珍品","data3":"2017/3/15"},
{"data1":"佳士得纽约有限公司","data2":"宗器寶繪 ─ 藤田美術館藏中國古代藝術珍品","data3":"2017/3/15"},
{"data1":"佳士得纽约有限公司","data2":"宗器寶繪 ─ 藤田美術館藏中國古代藝術珍品","data3":"2017/3/15"},
{"data1":"佳士得纽约有限公司","data2":"宗器寶繪 ─ 藤田美術館藏中國古代藝術珍品","data3":"2017/3/15"},
{"data1":"佳士得纽约有限公司","data2":"宗器寶繪 ─ 藤田美術館藏中國古代藝術珍品","data3":"2017/3/15"},
{"data1":"佳士得纽约有限公司","data2":"家族遗珍:玛丽·泰瑞莎·L·维勒泰亚洲艺术珍藏","data3":"2017/3/16"},
{"data1":"佳士得纽约有限公司","data2":"家族遗珍:玛丽·泰瑞莎·L·维勒泰亚洲艺术珍藏","data3":"2017/3/16"},
{"data1":"佳士得纽约有限公司","data2":"中国瓷器及工艺精品","data3":"2017/9/14"},
{"data1":"佳士得纽约有限公司","data2":"  宗器宝绘—藤田美术馆藏中国古代艺术珍品","data3":"  2017/3/15"},
{"data1":"佳士得香港有限公司","data2":"融艺/ 亚洲二十世纪及当代艺术(晚间拍卖)","data3":"2017/5/27"},
{"data1":"佳士得香港有限公司","data2":"融艺/ 亚洲二十世纪及当代艺术(晚间拍卖)","data3":"2017/5/27"},
{"data1":"佳士得香港有限公司","data2":"瑰丽珠宝及翡翠首饰","data3":"2017/5/30"},
{"data1":"佳士得香港有限公司","data2":"雍正粉青釉双龙尊","data3":"2017/5/31"},
{"data1":"佳士得香港有限公司","data2":"妙相圆明–佛教艺术精品","data3":"2017/5/31"},
{"data1":"佳士得香港有限公司","data2":"亚洲二十世纪及当代艺术(晚间拍卖)","data3":"2017/11/25"},
{"data1":"佳士得香港有限公司","data2":"瑰丽珠宝及翡翠首饰","data3":"2017/11/28"},
{"data1":"佳士得香港有限公司","data2":"瑰丽珠宝及翡翠首饰","data3":"2017/11/28"},
{"data1":"佳士得香港有限公司","data2":"千秋名韵—孔祥熙家族旧藏傅抱石《琵琶行》","data3":"2017/11/28"},
{"data1":"佳士得香港有限公司","data2":"重要中国瓷器及工艺精品","data3":"2017/11/29"},
{"data1":"佳士得香港有限公司","data2":"养德堂珍藏中国古玉器","data3":"2017/11/29"},
{"data1":"佳士得香港有限公司","data2":"养德堂珍藏中国古玉器","data3":"2017/11/29"},
{"data1":"佳士得香港有限公司","data2":"养德堂珍藏中国古玉器","data3":"2017/11/29"},
{"data1":"佳士得香港有限公司","data2":"重要中国瓷器及工艺精品","data3":"2017/11/29"},
{"data1":"佳士得香港有限公司","data2":"重要中国瓷器及工艺精品","data3":"2017/11/29"},
{"data1":"佳士得香港有限公司","data2":"乐从堂藏明代宫廷珍器晚间拍卖","data3":"  2017/11/27"},
{"data1":"佳士得香港有限公司","data2":"乐从堂藏明代宫廷珍器晚间拍卖","data3":"  2017-11-27"},
{"data1":"羅芙奧股份有限公司","data2":"亚洲现当代艺术专场","data3":"2017/6/4"},
{"data1":"纽约蘇富比有限公司","data2":"明·国风","data3":"2017/3/14"},
{"data1":"上海嘉禾拍卖有限公司","data2":"《禾风》—中国书画夜场","data3":"2017/12/30"},
{"data1":"上海匡时拍卖有限公司","data2":"大器——古代空间夜场","data3":"2017/11/5"},
{"data1":"上海匡时拍卖有限公司","data2":"文玩雅集专场","data3":"2017/11/5"},
{"data1":"苏富比巴黎","data2":"亚洲艺术","data3":"2017/6/22"},
{"data1":"天成国际拍卖有限公司","data2":"珠宝及翡翠","data3":"2017/12/3"},
{"data1":"西泠印社拍卖有限公司","data2":"登昆仑兮—中国首届和田玉籽料原石专场","data3":"2017/7/15"},
{"data1":"西泠印社拍卖有限公司","data2":"南宋宫廷旧藏西周重器国宝兮甲盘专拍暨中国青铜器专场","data3":"2017/7/15"},
{"data1":"西泠印社拍卖有限公司","data2":"中国历代钱币专场","data3":"2017/7/17"},
{"data1":"香港蘇富比拍卖有限公司","data2":"玲珑雅趣:明清掌上御瓷珍翫","data3":"2017/4/5"},
{"data1":"香港蘇富比拍卖有限公司","data2":"轻巧袖珍宝:攻玉山房藏明式家具","data3":"2017/4/5"},
{"data1":"香港蘇富比拍卖有限公司","data2":"鱼豫幽蓝:明宣德青花鱼藻纹十棱菱口大盌","data3":"2017/4/5"},
{"data1":"香港蘇富比拍卖有限公司","data2":"中国艺术珍品","data3":"2017/4/5"},
{"data1":"香港蘇富比拍卖有限公司","data2":"中国艺术珍品","data3":"2017/4/5"},
{"data1":"香港蘇富比拍卖有限公司","data2":"中国艺术珍品","data3":"2017/4/5"},
{"data1":"香港蘇富比拍卖有限公司","data2":"中国艺术珍品","data3":"2017/4/5"},
{"data1":"香港蘇富比拍卖有限公司","data2":"现当代艺术晚间拍卖","data3":"2017/9/30"},
{"data1":"香港蘇富比拍卖有限公司","data2":"现当代艺术晚间拍卖","data3":"2017/9/30"},
{"data1":"香港蘇富比拍卖有限公司","data2":"现当代艺术晚间拍卖","data3":"2017/9/30"},
{"data1":"香港蘇富比拍卖有限公司","data2":"中国古代书画","data3":"2017/10/1"},
{"data1":"香港蘇富比拍卖有限公司","data2":"八宝吉祥 — 仇焱之旧藏明宣德合盌","data3":"2017/10/3"},
{"data1":"香港蘇富比拍卖有限公司","data2":"俊雅清凝 — 乐从堂藏宋瓷粹珍","data3":"2017/10/3"},
{"data1":"香港蘇富比拍卖有限公司","data2":"密慧禅心:菩萨道珍藏及其他佛教艺术精品","data3":"2017/10/3"},
{"data1":"香港蘇富比拍卖有限公司","data2":"中国艺术珍品","data3":"2017/10/3"},
{"data1":"香港蘇富比拍卖有限公司","data2":"中国艺术珍品","data3":"2017/10/3"},
{"data1":"香港蘇富比拍卖有限公司","data2":"粉红之星:大自然的瑰宝","data3":"  2017/4/4"},
{"data1":"香港蘇富比拍卖有限公司","data2":"中国艺术珍品","data3":"  2017/4/5"},
{"data1":"中古陶(北京)拍卖行有限公司","data2":"华廷雅集·一带一路中国瓷器","data3":"2017/12/20"},
{"data1":"中国嘉德国际拍卖有限公司","data2":"大观——中国书画珍品之夜·古代","data3":"2017/6/19"},
{"data1":"中国嘉德国际拍卖有限公司","data2":"大观——中国书画珍品之夜·古代","data3":"2017/6/19"},
{"data1":"中国嘉德国际拍卖有限公司","data2":"大观——中国书画珍品之夜·近现代","data3":"2017/6/19"},
{"data1":"中国嘉德国际拍卖有限公司","data2":"大观——中国书画珍品之夜·近现代","data3":"2017/6/19"},
{"data1":"中国嘉德国际拍卖有限公司","data2":"旃檀林——佛教艺术集萃","data3":"2017/6/20"},
{"data1":"中国嘉德国际拍卖有限公司","data2":"见微知著——金银珍玩","data3":"2017/6/20"},
{"data1":"中国嘉德国际拍卖有限公司","data2":"见微知著——金银珍玩","data3":"2017/6/20"},
{"data1":"中国嘉德国际拍卖有限公司","data2":"见微知著——金银珍玩","data3":"2017/6/20"},
{"data1":"中国嘉德国际拍卖有限公司","data2":"清隽明朗——明清古典家具精品","data3":"2017/6/20"},
{"data1":"中国嘉德国际拍卖有限公司","data2":"古籍善本 金石碑帖","data3":"2017/6/21"},
{"data1":"中国嘉德国际拍卖有限公司","data2":"哲匠斤墨—名家藏明式家具精品及雅玩","data3":"2017/10/2"},
{"data1":"中国嘉德国际拍卖有限公司","data2":"大观——四海崇誉庆典之夜·古代","data3":"2017/12/18"},
{"data1":"中国嘉德国际拍卖有限公司","data2":"大观——四海崇誉庆典之夜·古代","data3":"2017/12/18"},
{"data1":"中国嘉德国际拍卖有限公司","data2":"大观——四海崇誉庆典之夜·古代","data3":"2017/12/18"},
{"data1":"中国嘉德国际拍卖有限公司","data2":"当代艺术夜场","data3":"2017/12/19"},
{"data1":"中国嘉德国际拍卖有限公司","data2":"古籍善本 金石碑帖","data3":"2017/12/20"},
{"data1":"中国嘉德国际拍卖有限公司","data2":"清隽明朗——明清古典家具精品","data3":"2017/12/21"},
{"data1":"中国嘉德国际拍卖有限公司","data2":"玉映壶光——明清玉器鼻烟壶","data3":"2017/12/21"},
{"data1":"中国嘉德国际拍卖有限公司","data2":"清宁——国石篆刻艺术","data3":"  2017/12/20"},
{"data1":"中国嘉德国际拍卖有限公司","data2":"锡文藏泉 古钱 金银币 金银锭","data3":"2017/12/22"},
{"data1":"中国嘉德国际拍卖有限公司","data2":"大观——中国书画珍品之夜·古代","data3":"2017-6-19"},
{"data1":"中国嘉德国际拍卖有限公司","data2":"大观——中国书画珍品之夜·古代","data3":"2017-6-19"},
{"data1":"中贸圣佳国际拍卖有限公司","data2":"璀璨——中国古代艺术珍品及宫廷器物夜场","data3":"2017/6/18"},
{"data1":"中贸圣佳国际拍卖有限公司","data2":"璀璨——中国古代艺术珍品及宫廷器物夜场","data3":"2017/6/18"},
{"data1":"中贸圣佳国际拍卖有限公司","data2":"集萃——古董珍玩","data3":"2017/6/18"},

]


sql_list = []
for item in ccc:
    aucr_name_spider = item['data1']
    session_name = item['data2']
    item_auct_time = item['data3']

    item_auct_time = item_auct_time.replace('-','/').replace(' ','')
    item_auct_time_list = item_auct_time.split('/')
    item_auct_time_year = item_auct_time_list[0]
    item_auct_time_month = item_auct_time_list[1]
    item_auct_time_day = item_auct_time_list[2]

    if int(item_auct_time_month)< 10:
        item_auct_time_month = "0"+ item_auct_time_month

    if int(item_auct_time_day)<10:
        item_auct_time_day = "0"+ item_auct_time_day

    auct_time = item_auct_time_year + item_auct_time_month + item_auct_time_day

    if int(auct_time) >=20170700:
      #核心代码 sql = "SELECT * FROM `guonei_artron_items_core__qingxi` WHERE item_auct_time = "+ "\"" + auct_time + "\""
+" AND aucr_name_spider =" + '\"' + aucr_name_spider + '"' +" and session_name =" + '\"'+ session_name + '\"' + " union all" sql_list.append(sql) result = set(sql_list)

print result


 输出结果是:

SELECT * FROM `guonei_artron_items_core__qingxi` WHERE item_auct_time = "20171002" AND aucr_name_spider ="中国嘉德国际拍卖有限公司" and session_name ="哲匠斤墨—名家藏明式家具精品及雅玩" union all
SELECT * FROM `guonei_artron_items_core__qingxi` WHERE item_auct_time = "20171115" AND aucr_name_spider ="北京伍伦国际拍卖有限公司" and session_name ="写经书画外国手迹专场" union all
SELECT * FROM `guonei_artron_items_core__qingxi` WHERE item_auct_time = "20171002" AND aucr_name_spider ="保利香港拍卖有限公司" and session_name ="璀璨珠宝专场" union all
SELECT * FROM `guonei_artron_items_core__qingxi` WHERE item_auct_time = "20171217" AND aucr_name_spider ="北京华辰拍卖有限公司" and session_name ="瓷器玉器工艺品" union all
SELECT * FROM `guonei_artron_items_core__qingxi` WHERE item_auct_time = "20171002" AND aucr_name_spider ="保利香港拍卖有限公司" and session_name ="尤伦斯男爵藏中国重要金器专场" union all
SELECT * FROM `guonei_artron_items_core__qingxi` WHERE item_auct_time = "20171127" AND aucr_name_spider ="佳士得香港有限公司" and session_name ="乐从堂藏明代宫廷珍器晚间拍卖" union all
SELECT * FROM `guonei_artron_items_core__qingxi` WHERE item_auct_time = "20171218" AND aucr_name_spider ="北京保利国际拍卖有限公司" and session_name ="佞宋——宋元巷陌间的“色·声·香·味·触”" union all
SELECT * FROM `guonei_artron_items_core__qingxi` WHERE item_auct_time = "20171217" AND aucr_name_spider ="北京保利国际拍卖有限公司" and session_name ="中国近现代书画夜场" union all
SELECT * FROM `guonei_artron_items_core__qingxi` WHERE item_auct_time = "20171223" AND aucr_name_spider ="北京保利国际拍卖有限公司" and session_name ="方寸聚九州——名家旧藏华东解放区专场" union all
SELECT * FROM `guonei_artron_items_core__qingxi` WHERE item_auct_time = "20170715" AND aucr_name_spider ="西泠印社拍卖有限公司" and session_name ="南宋宫廷旧藏西周重器国宝兮甲盘专拍暨中国青铜器专场" union all
SELECT * FROM `guonei_artron_items_core__qingxi` WHERE item_auct_time = "20171129" AND aucr_name_spider ="佳士得香港有限公司" and session_name ="重要中国瓷器及工艺精品" union all
SELECT * FROM `guonei_artron_items_core__qingxi` WHERE item_auct_time = "20171220" AND aucr_name_spider ="北京诚轩拍卖有限公司" and session_name ="古钱 银锭 机制币" union all
SELECT * FROM `guonei_artron_items_core__qingxi` WHERE item_auct_time = "20171128" AND aucr_name_spider ="佳士得香港有限公司" and session_name ="瑰丽珠宝及翡翠首饰" union all
SELECT * FROM `guonei_artron_items_core__qingxi` WHERE item_auct_time = "20171218" AND aucr_name_spider ="北京保利国际拍卖有限公司" and session_name ="禹贡(二)——康熙御制黄花梨大四件柜 唐英督陶与大清的辉煌时刻" union all
SELECT * FROM `guonei_artron_items_core__qingxi` WHERE item_auct_time = "20171203" AND aucr_name_spider ="北京匡时国际拍卖有限公司" and session_name ="天工开物——瓷器工艺品夜场" union all
SELECT * FROM `guonei_artron_items_core__qingxi` WHERE item_auct_time = "20170715" AND aucr_name_spider ="西泠印社拍卖有限公司" and session_name ="登昆仑兮—中国首届和田玉籽料原石专场" union all
SELECT * FROM `guonei_artron_items_core__qingxi` WHERE item_auct_time = "20171220" AND aucr_name_spider ="中国嘉德国际拍卖有限公司" and session_name ="古籍善本 金石碑帖" union all
SELECT * FROM `guonei_artron_items_core__qingxi` WHERE item_auct_time = "20171001" AND aucr_name_spider ="香港蘇富比拍卖有限公司" and session_name ="中国古代书画" union all
SELECT * FROM `guonei_artron_items_core__qingxi` WHERE item_auct_time = "20171105" AND aucr_name_spider ="上海匡时拍卖有限公司" and session_name ="大器——古代空间夜场" union all
SELECT * FROM `guonei_artron_items_core__qingxi` WHERE item_auct_time = "20171221" AND aucr_name_spider ="中国嘉德国际拍卖有限公司" and session_name ="清隽明朗——明清古典家具精品" union all
SELECT * FROM `guonei_artron_items_core__qingxi` WHERE item_auct_time = "20171217" AND aucr_name_spider ="北京保利国际拍卖有限公司" and session_name ="仰之弥高—中国古代书画夜场" union all
SELECT * FROM `guonei_artron_items_core__qingxi` WHERE item_auct_time = "20171129" AND aucr_name_spider ="佳士得香港有限公司" and session_name ="养德堂珍藏中国古玉器" union all
SELECT * FROM `guonei_artron_items_core__qingxi` WHERE item_auct_time = "20171002" AND aucr_name_spider ="保利香港拍卖有限公司" and session_name ="现当代艺术专场" union all
SELECT * FROM `guonei_artron_items_core__qingxi` WHERE item_auct_time = "20171003" AND aucr_name_spider ="香港蘇富比拍卖有限公司" and session_name ="俊雅清凝 — 乐从堂藏宋瓷粹珍" union all
SELECT * FROM `guonei_artron_items_core__qingxi` WHERE item_auct_time = "20171125" AND aucr_name_spider ="佳士得香港有限公司" and session_name ="亚洲二十世纪及当代艺术(晚间拍卖)" union all
SELECT * FROM `guonei_artron_items_core__qingxi` WHERE item_auct_time = "20171221" AND aucr_name_spider ="中国嘉德国际拍卖有限公司" and session_name ="玉映壶光——明清玉器鼻烟壶" union all
SELECT * FROM `guonei_artron_items_core__qingxi` WHERE item_auct_time = "20171203" AND aucr_name_spider ="天成国际拍卖有限公司" and session_name ="珠宝及翡翠" union all
SELECT * FROM `guonei_artron_items_core__qingxi` WHERE item_auct_time = "20171125" AND aucr_name_spider ="广州华艺国际拍卖有限公司" and session_name ="中国书画" union all
SELECT * FROM `guonei_artron_items_core__qingxi` WHERE item_auct_time = "20171203" AND aucr_name_spider ="北京匡时国际拍卖有限公司" and session_name ="田帝玄黄——田黄石专场" union all
SELECT * FROM `guonei_artron_items_core__qingxi` WHERE item_auct_time = "20170709" AND aucr_name_spider ="北京印千山国际拍卖有限公司" and session_name ="潜龙邸——明清家具专场" union all
SELECT * FROM `guonei_artron_items_core__qingxi` WHERE item_auct_time = "20171219" AND aucr_name_spider ="中国嘉德国际拍卖有限公司" and session_name ="当代艺术夜场" union all
SELECT * FROM `guonei_artron_items_core__qingxi` WHERE item_auct_time = "20171003" AND aucr_name_spider ="香港蘇富比拍卖有限公司" and session_name ="八宝吉祥 — 仇焱之旧藏明宣德合盌" union all
SELECT * FROM `guonei_artron_items_core__qingxi` WHERE item_auct_time = "20171222" AND aucr_name_spider ="北京保利国际拍卖有限公司" and session_name ="方寸聚九州——邮品专场" union all
SELECT * FROM `guonei_artron_items_core__qingxi` WHERE item_auct_time = "20171128" AND aucr_name_spider ="佳士得香港有限公司" and session_name ="千秋名韵—孔祥熙家族旧藏傅抱石《琵琶行》" union all
SELECT * FROM `guonei_artron_items_core__qingxi` WHERE item_auct_time = "20171003" AND aucr_name_spider ="香港蘇富比拍卖有限公司" and session_name ="中国艺术珍品" union all
SELECT * FROM `guonei_artron_items_core__qingxi` WHERE item_auct_time = "20171217" AND aucr_name_spider ="北京保利国际拍卖有限公司" and session_name ="震古烁今——从北宋到当代的中国书画" union all
SELECT * FROM `guonei_artron_items_core__qingxi` WHERE item_auct_time = "20170914" AND aucr_name_spider ="佳士得纽约有限公司" and session_name ="中国瓷器及工艺精品" union all
SELECT * FROM `guonei_artron_items_core__qingxi` WHERE item_auct_time = "20171002" AND aucr_name_spider ="保利香港拍卖有限公司" and session_name ="清净广严—重要藏家珍藏永乐宫廷造像" union all
SELECT * FROM `guonei_artron_items_core__qingxi` WHERE item_auct_time = "20171209" AND aucr_name_spider ="北京东正拍卖有限公司" and session_name ="皇家长物" union all
SELECT * FROM `guonei_artron_items_core__qingxi` WHERE item_auct_time = "20171218" AND aucr_name_spider ="北京保利国际拍卖有限公司" and session_name ="瑰映如茵Ⅱ——玫茵堂暨欧美名藏盛清五朝御窑隽品" union all
SELECT * FROM `guonei_artron_items_core__qingxi` WHERE item_auct_time = "20170717" AND aucr_name_spider ="西泠印社拍卖有限公司" and session_name ="中国历代钱币专场" union all
SELECT * FROM `guonei_artron_items_core__qingxi` WHERE item_auct_time = "20171218" AND aucr_name_spider ="中国嘉德国际拍卖有限公司" and session_name ="大观——四海崇誉庆典之夜·古代" union all
SELECT * FROM `guonei_artron_items_core__qingxi` WHERE item_auct_time = "20171128" AND aucr_name_spider ="邦瀚斯拍卖行" and session_name ="中国瓷器及工艺精品专场" union all
SELECT * FROM `guonei_artron_items_core__qingxi` WHERE item_auct_time = "20171220" AND aucr_name_spider ="中古陶(北京)拍卖行有限公司" and session_name ="华廷雅集·一带一路中国瓷器" union all
SELECT * FROM `guonei_artron_items_core__qingxi` WHERE item_auct_time = "20170930" AND aucr_name_spider ="香港蘇富比拍卖有限公司" and session_name ="现当代艺术晚间拍卖" union all
SELECT * FROM `guonei_artron_items_core__qingxi` WHERE item_auct_time = "20171003" AND aucr_name_spider ="香港蘇富比拍卖有限公司" and session_name ="密慧禅心:菩萨道珍藏及其他佛教艺术精品" union all
SELECT * FROM `guonei_artron_items_core__qingxi` WHERE item_auct_time = "20171220" AND aucr_name_spider ="中国嘉德国际拍卖有限公司" and session_name ="清宁——国石篆刻艺术" union all
SELECT * FROM `guonei_artron_items_core__qingxi` WHERE item_auct_time = "20171105" AND aucr_name_spider ="上海匡时拍卖有限公司" and session_name ="文玩雅集专场" union all
SELECT * FROM `guonei_artron_items_core__qingxi` WHERE item_auct_time = "20171222" AND aucr_name_spider ="中国嘉德国际拍卖有限公司" and session_name ="锡文藏泉 古钱 金银币 金银锭" union all
SELECT * FROM `guonei_artron_items_core__qingxi` WHERE item_auct_time = "20171230" AND aucr_name_spider ="上海嘉禾拍卖有限公司" and session_name ="《禾风》—中国书画夜场" union all
SELECT * FROM `guonei_artron_items_core__qingxi` WHERE item_auct_time = "20171208" AND aucr_name_spider ="保利华谊" and session_name ="中国书画" union all
51

解决问题并不重要,重要的是解决问题的思路。

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值