SQL Query Change

[Guest]

Hello, I'm new to PHP and OSCommerce. I'd like to make a change to the query (seemingly) generated by store_listing.php.

 

The query in my MySQL query log is:

 

select distinct sd.store_description, sd.store_name, sd.store_id

from store_main s, store_description sd, store_to_categories s2c

where s.store_id = sd.store_id and s.store_status = '1';

 

I looked in store_listing.php, and could not see any code blocks that would generate this query. Could someone point me in the correct general direction on how I might change this (and other) query?

 

Thanks in advance.

 

Chris