Database

$lc_query = '(SELECT SQL_CALC_FOUND_ROWS ' . substr($pc_query, 6) . ') LIMIT ' . (($ln_page - 1) * $ln_pagesize) . ', ' . $ln_pagesize; // This wipes out the parameters!

//PDOClass: Make a Default Connection
$cmd_sp = $PDOClass->QUERY($lc_query);
if ($b_mfgName) $cmd_sp->bindParam(':mfgName', $lc_mfg, PDO::PARAM_STR);                
if ($b_deptID) $cmd_sp->bindParam(':deptID', $pn_dept_id, PDO::PARAM_INT);
if ($b_partnerID) $cmd_sp->bindParam(':partnerID', $go_sitedict['partner_id'], PDO::PARAM_INT);

$SPClass = new SPClass(
  $cmd_sp, 
  $cmd_sp_mfg, 
  FALSE, 
  '', 
  $ll_debug
);

// So how to we wrap this around the query that we already sent to PDO?
$lc_query = '(SELECT SQL_CALC_FOUND_ROWS ' . substr($pc_query, 6) . ') LIMIT ' . (($ln_page - 1) * $ln_pagesize) . ', ' . $ln_pagesize; // This wipes out the parameters!
            
try {           
     // PDOClass: Execute the PDO that was passed in
     $cmd_showProduct->execute();
                
}

SELECT DISTINCT p.prod_id, p.model, p.showpricing, p.image_file, p.image_width, p.image_height, p.image_border, p.name, m.manufacturer,
  CASE WHEN sp.price IS NULL THEN 0 ELSE sp.price END AS list_price, 
  CASE WHEN sp.price IS NULL OR ssp.discount IS NULL THEN 0 ELSE sp.price - ssp.discount END AS sale_price, 
  CASE WHEN NOW() BETWEEN p.mfgrebatestart AND p.mfgrebateend THEN p.mfgrebate ELSE 0 END AS mfgrebate 
  
  FROM comm_product p, comm_manufacturer m
  
  INNER JOIN comm_dept_prod dp ON p.prod_id = dp.prod_id
  INNER JOIN comm_partners_products pa ON p.prod_id = pa.prod_id 
  LEFT JOIN comm_sku_price sp ON p.default_sku_id = sp.sku_id AND NOW() 
  
  BETWEEN sp.date_start AND sp.date_end 
  LEFT JOIN comm_sku_sale_price ssp ON p.default_sku_id = ssp.sku_id AND NOW() 
  BETWEEN ssp.date_start AND ssp.date_end 
  
  WHERE pa.p_id = :partnerID 
  AND p.mfg_id = m.mfg_id 
  AND p.avail_type < 3 AND p.image_file > '' 
  AND p.model NOT LIKE 'EBAY-%' 
  AND p.dept_ad = 1 
  AND dp.dept_id = :deptID 
  
  ORDER BY rand() LIMIT 4

table comm_product
`prod_id`, `model`, `name`, `list_order`, 
`image_file`, `image_width`, `image_height`, `image_border`, 
`big_image_file`, `big_image_width`, `big_image_height`, `big_image_border`, 
`feature_image_file`, `mfgrebate`, `mfgrebatestart`, `mfgrebateend`, 
`taxable`, `comp_name`, `comp_price`, `item_desc`, 
`attr_label1`, `attr_label2`, `attr_label3`, `attr_label4`, 
'attr_label5`, `special_note`, `manager_note`, `page_id`, 
`pdf_file`, `edittrack`, `date_created`, `time_created`, 
`user_created`, `date_edited`, `user_edited`, `mfg_id`, 
`condition`, `mfgrebatepost`, `mfgrebatefile`, `mfgrebatetype`, 
`default_sku_id`, `preselect_default_sku`, `clean_pdf`, `avail_type`, 
`showpricing`, `free_shipping`, `window_title`, `meta_description`, 
`meta_keywords`, `page_header`, `dept_ad`, `seoname`, 
`feed_title`, `feed_upc`, `feed_product_type`