Skip to main content

GROUP_CONCAT(cat.name ORDER BY cat.term_id SEPARATOR

select p.id as pid,p.post_title,p.post_content,GROUP_CONCAT(cat.name ORDER BY cat.term_id SEPARATOR
',') as catname,cat.slug as catslug from wp_posts as p left join wp_term_relationships as r on  p.id =
r.object_id  left join wp_term_taxonomy as t on r.term_taxonomy_id = t.term_taxonomy_id left join
wp_terms as cat on t.term_id = cat.term_id where id in (select id from wp_posts) GROUP BY pid ORDER BY
pid desc limit 0,10

Comments

Post a Comment

Popular posts from this blog

Reading Large JSON file through PHP Script

 <?php /* cat mexico.geojson | wc sed ':a;N;$!ba;s/\n/ /g' mexico.geojson  > mexico.geojson_out1 cat mexico.geojson_out1 | wc http://localhost/Utility/cord/largefile.php?filename=mexico.geojson_out1 sed -E 's/\{ "type": "FeatureCollection", "name": "mexico_administrative_osm_province_boundaries", "crs": \{ "type": "name", "properties": \{ "name": "urn:ogc:def:crs:OGC:1.3:CRS84" \} \}, "features": \[//g' ./mexico.geojson_out1  > mexico.geojson_out2 http://localhost/Utility/cord/largefile.php?filename=mexico.geojson_out2 sed -E 's/(\[|\{|\}|\])/ \1 /g' ./mexico.geojson_out2 > ./output/mexico.geojson_output http://localhost/Utility/cord/largefile.php?filename=output/mexico.geojson_output */ ini_set('max_execution_time', '500'); //300 seconds = 5 minutes ini_set('memory_limit', '1G');   //ini_set('max_execution...
Post a Comment
Read more

Javascript Generator as promise

     function* makeIterator(data) {       for(i in data){                 yield data[i];         }     }         function runPull() {         var obj = it.next();         var val;         console.log("RunPull Clicked",obj);         if(!obj.done) {             val = obj.value;             val.click();             setTimeout(function(){                 runPull();             },200);         }     }     ru...
Post a Comment
Read more