Where is product query located

[b5b4you]

I had asked before, but I believe i May have been overlooked due to my title of my post before.

So basically WHERE IS THE QUERY for this section/page located????

BIKE KITS : ChoppersCycle

I need to add a bike_app to the query, but Do not have ANY Idea where or how to find it, I have looked All over. this is the last part of the site that is not finished

I was able to find the query for other pages, and the on the Printable catalog page
Printable Catalog : ChoppersCycle

where it properly displays the "fitment text" below the "title of the part"

[michael_s]

Try includes/modules/product_listing.php

[b5b4you]

if looked up and down on that file.

Im looking for the way this item is listed in the product_listing file, the query for this is the one i need to add to

its using this to call the model number
$listing[$x]['products_model']



the piece i need to add is a call to the cell called bike_app, which is on the same table as the products_model above

But i cant find anything even remotely similar to a product query on the product_listing


I easily found the one for catalog_products_with_images, and added the piece easily

$products_query_raw = "select distinct p.products_id, p.products_image, p.products_model, p.products_quantity, p.products_weight, pd.products_name, p.manufacturers_id, IF(pg.customers_group_price IS NOT NULL, pg.customers_group_price, p.products_price) as products_price, p.products_date_added, IF(s.status = 1, s.specials_new_products_price, NULL) as final_price, m.manufacturers_name, pd.products_description, pd.bike_app, cd.categories_name, p.products_tax_class_id, p2c.categories_id from " . TABLE_PRODUCTS_DESCRIPTION . " pd left join " . TABLE_PRODUCTS_GROUPS . " pg on pg.products_id = pd.products_id and pg.customers_group_id = '" . $customers_group_id . "', " . TABLE_PRODUCTS . " p left join " . TABLE_MANUFACTURERS . " m on p.manufacturers_id = m.manufacturers_id left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id and s.customers_group_id = '" . $customers_group_id . "', " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c left join " . TABLE_CATEGORIES_DESCRIPTION . " cd on p2c.categories_id = cd.categories_id where p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '" . $languages_id . "' and cd.language_id = '" . $languages_id . "' order by $order";
$products_query = tep_db_query($products_query_raw);

[michael_s]

index.php has the base queries for products and categories. Then to display the data, you modify includes/modules/product_listing.php