Python 爬虫 数据提取

时间:2023-05-21 20:10:31

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

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

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

Python  爬虫   数据提取

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

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

SELECT * FROM `guonei_artron_items_core__qingxi` WHERE item_auct_time = "" 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--*-

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

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