| 3 | SELECT `Listing`.`id`, `Listing`.`user_id`, `Listing`.`desc`, `Listing`.`part_number`, `Listing`.`sku_number`, `Listing`.`buyer_pn`, `Listing`.`industry_pn`, `Listing`.`supplier_pn`, `Listing`.`supplier_sku`, `Listing`.`manufacturer_pn`, `Listing`.`wholesaler_pn`, `Listing`.`distributor_pn`, `Listing`.`retailer_pn`, `Listing`.`special_id`, `Listing`.`barcode`, `Listing`.`rfid`, `Listing`.`other_pn`, `Listing`.`make`, `Listing`.`model`, `Listing`.`model_number`, `Listing`.`serial_number`, `Listing`.`manufacture_date`, `Listing`.`other_make_model`, `Listing`.`drawing_buyer_key`, `Listing`.`drawing_buyer`, `Listing`.`drawing_industry`, `Listing`.`drawing_supplier`, `Listing`.`drawing_manufacturer`, `Listing`.`drawing_wholesaler`, `Listing`.`drawing_distributor`, `Listing`.`drawing_retailer`, `Listing`.`sketch_buyer`, `Listing`.`sketch_seller`, `Listing`.`sketch_other`, `Listing`.`materials_buyer`, `Listing`.`materials_seller`, `Listing`.`materials_industry`, `Listing`.`materials_other`, `Listing`.`size`, `Listing`.`shape`, `Listing`.`form`, `Listing`.`length`, `Listing`.`height`, `Listing`.`width`, `Listing`.`thickness`, `Listing`.`diameter`, `Listing`.`weight_estimated`, `Listing`.`weight_actual`, `Listing`.`color`, `Listing`.`made_from`, `Listing`.`ingredients`, `Listing`.`density`, `Listing`.`size_other`, `Listing`.`horsepower`, `Listing`.`speed`, `Listing`.`voltage`, `Listing`.`acdc`, `Listing`.`maintenance`, `Listing`.`noise`, `Listing`.`temperature`, `Listing`.`efficiency`, `Listing`.`kwh_usage`, `Listing`.`operating_parameters_other`, `Listing`.`24_7_365`, `Listing`.`operating_location`, `Listing`.`operating_temperature`, `Listing`.`operating_cond_other`, `Listing`.`assembly_required`, `Listing`.`testing_required`, `Listing`.`finishing_required`, `Listing`.`installation_required`, `Listing`.`additional_work_scope`, `Listing`.`bpp`, `Listing`.`bpp_type_plan`, `Listing`.`bpp_plan_number`, `Listing`.`bpp_kickoff`, `Listing`.`bpp_other`, `Listing`.`inspections`, `Listing`.`inspections_visual`, `Listing`.`inspections_markings`, `Listing`.`inspections_dye`, `Listing`.`inspections_mag`, `Listing`.`inspections_ultra`, `Listing`.`inspections_radiography`, `Listing`.`inspections_other`, `Listing`.`specific_requirements`, `Listing`.`industry_qcodes`, `Listing`.`procedures_submittals`, `Listing`.`certifications`, `Listing`.`source_inspections`, `Listing`.`in_process_hold`, `Listing`.`final_inspect`, `Listing`.`doc_package_review`, `Listing`.`customer_sign_off`, `Listing`.`packaging`, `Listing`.`handling`, `Listing`.`other_requirements`, `Listing`.`guards`, `Listing`.`lockout_tagout`, `Listing`.`startup_sequence`, `Listing`.`shutdown_sequence`, `Listing`.`safety_req_other`, `Listing`.`release_atmosphere`, `Listing`.`recycle`, `Listing`.`biodegradables`, `Listing`.`package_mat_restrict`, `Listing`.`enviro_other`, `Listing`.`spec_char`, `Listing`.`industry_standards`, `Listing`.`modified`, `Listing`.`specific_area`, `Listing`.`unique_detail`, `Listing`.`category_id`, `Listing`.`important_feature`, `Listing`.`commodity_code`, `Listing`.`industry_code`, `Listing`.`sic_code`, `Listing`.`unpsc_code`, `Listing`.`fb_code`, `Listing`.`other_code`, `Listing`.`quantity`, `Listing`.`condition`, `Listing`.`delivery_time`, `Listing`.`shipping_country`, `Listing`.`shipping_state`, `Listing`.`shipping_zip`, `Listing`.`shipping_city`, `Listing`.`partial_deliveries_accepted`, `Listing`.`multiple_ship_to_locations`, `Listing`.`shipping_name`, `Listing`.`shipping_co`, `Listing`.`address1_street`, `Listing`.`address1_state`, `Listing`.`address1_city`, `Listing`.`address1_zip`, `Listing`.`address2_street`, `Listing`.`address2_city`, `Listing`.`address2_state`, `Listing`.`address2_zip`, `Listing`.`contact_email`, `Listing`.`contact_phone`, `Listing`.`contact_fax`, `Listing`.`attn_to`, `Listing`.`governmental`, `Listing`.`business_corporate`, `Listing`.`legal`, `Listing`.`rules_other`, `Listing`.`special_char`, `Listing`.`ind_country_standard`, `Listing`.`budget_firm`, `Listing`.`price`, `Listing`.`budget_other`, `Listing`.`inclusive_total_individual`, `Listing`.`base_unit`, `Listing`.`base_total`, `Listing`.`surcharge_type`, `Listing`.`surcharge_lump`, `Listing`.`extra_type`, `Listing`.`extra_lump`, `Listing`.`handling_type`, `Listing`.`handling_lump`, `Listing`.`shipping_type`, `Listing`.`shipping_lump`, `Listing`.`currency_type`, `Listing`.`currency_lump`, `Listing`.`credits_type`, `Listing`.`credits_lump`, `Listing`.`tax_exempt`, `Listing`.`taxes_type`, `Listing`.`taxes_lump`, `Listing`.`grand_total`, `Listing`.`progress_payments`, `Listing`.`direct_budget`, `Listing`.`direct_department`, `Listing`.`direct_ledger`, `Listing`.`direct_other`, `Listing`.`indirect_budget`, `Listing`.`indirect_department`, `Listing`.`indirect_ledger`, `Listing`.`indirect_other`, `Listing`.`capital_budget`, `Listing`.`capital_department`, `Listing`.`capital_ledger`, `Listing`.`capital_other`, `Listing`.`project_name`, `Listing`.`project_number`, `Listing`.`project_account`, `Listing`.`monthly_usage`, `Listing`.`balance_hand`, `Listing`.`balance_hand_value`, `Listing`.`months_inventory`, `Listing`.`turns_inventory`, `Listing`.`essence`, `Listing`.`method`, `Listing`.`package_service`, `Listing`.`p_buyer_contract_no`, `Listing`.`p_buyer_rate_no`, `Listing`.`p_fb_contract_no`, `Listing`.`p_fb_rate_no`, `Listing`.`freight_carrier`, `Listing`.`f_buyer_rate_no`, `Listing`.`f_fb_contract_no`, `Listing`.`import_broker`, `Listing`.`i_buyer_contract_no`, `Listing`.`i_fb_buyer_contract_no`, `Listing`.`i_buyer_rate_no`, `Listing`.`i_fb_buyer_rate_no`, `Listing`.`3pl`, `Listing`.`3_buyer_contract_no`, `Listing`.`3_buyer_rate_no`, `Listing`.`3_fb_contract_no`, `Listing`.`3_fb_rate_no`, `Listing`.`freight_forwarder`, `Listing`.`ff_buyer_contract_no`, `Listing`.`ff_buyer_rate_no`, `Listing`.`ff_fb_contract_no`, `Listing`.`ff_fb_rate_no`, `Listing`.`tracking_required`, `Listing`.`shipping_notice`, `Listing`.`packing_slip`, `Listing`.`bill_lading`, `Listing`.`shipping_person`, `Listing`.`receiving_location`, `Listing`.`receiving_inspection`, `Listing`.`storeroom_location`, `Listing`.`point_location`, `Listing`.`special_instructions`, `Listing`.`add_picture1`, `Listing`.`notes`, `Listing`.`attachment`, `Listing`.`all_suppliers`, `Listing`.`filter_by_distance`, `Listing`.`filter_miles`, `Listing`.`filter_zip`, `Listing`.`filter_all_requirements`, `Listing`.`filter_equal_offers`, `Listing`.`filter_by_price`, `Listing`.`max_price`, `Listing`.`filter_mult_reviews`, `Listing`.`filter_all_terms`, `Listing`.`filter_pref_payment`, `Listing`.`filter_preapproved`, `Listing`.`approved_cert`, `Listing`.`approved_audit`, `Listing`.`approved_capable`, `Listing`.`approved_fb`, `Listing`.`approved_agency`, `Listing`.`filter_countries`, `Listing`.`exclude_countries`, `Listing`.`filter_other`, `Listing`.`other_filters`, `Listing`.`expire_date_offer`, `Listing`.`expire_date_listing`, `Listing`.`send_to`, `Listing`.`sendto_email`, `Listing`.`post_type`, `Listing`.`created`, `Listing`.`title`, `Listing`.`contact_mobile`, `Listing`.`offer_count`, `Listing`.`tax_exempt_number`, `Listing`.`terms_conditions`, `Listing`.`commit_date`, `Listing`.`f_buyer_contract_no`, `Listing`.`f_fb_rate_no`, `Listing`.`private_key`, `Listing`.`message_count`, `Listing`.`more_than_one`, `Listing`.`measure`, `Listing`.`add_picture2`, `Listing`.`add_picture3`, `Listing`.`attachment2`, `Listing`.`attachment3`, `Listing`.`rfi`, `Listing`.`payment_method`, `Listing`.`payment_timing`, `Listing`.`payment_terms`, `Listing`.`payment_other`, `Listing`.`pp_options`, `Listing`.`confidentiality_agreement_required`, `Listing`.`transpo_terms`, `Listing`.`terms_upload`, `Listing`.`directed`, `Listing`.`extra_other`, `Listing`.`carrier_name`, `Listing`.`i_fb_contract_no`, `Listing`.`i_fb_rate_no`, `Listing`.`op_param_other`, `Listing`.`email_notifications_sent`, `Listing`.`state_other`, `Listing`.`address1_state_other`, `Listing`.`address2_state_other`, `Listing`.`terms_type`, `Listing`.`address1_country`, `Listing`.`address2_country`, `Listing`.`customs_type`, `Listing`.`customs_lump`, `Listing`.`other_type1`, `Listing`.`other_lump1`, `Listing`.`other_type2`, `Listing`.`other_lump2`, `Listing`.`package_service_other`, `Listing`.`nda_url`, `Listing`.`where_located`, `Listing`.`published`, `Listing`.`under_contract`, `Listing`.`draft`, `Listing`.`active`, `Listing`.`transpo_terms_other`, `Listing`.`currency`, `Listing`.`currency_other`, `Listing`.`payment_method_other`, `Listing`.`deleted`, `Listing`.`show_contact_info`, `Listing`.`hide_finance`, `Listing`.`hide_focused_words`, `Listing`.`use_standard_delivery_method`, `Listing`.`filter_minority_owned`, `Listing`.`filter_small_disadvantaged`, `Listing`.`filter_woman_owned`, `Listing`.`filter_veteran_owned`, `Listing`.`filter_veteran_disabled_owned`, `Listing`.`filter_disabled_owned`, `Listing`.`filter_senior_owned`, `Listing`.`filter_economic_development`, `Listing`.`filter_economic_hub`, `Listing`.`filter_labor_surplus`, `Listing`.`quick_listing`, `Listing`.`show_logo`, `Listing`.`as_of_date`, `Listing`.`filter_lgbt_owned`, `User`.`id`, `User`.`group_id`, `User`.`corporate_admin`, `User`.`username`, `User`.`password`, `User`.`email`, `User`.`first_name`, `User`.`last_name`, `User`.`security_question`, `User`.`security_answer`, `User`.`receive_updates`, `User`.`agree`, `User`.`contract_prefs`, `User`.`standard_terms`, `User`.`standard_terms_upload`, `User`.`buyer_email`, `User`.`buyer_phone`, `User`.`buyer_fax`, `User`.`buyer_skype`, `User`.`seller_email`, `User`.`seller_phone`, `User`.`seller_fax`, `User`.`seller_skype`, `User`.`adv_phone`, `User`.`adv_fax`, `User`.`adv_email`, `User`.`adv_skype`, `User`.`twitter`, `User`.`linkedin`, `User`.`profile_img`, `User`.`about`, `User`.`location`, `User`.`affiliations`, `User`.`phone`, `User`.`skype`, `User`.`gender`, `User`.`use_buying`, `User`.`use_selling`, `User`.`use_advertising`, `User`.`use_business`, `User`.`use_personal`, `User`.`use_organization`, `User`.`use_public`, `User`.`company`, `User`.`parent_company`, `User`.`title`, `User`.`tax_id`, `User`.`address`, `User`.`address_2`, `User`.`city`, `User`.`state`, `User`.`state_other`, `User`.`active`, `User`.`created`, `User`.`modified`, `User`.`company_logo`, `User`.`gtalk`, `User`.`zip`, `User`.`country`, `User`.`accept_pp`, `User`.`corporation_id`, `User`.`corporate_permission`, `Category`.`id`, `Category`.`category`, `Category`.`order`, `Contract`.`id`, `Contract`.`listing_id`, `Contract`.`offer_id`, `Contract`.`acknowledgement`, `Contract`.`notes`, `Contract`.`receiving`, `Contract`.`payment_and_closure`, `Contract`.`submittals_and_transmittals`, `Contract`.`shipping_advice`, `Contract`.`receipt_inspection`, `Contract`.`disengagement`, `Contract`.`shipping_notice`, `Contract`.`acceptance`, `Contract`.`performance_ratings`, `Contract`.`bill_of_lading`, `Contract`.`rejection`, `Contract`.`packing_list`, `Contract`.`invoice`, `Contract`.`agree_to_purchase`, `Contract`.`agree_to_payment`, `Contract`.`agree_to_precious`, `Contract`.`agree_to_requirements`, `Contract`.`agree_with_exceptions`, `Contract`.`seller_acknowledge_notes`, `Contract`.`seller_acknowledge_negotiate`, `Contract`.`agree_with_acknowledgment`, `Contract`.`acknowledgment_not_acceptable`, `Contract`.`buyer_acknowledge_notes`, `Contract`.`buyer_acknowledge_negotiate`, `Contract`.`agree_procedures_received`, `Contract`.`procedures_disapproved`, `Contract`.`released_for_manufacture`, `Contract`.`agree_procedures_approved`, `Contract`.`service_before`, `Contract`.`service_before_date`, `Contract`.`service_delayed`, `Contract`.`service_delayed_date`, `Contract`.`shipping_advice_notes`, `Contract`.`shipping_advice_negotiate`, `Contract`.`shipment_made`, `Contract`.`shipment_made_date`, `Contract`.`shipment_made_carrier`, `Contract`.`service_completed`, `Contract`.`service_completed_date`, `Contract`.`service_completed_location`, `Contract`.`lading_attached`, `Contract`.`lading_file`, `Contract`.`packing_slip_attached`, `Contract`.`packing_slip_file`, `Contract`.`complete_invoice_attached`, `Contract`.`partial_invoice_attached`, `Contract`.`revised_invoice_attached`, `Contract`.`invoice_file`, `Contract`.`agree_service_received`, `Contract`.`service_received_date`, `Contract`.`agree_cert_received`, `Contract`.`cert_received_date`, `Contract`.`service_meets_requirements`, `Contract`.`service_met_date`, `Contract`.`cert_meets_requirements`, `Contract`.`cert_met_date`, `Contract`.`shipment_fails_requirements`, `Contract`.`shipment_fail_date`, `Contract`.`cert_fails_requirements`, `Contract`.`cert_fail_date`, `Contract`.`reason_for_rejection`, `Contract`.`required_disposition`, `Contract`.`return_no_charge`, `Contract`.`return_no_charge_negotiate`, `Contract`.`return_for_credit`, `Contract`.`return_credit_negotiate`, `Contract`.`auth_number`, `Contract`.`shipping_cost`, `Contract`.`buyer_account_notes`, `Contract`.`seller_account_notes`, `Contract`.`enter_resolution`, `Contract`.`latest_resolution_status`, `Contract`.`now_meets_requirements`, `Contract`.`now_meets_requirements_date`, `Contract`.`payment_made`, `Contract`.`payment_made_date`, `Contract`.`payment_made_via`, `Contract`.`payment_made_file`, `Contract`.`full_payment_received`, `Contract`.`full_payment_date`, `Contract`.`buyer_po_closed`, `Contract`.`seller_po_closed`, `Contract`.`buyer_want_cancel`, `Contract`.`buyer_cancel_notes`, `Contract`.`buyer_cancel_negotiate`, `Contract`.`seller_want_cancel`, `Contract`.`seller_cancel_notes`, `Contract`.`seller_cancel_negotiate`, `Contract`.`buyer_agree_cancel`, `Contract`.`seller_agree_cancel`, `Contract`.`cancellation_charges`, `Contract`.`success_cancel_notes`, `Contract`.`success_cancel_negotiate`, `Contract`.`res_buyer_initiate`, `Contract`.`res_supplier_initiate`, `Contract`.`enter_res_notes`, `Contract`.`enter_res_negotiate`, `Contract`.`resolution_complete`, `Contract`.`buyer_res_notes`, `Contract`.`seller_res_notes`, `Contract`.`contract_seller_again`, `Contract`.`recommend_seller`, `Contract`.`rate_seller`, `Contract`.`seller_perf_comments`, `Contract`.`contract_buyer_again`, `Contract`.`recommend_buyer`, `Contract`.`rate_buyer`, `Contract`.`buyer_perf_comments`, `Contract`.`revision`, `Contract`.`shipping_restrictions`, `Contract`.`standard_notes`, `Contract`.`attachments`, `Contract`.`send_to_email`, `Contract`.`attention`, `Contract`.`created`, `Contract`.`updated`, `Contract`.`sent`, `Contract`.`release_confirmation`, `Contract`.`release_confirmation_date`, `Contract`.`release_confirmation_name`, `Contract`.`approve_po`, `Contract`.`listing_user_id`, `Contract`.`revision_history`, `Contract`.`draft`, `Contract`.`active`, `Contract`.`supplier_submittal_notes`, `Contract`.`supplier_submittal_negotiate`, `Contract`.`service_delayed_until`, `Contract`.`buyer_po_closed_date`, `Contract`.`seller_po_closed_date`, `Contract`.`buyer_cancel_date`, `Contract`.`seller_cancel_date`, `Contract`.`successful_cancel_date`, `Contract`.`spreadsheet`, `Contract`.`closed`, `Contract`.`private_key`, `Contract`.`seller_address`, `Contract`.`seller_address_2`, `Contract`.`seller_city`, `Contract`.`seller_state`, `Contract`.`seller_country`, `Contract`.`seller_state_other`, `Contract`.`company_po_number`, `Contract`.`supplier_code`, `Contract`.`buyer_code`, `Contract`.`buyer_email`, `Contract`.`buyer_fax`, `Contract`.`buyer_mobile`, `Contract`.`buyer_attn`, `Contract`.`credit_card_type`, `Contract`.`seller_transaction_id`, `Contract`.`cc_transaction_id`, `Contract`.`cc_transaction_date`, `Contract`.`cc_posting_date`, `Contract`.`cc_last_four`, `Contract`.`seller_zip`, `Contract`.`seller_quotation_number`, `Contract`.`seller_job_number`, `Contract`.`sent_at` FROM `listings` AS `Listing` LEFT JOIN `users` AS `User` ON (`Listing`.`user_id` = `User`.`id`) LEFT JOIN `categories` AS `Category` ON (`Listing`.`category_id` = `Category`.`id`) LEFT JOIN `contracts` AS `Contract` ON (`Contract`.`listing_id` = `Listing`.`id`) WHERE `Listing`.`id` = 1712 AND `Listing`.`deleted` = 0 LIMIT 1 | | 1 | 1 | 2 |
