SHARE
TWEET

dump

a guest Mar 13th, 2013 22 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. Method: prev
  2.  
  3. This entry ID: 144190
  4.  
  5. Prelim SQL: SELECT entry_id FROM exp_channel_titles WHERE channel_id IN ( 016) ORDER BY entry_date desc LIMIT 999
  6.  
  7. Raw results: 147845|147844|147843|147842|147841|147840|147839|147838|147837|147836|147835|147834|147833|147832|147831|147830|147829|147828|147827|147826|147825|147824|147823|147822|147821|147820|147819|147818|147817|147816|147815|147814|147813|147812|147811|147810|147809|147808|147807|147806|147805|147804|147803|147802|147801|147800|147799|147798|147797|147796|147795|147794|147793|147792|147791|147790|147789|147788|147787|147786|147785|147784|147783|147782|147781|147780|147779|147778|147777|147776|147775|147774|147773|147772|147771|147770|147769|147768|147767|147766|147765|147764|147763|147762|147761|147760|147759|147758|147757|147756|147755|147754|147753|147752|147751|147750|147749|147748|147747|147746|147745|147744|147743|147742|147741|147740|147739|147738|147737|147736|147735|147734|147733|147732|147731|147730|147729|147728|147727|147726|147725|147724|147723|147722|147721|147720|147719|147718|147717|147716|147715|147714|147713|147712|147711|147710|147709|147708|147707|147706|147705|147704|147703|147702|147701|147700|147699|147698|147697|147696|147695|147694|147693|147692|147691|147690|147689|147688|147687|147686|147685|147684|147683|147682|147681|147680|147679|147678|147677|147676|147675|147674|147673|147672|147671|147670|147669|147668|147667|147666|147665|147664|147663|147662|147661|147660|147659|147658|147657|147656|147655|147654|147653|147652|147651|147650|147649|147648|147647|147646|147645|147644|147643|147642|147641|147640|147639|147638|147637|147636|147635|147634|147633|147632|147631|147630|147629|147628|147627|147626|147625|147624|147623|147622|147621|147620|147619|147618|147617|147616|147615|147614|147613|147612|147611|147610|147609|147608|147607|147606|147605|147604|147603|147602|147601|147600|147599|147598|147597|147596|147595|147594|147593|147592|147591|147590|147589|147588|147587|147586|147585|147584|147583|147582|147581|147580|147579|147578|147577|147576|147575|147574|147573|147572|147571|147570|147569|147568|147567|147566|147565|147564|147563|147562|147561|147560|147559|147558|147557|147556|147555|147554|147553|147552|147551|147550|147549|147548|147547|147546|147545|147544|147543|147542|147541|147540|147539|147538|147537|147536|147535|147534|147533|147532|147531|147530|147529|147528|147527|147526|147525|147524|147523|147522|147521|147520|147519|147518|147517|147516|147515|147514|147513|147512|147511|147510|147509|147508|147507|147506|147505|147504|147503|147502|147501|147500|147499|147498|147497|147496|147495|147494|147493|147492|147491|147490|147489|147488|147487|147486|147485|147484|147483|147482|147481|147480|147479|147478|147477|147476|147475|147474|147473|147472|147471|147470|147469|147468|147467|147466|147465|147464|147463|147462|147461|147460|147459|147458|147457|147456|147455|147454|147453|147452|147451|147450|147449|147448|147447|147446|147445|147444|147443|147442|147441|147440|147439|147438|147437|147436|147435|147434|147433|147432|147431|147430|147429|147428|147427|147426|147425|147424|147423|147422|147421|147420|147419|147418|147417|147416|147415|147414|147413|147412|147411|147410|147409|147408|147407|147406|147405|147404|147403|147402|147401|147400|147399|147398|147397|147396|147395|147394|147393|147392|147391|147390|147389|147388|147387|147386|147385|147384|147383|147382|147381|147380|147379|147378|147377|147376|147375|147374|147373|147372|147371|147370|147369|147368|147367|147366|147365|147364|147363|147362|147361|147360|147359|147358|147357|147356|147355|147354|147353|147352|147351|147350|147349|147348|147347|147346|147345|147344|147343|147342|147341|147340|147339|147338|147337|147336|147335|147334|147333|147332|147331|147330|147329|147328|147327|147326|147325|147324|147323|147322|147321|147320|147319|147318|147317|147316|147315|147314|147313|147312|147311|147310|147309|147308|147307|147306|147305|147304|147303|147302|147301|147300|147299|147298|147297|147296|147295|147294|147293|147292|147291|147290|147289|147288|147287|147286|147285|147284|147283|147282|147281|147280|147279|147278|147277|147276|147275|147274|147273|147272|147271|147270|147269|147268|147267|147266|147265|147264|147263|147262|147261|147260|147259|147258|147257|147256|147255|147254|147253|147252|147251|147250|147249|147248|147247|147246|147245|147244|147243|147242|147241|147240|147239|147238|147237|147236|147235|147234|147233|147232|147231|147230|147229|147228|147227|147226|147225|147224|147223|147222|147221|147220|147219|147218|147217|147216|147215|147214|147213|147212|147211|147210|147209|147208|147207|147206|147205|147204|147203|147202|147201|147200|147199|147198|147197|147196|147195|147194|147193|147192|147191|147190|147189|147188|147187|147186|147185|147184|147183|147182|147181|147180|147179|147178|147177|147176|147175|147174|147173|147172|147171|147170|147169|147168|147167|147166|147165|147164|147163|147162|147161|147160|147159|147158|147157|147156|147155|147154|147153|147152|147151|147150|147149|147148|147147|147146|147145|147144|147143|147142|147141|147140|147139|147138|147137|147136|147135|147134|147133|147132|147131|147130|147129|147128|147127|147126|147125|147124|147123|147122|147121|147120|147119|147118|147117|147116|147115|147114|147113|147112|147111|147110|147109|147108|147107|147106|147105|147104|147103|147102|147101|147100|147099|147098|147097|147096|147095|147094|147093|147092|147091|147090|147089|147088|147087|147086|147085|147084|147083|147082|147081|147080|147079|147078|147077|147076|147075|147074|147073|147072|147071|147070|147069|147068|147067|147066|147065|147064|147063|147062|147061|147060|147059|147058|147057|147056|147055|147054|147053|147052|147051|147050|147049|147048|147047|147046|147045|147044|147043|147042|147041|147040|147039|147038|147037|147036|147035|147034|147033|147032|147031|147030|147029|147028|147027|147026|147025|147024|147023|147022|147021|147020|147019|147018|147017|147016|147015|147014|147013|147012|147011|147010|147009|147008|147007|147006|147005|147004|147003|147002|147001|147000|146999|146998|146997|146996|146995|146994|146993|146992|146991|146990|146989|146988|146987|146986|146985|146984|146983|146982|146981|146980|146979|146978|146977|146976|146975|146974|146973|146972|146971|146970|146969|146968|146967|146966|146965|146964|146963|146962|146961|146960|146959|146958|146957|146956|146955|146954|146953|146952|146951|146950|146949|146948|146947|146946|146945|146944|146943|146942|146941|146940|146939|146938|146937|146936|146935|146934|146933|146932|146931|146930|146929|146928|146927|146926|146925|146924|146923|146922|146921|146920|146919|146918|146917|146916|146915|146914|146913|146912|146911|146910|146909|146908|146907|146906|146905|146904|146903|146902|146901|146900|146899|146898|146897|146896|146895|146894|146893|146892|146891|146890|146889|146888|146887|146886|146885|146884|146883|146882|146881|146880|146879|146878|146877|146876|146875|146874|146873|146872|146871|146870|146869|146868|146867|146866|146865|146864|146863|146862|146861|146860|146859|146858|146857|146856|146855|146854|146853|146852|146851|146850|146849|146848|146847
  8.  
  9. Limited SQL: SELECT t.entry_id, t.channel_id, t.forum_topic_id, t.author_id, t.ip_address, t.title, t.url_title, t.status, t.dst_enabled, t.view_count_one, t.view_count_two, t.view_count_three, t.view_count_four, t.allow_comments, t.comment_expiration_date, t.sticky, t.entry_date, t.year, t.month, t.day, t.edit_date, t.expiration_date, t.recent_comment_date, t.comment_total, t.site_id as entry_site_id, w.channel_title, w.channel_name, w.channel_url, w.comment_url, w.comment_moderate, w.channel_html_formatting, w.channel_allow_img_urls, w.channel_auto_link_urls, w.comment_system_enabled, m.username, m.email, m.url, m.screen_name, m.location, m.occupation, m.interests, m.aol_im, m.yahoo_im, m.msn_im, m.icq, m.signature, m.sig_img_filename, m.sig_img_width, m.sig_img_height, m.avatar_filename, m.avatar_width, m.avatar_height, m.photo_filename, m.photo_width, m.photo_height, m.group_id, m.member_id, m.bday_d, m.bday_m, m.bday_y, m.bio, md.*, wd.* FROM exp_channel_titles     AS t LEFT JOIN exp_channels AS w ON t.channel_id = w.channel_id LEFT JOIN exp_channel_data     AS wd ON t.entry_id = wd.entry_id LEFT JOIN exp_members  AS m ON m.member_id = t.author_id LEFT JOIN exp_member_data    AS md ON md.member_id = m.member_id WHERE t.entry_id IN (147845) ORDER BY t.sticky desc, t.entry_date desc, t.entry_id desc
  10.  
  11. Limited Results: 147845
  12.  
  13. Limit Entries function's parameters:
  14.  
  15. Fields SQL: SELECT DISTINCT f.field_id, f.field_name FROM exp_channel_fields AS f, exp_channels AS c, exp_channel_titles AS e WHERE f.group_id = c.field_group AND c.channel_id = e.channel_id AND e.entry_id IN (147845) AND f.site_id = 1;
  16.  
  17. Final SQL: SELECT t.entry_id, t.channel_id, t.forum_topic_id, t.author_id, t.ip_address, t.title, t.url_title, t.status, t.dst_enabled, t.view_count_one, t.view_count_two, t.view_count_three, t.view_count_four, t.allow_comments, t.comment_expiration_date, t.sticky, t.entry_date, t.year, t.month, t.day, t.edit_date, t.expiration_date, t.recent_comment_date, t.comment_total, t.site_id as entry_site_id, w.channel_title, w.channel_name, w.channel_url, w.comment_url, w.comment_moderate, w.channel_html_formatting, w.channel_allow_img_urls, w.channel_auto_link_urls, w.comment_system_enabled, m.username, m.email, m.url, m.screen_name, m.location, m.occupation, m.interests, m.aol_im, m.yahoo_im, m.msn_im, m.icq, m.signature, m.sig_img_filename, m.sig_img_width, m.sig_img_height, m.avatar_filename, m.avatar_width, m.avatar_height, m.photo_filename, m.photo_width, m.photo_height, m.group_id, m.member_id, m.bday_d, m.bday_m, m.bday_y, m.bio, md.*, wd.* FROM exp_channel_titles       AS t LEFT JOIN exp_channels AS w ON t.channel_id = w.channel_id LEFT JOIN exp_channel_data     AS wd ON t.entry_id = wd.entry_id LEFT JOIN exp_members  AS m ON m.member_id = t.author_id LEFT JOIN exp_member_data    AS md ON md.member_id = m.member_id WHERE t.entry_id IN (147845) ORDER BY t.sticky desc, t.entry_date desc, t.entry_id desc
  18.  
  19. Method: next
  20.  
  21. This entry ID: 144190
  22.  
  23. Prelim SQL: SELECT entry_id FROM exp_channel_titles WHERE channel_id IN ( 016) ORDER BY entry_date desc LIMIT 999
  24.  
  25. Raw results:
  26.  
  27. Limited SQL:
  28.  
  29. Limited Results:
  30.  
  31. Limit Entries function's parameters:
  32.  
  33. Fields SQL:
  34.  
  35. Final SQL:
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!
 
Top