Retrospective of 2000s: there are many watches from this decade that I really like, some of which I like so much and …
Just one day after the The Royal Oak 50th thematic auction, Phillips held the The Geneva Watch Auction: XV over the weekend, …
As said in the Auction Preview 拍卖前瞻 – Monaco April 2022, the big forerunner of this spring auction season is Sotheby’s two …
Recent Posts
Archives
collapsArch options:
Array
(
[title] => Archives
[noTitle] =>
[inExcludeCat] => exclude
[inExcludeCats] =>
[inExcludeYear] => exclude
[inExcludeYears] =>
[showPages] =>
[sort] => DESC
[linkToArch] => 1
[showYearCount] => 1
[expandCurrentYear] => 1
[expandMonths] => 1
[expandYears] => 1
[expandCurrentMonth] => 1
[showMonthCount] => 1
[showPostTitle] => 1
[expand] => 0
[showPostDate] => 1
[debug] => 1
[postDateFormat] => m/d
[postDateAppend] => after
[accordion] => 1
[useCookies] => 1
[post_type] => post
[taxoncmy] => category
[postTitleLength] =>
[showPostCount] => 1
[style] => custom
[archSortOrder] => DESC
[showPosts] =>
[customExpand] =>
[customCollapse] =>
[taxonomy] => both
[number] => 2
)
POST QUERY:
SELECT qhn_terms.slug, qhn_posts.ID,
qhn_posts.post_name, qhn_posts.post_title, qhn_posts.post_author,
qhn_posts.post_date, YEAR(qhn_posts.post_date) AS 'year',
MONTH(qhn_posts.post_date) AS 'month' ,
qhn_posts.post_type
FROM qhn_posts LEFT JOIN qhn_term_relationships ON qhn_posts.ID =
qhn_term_relationships.object_id
LEFT JOIN qhn_term_taxonomy ON qhn_term_taxonomy.term_taxonomy_id =
qhn_term_relationships.term_taxonomy_id
LEFT JOIN qhn_terms ON qhn_terms.term_id =
qhn_term_taxonomy.term_id
WHERE post_status='publish' AND qhn_posts.post_type='post'
GROUP BY qhn_posts.ID
ORDER BY qhn_posts.post_date DESC
POST QUERY RESULTS
Array
(
[0] => stdClass Object
(
[slug] => article
[ID] => 3731
[post_name] => rec2023
[post_title] => 2023购表推荐
[post_author] => 1
[post_date] => 2023-06-01 18:01:00
[year] => 2023
[month] => 6
[post_type] => post
)
[1] => stdClass Object
(
[slug] => review
[ID] => 3728
[post_name] => 2023-may-geneva-auctions
[post_title] => 2023日内瓦五月春拍回顾
[post_author] => 1
[post_date] => 2023-05-15 17:25:21
[year] => 2023
[month] => 5
[post_type] => post
)
[2] => stdClass Object
(
[slug] => article
[ID] => 3655
[post_name] => geometer
[post_title] => Rodania Geometer
[post_author] => 1
[post_date] => 2023-05-01 08:00:00
[year] => 2023
[month] => 5
[post_type] => post
)
[3] => stdClass Object
(
[slug] => article
[ID] => 3495
[post_name] => sotc-2023
[post_title] => SOTC 2023
[post_author] => 1
[post_date] => 2023-03-24 22:08:48
[year] => 2023
[month] => 3
[post_type] => post
)
[4] => stdClass Object
(
[slug] => review
[ID] => 3470
[post_name] => 2022review
[post_title] => 2022回顾
[post_author] => 1
[post_date] => 2022-12-30 22:30:00
[year] => 2022
[month] => 12
[post_type] => post
)
[5] => stdClass Object
(
[slug] => article
[ID] => 3419
[post_name] => top-10-of-2010s
[post_title] => Top 10 of 2010s – 10年代个人最推崇的表
[post_author] => 1
[post_date] => 2022-11-01 23:00:00
[year] => 2022
[month] => 11
[post_type] => post
)
[6] => stdClass Object
(
[slug] => article
[ID] => 3372
[post_name] => top-10-2000s
[post_title] => Top 10 of 2000s - 00年代个人最推崇的表
[post_author] => 1
[post_date] => 2022-08-22 20:51:59
[year] => 2022
[month] => 8
[post_type] => post
)
[7] => stdClass Object
(
[slug] => article
[ID] => 3266
[post_name] => top-10-patek-2526
[post_title] => Top 10: Patek 2526
[post_author] => 1
[post_date] => 2022-07-17 21:17:04
[year] => 2022
[month] => 7
[post_type] => post
)
[8] => stdClass Object
(
[slug] => article
[ID] => 3185
[post_name] => top-10-lange
[post_title] => 现代朗格经典
[post_author] => 1
[post_date] => 2022-05-30 22:00:00
[year] => 2022
[month] => 5
[post_type] => post
)
[9] => stdClass Object
(
[slug] => review
[ID] => 2939
[post_name] => auction-review-phillips-may-2022
[post_title] => Auction Review 拍卖点评 Phillips May 2022
[post_author] => 1
[post_date] => 2022-05-08 21:31:16
[year] => 2022
[month] => 5
[post_type] => post
)
[10] => stdClass Object
(
[slug] => article
[ID] => 2259
[post_name] => pre-moon
[post_title] => Pre-Moon
[post_author] => 1
[post_date] => 2022-04-30 20:40:00
[year] => 2022
[month] => 4
[post_type] => post
)
[11] => stdClass Object
(
[slug] => article
[ID] => 2733
[post_name] => top-10-rolex
[post_title] => Top 10: Rolex 十大劳力士
[post_author] => 1
[post_date] => 2022-04-30 13:18:00
[year] => 2022
[month] => 4
[post_type] => post
)
[12] => stdClass Object
(
[slug] => review
[ID] => 2873
[post_name] => auction-review-sothebys-april-2022
[post_title] => Auction Review 拍卖点评 Sotheby's April 2022
[post_author] => 1
[post_date] => 2022-04-29 22:55:00
[year] => 2022
[month] => 4
[post_type] => post
)
[13] => stdClass Object
(
[slug] => preview
[ID] => 2567
[post_name] => auction-preview-monaco-april-2022
[post_title] => Auction Preview 拍卖前瞻 - Monaco April 2022
[post_author] => 1
[post_date] => 2022-04-11 21:37:29
[year] => 2022
[month] => 4
[post_type] => post
)
[14] => stdClass Object
(
[slug] => review
[ID] => 2422
[post_name] => 2021review
[post_title] => 2021回顾
[post_author] => 1
[post_date] => 2021-12-17 15:06:00
[year] => 2021
[month] => 12
[post_type] => post
)
[15] => stdClass Object
(
[slug] => article
[ID] => 3444
[post_name] => top-10-of-1990s
[post_title] => Top 10 of 1990s – 90年代个人最推崇的表
[post_author] => 1
[post_date] => 2021-11-22 23:00:00
[year] => 2021
[month] => 11
[post_type] => post
)
[16] => stdClass Object
(
[slug] => article
[ID] => 2766
[post_name] => rolex-explorer
[post_title] => Rolex Explorer 探险家指南
[post_author] => 1
[post_date] => 2021-05-02 22:50:34
[year] => 2021
[month] => 5
[post_type] => post
)
[17] => stdClass Object
(
[slug] => review
[ID] => 2453
[post_name] => 2020review
[post_title] => 2020回顾
[post_author] => 1
[post_date] => 2020-12-16 08:45:00
[year] => 2020
[month] => 12
[post_type] => post
)
[18] => stdClass Object
(
[slug] => review
[ID] => 2459
[post_name] => 2019review
[post_title] => 2019回顾
[post_author] => 1
[post_date] => 2020-02-07 22:31:00
[year] => 2020
[month] => 2
[post_type] => post
)
[19] => stdClass Object
(
[slug] => review
[ID] => 2468
[post_name] => 2018review
[post_title] => 2018回顾
[post_author] => 1
[post_date] => 2019-01-08 23:50:00
[year] => 2019
[month] => 1
[post_type] => post
)
[20] => stdClass Object
(
[slug] => article
[ID] => 2694
[post_name] => ten-dreams
[post_title] => 10 Dreams 梦幻十大
[post_author] => 1
[post_date] => 2018-10-27 22:35:00
[year] => 2018
[month] => 10
[post_type] => post
)
[21] => stdClass Object
(
[slug] => article
[ID] => 2924
[post_name] => royal-oak
[post_title] => 高级运动表入门推荐 - 皇家橡树篇
[post_author] => 1
[post_date] => 2018-08-11 14:00:00
[year] => 2018
[month] => 8
[post_type] => post
)
[22] => stdClass Object
(
[slug] => review
[ID] => 2478
[post_name] => 2017review
[post_title] => 2017回顾
[post_author] => 1
[post_date] => 2017-12-08 09:00:00
[year] => 2017
[month] => 12
[post_type] => post
)
[23] => stdClass Object
(
[slug] => article
[ID] => 2738
[post_name] => top-10-simplicity
[post_title] => Top 10: 十大Simplicity
[post_author] => 1
[post_date] => 2017-10-10 08:00:55
[year] => 2017
[month] => 10
[post_type] => post
)
[24] => stdClass Object
(
[slug] => review
[ID] => 2491
[post_name] => 2016review
[post_title] => 2016回顾
[post_author] => 1
[post_date] => 2016-12-31 22:10:00
[year] => 2016
[month] => 12
[post_type] => post
)
[25] => stdClass Object
(
[slug] => article
[ID] => 2838
[post_name] => top9-pp
[post_title] => 九大PP
[post_author] => 1
[post_date] => 2015-07-15 22:30:00
[year] => 2015
[month] => 7
[post_type] => post
)
[26] => stdClass Object
(
[slug] => article
[ID] => 3216
[post_name] => observatory
[post_title] => 天文台表
[post_author] => 1
[post_date] => 2013-03-31 13:30:00
[year] => 2013
[month] => 3
[post_type] => post
)
[27] => stdClass Object
(
[slug] => article
[ID] => 2840
[post_name] => patek2499
[post_title] => 巨星永恒 — 2499
[post_author] => 1
[post_date] => 2012-12-12 15:11:00
[year] => 2012
[month] => 12
[post_type] => post
)
[28] => stdClass Object
(
[slug] => article
[ID] => 3351
[post_name] => iwc-mark
[post_title] => 马克一族
[post_author] => 1
[post_date] => 2012-12-08 21:00:00
[year] => 2012
[month] => 12
[post_type] => post
)
[29] => stdClass Object
(
[slug] => article
[ID] => 3876
[post_name] => mark11
[post_title] => 马克十一
[post_author] => 1
[post_date] => 2012-05-16 12:18:00
[year] => 2012
[month] => 5
[post_type] => post
)
[30] => stdClass Object
(
[slug] => article
[ID] => 3840
[post_name] => modern-dials
[post_title] => 最美的面盘（现代篇）
[post_author] => 1
[post_date] => 2012-05-01 00:31:00
[year] => 2012
[month] => 5
[post_type] => post
)
[31] => stdClass Object
(
[slug] => article
[ID] => 3532
[post_name] => speedmaster
[post_title] => 闲谈超霸
[post_author] => 1
[post_date] => 2012-03-27 21:30:00
[year] => 2012
[month] => 3
[post_type] => post
)
[32] => stdClass Object
(
[slug] => article
[ID] => 3834
[post_name] => modern-movements
[post_title] => 最美的机芯（现代篇）
[post_author] => 1
[post_date] => 2012-03-12 00:05:00
[year] => 2012
[month] => 3
[post_type] => post
)
[33] => stdClass Object
(
[slug] => article
[ID] => 3126
[post_name] => lange-journe
[post_title] => 闲谈Lange和Journe
[post_author] => 1
[post_date] => 2011-12-11 09:55:00
[year] => 2011
[month] => 12
[post_type] => post
)
[34] => stdClass Object
(
[slug] => article
[ID] => 2989
[post_name] => gp90200
[post_title] => 逐风追电
[post_author] => 1
[post_date] => 2011-01-05 13:20:00
[year] => 2011
[month] => 1
[post_type] => post
)
[35] => stdClass Object
(
[slug] => article
[ID] => 2334
[post_name] => simplicity
[post_title] => 返璞归真
[post_author] => 1
[post_date] => 2010-03-26 22:10:00
[year] => 2010
[month] => 3
[post_type] => post
)
[36] => stdClass Object
(
[slug] => article
[ID] => 2268
[post_name] => the-wait-is-over-the-landing-of-simplicity
[post_title] => The wait is over – the landing of Simplicity
[post_author] => 1
[post_date] => 2009-12-23 20:50:00
[year] => 2009
[month] => 12
[post_type] => post
)
[37] => stdClass Object
(
[slug] => article
[ID] => 2502
[post_name] => jarre
[post_title] => 雅尔的世界
[post_author] => 1
[post_date] => 2009-07-15 00:00:00
[year] => 2009
[month] => 7
[post_type] => post
)
[38] => stdClass Object
(
[slug] => article
[ID] => 3004
[post_name] => guarneri
[post_title] => 小名琴
[post_author] => 1
[post_date] => 2008-10-31 10:01:30
[year] => 2008
[month] => 10
[post_type] => post
)
)