SELECT vi.*, item_finish_name, p.product_description, p.item_id,
   item_desc, p.item_brand_id, item_brand_name, p.item_model_id,
   item_model_name, vip.vendor_item_price_id, vip.vendor_item_price,
   vip.vendor_item_price_date, name, company_name
  FROM pjm_vendor_item AS vi
  JOIN pjm_product AS p USING (product_id)
  JOIN pjm_person AS v USING (person_id)
  JOIN pjm_company AS c USING (company_id)
  JOIN pjm_item AS i USING (item_id)
  JOIN pjm_item_brand AS itb USING (item_brand_id)
  JOIN pjm_item_model AS itm USING (item_model_id)
  JOIN pjm_item_finish AS itf USING (item_finish_id)
  JOIN (
    SELECT vendor_item_id,MAX(vendor_item_price_date) AS vendor_item_price_date FROM pjm_vendor_item_price GROUP BY vendor_item_id
  ) AS vip_date USING (vendor_item_id)
  JOIN pjm_vendor_item_price AS vip USING (vendor_item_id, vendor_item_price_date)
  LEFT JOIN pjm_action_log AS submit ON (
		    submit.column_name = 'vendor_item_id' AND
		    submit.key_id = vi.vendor_item_id AND
		    submit.action_id = 75
		 )
  WHERE (
    vi.vendor_item_status = 'vendor_item_active'
  )
  GROUP BY vendor_item_id
  ORDER BY item_desc, item_brand_name, item_model_name, item_finish_name, vendor_item_price
  LIMIT 0,100