Guest User

Untitled

a guest
Dec 2nd, 2019
156
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. SELECT DISTINCT BE.ID as ID,BE.IBLOCK_ID as IBLOCK_ID,BE.CODE as CODE,BE.XML_ID as XML_ID,BE.NAME as NAME,BE.ACTIVE as ACTIVE,IF(EXTRACT(HOUR_SECOND FROM BE.ACTIVE_FROM)>0, DATE_FORMAT(BE.ACTIVE_FROM, '%d.%m.%Y %H:%i:%s'), DATE_FORMAT(BE.ACTIVE_FROM, '%d.%m.%Y')) as DATE_ACTIVE_FROM,IF(EXTRACT(HOUR_SECOND FROM BE.ACTIVE_TO)>0, DATE_FORMAT(BE.ACTIVE_TO, '%d.%m.%Y %H:%i:%s'), DATE_FORMAT(BE.ACTIVE_TO, '%d.%m.%Y')) as DATE_ACTIVE_TO,BE.SORT as SORT,BE.PREVIEW_TEXT as PREVIEW_TEXT,BE.PREVIEW_TEXT_TYPE as PREVIEW_TEXT_TYPE,BE.DETAIL_TEXT as DETAIL_TEXT,BE.DETAIL_TEXT_TYPE as DETAIL_TEXT_TYPE,DATE_FORMAT(BE.DATE_CREATE, '%d.%m.%Y %H:%i:%s') as DATE_CREATE,BE.CREATED_BY as CREATED_BY,BE.TAGS as TAGS,DATE_FORMAT(BE.TIMESTAMP_X, '%d.%m.%Y %H:%i:%s') as TIMESTAMP_X,BE.MODIFIED_BY as MODIFIED_BY,BE.IBLOCK_SECTION_ID as IBLOCK_SECTION_ID,B.DETAIL_PAGE_URL as DETAIL_PAGE_URL,BE.DETAIL_PICTURE as DETAIL_PICTURE,BE.PREVIEW_PICTURE as PREVIEW_PICTURE,L.DIR as LANG_DIR,BE.XML_ID as EXTERNAL_ID,B.IBLOCK_TYPE_ID as IBLOCK_TYPE_ID,B.CODE as IBLOCK_CODE,B.XML_ID as IBLOCK_EXTERNAL_ID,B.LID as LID , PRD.AVAILABLE as AVAILABLE, PRD.TYPE as TYPE, PRD.BUNDLE as BUNDLE, PRD.QUANTITY as QUANTITY, IF (PRD.QUANTITY_TRACE = 'D', 'N', PRD.QUANTITY_TRACE) as QUANTITY_TRACE, IF (PRD.CAN_BUY_ZERO = 'D', 'N', PRD.CAN_BUY_ZERO) as CAN_BUY_ZERO, PRD.MEASURE as MEASURE, IF (PRD.SUBSCRIBE = 'D', 'Y', PRD.SUBSCRIBE) as SUBSCRIBE, PRD.VAT_ID as VAT_ID, PRD.VAT_INCLUDED as VAT_INCLUDED, PRD.WEIGHT as WEIGHT, PRD.WIDTH as WIDTH, PRD.LENGTH as LENGTH, PRD.HEIGHT as HEIGHT, PRD.PRICE_TYPE as PAYMENT_TYPE, PRD.RECUR_SCHEME_LENGTH as RECUR_SCHEME_LENGTH, PRD.RECUR_SCHEME_TYPE as RECUR_SCHEME_TYPE, PRD.TRIAL_PRICE_ID as TRIAL_PRICE_ID, PRD.QUANTITY_TRACE as QUANTITY_TRACE_RAW, PRD.CAN_BUY_ZERO as CAN_BUY_ZERO_RAW, PRD.SUBSCRIBE as SUBSCRIBE_RAW, PRD.PURCHASING_PRICE as PURCHASING_PRICE, PRD.PURCHASING_CURRENCY as PURCHASING_CURRENCY, PRD.BARCODE_MULTI as BARCODE_MULTI, PRD.WITHOUT_ORDER as WITHOUT_ORDER
  2. FROM
  3. b_iblock B
  4. INNER JOIN b_lang L ON B.LID=L.LID
  5. INNER JOIN b_iblock_element BE ON BE.IBLOCK_ID = B.ID
  6. INNER JOIN b_iblock_element_prop_s6 FPS0 ON FPS0.IBLOCK_ELEMENT_ID = BE.ID
  7. INNER JOIN (
  8. SELECT DISTINCT BSE.IBLOCK_ELEMENT_ID
  9. FROM b_iblock_section_element BSE
  10.  
  11. INNER JOIN b_iblock_section BSubS ON BSE.IBLOCK_SECTION_ID = BSubS.ID
  12. INNER JOIN b_iblock_section BS ON (BSubS.IBLOCK_ID=BS.IBLOCK_ID
  13. AND BSubS.LEFT_MARGIN>=BS.LEFT_MARGIN
  14. AND BSubS.RIGHT_MARGIN<=BS.RIGHT_MARGIN)
  15.  
  16. WHERE ((BSubS.GLOBAL_ACTIVE = 'Y'))
  17. ) BES ON BES.IBLOCK_ELEMENT_ID = BE.ID
  18.  
  19.  
  20. left join b_catalog_product as PRD on (PRD.ID = BE.ID)
  21.  
  22.  
  23. WHERE 1=1
  24. AND (
  25.  
  26. ((( BE.ID IS NULL OR NOT (BE.ID = '166969'))))
  27. AND (EXISTS (
  28. SELECT IBLOCK_ID FROM b_iblock_site WHERE IBLOCK_ID = B.ID
  29. AND (((SITE_ID='s1')))
  30. ))
  31. AND (((BE.ACTIVE_TO >= now() OR BE.ACTIVE_TO IS NULL) AND (BE.ACTIVE_FROM <= now() OR BE.ACTIVE_FROM IS NULL)))
  32. AND ((((BE.ACTIVE='Y'))))
  33. AND ((((BE.IBLOCK_ID = '6'))))
  34. AND ((((FPS0.PROPERTY_85 LIKE 'Sphere'))))
  35. )
  36. AND (((BE.WF_STATUS_ID=1 AND BE.WF_PARENT_ELEMENT_ID IS NULL)))
  37. AND ((
  38. B.ID IN (
  39. SELECT IBLOCK_ID
  40. FROM b_iblock_group IBG
  41. WHERE IBG.GROUP_ID IN (2)
  42. AND IBG.PERMISSION >= 'R'
  43.  
  44. AND (IBG.PERMISSION='X' OR B.ACTIVE='Y')
  45. )
  46. OR (B.RIGHTS_MODE = 'E' AND EXISTS (
  47. SELECT ER.ELEMENT_ID
  48. FROM b_iblock_element_right ER
  49. INNER JOIN b_iblock_right IBR ON IBR.ID = ER.RIGHT_ID
  50. INNER JOIN b_user_access UA ON UA.ACCESS_CODE = IBR.GROUP_CODE AND UA.USER_ID = 0
  51. WHERE ER.ELEMENT_ID = BE.ID
  52. AND IBR.OP_EREAD = 'Y'
  53.  
  54. ))
  55. ))
  56.  
  57. ORDER BY PRD.AVAILABLE desc , RAND(580006)
  58. LIMIT 20
RAW Paste Data

Adblocker detected! Please consider disabling it...

We've detected AdBlock Plus or some other adblocking software preventing Pastebin.com from fully loading.

We don't have any obnoxious sound, or popup ads, we actively block these annoying types of ads!

Please add Pastebin.com to your ad blocker whitelist or disable your adblocking software.

×