JavaScript
/*
SELECT VIEW_DEFINITION FROM INFORMATION_SCHEMA.VIEWS WHERE `TABLE_SCHEMA`='oodles_technologies' AND `TABLE_NAME` = 'simple_search_custom_blogs_tag_relation'
SELECT GROUP_CONCAT(`COLUMN_NAME`) FROM `INFORMATION_SCHEMA`.`COLUMNS` WHERE `TABLE_SCHEMA`='oodles_technologies' AND `TABLE_NAME`='custom_blogs_tag_relation'
*/
/* simple_search_custom_portfolio
SELECT '5.3427835' AS `_score`,'doc' AS `_type`,'custom_portfolio' AS `_index`, JSON_OBJECT('canonical_url',canonical_url,'client_id',client_id,'current_status',current_status,'google_play_url',google_play_url,'id',id,'itunes_url',itunes_url,'keywords',keywords,'logo_url',logo_url,'micro_site',micro_site,'our_solution',our_solution,'post_content',post_content,'post_date',post_date,'post_name',post_name,'post_status',post_status,'post_title',post_title,'project_images',project_images,'project_type',project_type,'project_url',project_url,'s3foldername',s3foldername,'scope_of_work',scope_of_work,'tags',tags,'team_id',team_id,'type',type,'website_url',website_url) as _source FROM `custom_portfolio`;
SELECT JSON_OBJECT('_index',_index,'_type',_type,'_score',_score,'_source',_source) FROM `simple_search_custom_portfolio`;
SET SESSION group_concat_max_len = @@max_allowed_packet
SELECT concat( '[',GROUP_CONCAT( JSON_OBJECT('_index',_index,'_type',_type,'_score',_score,'_source',_source)),']') FROM `simple_search_custom_portfolio` limit 10
SELECT COUNT(*), concat( '[',GROUP_CONCAT( JSON_OBJECT('_index',_index,'_type',_type,'_score',_score,'_source',_source)),']') hits FROM `simple_search_custom_portfolio` LIMIT 5
SET global group_concat_max_len=15000;
SELECT * FROM (
SELECT concat( '[',GROUP_CONCAT(JSON_OBJECT('_index',_index,'_type',_type,'_score',_score,'_source',_source)),']') js FROM `simple_search_custom_portfolio` limit 4) AS some_name
SELECT count(js),concat( '[',GROUP_CONCAT(js),']') AS Hits FROM ( SELECT JSON_OBJECT('_index',_index,'_type',_type,'_score',_score,'_source',_source) js FROM...