Untitled

mail@pastecode.io avatar
unknown
plain_text
a month ago
2.5 kB
1
Indexable
Never
select 
  `id`, 
  `Int Ref #`, 
  `Request Date`, 
  `Design Reps`, 
  `Percentages`, 
  `Customer`, 
  `Bel Part Number`, 
  `Customer Part Number`, 
  `Project Name`, 
  `Disty`, 
  `CEM`, 
  `Split`, 
  `Status` 
from 
  vw_Report_DesignIn 
where 
  1 = 1 
  AND (
    (`id` LIKE '%MeritageSale%') 
    OR (
      `Int Ref #` LIKE '%MeritageSale%'
    ) 
    OR (
      `Request Date` LIKE '%MeritageSale%'
    ) 
    OR (
      `Design Reps` LIKE '%MeritageSale%'
    ) 
    OR (
      `Percentages` LIKE '%MeritageSale%'
    ) 
    OR (`Customer` LIKE '%MeritageSale%') 
    OR (
      `Bel Part Number` LIKE '%MeritageSale%'
    ) 
    OR (
      `Customer Part Number` LIKE '%MeritageSale%'
    ) 
    OR (
      `Project Name` LIKE '%MeritageSale%'
    ) 
    OR (`Disty` LIKE '%MeritageSale%') 
    OR (`CEM` LIKE '%MeritageSale%') 
    OR (`Split` LIKE '%MeritageSale%') 
    OR (`Status` LIKE '%MeritageSale%') 
    OR (`rep_name` LIKE '%MeritageSale%') 
    OR (
      `regional_manager` LIKE '%MeritageSale%'
    ) 
    OR (
      `rep_contact_name` LIKE '%MeritageSale%'
    ) 
    OR (
      `rep_email_address` LIKE '%MeritageSale%'
    ) 
    OR (
      `sample_number` LIKE '%MeritageSale%'
    ) 
    OR (
      `project_engineer` LIKE '%MeritageSale%'
    ) 
    OR (
      `quote_identifier` LIKE '%MeritageSale%'
    ) 
    OR (
      `estimated_annual_usage` LIKE '%MeritageSale%'
    ) 
    OR (
      `production_timeframe` LIKE '%MeritageSale%'
    ) 
    OR (
      `engineering_design_qualification` LIKE '%MeritageSale%'
    ) 
    OR (
      `purchase_location` LIKE '%MeritageSale%'
    ) 
    OR (
      `shipping_location` LIKE '%MeritageSale%'
    ) 
    OR (
      `commission_rep_number` LIKE '%MeritageSale%'
    ) 
    OR (
      `approved_by` LIKE '%MeritageSale%'
    ) 
    OR (
      `approval_date` LIKE '%MeritageSale%'
    ) 
    OR (
      `quote_effective_date` LIKE '%MeritageSale%'
    ) 
    OR (
      `record_creator_identifier` LIKE '%MeritageSale%'
    ) 
    OR (`comments` LIKE '%MeritageSale%') 
    OR (
      `distributor_who_is_purchasing` LIKE '%MeritageSale%'
    ) 
    OR (
      `internal_part_number` LIKE '%MeritageSale%'
    ) 
    OR (
      `origin_information` LIKE '%MeritageSale%'
    ) 
    OR (
      `sales_code` LIKE '%MeritageSale%'
    ) 
    OR (
      `manufacturing_location` LIKE '%MeritageSale%'
    ) 
    OR (
      `territory` LIKE '%MeritageSale%'
    ) 
    OR (`year` LIKE '%MeritageSale%') 
    OR (`quarter` LIKE '%MeritageSale%')
  ) 
Order by 
  id Desc
Leave a Comment