jsk

Custom SQL query returning 1 row (hide)

select id, screen_name, name, description, location, url, protected, followers_count, friends_count, listed_count, created_at, favourites_count, utc_offset, time_zone, geo_enabled, verified, statuses_count, lang, contributors_enabled, is_translator, is_translation_enabled, profile_background_color, profile_background_image_url, profile_background_image_url_https, profile_background_tile, profile_image_url, profile_image_url_https, profile_banner_url, profile_link_color, profile_sidebar_border_color, profile_sidebar_fill_color, profile_text_color, profile_use_background_image, has_extended_profile, default_profile, default_profile_image, following, follow_request_sent, notifications, translator_type from users where "profile_background_image_url_https" = :p0 and "profile_link_color" = :p1 order by id limit 101

Query parameters

This data as json, CSV

id	screen_name	name	description	location	url	protected	followers_count	friends_count	listed_count	created_at	favourites_count	utc_offset	time_zone	geo_enabled	verified	statuses_count	lang	contributors_enabled	is_translator	is_translation_enabled	profile_background_color	profile_background_image_url	profile_background_image_url_https	profile_background_tile	profile_image_url	profile_image_url_https	profile_banner_url	profile_link_color	profile_sidebar_border_color	profile_sidebar_fill_color	profile_text_color	profile_use_background_image	has_extended_profile	default_profile	default_profile_image	following	follow_request_sent	notifications	translator_type
500219903	CReporting	Compu Reporting	Computational Reporting. All about Data Mining	US	http://computationalreporting.com	0	59	57	11	2012-02-22T22:40:11+00:00	0			1	0	147		0	0	0	FFFFFF	http://abs.twimg.com/images/themes/theme14/bg.gif	https://abs.twimg.com/images/themes/theme14/bg.gif	0	http://pbs.twimg.com/profile_images/1872022267/logocr_normal.gif	https://pbs.twimg.com/profile_images/1872022267/logocr_normal.gif		F91717	DFD5A7	FF6600	535252	0	0	0	0	0	0	0	none