{"type":"rich","version":"1.0","provider_name":"phorkie","provider_url":"https:\/\/p.cweiske.de\/","title":"TYPO3: read category names of a page","author_name":"Christian Weiske","cache_age":86400,"width":900,"height":900,"html":"<!-- embedding all files of https:\/\/p.cweiske.de\/284 -->\n<link rel=\"stylesheet\" href=\"https:\/\/p.cweiske.de\/css\/embed.css\"\/>\n<div class=\"phork\" id=\"284\">\n    <div class=\"phork-file\">\n <div class=\"phork-content\">\n  <style type=\"text\/css\">\/**\n * GeSHi (C) 2004 - 2007 Nigel McNie, 2007 - 2008 Benny Baumann\n * (http:\/\/qbnz.com\/highlighter\/ and http:\/\/geshi.org\/)\n *\/\n.typoscript .de1, .typoscript .de2 {font: normal normal 1em\/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;}\n.typoscript  {font-family:monospace;}\n.typoscript .imp {font-weight: bold; color: red;}\n.typoscript li, .typoscript .li1 {color: #DDD;}\n.typoscript .ln {width:1px;text-align:right;margin:0;padding:0 2px;vertical-align:top;}\n.typoscript .kw1 {color: #ed7d14;}\n.typoscript .kw2 {font-weight: bold;}\n.typoscript .kw3 {color: #990000; font-weight: bold;}\n.typoscript .kw4 {color: #990000; font-weight: bold;}\n.typoscript .kw5 {color: #990000; font-weight: bold;}\n.typoscript .kw6 {color: #990000; font-weight: bold;}\n.typoscript .kw7 {color: #990000; font-weight: bold;}\n.typoscript .kw8 {font-weight: bold;}\n.typoscript .kw9 {color: #990000; font-weight: bold;}\n.typoscript .co1 {color: #aaa; font-style: italic;}\n.typoscript .co2 {color: #aaa; font-style: italic;}\n.typoscript .coMULTI {color: #aaa; font-style: italic;}\n.typoscript .br0 {color: #009900;}\n.typoscript .sy0 {color: #339933; font-weight: bold;}\n.typoscript .sy1 {color: #009900; font-weight: bold;}\n.typoscript .st0 {color: #ac14aa;}\n.typoscript .nu0 {color: #cc0000;}\n.typoscript .me1 {color: #0000e0; font-weight: bold;}\n.typoscript .me2 {color: #0000e0; font-weight: bold;}\n.typoscript .re0 {color: #009900;}\n.typoscript .re1 {color: #009900; font-weight: bold;}\n.typoscript .re2 {color: #3366CC;}\n.typoscript .re3 {color: #000066; font-weight: bold;}\n.typoscript .re4 {color: #ed7d14;}\n.typoscript .re5 {color: #000066; font-weight: bold;}\n.typoscript .re6 {color: #009900;}\n.typoscript .re7 {color: #3366CC;}\n.typoscript span.xtra { display:block; }\n<\/style><div class=\"code\"><table class=\"typoscript\"><tbody><tr class=\"li1\"><td class=\"ln\"><pre class=\"de1\">1\n2\n3\n4\n5\n6\n7\n8\n9\n10\n11\n<\/pre><\/td><td class=\"de1\"><pre class=\"de1\">&#160; &#160; table <span class=\"sy0\">=<\/span> sys_category\n&#160; &#160; <a href=\"http:\/\/documentation.typo3.org\/documentation\/tsref\/functions\/select\/\"><span class=\"kw2\">select<\/span><\/a> <span class=\"br0\">&#123;<\/span>\n&#160; &#160; &#160; &#160; languageField <span class=\"sy0\">=<\/span> sys_language_uid\n&#160; &#160; &#160; &#160; pidInList <span class=\"sy0\">=<\/span> <span class=\"nu0\">222<\/span>\n&#160; &#160; &#160; &#160; selectFields <span class=\"sy0\">=<\/span> LOWER<span class=\"br0\">&#40;<\/span>sys_category<span class=\"sy0\">.<\/span>title<span class=\"br0\">&#41;<\/span> as aTitle\n&#160; &#160; &#160; &#160; join <span class=\"sy0\">=<\/span> sys_category_record_mm ON sys_category<span class=\"sy0\">.<\/span>uid <span class=\"sy0\">=<\/span> sys_category_record_mm<span class=\"sy0\">.<\/span>uid_local\n&#160; &#160; &#160; &#160; where <span class=\"sy0\">=<\/span> sys_category_record_mm<span class=\"sy0\">.<\/span>tablenames <span class=\"sy0\">=<\/span> 'pages'\n&#160; &#160; &#160; &#160; andWhere<span class=\"sy0\">.<\/span>data <span class=\"sy0\">=<\/span> <span class=\"re5\">page<\/span><span class=\"sy0\">:<\/span>uid\n&#160; &#160; &#160; &#160; andWhere<span class=\"sy0\">.<\/span>wrap <span class=\"sy0\">=<\/span> sys_category_record_mm<span class=\"sy0\">.<\/span>uid_foreign IN <span class=\"br0\">&#40;<\/span><span class=\"sy0\">|<\/span><span class=\"br0\">&#41;<\/span>\n&#160; &#160; <span class=\"br0\">&#125;<\/span>\n&#160;<\/pre><\/td><\/tr><\/tbody><\/table><\/div>\n <\/div>\n <div class=\"phork-meta\">\n  <a href=\"https:\/\/p.cweiske.de\/284\/rev-raw\/138064bb7102ec5c58c1dfdd661e3d863103b463\/typoscript.ts\" style=\"float: right\">view raw source<\/a>\n  <a href=\"https:\/\/p.cweiske.de\/284#typoscript.ts\">typoscript.ts<\/a>\n <\/div>\n<\/div>\n<\/div>\n"}