query
RESULTSET
query
  ACTIVE ARCHIVED AUSPOSTCOUNTRYNAME COMMISSION_AMOUNT COMMISSION_TYPE COUNTRYACTIVE COUNTRYCODE COUNTRYDESC COUNTRY_IMAGE COUNTRY_OF_ORIGIN COUNTRY_OF_ORIGIN_IMAGE CREATE_DATE CREATE_DATE DEMO_DOWNLOAD_FILENAME GOOGLE_FREQUENCY GOOGLE_INCLUDED_IN_SITEMAP GOOGLE_PRIORITY IMAGE INTERNALID MODIFY_DATE OLDID OLDID PRODACCESSORYITEM PRODACTIVE PRODAVAILABLEDATE PRODCODE PRODCREATIONDATE PRODDESCFULL PRODDESCFULL_SP PRODDESCSHORT PRODDESCSHORT_SP PRODDIMH PRODDIML PRODDIMW PRODDOWNLOADFILENAME PRODDOWNLOADFILENAME_FILESIZE PRODFEATURED PRODFLAG1 PRODFLAG2 PRODFLAG3 PRODFLAG4 PRODFLAG5 PRODMAINLINEITEM PRODMISC1 PRODMISC2 PRODOPTIONSALLOCATED PRODPRICE PRODPRICEID PRODPRICERETAIL PRODPRIMARYIMAGE PRODSELLOUTOFSTOCK PRODSOFTWARE PRODSTOCKCODE PRODSTOCKLEVEL PRODSTOCKLEVELTRACKED PRODSUPPLIERID PRODTAXID PRODTITLE PRODTITLE2 PRODTITLE2_ESP PRODTITLE2_SP PRODTITLE_ESP PRODTITLE_SP PRODUCT_TYPE PRODWEIGHT PROD_COUNTRYOFORIGIN PROD_KEYWORDS PROD_PARENT_ID PROD_PRIMARY_IMAGE_THUMB PROD_SPECIALNOTES RECURRING_FREQUENCY RECURRING_FREQUENCY_DISPLAY_OPTIONS RECURRING_FREQUENCY_DISPLAY_TEXT RECURRING_FREQUENCY_TOTAL RECURRING_PRICE RECURRING_SHIPPING_COST RECURRING_SHIPPING_METHOD RECURRING_START_DELAY SES_FILE_CREATE_DATE SES_FILE_MODIFY_DATE SES_FILE_NAME SES_FILE_PATH SES_FLAG SHIPPING_PER_BOX STOCKCODEDESC STOCKCODEID STOCKCODEIMAGE STOCKCODENOTES SUPPORTAIRBORNE SUPPORTAUSPOST SUPPORTCANADAPOST SUPPORTFEDEX SUPPORTUPS SUPPORTUSPS UOLT_ADDRVALIDATON UOLT_CURRENCYCODE UOLT_EUMEMBER UOLT_LANGUAGECODE UOLT_MAXINSUREDVALUE UOLT_MAXWEIGHT UOLT_POSTCODES UOLT_RATES UOLT_REGION UOLT_SECURITYELEMENTS UOLT_SHIPPING UOLT_SIGTRACKING UOLT_TNT UOLT_TRACK UOLT_WEIGHTUNIT USPSCOUNTRYNAME VENDORBLURB VENDORBLURB_SP VENDORCATID VENDORDESC VENDORDESC_SP VENDORDISPLAYPRIORITY VENDORID VENDORIMAGE VENDORSPOTLIGHT VENDOR_PASSWORD VENDOR_USERNAME VEN_GOOGLE_FREQUENCY VEN_GOOGLE_INCLUDED_IN_SITEMAP VEN_GOOGLE_PRIORITY VEN_SES_FILE_CREATE_DATE VEN_SES_FILE_MODIFY_DATE VEN_SES_FILE_NAME VEN_SES_FILE_PATH
CACHED false
EXECUTIONTIME 0
SQL SELECT * FROM product P LEFT JOIN stock_codes SC ON (P.prodStockCode = SC.StockCodeID) LEFT JOIN vendors V ON (P.prodSupplierID = V.vendorID) LEFT JOIN country_list CL ON (P.prod_countryoforigin = CL.countrycode) WHERE internalID = ? AND prodActive = 1
SQLPARAMETERS
array
1 3124