WordPress database error: [Table 'jeromekj_wp.Qlnvm03_wfConfig' doesn't exist] SELECT name, val, autoload FROM Qlnvm03_wfConfig WHERE name = 'allowLegacy2FA'
WordPress database error: [Table 'jeromekj_wp.Qlnvm03_wfls_settings' doesn't exist] SELECT `name`, `value`, `autoload` FROM `Qlnvm03_wfls_settings` WHERE `name` = 'require-2fa.administrator'
WordPress database error: [Table 'jeromekj_wp.Qlnvm03_wfls_settings' doesn't exist] SELECT `name`, `value`, `autoload` FROM `Qlnvm03_wfls_settings` WHERE `name` = 'allow-xml-rpc'
WordPress database error: [Table 'jeromekj_wp.Qlnvm03_wfls_settings' doesn't exist] SELECT `name`, `value`, `autoload` FROM `Qlnvm03_wfls_settings` WHERE `name` = 'enable-woocommerce-integration'
WordPress database error: [Table 'jeromekj_wp.Qlnvm03_wfls_settings' doesn't exist] SELECT `name`, `value`, `autoload` FROM `Qlnvm03_wfls_settings` WHERE `name` = 'enable-shortcode'
WordPress database error: [Table 'jeromekj_wp.Qlnvm03_wfConfig' doesn't exist] SELECT name, val, autoload FROM Qlnvm03_wfConfig WHERE name = 'apiKey'
WordPress database error: [Table 'jeromekj_wp.Qlnvm03_wfConfig' doesn't exist] SELECT name, val, autoload FROM Qlnvm03_wfConfig WHERE name = 'howGetIPs'
WordPress database error: [Table 'jeromekj_wp.Qlnvm03_wfConfig' doesn't exist] SELECT name, val, autoload FROM Qlnvm03_wfConfig WHERE name = 'detectProxyRecommendation'
WordPress database error: [Table 'jeromekj_wp.Qlnvm03_wfConfig' doesn't exist] SELECT name, val, autoload FROM Qlnvm03_wfConfig WHERE name = 'howGetIPs_trusted_proxies'
WordPress database error: [Table 'jeromekj_wp.Qlnvm03_wfConfig' doesn't exist] SELECT name, val, autoload FROM Qlnvm03_wfConfig WHERE name = 'whitelistPresets'
WordPress database error: [Table 'jeromekj_wp.Qlnvm03_wfConfig' doesn't exist] SELECT name, val, autoload FROM Qlnvm03_wfConfig WHERE name = 'whitelistedServices'
WordPress database error: [Table 'jeromekj_wp.Qlnvm03_wfConfig' doesn't exist] SELECT name, val, autoload FROM Qlnvm03_wfConfig WHERE name = 'whitelisted'
WordPress database error: [Table 'jeromekj_wp.Qlnvm03_wfConfig' doesn't exist] SELECT name, val, autoload FROM Qlnvm03_wfConfig WHERE name = 'ajaxWatcherDisabled_front'
WordPress database error: [Table 'jeromekj_wp.Qlnvm03_wfConfig' doesn't exist] SELECT name, val, autoload FROM Qlnvm03_wfConfig WHERE name = 'ajaxWatcherDisabled_admin'
WordPress database error: [Table 'jeromekj_wp.Qlnvm03_wfBlocks7' doesn't exist] SHOW FULL COLUMNS FROM `Qlnvm03_wfBlocks7`
WordPress database error: [Table 'jeromekj_wp.Qlnvm03_wfBlocks7' doesn't exist] SHOW FULL COLUMNS FROM `Qlnvm03_wfBlocks7`
WordPress database error: [Table 'jeromekj_wp.Qlnvm03_wfConfig' doesn't exist] SELECT name, val, autoload FROM Qlnvm03_wfConfig WHERE name = 'loginSec_enableSeparateTwoFactor'
WordPress database error: [Table 'jeromekj_wp.Qlnvm03_wfConfig' doesn't exist] SELECT name, val, autoload FROM Qlnvm03_wfConfig WHERE name = 'other_hideWPVersion'
WordPress database error: [Table 'jeromekj_wp.Qlnvm03_wfConfig' doesn't exist] SELECT name, val, autoload FROM Qlnvm03_wfConfig WHERE name = 'loginSec_disableAuthorScan'
WordPress database error: [Table 'jeromekj_wp.Qlnvm03_wfConfig' doesn't exist] SELECT name, val, autoload FROM Qlnvm03_wfConfig WHERE name = 'loginSec_disableApplicationPasswords'
WordPress database error: [Table 'jeromekj_wp.Qlnvm03_wfConfig' doesn't exist] SELECT name, val, autoload FROM Qlnvm03_wfConfig WHERE name = 'scanType'
WordPress database error: [Table 'jeromekj_wp.Qlnvm03_wfConfig' doesn't exist] SELECT name, val, autoload FROM Qlnvm03_wfConfig WHERE name = 'scan_exclude'
WordPress database error: [Table 'jeromekj_wp.Qlnvm03_wfConfig' doesn't exist] SELECT name, val, autoload FROM Qlnvm03_wfConfig WHERE name = 'scan_include_extra'
WordPress database error: [Table 'jeromekj_wp.Qlnvm03_wfConfig' doesn't exist] SELECT name, val, autoload FROM Qlnvm03_wfConfig WHERE name = 'liveTrafficEnabled'
WordPress database error: [Table 'jeromekj_wp.Qlnvm03_wfConfig' doesn't exist] SELECT name, val, autoload FROM Qlnvm03_wfConfig WHERE name = 'other_hideWPVersion'
WordPress database error: [Table 'jeromekj_wp.Qlnvm03_wfConfig' doesn't exist] SELECT name, val, autoload FROM Qlnvm03_wfConfig WHERE name = 'wordfenceCentralConnected'
WordPress database error: [Table 'jeromekj_wp.Qlnvm03_wfConfig' doesn't exist] SELECT name, val, autoload FROM Qlnvm03_wfConfig WHERE name = 'wordfenceI18n'
WordPress database error: [Table 'jeromekj_wp.Qlnvm03_wfConfig' doesn't exist] SELECT name, val, autoload FROM Qlnvm03_wfConfig WHERE name = 'wp_home_url'
WordPress database error: [Table 'jeromekj_wp.Qlnvm03_wfConfig' doesn't exist] SELECT name, val, autoload FROM Qlnvm03_wfConfig WHERE name = 'wp_site_url'
WordPress database error: [Table 'jeromekj_wp.Qlnvm03_wfConfig' doesn't exist] SELECT name, val, autoload FROM Qlnvm03_wfConfig WHERE name = 'needsGeoIPSync'
WordPress database error: [Table 'jeromekj_wp.Qlnvm03_wfConfig' doesn't exist] SELECT name, val, autoload FROM Qlnvm03_wfConfig WHERE name = 'lastPermissionsTemplateCheck'
WordPress database error: [Table 'jeromekj_wp.Qlnvm03_wfConfig' doesn't exist] INSERT INTO Qlnvm03_wfConfig (name, val, autoload) values ('lastPermissionsTemplateCheck', '1686105313', 'yes') ON DUPLICATE KEY UPDATE val = '1686105313', autoload = 'yes'
WordPress database error: [Table 'jeromekj_wp.Qlnvm03_wfConfig' doesn't exist] SELECT name, val, autoload FROM Qlnvm03_wfConfig WHERE name = 'previousWflogsFileList'
WordPress database error: [Table 'jeromekj_wp.Qlnvm03_wfConfig' doesn't exist] INSERT INTO Qlnvm03_wfConfig (name, val, autoload) values ('previousWflogsFileList', '[\".htaccess\",\"ips.php\",\"config.php\",\"attack-data.php\",\"rules.php\",\"config-synced.php\",\"config-livewaf.php\",\"config-transient.php\",\"GeoLite2-Country.mmdb\",\"template.php\"]', 'yes') ON DUPLICATE KEY UPDATE val = '[\".htaccess\",\"ips.php\",\"config.php\",\"attack-data.php\",\"rules.php\",\"config-synced.php\",\"config-livewaf.php\",\"config-transient.php\",\"GeoLite2-Country.mmdb\",\"template.php\"]', autoload = 'yes'
WordPress database error: [Table 'jeromekj_wp.Qlnvm03_wfConfig' doesn't exist] SELECT name, val, autoload FROM Qlnvm03_wfConfig WHERE name = 'apiKey'
WordPress database error: [Table 'jeromekj_wp.Qlnvm03_wfConfig' doesn't exist] SELECT name, val, autoload FROM Qlnvm03_wfConfig WHERE name = 'isPaid'
WordPress database error: [Table 'jeromekj_wp.Qlnvm03_wfConfig' doesn't exist] SELECT name, val, autoload FROM Qlnvm03_wfConfig WHERE name = 'whitelisted'
WordPress database error: [Table 'jeromekj_wp.Qlnvm03_wfConfig' doesn't exist] SELECT name, val, autoload FROM Qlnvm03_wfConfig WHERE name = 'whitelistedServices'
WordPress database error: [Table 'jeromekj_wp.Qlnvm03_wfConfig' doesn't exist] SELECT name, val, autoload FROM Qlnvm03_wfConfig WHERE name = 'howGetIPs'
WordPress database error: [Table 'jeromekj_wp.Qlnvm03_wfConfig' doesn't exist] SELECT name, val, autoload FROM Qlnvm03_wfConfig WHERE name = 'howGetIPs_trusted_proxies'
WordPress database error: [Table 'jeromekj_wp.Qlnvm03_wfConfig' doesn't exist] SELECT name, val, autoload FROM Qlnvm03_wfConfig WHERE name = 'detectProxyRecommendation'
WordPress database error: [Table 'jeromekj_wp.Qlnvm03_wfConfig' doesn't exist] SELECT name, val, autoload FROM Qlnvm03_wfConfig WHERE name = 'other_WFNet'
WordPress database error: [Table 'jeromekj_wp.Qlnvm03_wfConfig' doesn't exist] SELECT name, val, autoload FROM Qlnvm03_wfConfig WHERE name = 'serverIP'
WordPress database error: [Table 'jeromekj_wp.Qlnvm03_wfConfig' doesn't exist] SELECT name, val, autoload FROM Qlnvm03_wfConfig WHERE name = 'serverDNS'
WordPress database error: [Table 'jeromekj_wp.Qlnvm03_wfConfig' doesn't exist] INSERT INTO Qlnvm03_wfConfig (name, val, autoload) values ('serverDNS', '1686105313;86400;77.68.30.237', 'yes') ON DUPLICATE KEY UPDATE val = '1686105313;86400;77.68.30.237', autoload = 'yes'
WordPress database error: [Table 'jeromekj_wp.Qlnvm03_wfConfig' doesn't exist] SELECT name, val, autoload FROM Qlnvm03_wfConfig WHERE name = 'blockCustomText'
WordPress database error: [Table 'jeromekj_wp.Qlnvm03_wfConfig' doesn't exist] SELECT name, val, autoload FROM Qlnvm03_wfConfig WHERE name = 'disableWAFIPBlocking'
WordPress database error: [Table 'jeromekj_wp.Qlnvm03_wfConfig' doesn't exist] SELECT name, val, autoload FROM Qlnvm03_wfConfig WHERE name = 'wordpressVersion'
WordPress database error: [Table 'jeromekj_wp.Qlnvm03_wfConfig' doesn't exist] select val from Qlnvm03_wfConfig where name='wordfence_chunked_wordpressPluginVersions_header'
WordPress database error: [Table 'jeromekj_wp.Qlnvm03_wfConfig' doesn't exist] select val from Qlnvm03_wfConfig where name='wordpressPluginVersions'
WordPress database error: [Table 'jeromekj_wp.Qlnvm03_wfConfig' doesn't exist] select val from Qlnvm03_wfConfig where name='wordfence_chunked_wordpressThemeVersions_header'
WordPress database error: [Table 'jeromekj_wp.Qlnvm03_wfConfig' doesn't exist] select val from Qlnvm03_wfConfig where name='wordpressThemeVersions'
WordPress database error: [Table 'jeromekj_wp.Qlnvm03_wfConfig' doesn't exist] SELECT name, val, autoload FROM Qlnvm03_wfConfig WHERE name = 'timeoffset_wf'
WordPress database error: [Table 'jeromekj_wp.Qlnvm03_wfConfig' doesn't exist] SELECT name, val, autoload FROM Qlnvm03_wfConfig WHERE name = 'firewallEnabled'
WordPress database error: [Table 'jeromekj_wp.Qlnvm03_wfls_settings' doesn't exist] SELECT `name`, `value`, `autoload` FROM `Qlnvm03_wfls_settings` WHERE `name` = 'enable-shortcode'
WordPress database error: [Table 'jeromekj_wp.Qlnvm03_wfConfig' doesn't exist] SELECT name, val, autoload FROM Qlnvm03_wfConfig WHERE name = 'other_hideWPVersion'
WordPress database error: [Table 'jeromekj_wp.Qlnvm03_wfLiveTrafficHuman' doesn't exist] SHOW FULL COLUMNS FROM `Qlnvm03_wfLiveTrafficHuman`
WordPress database error: [Table 'jeromekj_wp.Qlnvm03_wfLiveTrafficHuman' doesn't exist] SHOW FULL COLUMNS FROM `Qlnvm03_wfLiveTrafficHuman`
WordPress database error: [Table 'jeromekj_wp.Qlnvm03_wfConfig' doesn't exist] SELECT name, val, autoload FROM Qlnvm03_wfConfig WHERE name = 'loginSec_disableAuthorScan'
Warning: session_start(): Session cannot be started after headers have already been sent in /var/www/vhosts/jeromekjerome.com/httpdocs/wp-content/themes/enfold/config-templatebuilder/avia-shortcodes/masonry_entries/masonry_entries.php on line 112
Warning: session_start(): Session cannot be started after headers have already been sent in /var/www/vhosts/jeromekjerome.com/httpdocs/wp-content/themes/enfold/config-templatebuilder/avia-shortcodes/portfolio/portfolio.php on line 65
WordPress database error: [Table 'jeromekj_wp.Qlnvm03_wfConfig' doesn't exist] SELECT name, val, autoload FROM Qlnvm03_wfConfig WHERE name = 'liveTraf_ignoreIPs'
WordPress database error: [Table 'jeromekj_wp.Qlnvm03_wfConfig' doesn't exist] SELECT name, val, autoload FROM Qlnvm03_wfConfig WHERE name = 'liveTraf_ignoreUA'
WordPress database error: [Table 'jeromekj_wp.Qlnvm03_wfConfig' doesn't exist] SELECT name, val, autoload FROM Qlnvm03_wfConfig WHERE name = 'firewallEnabled'
30. The Passing of the Third Floor Back and Other Stories – The Jerome K Jerome Society
WordPress database error: [Table 'jeromekj_wp.Qlnvm03_wfConfig' doesn't exist] SELECT name, val, autoload FROM Qlnvm03_wfConfig WHERE name = 'other_hideWPVersion'
You are here:Home1/Bibliography2/Books3/30. The Passing of the Third Floor Back and Other Stories
*The Passing of the Third Floor Back and Other Stories. London, Hurst & Blackett, 1907.
?4 1-108. Pp. [8] 1 2-160.
Contents: [1-2] blank; [3] half-title: THE PASSING OF THE / THIRD FLOOR BACK; [4] Popular 3s. 6d. Books. [… list of 6 titles, beginning with The Second Thoughts of an Idle Fellow and Idle Ideas in 1905]; [5] title-page; [6] lower right, logo of the Chapel River Press, Kingston, Surrey; [7] CONTENTS.; [8] blank; 1 2-40 The Passing of the Third Floor Back; 41-72 The Philosopher’s Joke; 73-102 The Soul of Nicholas Snyders, or the Miser of Zandam; 103-28 Mrs. Korner Sins Her Mercies; 129-45 The Cost of Kindness; 146 blank; 147-60 The Love of Ulrich Nebendahl
Printed on wove paper, size 187 x 120mm., fore-edge and bottom edge uncut.
Inserted after the last gathering are 4 pages of Hurst and Blackett advertisements.
*Green cloth , lettered in light green on front and spine; spine: THE PASSING / OF THE / THIRD FLOOR / BACK / JEROME / HURST & BLACKETT
Listed in English Catalogue, May 1907, 2/6; reviewed in Times Literary Supplement, 24 May 1907, 166.
Copies seen: FR; APR (9).
*The Passing of the Third Floor Back and Other Stories. London, Hurst & Blackett, 1909.
?4 1-516. Pp. [8] 1 2-160.
Contents: as Hurst & Blackett 1907 edition, but the type has been reset.
Printed on wove paper, size 182 x 119mm.
Inserted after the last gathering are 4 pages of Hurst and Blackett advertisements.
*Red cloth, lettered in black on front and spine; spine: THE PASSING / OF THE / THIRD FLOOR / ·BACK· / JEROME / K. / JEROME / 1/- NET / HURST & / BLACKETT
Listed in English Catalogue, July 1909, 1/-.
Copies seen: FR; APR (5, including reprints).
The 1909 edition was reprinted without date on the title-page and omitting the price on the cover; also including advertisements for the play and the separately published single story The Passing of the Third Floor Back, both published in 1910.
Copies seen: APR (5)
The Passing of the Third Floor Back and Other Stories. Toronto, The Copp, Clark Company, Limited.
?4 1-516. Pp. [8] 1 2-160.
Contents: [1-2] blank; [3] half-title: THE PASSING OF THE / THIRD FLOOR BACK; [4] blank; [5] title-page; [6] Printed in Great Britain’; lower right, logo of the Chapel River Press, Kingston, Surrey; [7] CONTENTS.; [8] blank; 1 2-160 text.
Uses sheets of the Hurst & Blackett 1909 edition, except for changes in preliminaries.
Printed on wove paper, size 180 x 117mm., fore-edge uncut.
Red cloth, lettered in black as in the Hurst & Blackett 1909 edition except for omission of the price on front and spine and substitution of the Canadian publisher’s name at foot of spine: THE COPP, CLARK / COMPANY LIMITED
Copies seen: FR.
*The Passing of the Third Floor Back and Other Stories. London, Hurst & Blackett, [1927].
?4 1-148 154. Pp. [8] 1 2-232.
Contents: [1-2] blank; [3] half-title: THE PASSING OF THE THIRD FLOOR BACK; [4] By the same / author / “Three Men in a Boat,” / “Paul Kelver,” / etc. etc.; [5] title-page; [6] blank; [7] CONTENTS. / [short rule] / [8] blank; 1 2-232 text.
The text to page 160 uses the plates of the Hurst & Blackett 1909 edition, after which are three additional stories: 161-84 His Time Over Again; 185-209 The House of the Two Cedars; 210-32 House Hunting
Printed on wove paper, size 187 x 120mm.
*Green cloth, lettered in red on front and spine; spine: [rule] / THE / PASSING / OF THE / THIRD / FLOOR / BACK / JEROME K. / JEROME / HURST & / BLACKETT / [rule]
Copies seen: APR (1927; 1929 (2) undated, no catalogue (5); FR (1929).
The Passing of the Third Floor Back and Other Stories. Leipzig, Bernhard Tauchnitz, 1907.
18 2-158 164. Pp. 1-9 10-246 247-48. Stapled.
Contents: 1 half-title: COLLECTION / OF / BRITISH AUTHORS / TAUCHNITZ EDITION. / VOL. 3973. / THE PASSING OF THE THIRD FLOOR BACK. / BY / JEROME K. JEROME. / IN ONE VOLUME. ; 2 list of other Jerome titles in Tauchnitz editions; 3 title-page; 4 blank; 5 CONTENTS; 6 blank; 7 half-title; 8 blank; 9 10-246 text (each story has a half-title); 247 [rule] / PRINTING OFFICE OF THE PUBLISHER. / [rule]; 248 blank.
Printed on wove paper, size 152 x 111mm.
Buff paper cover, lettered in black.
Copies seen: FR; APR (3).
*Passing of the Third Floor Back. New York, Dodd, Mead & Company, 1908.
Unsigned, 1-128. Pp. i-iv v-vi 1 2-186.
Contents: i half-title: PASSING OF THE / THIRD FLOOR BACK; ii blank; iii title-page; iv COPYRIGHT, 1904, BY / JEROME K. JEROME / COPYRIGHT, 1908, BY / DODD, MEAD & COMPANY / Published, September, 1908; v CONTENTS; vi blank; 1-186 text
*Dark green cloth, lettered in white on front and spine; spine: [three blind-stamped rules] / PASSING OF / THE THIRD / FLOOR BACK / JEROME / [three blind-stamped rules] / DODD, MEAD / & COMPANY
Listed in Publisher’s Weekly 1920, 14 November 1908; American Catalog, 1908-10, $1.00.
Copies seen: FR; APR (1909).
Passing of the Third Floor Back. Toronto, Wm. Briggs, 1908.
Identical in every respect with the Dodd, Mead edition, above, except for substitution of the Canadian publisher’s name on the title-page and, at foot of spine: BRIGGS
Copies seen: FR; APR.
Passing of the Third Floor Back. New York, Grosset & Dunlap.
Unsigned, 1-208. Pp. [6] 1 2-186 [2] 7-123 124 [8].
Contents: [1] half-title: PASSING OF THE / THIRD FLOOR BACK; [2] blank; [3] title-page; [4] COPYRIGHT, 1904, BY / JEROME K. JEROME / COPYRIGHT, 1908, BY / DODD, MEAD & COMPANY / Published, September, 1908; [5] CONTENTS; [6] blank; 1 2-186 PASSING OF THE THIRD / FLOOR BACK; [1] half-title [gothic type face] Tea Table Talk / By / Jerome K. Jerome; [2] Copyright, 1902, / By JEROME K. JEROME. / Copyright, 1903, / By DODD, MEAD AND COMPANY. / [short rule] / Published, October, 1903.; 7-123 TEA-TABLE TALK / [short rule]; 124 blank; [1-2] list of other Grosset & Dunlap publications.
Text printed from the plates of the Dodd, Mead editions.
Printed on wove paper, size 188 x 128mm. Frontispiece, on plate paper, inserted facing title-page and plates facing Passing page 120 and Tea-Table Talk pages 8, 64.
Grey-green cloth, lettered in red on front and spine; spine [three dark green rules] / PASSING OF / THE THIRD / FLOOR BACK / JEROME / [three dark green rules] / GROSSET / & DUNLAP
Copies seen: FR; APR (2); University of California, Berkeley, Library, University of Miami Library (advertisements differ).
0replies
Leave a Reply
Want to join the discussion? Feel free to contribute!
We may request cookies to be set on your device. We use cookies to let us know when you visit our websites, how you interact with us, to enrich your user experience, and to customize your relationship with our website.
Click on the different category headings to find out more. You can also change some of your preferences. Note that blocking some types of cookies may impact your experience on our websites and the services we are able to offer.
Essential Website Cookies
These cookies are strictly necessary to provide you with services available through our website and to use some of its features.
Because these cookies are strictly necessary to deliver the website, refusing them will have impact how our site functions. You always can block or delete cookies by changing your browser settings and force blocking all cookies on this website. But this will always prompt you to accept/refuse cookies when revisiting our site.
We fully respect if you want to refuse cookies but to avoid asking you again and again kindly allow us to store a cookie for that. You are free to opt out any time or opt in for other cookies to get a better experience. If you refuse cookies we will remove all set cookies in our domain.
We provide you with a list of stored cookies on your computer in our domain so you can check what we stored. Due to security reasons we are not able to show or modify cookies from other domains. You can check these in your browser security settings.
Google Analytics Cookies
These cookies collect information that is used either in aggregate form to help us understand how our website is being used or how effective our marketing campaigns are, or to help us customize our website and application for you in order to enhance your experience.
If you do not want that we track your visit to our site you can disable tracking in your browser here:
Other external services
We also use different external services like Google Webfonts, Google Maps, and external Video providers. Since these providers may collect personal data like your IP address we allow you to block them here. Please be aware that this might heavily reduce the functionality and appearance of our site. Changes will take effect once you reload the page.
Google Webfont Settings:
Google Map Settings:
Google reCaptcha Settings:
Vimeo and Youtube video embeds:
Other cookies
The following cookies are also needed - You can choose if you want to allow them:
WordPress database error: [Table 'jeromekj_wp.Qlnvm03_wfConfig' doesn't exist] SELECT name, val, autoload FROM Qlnvm03_wfConfig WHERE name = 'liveTrafficEnabled'
WordPress database error: [Table 'jeromekj_wp.Qlnvm03_wfConfig' doesn't exist] SELECT name, val, autoload FROM Qlnvm03_wfConfig WHERE name = 'liveTraf_ignoreIPs'
WordPress database error: [Table 'jeromekj_wp.Qlnvm03_wfConfig' doesn't exist] SELECT name, val, autoload FROM Qlnvm03_wfConfig WHERE name = 'liveTraf_ignoreUA'
WordPress database error: [Table 'jeromekj_wp.Qlnvm03_wfBlocks7' doesn't exist] SELECT *, CASE
WHEN `type` = 3 THEN 0
WHEN `type` = 4 THEN 1
WHEN `type` = 7 THEN 2
WHEN `type` = 6 THEN 3
WHEN `type` = 5 THEN 4
WHEN `type` = 9 THEN 5
WHEN `type` = 8 THEN 6
WHEN `type` = 2 THEN 7
WHEN `type` = 1 THEN 8
ELSE 9999
END AS `typeSort`, CASE
WHEN `type` = 3 THEN `parameters`
WHEN `type` = 4 THEN `parameters`
WHEN `type` = 1 THEN `IP`
WHEN `type` = 9 THEN `IP`
WHEN `type` = 5 THEN `IP`
WHEN `type` = 6 THEN `IP`
WHEN `type` = 7 THEN `IP`
WHEN `type` = 2 THEN `IP`
WHEN `type` = 8 THEN `IP`
ELSE 9999
END AS `detailSort`
FROM `Qlnvm03_wfBlocks7` WHERE `type` IN (4) AND (`expiration` = 0 OR `expiration` > UNIX_TIMESTAMP()) ORDER BY `typeSort` ASC, `id` DESC
WordPress database error: [Table 'jeromekj_wp.Qlnvm03_wfBlocks7' doesn't exist] SELECT *, CASE
WHEN `type` = 3 THEN 0
WHEN `type` = 4 THEN 1
WHEN `type` = 7 THEN 2
WHEN `type` = 6 THEN 3
WHEN `type` = 5 THEN 4
WHEN `type` = 9 THEN 5
WHEN `type` = 8 THEN 6
WHEN `type` = 2 THEN 7
WHEN `type` = 1 THEN 8
ELSE 9999
END AS `typeSort`, CASE
WHEN `type` = 3 THEN `parameters`
WHEN `type` = 4 THEN `parameters`
WHEN `type` = 1 THEN `IP`
WHEN `type` = 9 THEN `IP`
WHEN `type` = 5 THEN `IP`
WHEN `type` = 6 THEN `IP`
WHEN `type` = 7 THEN `IP`
WHEN `type` = 2 THEN `IP`
WHEN `type` = 8 THEN `IP`
ELSE 9999
END AS `detailSort`
FROM `Qlnvm03_wfBlocks7` WHERE `type` IN (3) AND (`expiration` = 0 OR `expiration` > UNIX_TIMESTAMP()) ORDER BY `typeSort` ASC, `id` DESC
WordPress database error: [Table 'jeromekj_wp.Qlnvm03_wfConfig' doesn't exist] SELECT name, val, autoload FROM Qlnvm03_wfConfig WHERE name = 'cbl_action'
WordPress database error: [Table 'jeromekj_wp.Qlnvm03_wfConfig' doesn't exist] SELECT name, val, autoload FROM Qlnvm03_wfConfig WHERE name = 'cbl_loggedInBlocked'
WordPress database error: [Table 'jeromekj_wp.Qlnvm03_wfConfig' doesn't exist] SELECT name, val, autoload FROM Qlnvm03_wfConfig WHERE name = 'cbl_bypassRedirURL'
WordPress database error: [Table 'jeromekj_wp.Qlnvm03_wfConfig' doesn't exist] SELECT name, val, autoload FROM Qlnvm03_wfConfig WHERE name = 'cbl_bypassRedirDest'
WordPress database error: [Table 'jeromekj_wp.Qlnvm03_wfConfig' doesn't exist] SELECT name, val, autoload FROM Qlnvm03_wfConfig WHERE name = 'cbl_bypassViewURL'
WordPress database error: [Table 'jeromekj_wp.Qlnvm03_wfConfig' doesn't exist] SELECT name, val, autoload FROM Qlnvm03_wfConfig WHERE name = 'cbl_redirURL'
WordPress database error: [Table 'jeromekj_wp.Qlnvm03_wfConfig' doesn't exist] SELECT name, val, autoload FROM Qlnvm03_wfConfig WHERE name = 'cbl_cookieVal'
WordPress database error: [Table 'jeromekj_wp.Qlnvm03_wfConfig' doesn't exist] INSERT INTO Qlnvm03_wfConfig (name, val, autoload) values ('cbl_cookieVal', '647fece1f2428', 'yes') ON DUPLICATE KEY UPDATE val = '647fece1f2428', autoload = 'yes'
WordPress database error: [Table 'jeromekj_wp.Qlnvm03_wfConfig' doesn't exist] SELECT name, val, autoload FROM Qlnvm03_wfConfig WHERE name = 'blockedTime'
WordPress database error: [Table 'jeromekj_wp.Qlnvm03_wfBlocks7' doesn't exist] SELECT *, CASE
WHEN `type` = 3 THEN 0
WHEN `type` = 4 THEN 1
WHEN `type` = 7 THEN 2
WHEN `type` = 6 THEN 3
WHEN `type` = 5 THEN 4
WHEN `type` = 9 THEN 5
WHEN `type` = 8 THEN 6
WHEN `type` = 2 THEN 7
WHEN `type` = 1 THEN 8
ELSE 9999
END AS `typeSort`, CASE
WHEN `type` = 3 THEN `parameters`
WHEN `type` = 4 THEN `parameters`
WHEN `type` = 1 THEN `IP`
WHEN `type` = 9 THEN `IP`
WHEN `type` = 5 THEN `IP`
WHEN `type` = 6 THEN `IP`
WHEN `type` = 7 THEN `IP`
WHEN `type` = 2 THEN `IP`
WHEN `type` = 8 THEN `IP`
ELSE 9999
END AS `detailSort`
FROM `Qlnvm03_wfBlocks7` WHERE `type` IN (1, 8, 9, 2, 5, 6) AND (`expiration` = 0 OR `expiration` > UNIX_TIMESTAMP()) ORDER BY `typeSort` ASC, `id` DESC
WordPress database error: [Table 'jeromekj_wp.Qlnvm03_wfBlocks7' doesn't exist] SELECT *, CASE
WHEN `type` = 3 THEN 0
WHEN `type` = 4 THEN 1
WHEN `type` = 7 THEN 2
WHEN `type` = 6 THEN 3
WHEN `type` = 5 THEN 4
WHEN `type` = 9 THEN 5
WHEN `type` = 8 THEN 6
WHEN `type` = 2 THEN 7
WHEN `type` = 1 THEN 8
ELSE 9999
END AS `typeSort`, CASE
WHEN `type` = 3 THEN `parameters`
WHEN `type` = 4 THEN `parameters`
WHEN `type` = 1 THEN `IP`
WHEN `type` = 9 THEN `IP`
WHEN `type` = 5 THEN `IP`
WHEN `type` = 6 THEN `IP`
WHEN `type` = 7 THEN `IP`
WHEN `type` = 2 THEN `IP`
WHEN `type` = 8 THEN `IP`
ELSE 9999
END AS `detailSort`
FROM `Qlnvm03_wfBlocks7` WHERE `type` IN (7) AND (`expiration` = 0 OR `expiration` > UNIX_TIMESTAMP()) ORDER BY `typeSort` ASC, `id` DESC
WordPress database error: [Table 'jeromekj_wp.Qlnvm03_wfConfig' doesn't exist] SELECT name, val, autoload FROM Qlnvm03_wfConfig WHERE name = 'loginSec_lockoutMins'
WordPress database error: [Table 'jeromekj_wp.Qlnvm03_wfConfig' doesn't exist] SELECT name, val, autoload FROM Qlnvm03_wfConfig WHERE name = 'firewallEnabled'
WordPress database error: [Table 'jeromekj_wp.Qlnvm03_wfConfig' doesn't exist] SELECT name, val, autoload FROM Qlnvm03_wfConfig WHERE name = 'disableWAFIPBlocking'
Leave a Reply
Want to join the discussion?Feel free to contribute!