trucking and transportation companies.

SELECT
city.id,
city.name,
city.province_id
FROM
city as city
WHERE
city.id = 2299
LIMIT 1

SELECT
prov.id,
prov.name,
prov.city_id,
prov.country_id,
prov.shortname,
prov.url_id
FROM
province as prov
LIMIT 1

SELECT
cat.id,
cat.parent_id,
cat.name,
cat.longname,
cat.status,
cat.ordering,
cat.type,
cat.keywords,
cat.url,
cat.title,
cat.description,
cat.h1,
cat.firsttext,
cat.comment,
cat.endcomment,
cat.bottomtext,
cat.lasttext,
cat.profilelink,
cat.url_id
FROM
category as cat
WHERE
cat.id = 1699
LIMIT 1

SELECT
com.id as id,
com.name as name,
com.city_id as city_id,
com.country_id as country_id,
com.status as status,
com.added as added,
com.modified as modified,
com.url_id as url_id,
com.postalcode as postalcode,
com.street as street,
com.email as email,
com.phone as phone,
com.fax as fax,
com.web as web,
com.description as description,
com.canada as canada,
com.united_states as united_states,
com.mexico as mexico,
com.worldwide as worldwide,
com.servicearea as servicearea,
com.branches as branches,
com.trailers as trailers,
com.tractors as tractors,
com.vans as vans,
com.trucks as trucks,
com.empl as empl,
com.yofe as yofe,
com.iso as iso,
com.specs as specs
FROM
category_to_company as ref,
category as cat,
company as com
WHERE
ref.category_id = 1699
AND cat.id=ref.category_id
AND cat.id = 1699
AND com.id=ref.company_id
AND com.city_id = 2299
AND com.status = '0' 
LIMIT 1000