The tag has no wiki summary.

learn more… | top users | synonyms

3
votes
2answers
188 views

How to find the source of awful queries generated by EE

One of our sites has been really suffering and our ISP pointed out that we needed to optimize our templates because we were generating some really slow queries. For example this: SELECT ...
3
votes
1answer
125 views

SQL Query Help Needed

During a migration from 1x to 2x on an EE site, I needed to switch to current Google Maps add-ons and chose MX Google Maps (for now anyway). The site was using a geotagger that filled a Latitude field ...
3
votes
1answer
92 views

QUERY join for members that have entries

I'm trying to learn how to do mysql joins. Twitter has helped already get me started. I'm trying to find the number of members that have entries attached to them... Then the number of members that ...
3
votes
1answer
122 views

Direct access to exp_store_stock exp_store_stock_options tables via Expresso Store tags?

I was wondering if any tags in Expresso Store just give you direct access to the exp_store_stock and exp_store_stock_options tables. What I want to do, when I display a store item, is filter the ...
3
votes
1answer
84 views

How to Batch Update Channel Preferences?

I inherited a site with a zillion channels, and every channel has "Automatically Convert URLs to Links?" set to "yes". Is there a query I can use to update the preferences for all of these channels ...