Hi there,
On http://kamusi.org we are using the relation module to create translations between language dictionary terms. The main idea, is that there is a transitive setup, with infinity number of connections between words. This allows us to create a multi-language translation system, where one enters a word in English, links it to the corresponding word in French, and once Swahili is added, we have a English <-> French <-> Swahili dictionary.
The issue is that we have launched the 17th language, and are in the process of adding more. So, for the first time, we've run into a JOIN issue on relation, where if you add 30+ endpoints, with relation_select as the widget, the DB Query below is executed, and there is a fail. I'm not sure whether this is relation_select specific, but I thought I would start at the source first.
I tried looking at MongoDB as a potential solution, but that requires working the system again from the ground-up and given the NGO status of the project, funds are needed elsewhere, there must be an easier solution for this. postgres is an option, only in so far as it's a last resort. We're uncertain what modules would break, and would rather expend energy making relation better if possible.
Given the code below, where is this select created? I've looked into the module, and there's field_attach API work going on in the save, but I'm not sure where to start poking around. Could you help please?
PDOException: SQLSTATE[HY000]: General error: 1116 Too many tables; MySQL can only use 61 tables in a join:
SELECT DISTINCT field_data_endpoints0.entity_type AS entity_type, field_data_endpoints0.entity_id AS entity_id, field_data_endpoints0.revision_id AS revision_id, field_data_endpoints0.bundle AS bundle
FROM {field_data_endpoints} field_data_endpoints0
INNER JOIN {field_data_endpoints} field_data_endpoints1 ON field_data_endpoints1.entity_type = field_data_endpoints0.entity_type AND field_data_endpoints1.entity_id = field_data_endpoints0.entity_id INNER JOIN {field_data_endpoints} field_data_endpoints2 ON field_data_endpoints2.entity_type = field_data_endpoints0.entity_type AND field_data_endpoints2.entity_id = field_data_endpoints0.entity_id INNER JOIN {field_data_endpoints} field_data_endpoints3 ON field_data_endpoints3.entity_type = field_data_endpoints0.entity_type AND field_data_endpoints3.entity_id = field_data_endpoints0.entity_id INNER JOIN {field_data_endpoints} field_data_endpoints4 ON field_data_endpoints4.entity_type = field_data_endpoints0.entity_type AND field_data_endpoints4.entity_id = field_data_endpoints0.entity_id INNER JOIN {field_data_endpoints} field_data_endpoints5 ON field_data_endpoints5.entity_type = field_data_endpoints0.entity_type AND field_data_endpoints5.entity_id = field_data_endpoints0.entity_id INNER JOIN {field_data_endpoints} field_data_endpoints6 ON field_data_endpoints6.entity_type = field_data_endpoints0.entity_type AND field_data_endpoints6.entity_id = field_data_endpoints0.entity_id INNER JOIN {field_data_endpoints} field_data_endpoints7 ON field_data_endpoints7.entity_type = field_data_endpoints0.entity_type AND field_data_endpoints7.entity_id = field_data_endpoints0.entity_id INNER JOIN {field_data_endpoints} field_data_endpoints8 ON field_data_endpoints8.entity_type = field_data_endpoints0.entity_type AND field_data_endpoints8.entity_id = field_data_endpoints0.entity_id INNER JOIN {field_data_endpoints} field_data_endpoints9 ON field_data_endpoints9.entity_type = field_data_endpoints0.entity_type AND field_data_endpoints9.entity_id = field_data_endpoints0.entity_id INNER JOIN {field_data_endpoints} field_data_endpoints10 ON field_data_endpoints10.entity_type = field_data_endpoints0.entity_type AND field_data_endpoints10.entity_id = field_data_endpoints0.entity_id INNER JOIN {field_data_endpoints} field_data_endpoints11 ON field_data_endpoints11.entity_type = field_data_endpoints0.entity_type AND field_data_endpoints11.entity_id = field_data_endpoints0.entity_id INNER JOIN {field_data_endpoints} field_data_endpoints12 ON field_data_endpoints12.entity_type = field_data_endpoints0.entity_type AND field_data_endpoints12.entity_id = field_data_endpoints0.entity_id INNER JOIN {field_data_endpoints} field_data_endpoints13 ON field_data_endpoints13.entity_type = field_data_endpoints0.entity_type AND field_data_endpoints13.entity_id = field_data_endpoints0.entity_id INNER JOIN {field_data_endpoints} field_data_endpoints14 ON field_data_endpoints14.entity_type = field_data_endpoints0.entity_type AND field_data_endpoints14.entity_id = field_data_endpoints0.entity_id INNER JOIN {field_data_endpoints} field_data_endpoints15 ON field_data_endpoints15.entity_type = field_data_endpoints0.entity_type AND field_data_endpoints15.entity_id = field_data_endpoints0.entity_id INNER JOIN {field_data_endpoints} field_data_endpoints16 ON field_data_endpoints16.entity_type = field_data_endpoints0.entity_type AND field_data_endpoints16.entity_id = field_data_endpoints0.entity_id INNER JOIN {field_data_endpoints} field_data_endpoints17 ON field_data_endpoints17.entity_type = field_data_endpoints0.entity_type AND field_data_endpoints17.entity_id = field_data_endpoints0.entity_id INNER JOIN {field_data_endpoints} field_data_endpoints18 ON field_data_endpoints18.entity_type = field_data_endpoints0.entity_type AND field_data_endpoints18.entity_id = field_data_endpoints0.entity_id INNER JOIN {field_data_endpoints} field_data_endpoints19 ON field_data_endpoints19.entity_type = field_data_endpoints0.entity_type AND field_data_endpoints19.entity_id = field_data_endpoints0.entity_id INNER JOIN {field_data_endpoints} field_data_endpoints20 ON field_data_endpoints20.entity_type = field_data_endpoints0.entity_type AND field_data_endpoints20.entity_id = field_data_endpoints0.entity_id INNER JOIN {field_data_endpoints} field_data_endpoints21 ON field_data_endpoints21.entity_type = field_data_endpoints0.entity_type AND field_data_endpoints21.entity_id = field_data_endpoints0.entity_id INNER JOIN {field_data_endpoints} field_data_endpoints22 ON field_data_endpoints22.entity_type = field_data_endpoints0.entity_type AND field_data_endpoints22.entity_id = field_data_endpoints0.entity_id INNER JOIN {field_data_endpoints} field_data_endpoints23 ON field_data_endpoints23.entity_type = field_data_endpoints0.entity_type AND field_data_endpoints23.entity_id = field_data_endpoints0.entity_id INNER JOIN {field_data_endpoints} field_data_endpoints24 ON field_data_endpoints24.entity_type = field_data_endpoints0.entity_type AND field_data_endpoints24.entity_id = field_data_endpoints0.entity_id INNER JOIN {field_data_endpoints} field_data_endpoints25 ON field_data_endpoints25.entity_type = field_data_endpoints0.entity_type AND field_data_endpoints25.entity_id = field_data_endpoints0.entity_id INNER JOIN {field_data_endpoints} field_data_endpoints26 ON field_data_endpoints26.entity_type = field_data_endpoints0.entity_type AND field_data_endpoints26.entity_id = field_data_endpoints0.entity_id INNER JOIN {field_data_endpoints} field_data_endpoints27 ON field_data_endpoints27.entity_type = field_data_endpoints0.entity_type AND field_data_endpoints27.entity_id = field_data_endpoints0.entity_id INNER JOIN {field_data_endpoints} field_data_endpoints28 ON field_data_endpoints28.entity_type = field_data_endpoints0.entity_type AND field_data_endpoints28.entity_id = field_data_endpoints0.entity_id INNER JOIN {field_data_endpoints} field_data_endpoints29 ON field_data_endpoints29.entity_type = field_data_endpoints0.entity_type AND field_data_endpoints29.entity_id = field_data_endpoints0.entity_id INNER JOIN {field_data_endpoints} field_data_endpoints30 ON field_data_endpoints30.entity_type = field_data_endpoints0.entity_type AND field_data_endpoints30.entity_id = field_data_endpoints0.entity_id INNER JOIN {field_data_endpoints} field_data_endpoints31 ON field_data_endpoints31.entity_type = field_data_endpoints0.entity_type AND field_data_endpoints31.entity_id = field_data_endpoints0.entity_id INNER JOIN {field_data_endpoints} field_data_endpoints32 ON field_data_endpoints32.entity_type = field_data_endpoints0.entity_type AND field_data_endpoints32.entity_id = field_data_endpoints0.entity_id INNER JOIN {field_data_endpoints} field_data_endpoints33 ON field_data_endpoints33.entity_type = field_data_endpoints0.entity_type AND field_data_endpoints33.entity_id = field_data_endpoints0.entity_id INNER JOIN {field_data_endpoints} field_data_endpoints34 ON field_data_endpoints34.entity_type = field_data_endpoints0.entity_type AND field_data_endpoints34.entity_id = field_data_endpoints0.entity_id INNER JOIN {field_data_endpoints} field_data_endpoints35 ON field_data_endpoints35.entity_type = field_data_endpoints0.entity_type AND field_data_endpoints35.entity_id = field_data_endpoints0.entity_id INNER JOIN {field_data_endpoints} field_data_endpoints36 ON field_data_endpoints36.entity_type = field_data_endpoints0.entity_type AND field_data_endpoints36.entity_id = field_data_endpoints0.entity_id INNER JOIN {field_data_endpoints} field_data_endpoints37 ON field_data_endpoints37.entity_type = field_data_endpoints0.entity_type AND field_data_endpoints37.entity_id = field_data_endpoints0.entity_id INNER JOIN {field_data_endpoints} field_data_endpoints38 ON field_data_endpoints38.entity_type = field_data_endpoints0.entity_type AND field_data_endpoints38.entity_id = field_data_endpoints0.entity_id INNER JOIN {field_data_endpoints} field_data_endpoints39 ON field_data_endpoints39.entity_type = field_data_endpoints0.entity_type AND field_data_endpoints39.entity_id = field_data_endpoints0.entity_id INNER JOIN {field_data_endpoints} field_data_endpoints40 ON field_data_endpoints40.entity_type = field_data_endpoints0.entity_type AND field_data_endpoints40.entity_id = field_data_endpoints0.entity_id INNER JOIN {field_data_endpoints} field_data_endpoints41 ON field_data_endpoints41.entity_type = field_data_endpoints0.entity_type AND field_data_endpoints41.entity_id = field_data_endpoints0.entity_id INNER JOIN {field_data_endpoints} field_data_endpoints42 ON field_data_endpoints42.entity_type = field_data_endpoints0.entity_type AND field_data_endpoints42.entity_id = field_data_endpoints0.entity_id INNER JOIN {field_data_endpoints} field_data_endpoints43 ON field_data_endpoints43.entity_type = field_data_endpoints0.entity_type AND field_data_endpoints43.entity_id = field_data_endpoints0.entity_id INNER JOIN {field_data_endpoints} field_data_endpoints44 ON field_data_endpoints44.entity_type = field_data_endpoints0.entity_type AND field_data_endpoints44.entity_id = field_data_endpoints0.entity_id INNER JOIN {field_data_endpoints} field_data_endpoints45 ON field_data_endpoints45.entity_type = field_data_endpoints0.entity_type AND field_data_endpoints45.entity_id = field_data_endpoints0.entity_id INNER JOIN {field_data_endpoints} field_data_endpoints46 ON field_data_endpoints46.entity_type = field_data_endpoints0.entity_type AND field_data_endpoints46.entity_id = field_data_endpoints0.entity_id INNER JOIN {field_data_endpoints} field_data_endpoints47 ON field_data_endpoints47.entity_type = field_data_endpoints0.entity_type AND field_data_endpoints47.entity_id = field_data_endpoints0.entity_id INNER JOIN {field_data_endpoints} field_data_endpoints48 ON field_data_endpoints48.entity_type = field_data_endpoints0.entity_type AND field_data_endpoints48.entity_id = field_data_endpoints0.entity_id INNER JOIN {field_data_endpoints} field_data_endpoints49 ON field_data_endpoints49.entity_type = field_data_endpoints0.entity_type AND field_data_endpoints49.entity_id = field_data_endpoints0.entity_id INNER JOIN {field_data_endpoints} field_data_endpoints50 ON field_data_endpoints50.entity_type = field_data_endpoints0.entity_type AND field_data_endpoints50.entity_id = field_data_endpoints0.entity_id INNER JOIN {field_data_endpoints} field_data_endpoints51 ON field_data_endpoints51.entity_type = field_data_endpoints0.entity_type AND field_data_endpoints51.entity_id = field_data_endpoints0.entity_id INNER JOIN {field_data_endpoints} field_data_endpoints52 ON field_data_endpoints52.entity_type = field_data_endpoints0.entity_type AND field_data_endpoints52.entity_id = field_data_endpoints0.entity_id INNER JOIN {field_data_endpoints} field_data_endpoints53 ON field_data_endpoints53.entity_type = field_data_endpoints0.entity_type AND field_data_endpoints53.entity_id = field_data_endpoints0.entity_id INNER JOIN {field_data_endpoints} field_data_endpoints54 ON field_data_endpoints54.entity_type = field_data_endpoints0.entity_type AND field_data_endpoints54.entity_id = field_data_endpoints0.entity_id INNER JOIN {field_data_endpoints} field_data_endpoints55 ON field_data_endpoints55.entity_type = field_data_endpoints0.entity_type AND field_data_endpoints55.entity_id = field_data_endpoints0.entity_id INNER JOIN {field_data_endpoints} field_data_endpoints56 ON field_data_endpoints56.entity_type = field_data_endpoints0.entity_type AND field_data_endpoints56.entity_id = field_data_endpoints0.entity_id INNER JOIN {field_data_endpoints} field_data_endpoints57 ON field_data_endpoints57.entity_type = field_data_endpoints0.entity_type AND field_data_endpoints57.entity_id = field_data_endpoints0.entity_id INNER JOIN {field_data_endpoints} field_data_endpoints58 ON field_data_endpoints58.entity_type = field_data_endpoints0.entity_type AND field_data_endpoints58.entity_id = field_data_endpoints0.entity_id INNER JOIN {field_data_endpoints} field_data_endpoints59 ON field_data_endpoints59.entity_type = field_data_endpoints0.entity_type AND field_data_endpoints59.entity_id = field_data_endpoints0.entity_id INNER JOIN {field_data_endpoints} field_data_endpoints60 ON field_data_endpoints60.entity_type = field_data_endpoints0.entity_type AND field_data_endpoints60.entity_id = field_data_endpoints0.entity_id INNER JOIN {field_data_endpoints} field_data_endpoints61 ON field_data_endpoints61.entity_type = field_data_endpoints0.entity_type AND field_data_endpoints61.entity_id = field_data_endpoints0.entity_id INNER JOIN {field_data_endpoints} field_data_endpoints62 ON field_data_endpoints62.entity_type = field_data_endpoints0.entity_type AND field_data_endpoints62.entity_id = field_data_endpoints0.entity_id INNER JOIN {field_data_endpoints} field_data_endpoints63 ON field_data_endpoints63.entity_type = field_data_endpoints0.entity_type AND field_data_endpoints63.entity_id = field_data_endpoints0.entity_id INNER JOIN {field_data_endpoints} field_data_endpoints64 ON field_data_endpoints64.entity_type = field_data_endpoints0.entity_type AND field_data_endpoints64.entity_id = field_data_endpoints0.entity_id INNER JOIN {field_data_endpoints} field_data_endpoints65 ON field_data_endpoints65.entity_type = field_data_endpoints0.entity_type AND field_data_endpoints65.entity_id = field_data_endpoints0.entity_id INNER JOIN {field_data_endpoints} field_data_endpoints66 ON field_data_endpoints66.entity_type = field_data_endpoints0.entity_type AND field_data_endpoints66.entity_id = field_data_endpoints0.entity_id INNER JOIN {field_data_endpoints} field_data_endpoints67 ON field_data_endpoints67.entity_type = field_data_endpoints0.entity_type AND field_data_endpoints67.entity_id = field_data_endpoints0.entity_id INNER JOIN {field_data_endpoints} field_data_endpoints68 ON field_data_endpoints68.entity_type = field_data_endpoints0.entity_type AND field_data_endpoints68.entity_id = field_data_endpoints0.entity_id INNER JOIN {field_data_endpoints} field_data_endpoints69 ON field_data_endpoints69.entity_type = field_data_endpoints0.entity_type AND field_data_endpoints69.entity_id = field_data_endpoints0.entity_id INNER JOIN {field_data_endpoints} field_data_endpoints70 ON field_data_endpoints70.entity_type = field_data_endpoints0.entity_type AND field_data_endpoints70.entity_id = field_data_endpoints0.entity_id INNER JOIN {field_data_endpoints} field_data_endpoints71 ON field_data_endpoints71.entity_type = field_data_endpoints0.entity_type AND field_data_endpoints71.entity_id = field_data_endpoints0.entity_id INNER JOIN {field_data_endpoints} field_data_endpoints72 ON field_data_endpoints72.entity_type = field_data_endpoints0.entity_type AND field_data_endpoints72.entity_id = field_data_endpoints0.entity_id INNER JOIN {field_data_endpoints} field_data_endpoints73 ON field_data_endpoints73.entity_type = field_data_endpoints0.entity_type AND field_data_endpoints73.entity_id = field_data_endpoints0.entity_id INNER JOIN {field_data_endpoints} field_data_endpoints74 ON field_data_endpoints74.entity_type = field_data_endpoints0.entity_type AND field_data_endpoints74.entity_id = field_data_endpoints0.entity_id INNER JOIN {field_data_endpoints} field_data_endpoints75 ON field_data_endpoints75.entity_type = field_data_endpoints0.entity_type AND field_data_endpoints75.entity_id = field_data_endpoints0.entity_id INNER JOIN {field_data_endpoints} field_data_endpoints76 ON field_data_endpoints76.entity_type = field_data_endpoints0.entity_type AND field_data_endpoints76.entity_id = field_data_endpoints0.entity_id INNER JOIN {field_data_endpoints} field_data_endpoints77 ON field_data_endpoints77.entity_type = field_data_endpoints0.entity_type AND field_data_endpoints77.entity_id = field_data_endpoints0.entity_id INNER JOIN {field_data_endpoints} field_data_endpoints78 ON field_data_endpoints78.entity_type = field_data_endpoints0.entity_type AND field_data_endpoints78.entity_id = field_data_endpoints0.entity_id INNER JOIN {field_data_endpoints} field_data_endpoints79 ON field_data_endpoints79.entity_type = field_data_endpoints0.entity_type AND field_data_endpoints79.entity_id = field_data_endpoints0.entity_id INNER JOIN {field_data_endpoints} field_data_endpoints80 ON field_data_endpoints80.entity_type = field_data_endpoints0.entity_type AND field_data_endpoints80.entity_id = field_data_endpoints0.entity_id INNER JOIN {field_data_endpoints} field_data_endpoints81 ON field_data_endpoints81.entity_type = field_data_endpoints0.entity_type AND field_data_endpoints81.entity_id = field_data_endpoints0.entity_id INNER JOIN {relation} relation ON relation.rid = field_data_endpoints0.entity_id
WHERE
(field_data_endpoints0.endpoints_entity_type = :db_condition_placeholder_0) AND (field_data_endpoints1.endpoints_entity_id = :db_condition_placeholder_1) AND (field_data_endpoints1.delta = field_data_endpoints0.delta) AND (field_data_endpoints2.endpoints_entity_type = :db_condition_placeholder_2) AND (field_data_endpoints3.endpoints_entity_id = :db_condition_placeholder_3) AND (field_data_endpoints3.delta = field_data_endpoints2.delta) AND (field_data_endpoints4.endpoints_entity_type = :db_condition_placeholder_4) AND (field_data_endpoints5.endpoints_entity_id = :db_condition_placeholder_5) AND (field_data_endpoints5.delta = field_data_endpoints4.delta) AND (field_data_endpoints6.endpoints_entity_type = :db_condition_placeholder_6) AND (field_data_endpoints7.endpoints_entity_id = :db_condition_placeholder_7) AND (field_data_endpoints7.delta = field_data_endpoints6.delta) AND (field_data_endpoints8.endpoints_entity_type = :db_condition_placeholder_8) AND (field_data_endpoints9.endpoints_entity_id = :db_condition_placeholder_9) AND (field_data_endpoints9.delta = field_data_endpoints8.delta) AND (field_data_endpoints10.endpoints_entity_type = :db_condition_placeholder_10) AND (field_data_endpoints11.endpoints_entity_id = :db_condition_placeholder_11) AND (field_data_endpoints11.delta = field_data_endpoints10.delta) AND (field_data_endpoints12.endpoints_entity_type = :db_condition_placeholder_12) AND (field_data_endpoints13.endpoints_entity_id = :db_condition_placeholder_13) AND (field_data_endpoints13.delta = field_data_endpoints12.delta) AND (field_data_endpoints14.endpoints_entity_type = :db_condition_placeholder_14) AND (field_data_endpoints15.endpoints_entity_id = :db_condition_placeholder_15) AND (field_data_endpoints15.delta = field_data_endpoints14.delta) AND (field_data_endpoints16.endpoints_entity_type = :db_condition_placeholder_16) AND (field_data_endpoints17.endpoints_entity_id = :db_condition_placeholder_17) AND (field_data_endpoints17.delta = field_data_endpoints16.delta) AND (field_data_endpoints18.endpoints_entity_type = :db_condition_placeholder_18) AND (field_data_endpoints19.endpoints_entity_id = :db_condition_placeholder_19) AND (field_data_endpoints19.delta = field_data_endpoints18.delta) AND (field_data_endpoints20.endpoints_entity_type = :db_condition_placeholder_20) AND (field_data_endpoints21.endpoints_entity_id = :db_condition_placeholder_21) AND (field_data_endpoints21.delta = field_data_endpoints20.delta) AND (field_data_endpoints22.endpoints_entity_type = :db_condition_placeholder_22) AND (field_data_endpoints23.endpoints_entity_id = :db_condition_placeholder_23) AND (field_data_endpoints23.delta = field_data_endpoints22.delta) AND (field_data_endpoints24.endpoints_entity_type = :db_condition_placeholder_24) AND (field_data_endpoints25.endpoints_entity_id = :db_condition_placeholder_25) AND (field_data_endpoints25.delta = field_data_endpoints24.delta) AND (field_data_endpoints26.endpoints_entity_type = :db_condition_placeholder_26) AND (field_data_endpoints27.endpoints_entity_id = :db_condition_placeholder_27) AND (field_data_endpoints27.delta = field_data_endpoints26.delta) AND (field_data_endpoints28.endpoints_entity_type = :db_condition_placeholder_28) AND (field_data_endpoints29.endpoints_entity_id = :db_condition_placeholder_29) AND (field_data_endpoints29.delta = field_data_endpoints28.delta) AND (field_data_endpoints30.endpoints_entity_type = :db_condition_placeholder_30) AND (field_data_endpoints31.endpoints_entity_id = :db_condition_placeholder_31) AND (field_data_endpoints31.delta = field_data_endpoints30.delta) AND (field_data_endpoints32.endpoints_entity_type = :db_condition_placeholder_32) AND (field_data_endpoints33.endpoints_entity_id = :db_condition_placeholder_33) AND (field_data_endpoints33.delta = field_data_endpoints32.delta) AND (field_data_endpoints34.endpoints_entity_type = :db_condition_placeholder_34) AND (field_data_endpoints35.endpoints_entity_id = :db_condition_placeholder_35) AND (field_data_endpoints35.delta = field_data_endpoints34.delta) AND (field_data_endpoints36.endpoints_entity_type = :db_condition_placeholder_36) AND (field_data_endpoints37.endpoints_entity_id = :db_condition_placeholder_37) AND (field_data_endpoints37.delta = field_data_endpoints36.delta) AND (field_data_endpoints38.endpoints_entity_type = :db_condition_placeholder_38) AND (field_data_endpoints39.endpoints_entity_id = :db_condition_placeholder_39) AND (field_data_endpoints39.delta = field_data_endpoints38.delta) AND (field_data_endpoints40.endpoints_entity_type = :db_condition_placeholder_40) AND (field_data_endpoints41.endpoints_entity_id = :db_condition_placeholder_41) AND (field_data_endpoints41.delta = field_data_endpoints40.delta) AND (field_data_endpoints42.endpoints_entity_type = :db_condition_placeholder_42) AND (field_data_endpoints43.endpoints_entity_id = :db_condition_placeholder_43) AND (field_data_endpoints43.delta = field_data_endpoints42.delta) AND (field_data_endpoints44.endpoints_entity_type = :db_condition_placeholder_44) AND (field_data_endpoints45.endpoints_entity_id = :db_condition_placeholder_45) AND (field_data_endpoints45.delta = field_data_endpoints44.delta) AND (field_data_endpoints46.endpoints_entity_type = :db_condition_placeholder_46) AND (field_data_endpoints47.endpoints_entity_id = :db_condition_placeholder_47) AND (field_data_endpoints47.delta = field_data_endpoints46.delta) AND (field_data_endpoints48.endpoints_entity_type = :db_condition_placeholder_48) AND (field_data_endpoints49.endpoints_entity_id = :db_condition_placeholder_49) AND (field_data_endpoints49.delta = field_data_endpoints48.delta) AND (field_data_endpoints50.endpoints_entity_type = :db_condition_placeholder_50) AND (field_data_endpoints51.endpoints_entity_id = :db_condition_placeholder_51) AND (field_data_endpoints51.delta = field_data_endpoints50.delta) AND (field_data_endpoints52.endpoints_entity_type = :db_condition_placeholder_52) AND (field_data_endpoints53.endpoints_entity_id = :db_condition_placeholder_53) AND (field_data_endpoints53.delta = field_data_endpoints52.delta) AND (field_data_endpoints54.endpoints_entity_type = :db_condition_placeholder_54) AND (field_data_endpoints55.endpoints_entity_id = :db_condition_placeholder_55) AND (field_data_endpoints55.delta = field_data_endpoints54.delta) AND (field_data_endpoints56.endpoints_entity_type = :db_condition_placeholder_56) AND (field_data_endpoints57.endpoints_entity_id = :db_condition_placeholder_57) AND (field_data_endpoints57.delta = field_data_endpoints56.delta) AND (field_data_endpoints58.endpoints_entity_type = :db_condition_placeholder_58) AND (field_data_endpoints59.endpoints_entity_id = :db_condition_placeholder_59) AND (field_data_endpoints59.delta = field_data_endpoints58.delta) AND (field_data_endpoints60.endpoints_entity_type = :db_condition_placeholder_60) AND (field_data_endpoints61.endpoints_entity_id = :db_condition_placeholder_61) AND (field_data_endpoints61.delta = field_data_endpoints60.delta) AND (field_data_endpoints62.endpoints_entity_type = :db_condition_placeholder_62) AND (field_data_endpoints63.endpoints_entity_id = :db_condition_placeholder_63) AND (field_data_endpoints63.delta = field_data_endpoints62.delta) AND (field_data_endpoints64.endpoints_entity_type = :db_condition_placeholder_64) AND (field_data_endpoints65.endpoints_entity_id = :db_condition_placeholder_65) AND (field_data_endpoints65.delta = field_data_endpoints64.delta) AND (field_data_endpoints66.endpoints_entity_type = :db_condition_placeholder_66) AND (field_data_endpoints67.endpoints_entity_id = :db_condition_placeholder_67) AND (field_data_endpoints67.delta = field_data_endpoints66.delta) AND (field_data_endpoints68.endpoints_entity_type = :db_condition_placeholder_68) AND (field_data_endpoints69.endpoints_entity_id = :db_condition_placeholder_69) AND (field_data_endpoints69.delta = field_data_endpoints68.delta) AND (field_data_endpoints70.endpoints_entity_type = :db_condition_placeholder_70) AND (field_data_endpoints71.endpoints_entity_id = :db_condition_placeholder_71) AND (field_data_endpoints71.delta = field_data_endpoints70.delta) AND (field_data_endpoints72.endpoints_entity_type = :db_condition_placeholder_72) AND (field_data_endpoints73.endpoints_entity_id = :db_condition_placeholder_73) AND (field_data_endpoints73.delta = field_data_endpoints72.delta) AND (field_data_endpoints74.endpoints_entity_type = :db_condition_placeholder_74) AND (field_data_endpoints75.endpoints_entity_id = :db_condition_placeholder_75) AND (field_data_endpoints75.delta = field_data_endpoints74.delta) AND (field_data_endpoints76.endpoints_entity_type = :db_condition_placeholder_76) AND (field_data_endpoints77.endpoints_entity_id = :db_condition_placeholder_77) AND (field_data_endpoints77.delta = field_data_endpoints76.delta) AND (field_data_endpoints78.endpoints_entity_type = :db_condition_placeholder_78) AND (field_data_endpoints79.endpoints_entity_id = :db_condition_placeholder_79) AND (field_data_endpoints79.delta = field_data_endpoints78.delta) AND (field_data_endpoints80.endpoints_entity_type = :db_condition_placeholder_80) AND (field_data_endpoints81.endpoints_entity_id = :db_condition_placeholder_81) AND (field_data_endpoints81.delta = field_data_endpoints80.delta) AND (field_data_endpoints0.deleted = :db_condition_placeholder_82) AND (relation.relation_type = :db_condition_placeholder_83) AND (relation.arity = :db_condition_placeholder_84) AND (field_data_endpoints0.entity_type = :db_condition_placeholder_85) AND
(field_data_endpoints0.endpoints_r_index != field_data_endpoints2.endpoints_r_index) AND (field_data_endpoints0.endpoints_r_index != field_data_endpoints4.endpoints_r_index) AND (field_data_endpoints0.endpoints_r_index != field_data_endpoints6.endpoints_r_index) AND (field_data_endpoints0.endpoints_r_index != field_data_endpoints8.endpoints_r_index) AND (field_data_endpoints0.endpoints_r_index != field_data_endpoints10.endpoints_r_index) AND (field_data_endpoints0.endpoints_r_index != field_data_endpoints12.endpoints_r_index) AND (field_data_endpoints0.endpoints_r_index != field_data_endpoints14.endpoints_r_index) AND (field_data_endpoints0.endpoints_r_index != field_data_endpoints16.endpoints_r_index) AND (field_data_endpoints0.endpoints_r_index != field_data_endpoints18.endpoints_r_index) AND (field_data_endpoints0.endpoints_r_index != field_data_endpoints20.endpoints_r_index) AND (field_data_endpoints0.endpoints_r_index != field_data_endpoints22.endpoints_r_index) AND (field_data_endpoints0.endpoints_r_index != field_data_endpoints24.endpoints_r_index) AND (field_data_endpoints0.endpoints_r_index != field_data_endpoints26.endpoints_r_index) AND (field_data_endpoints0.endpoints_r_index != field_data_endpoints28.endpoints_r_index) AND (field_data_endpoints0.endpoints_r_index != field_data_endpoints30.endpoints_r_index) AND (field_data_endpoints0.endpoints_r_index != field_data_endpoints32.endpoints_r_index) AND (field_data_endpoints0.endpoints_r_index != field_data_endpoints34.endpoints_r_index) AND (field_data_endpoints0.endpoints_r_index != field_data_endpoints36.endpoints_r_index) AND (field_data_endpoints0.endpoints_r_index != field_data_endpoints38.endpoints_r_index) AND (field_data_endpoints0.endpoints_r_index != field_data_endpoints40.endpoints_r_index) AND (field_data_endpoints0.endpoints_r_index != field_data_endpoints42.endpoints_r_index) AND (field_data_endpoints0.endpoints_r_index != field_data_endpoints44.endpoints_r_index) AND (field_data_endpoints0.endpoints_r_index != field_data_endpoints46.endpoints_r_index) AND (field_data_endpoints0.endpoints_r_index != field_data_endpoints48.endpoints_r_index) AND (field_data_endpoints0.endpoints_r_index != field_data_endpoints50.endpoints_r_index) AND (field_data_endpoints0.endpoints_r_index != field_data_endpoints52.endpoints_r_index) AND (field_data_endpoints0.endpoints_r_index != field_data_endpoints54.endpoints_r_index) AND (field_data_endpoints0.endpoints_r_index != field_data_endpoints56.endpoints_r_index) AND (field_data_endpoints0.endpoints_r_index != field_data_endpoints58.endpoints_r_index) AND (field_data_endpoints0.endpoints_r_index != field_data_endpoints60.endpoints_r_index) AND (field_data_endpoints0.endpoints_r_index != field_data_endpoints62.endpoints_r_index) AND (field_data_endpoints0.endpoints_r_index != field_data_endpoints64.endpoints_r_index) AND (field_data_endpoints0.endpoints_r_index != field_data_endpoints66.endpoints_r_index) AND (field_data_endpoints0.endpoints_r_index != field_data_endpoints68.endpoints_r_index) AND (field_data_endpoints0.endpoints_r_index != field_data_endpoints70.endpoints_r_index) AND (field_data_endpoints0.endpoints_r_index != field_data_endpoints72.endpoints_r_index) AND (field_data_endpoints0.endpoints_r_index != field_data_endpoints74.endpoints_r_index) AND (field_data_endpoints0.endpoints_r_index != field_data_endpoints76.endpoints_r_index) AND (field_data_endpoints0.endpoints_r_index != field_data_endpoints78.endpoints_r_index) AND (field_data_endpoints0.endpoints_r_index != field_data_endpoints80.endpoints_r_index) AND (field_data_endpoints2.endpoints_r_index != field_data_endpoints4.endpoints_r_index) AND (field_data_endpoints2.endpoints_r_index != field_data_endpoints6.endpoints_r_index) AND (field_data_endpoints2.endpoints_r_index != field_data_endpoints8.endpoints_r_index) AND (field_data_endpoints2.endpoints_r_index != field_data_endpoints10.endpoints_r_index) AND (field_data_endpoints2.endpoints_r_index != field_data_endpoints12.endpoints_r_index) AND (field_data_endpoints2.endpoints_r_index != field_data_endpoints14.endpoints_r_index) AND (field_data_endpoints2.endpoints_r_index != field_data_endpoints16.endpoints_r_index) AND (field_data_endpoints2.endpoints_r_index != field_data_endpoints18.endpoints_r_index) AND (field_data_endpoints2.endpoints_r_index != field_data_endpoints20.endpoints_r_index) AND (field_data_endpoints2.endpoints_r_index != field_data_endpoints22.endpoints_r_index) AND (field_data_endpoints2.endpoints_r_index != field_data_endpoints24.endpoints_r_index) AND (field_data_endpoints2.endpoints_r_index != field_data_endpoints26.endpoints_r_index) AND (field_data_endpoints2.endpoints_r_index != field_data_endpoints28.endpoints_r_index) AND (field_data_endpoints2.endpoints_r_index != field_data_endpoints30.endpoints_r_index) AND (field_data_endpoints2.endpoints_r_index != field_data_endpoints32.endpoints_r_index) AND (field_data_endpoints2.endpoints_r_index != field_data_endpoints34.endpoints_r_index) AND (field_data_endpoints2.endpoints_r_index != field_data_endpoints36.endpoints_r_index) AND (field_data_endpoints2.endpoints_r_index != field_data_endpoints38.endpoints_r_index) AND (field_data_endpoints2.endpoints_r_index != field_data_endpoints40.endpoints_r_index) AND (field_data_endpoints2.endpoints_r_index != field_data_endpoints42.endpoints_r_index) AND (field_data_endpoints2.endpoints_r_index != field_data_endpoints44.endpoints_r_index) AND (field_data_endpoints2.endpoints_r_index != field_data_endpoints46.endpoints_r_index) AND (field_data_endpoints2.endpoints_r_index != field_data_endpoints48.endpoints_r_index) AND (field_data_endpoints2.endpoints_r_index != field_data_endpoints50.endpoints_r_index) AND (field_data_endpoints2.endpoints_r_index != field_data_endpoints52.endpoints_r_index) AND (field_data_endpoints2.endpoints_r_index != field_data_endpoints54.endpoints_r_index) AND (field_data_endpoints2.endpoints_r_index != field_data_endpoints56.endpoints_r_index) AND (field_data_endpoints2.endpoints_r_index != field_data_endpoints58.endpoints_r_index) AND (field_data_endpoints2.endpoints_r_index != field_data_endpoints60.endpoints_r_index) AND (field_data_endpoints2.endpoints_r_index != field_data_endpoints62.endpoints_r_index) AND (field_data_endpoints2.endpoints_r_index != field_data_endpoints64.endpoints_r_index) AND (field_data_endpoints2.endpoints_r_index != field_data_endpoints66.endpoints_r_index) AND (field_data_endpoints2.endpoints_r_index != field_data_endpoints68.endpoints_r_index) AND (field_data_endpoints2.endpoints_r_index != field_data_endpoints70.endpoints_r_index) AND (field_data_endpoints2.endpoints_r_index != field_data_endpoints72.endpoints_r_index) AND (field_data_endpoints2.endpoints_r_index != field_data_endpoints74.endpoints_r_index) AND (field_data_endpoints2.endpoints_r_index != field_data_endpoints76.endpoints_r_index) AND (field_data_endpoints2.endpoints_r_index != field_data_endpoints78.endpoints_r_index) AND (field_data_endpoints2.endpoints_r_index != field_data_endpoints80.endpoints_r_index) AND (field_data_endpoints4.endpoints_r_index != field_data_endpoints6.endpoints_r_index) AND (field_data_endpoints4.endpoints_r_index != field_data_endpoints8.endpoints_r_index) AND (field_data_endpoints4.endpoints_r_index != field_data_endpoints10.endpoints_r_index) AND (field_data_endpoints4.endpoints_r_index != field_data_endpoints12.endpoints_r_index) AND (field_data_endpoints4.endpoints_r_index != field_data_endpoints14.endpoints_r_index) AND (field_data_endpoints4.endpoints_r_index != field_data_endpoints16.endpoints_r_index) AND (field_data_endpoints4.endpoints_r_index != field_data_endpoints18.endpoints_r_index) AND (field_data_endpoints4.endpoints_r_index != field_data_endpoints20.endpoints_r_index) AND (field_data_endpoints4.endpoints_r_index != field_data_endpoints22.endpoints_r_index) AND (field_data_endpoints4.endpoints_r_index != field_data_endpoints24.endpoints_r_index) AND (field_data_endpoints4.endpoints_r_index != field_data_endpoints26.endpoints_r_index) AND (field_data_endpoints4.endpoints_r_index != field_data_endpoints28.endpoints_r_index) AND (field_data_endpoints4.endpoints_r_index != field_data_endpoints30.endpoints_r_index) AND (field_data_endpoints4.endpoints_r_index != field_data_endpoints32.endpoints_r_index) AND (field_data_endpoints4.endpoints_r_index != field_data_endpoints34.endpoints_r_index) AND (field_data_endpoints4.endpoints_r_index != field_data_endpoints36.endpoints_r_index) AND (field_data_endpoints4.endpoints_r_index != field_data_endpoints38.endpoints_r_index) AND (field_data_endpoints4.endpoints_r_index != field_data_endpoints40.endpoints_r_index) AND (field_data_endpoints4.endpoints_r_index != field_data_endpoints42.endpoints_r_index) AND (field_data_endpoints4.endpoints_r_index != field_data_endpoints44.endpoints_r_index) AND (field_data_endpoints4.endpoints_r_index != field_data_endpoints46.endpoints_r_index) AND (field_data_endpoints4.endpoints_r_index != field_data_endpoints48.endpoints_r_index) AND (field_data_endpoints4.endpoints_r_index != field_data_endpoints50.endpoints_r_index) AND (field_data_endpoints4.endpoints_r_index != field_data_endpoints52.endpoints_r_index) AND (field_data_endpoints4.endpoints_r_index != field_data_endpoints54.endpoints_r_index) AND (field_data_endpoints4.endpoints_r_index != field_data_endpoints56.endpoints_r_index) AND (field_data_endpoints4.endpoints_r_index != field_data_endpoints58.endpoints_r_index) AND (field_data_endpoints4.endpoints_r_index != field_data_endpoints60.endpoints_r_index) AND (field_data_endpoints4.endpoints_r_index != field_data_endpoints62.endpoints_r_index) AND (field_data_endpoints4.endpoints_r_index != field_data_endpoints64.endpoints_r_index) AND (field_data_endpoints4.endpoints_r_index != field_data_endpoints66.endpoints_r_index) AND (field_data_endpoints4.endpoints_r_index != field_data_endpoints68.endpoints_r_index) AND (field_data_endpoints4.endpoints_r_index != field_data_endpoints70.endpoints_r_index) AND (field_data_endpoints4.endpoints_r_index != field_data_endpoints72.endpoints_r_index) AND (field_data_endpoints4.endpoints_r_index != field_data_endpoints74.endpoints_r_index) AND (field_data_endpoints4.endpoints_r_index != field_data_endpoints76.endpoints_r_index) AND (field_data_endpoints4.endpoints_r_index != field_data_endpoints78.endpoints_r_index) AND (field_data_endpoints4.endpoints_r_index != field_data_endpoints80.endpoints_r_index) AND (field_data_endpoints6.endpoints_r_index != field_data_endpoints8.endpoints_r_index) AND (field_data_endpoints6.endpoints_r_index != field_data_endpoints10.endpoints_r_index) AND (field_data_endpoints6.endpoints_r_index != field_data_endpoints12.endpoints_r_index) AND (field_data_endpoints6.endpoints_r_index != field_data_endpoints14.endpoints_r_index) AND (field_data_endpoints6.endpoints_r_index != field_data_endpoints16.endpoints_r_index) AND (field_data_endpoints6.endpoints_r_index != field_data_endpoints18.endpoints_r_index) AND (field_data_endpoints6.endpoints_r_index != field_data_endpoints20.endpoints_r_index) AND (field_data_endpoints6.endpoints_r_index != field_data_endpoints22.endpoints_r_index) AND (field_data_endpoints6.endpoints_r_index != field_data_endpoints24.endpoints_r_index) AND (field_data_endpoints6.endpoints_r_index != field_data_endpoints26.endpoints_r_index) AND (field_data_endpoints6.endpoints_r_index != field_data_endpoints28.endpoints_r_index) AND (field_data_endpoints6.endpoints_r_index != field_data_endpoints30.endpoints_r_index) AND (field_data_endpoints6.endpoints_r_index != field_data_endpoints32.endpoints_r_index) AND (field_data_endpoints6.endpoints_r_index != field_data_endpoints34.endpoints_r_index) AND (field_data_endpoints6.endpoints_r_index != field_data_endpoints36.endpoints_r_index) AND (field_data_endpoints6.endpoints_r_index != field_data_endpoints38.endpoints_r_index) AND (field_data_endpoints6.endpoints_r_index != field_data_endpoints40.endpoints_r_index) AND (field_data_endpoints6.endpoints_r_index != field_data_endpoints42.endpoints_r_index) AND (field_data_endpoints6.endpoints_r_index != field_data_endpoints44.endpoints_r_index) AND (field_data_endpoints6.endpoints_r_index != field_data_endpoints46.endpoints_r_index) AND (field_data_endpoints6.endpoints_r_index != field_data_endpoints48.endpoints_r_index) AND (field_data_endpoints6.endpoints_r_index != field_data_endpoints50.endpoints_r_index) AND (field_data_endpoints6.endpoints_r_index != field_data_endpoints52.endpoints_r_index) AND (field_data_endpoints6.endpoints_r_index != field_data_endpoints54.endpoints_r_index) AND (field_data_endpoints6.endpoints_r_index != field_data_endpoints56.endpoints_r_index) AND (field_data_endpoints6.endpoints_r_index != field_data_endpoints58.endpoints_r_index) AND (field_data_endpoints6.endpoints_r_index != field_data_endpoints60.endpoints_r_index) AND (field_data_endpoints6.endpoints_r_index != field_data_endpoints62.endpoints_r_index) AND (field_data_endpoints6.endpoints_r_index != field_data_endpoints64.endpoints_r_index) AND (field_data_endpoints6.endpoints_r_index != field_data_endpoints66.endpoints_r_index) AND (field_data_endpoints6.endpoints_r_index != field_data_endpoints68.endpoints_r_index) AND (field_data_endpoints6.endpoints_r_index != field_data_endpoints70.endpoints_r_index) AND (field_data_endpoints6.endpoints_r_index != field_data_endpoints72.endpoints_r_index) AND (field_data_endpoints6.endpoints_r_index != field_data_endpoints74.endpoints_r_index) AND (field_data_endpoints6.endpoints_r_index != field_data_endpoints76.endpoints_r_index) AND (field_data_endpoints6.endpoints_r_index != field_data_endpoints78.endpoints_r_index) AND (field_data_endpoints6.endpoints_r_index != field_data_endpoints80.endpoints_r_index) AND (field_data_endpoints8.endpoints_r_index != field_data_endpoints10.endpoints_r_index) AND (field_data_endpoints8.endpoints_r_index != field_data_endpoints12.endpoints_r_index) AND (field_data_endpoints8.endpoints_r_index != field_data_endpoints14.endpoints_r_index) AND (field_data_endpoints8.endpoints_r_index != field_data_endpoints16.endpoints_r_index) AND (field_data_endpoints8.endpoints_r_index != field_data_endpoints18.endpoints_r_index) AND (field_data_endpoints8.endpoints_r_index != field_data_endpoints20.endpoints_r_index) AND (field_data_endpoints8.endpoints_r_index != field_data_endpoints22.endpoints_r_index) AND (field_data_endpoints8.endpoints_r_index != field_data_endpoints24.endpoints_r_index) AND (field_data_endpoints8.endpoints_r_index != field_data_endpoints26.endpoints_r_index) AND (field_data_endpoints8.endpoints_r_index != field_data_endpoints28.endpoints_r_index) AND (field_data_endpoints8.endpoints_r_index != field_data_endpoints30.endpoints_r_index) AND (field_data_endpoints8.endpoints_r_index != field_data_endpoints32.endpoints_r_index) AND (field_data_endpoints8.endpoints_r_index != field_data_endpoints34.endpoints_r_index) AND (field_data_endpoints8.endpoints_r_index != field_data_endpoints36.endpoints_r_index) AND (field_data_endpoints8.endpoints_r_index != field_data_endpoints38.endpoints_r_index) AND (field_data_endpoints8.endpoints_r_index != field_data_endpoints40.endpoints_r_index) AND (field_data_endpoints8.endpoints_r_index != field_data_endpoints42.endpoints_r_index) AND (field_data_endpoints8.endpoints_r_index != field_data_endpoints44.endpoints_r_index) AND (field_data_endpoints8.endpoints_r_index != field_data_endpoints46.endpoints_r_index) AND (field_data_endpoints8.endpoints_r_index != field_data_endpoints48.endpoints_r_index) AND (field_data_endpoints8.endpoints_r_index != field_data_endpoints50.endpoints_r_index) AND (field_data_endpoints8.endpoints_r_index != field_data_endpoints52.endpoints_r_index) AND (field_data_endpoints8.endpoints_r_index != field_data_endpoints54.endpoints_r_index) AND (field_data_endpoints8.endpoints_r_index != field_data_endpoints56.endpoints_r_index) AND (field_data_endpoints8.endpoints_r_index != field_data_endpoints58.endpoints_r_index) AND (field_data_endpoints8.endpoints_r_index != field_data_endpoints60.endpoints_r_index) AND (field_data_endpoints8.endpoints_r_index != field_data_endpoints62.endpoints_r_index) AND (field_data_endpoints8.endpoints_r_index != field_data_endpoints64.endpoints_r_index) AND (field_data_endpoints8.endpoints_r_index != field_data_endpoints66.endpoints_r_index) AND (field_data_endpoints8.endpoints_r_index != field_data_endpoints68.endpoints_r_index) AND (field_data_endpoints8.endpoints_r_index != field_data_endpoints70.endpoints_r_index) AND (field_data_endpoints8.endpoints_r_index != field_data_endpoints72.endpoints_r_index) AND (field_data_endpoints8.endpoints_r_index != field_data_endpoints74.endpoints_r_index) AND (field_data_endpoints8.endpoints_r_index != field_data_endpoints76.endpoints_r_index) AND (field_data_endpoints8.endpoints_r_index != field_data_endpoints78.endpoints_r_index) AND (field_data_endpoints8.endpoints_r_index != field_data_endpoints80.endpoints_r_index) AND (field_data_endpoints10.endpoints_r_index != field_data_endpoints12.endpoints_r_index) AND (field_data_endpoints10.endpoints_r_index != field_data_endpoints14.endpoints_r_index) AND (field_data_endpoints10.endpoints_r_index != field_data_endpoints16.endpoints_r_index) AND (field_data_endpoints10.endpoints_r_index != field_data_endpoints18.endpoints_r_index) AND (field_data_endpoints10.endpoints_r_index != field_data_endpoints20.endpoints_r_index) AND (field_data_endpoints10.endpoints_r_index != field_data_endpoints22.endpoints_r_index) AND (field_data_endpoints10.endpoints_r_index != field_data_endpoints24.endpoints_r_index) AND (field_data_endpoints10.endpoints_r_index != field_data_endpoints26.endpoints_r_index) AND (field_data_endpoints10.endpoints_r_index != field_data_endpoints28.endpoints_r_index) AND (field_data_endpoints10.endpoints_r_index != field_data_endpoints30.endpoints_r_index) AND (field_data_endpoints10.endpoints_r_index != field_data_endpoints32.endpoints_r_index) AND (field_data_endpoints10.endpoints_r_index != field_data_endpoints34.endpoints_r_index) AND (field_data_endpoints10.endpoints_r_index != field_data_endpoints36.endpoints_r_index) AND (field_data_endpoints10.endpoints_r_index != field_data_endpoints38.endpoints_r_index) AND (field_data_endpoints10.endpoints_r_index != field_data_endpoints40.endpoints_r_index) AND (field_data_endpoints10.endpoints_r_index != field_data_endpoints42.endpoints_r_index) AND (field_data_endpoints10.endpoints_r_index != field_data_endpoints44.endpoints_r_index) AND (field_data_endpoints10.endpoints_r_index != field_data_endpoints46.endpoints_r_index) AND (field_data_endpoints10.endpoints_r_index != field_data_endpoints48.endpoints_r_index) AND (field_data_endpoints10.endpoints_r_index != field_data_endpoints50.endpoints_r_index) AND (field_data_endpoints10.endpoints_r_index != field_data_endpoints52.endpoints_r_index) AND (field_data_endpoints10.endpoints_r_index != field_data_endpoints54.endpoints_r_index) AND (field_data_endpoints10.endpoints_r_index != field_data_endpoints56.endpoints_r_index) AND (field_data_endpoints10.endpoints_r_index != field_data_endpoints58.endpoints_r_index) AND (field_data_endpoints10.endpoints_r_index != field_data_endpoints60.endpoints_r_index) AND (field_data_endpoints10.endpoints_r_index != field_data_endpoints62.endpoints_r_index) AND (field_data_endpoints10.endpoints_r_index != field_data_endpoints64.endpoints_r_index) AND (field_data_endpoints10.endpoints_r_index != field_data_endpoints66.endpoints_r_index) AND (field_data_endpoints10.endpoints_r_index != field_data_endpoints68.endpoints_r_index) AND (field_data_endpoints10.endpoints_r_index != field_data_endpoints70.endpoints_r_index) AND (field_data_endpoints10.endpoints_r_index != field_data_endpoints72.endpoints_r_index) AND (field_data_endpoints10.endpoints_r_index != field_data_endpoints74.endpoints_r_index) AND (field_data_endpoints10.endpoints_r_index != field_data_endpoints76.endpoints_r_index) AND (field_data_endpoints10.endpoints_r_index != field_data_endpoints78.endpoints_r_index) AND (field_data_endpoints10.endpoints_r_index != field_data_endpoints80.endpoints_r_index) AND (field_data_endpoints12.endpoints_r_index != field_data_endpoints14.endpoints_r_index) AND (field_data_endpoints12.endpoints_r_index != field_data_endpoints16.endpoints_r_index) AND (field_data_endpoints12.endpoints_r_index != field_data_endpoints18.endpoints_r_index) AND (field_data_endpoints12.endpoints_r_index != field_data_endpoints20.endpoints_r_index) AND (field_data_endpoints12.endpoints_r_index != field_data_endpoints22.endpoints_r_index) AND (field_data_endpoints12.endpoints_r_index != field_data_endpoints24.endpoints_r_index) AND (field_data_endpoints12.endpoints_r_index != field_data_endpoints26.endpoints_r_index) AND (field_data_endpoints12.endpoints_r_index != field_data_endpoints28.endpoints_r_index) AND (field_data_endpoints12.endpoints_r_index != field_data_endpoints30.endpoints_r_index) AND (field_data_endpoints12.endpoints_r_index != field_data_endpoints32.endpoints_r_index) AND (field_data_endpoints12.endpoints_r_index != field_data_endpoints34.endpoints_r_index) AND (field_data_endpoints12.endpoints_r_index != field_data_endpoints36.endpoints_r_index) AND (field_data_endpoints12.endpoints_r_index != field_data_endpoints38.endpoints_r_index) AND (field_data_endpoints12.endpoints_r_index != field_data_endpoints40.endpoints_r_index) AND (field_data_endpoints12.endpoints_r_index != field_data_endpoints42.endpoints_r_index) AND (field_data_endpoints12.endpoints_r_index != field_data_endpoints44.endpoints_r_index) AND (field_data_endpoints12.endpoints_r_index != field_data_endpoints46.endpoints_r_index) AND (field_data_endpoints12.endpoints_r_index != field_data_endpoints48.endpoints_r_index) AND (field_data_endpoints12.endpoints_r_index != field_data_endpoints50.endpoints_r_index) AND (field_data_endpoints12.endpoints_r_index != field_data_endpoints52.endpoints_r_index) AND (field_data_endpoints12.endpoints_r_index != field_data_endpoints54.endpoints_r_index) AND (field_data_endpoints12.endpoints_r_index != field_data_endpoints56.endpoints_r_index) AND (field_data_endpoints12.endpoints_r_index != field_data_endpoints58.endpoints_r_index) AND (field_data_endpoints12.endpoints_r_index != field_data_endpoints60.endpoints_r_index) AND (field_data_endpoints12.endpoints_r_index != field_data_endpoints62.endpoints_r_index) AND (field_data_endpoints12.endpoints_r_index != field_data_endpoints64.endpoints_r_index) AND (field_data_endpoints12.endpoints_r_index != field_data_endpoints66.endpoints_r_index) AND (field_data_endpoints12.endpoints_r_index != field_data_endpoints68.endpoints_r_index) AND (field_data_endpoints12.endpoints_r_index != field_data_endpoints70.endpoints_r_index) AND (field_data_endpoints12.endpoints_r_index != field_data_endpoints72.endpoints_r_index) AND (field_data_endpoints12.endpoints_r_index != field_data_endpoints74.endpoints_r_index) AND (field_data_endpoints12.endpoints_r_index != field_data_endpoints76.endpoints_r_index) AND (field_data_endpoints12.endpoints_r_index != field_data_endpoints78.endpoints_r_index) AND (field_data_endpoints12.endpoints_r_index != field_data_endpoints80.endpoints_r_index) AND (field_data_endpoints14.endpoints_r_index != field_data_endpoints16.endpoints_r_index) AND (field_data_endpoints14.endpoints_r_index != field_data_endpoints18.endpoints_r_index) AND (field_data_endpoints14.endpoints_r_index != field_data_endpoints20.endpoints_r_index) AND (field_data_endpoints14.endpoints_r_index != field_data_endpoints22.endpoints_r_index) AND (field_data_endpoints14.endpoints_r_index != field_data_endpoints24.endpoints_r_index) AND (field_data_endpoints14.endpoints_r_index != field_data_endpoints26.endpoints_r_index) AND (field_data_endpoints14.endpoints_r_index != field_data_endpoints28.endpoints_r_index) AND (field_data_endpoints14.endpoints_r_index != field_data_endpoints30.endpoints_r_index) AND (field_data_endpoints14.endpoints_r_index != field_data_endpoints32.endpoints_r_index) AND (field_data_endpoints14.endpoints_r_index != field_data_endpoints34.endpoints_r_index) AND (field_data_endpoints14.endpoints_r_index != field_data_endpoints36.endpoints_r_index) AND (field_data_endpoints14.endpoints_r_index != field_data_endpoints38.endpoints_r_index) AND (field_data_endpoints14.endpoints_r_index != field_data_endpoints40.endpoints_r_index) AND (field_data_endpoints14.endpoints_r_index != field_data_endpoints42.endpoints_r_index) AND (field_data_endpoints14.endpoints_r_index != field_data_endpoints44.endpoints_r_index) AND (field_data_endpoints14.endpoints_r_index != field_data_endpoints46.endpoints_r_index) AND (field_data_endpoints14.endpoints_r_index != field_data_endpoints48.endpoints_r_index) AND (field_data_endpoints14.endpoints_r_index != field_data_endpoints50.endpoints_r_index) AND (field_data_endpoints14.endpoints_r_index != field_data_endpoints52.endpoints_r_index) AND (field_data_endpoints14.endpoints_r_index != field_data_endpoints54.endpoints_r_index) AND (field_data_endpoints14.endpoints_r_index != field_data_endpoints56.endpoints_r_index) AND (field_data_endpoints14.endpoints_r_index != field_data_endpoints58.endpoints_r_index) AND (field_data_endpoints14.endpoints_r_index != field_data_endpoints60.endpoints_r_index) AND (field_data_endpoints14.endpoints_r_index != field_data_endpoints62.endpoints_r_index) AND (field_data_endpoints14.endpoints_r_index != field_data_endpoints64.endpoints_r_index) AND (field_data_endpoints14.endpoints_r_index != field_data_endpoints66.endpoints_r_index) AND (field_data_endpoints14.endpoints_r_index != field_data_endpoints68.endpoints_r_index) AND (field_data_endpoints14.endpoints_r_index != field_data_endpoints70.endpoints_r_index) AND (field_data_endpoints14.endpoints_r_index != field_data_endpoints72.endpoints_r_index) AND (field_data_endpoints14.endpoints_r_index != field_data_endpoints74.endpoints_r_index) AND (field_data_endpoints14.endpoints_r_index != field_data_endpoints76.endpoints_r_index) AND (field_data_endpoints14.endpoints_r_index != field_data_endpoints78.endpoints_r_index) AND (field_data_endpoints14.endpoints_r_index != field_data_endpoints80.endpoints_r_index) AND (field_data_endpoints16.endpoints_r_index != field_data_endpoints18.endpoints_r_index) AND (field_data_endpoints16.endpoints_r_index != field_data_endpoints20.endpoints_r_index) AND (field_data_endpoints16.endpoints_r_index != field_data_endpoints22.endpoints_r_index) AND (field_data_endpoints16.endpoints_r_index != field_data_endpoints24.endpoints_r_index) AND (field_data_endpoints16.endpoints_r_index != field_data_endpoints26.endpoints_r_index) AND (field_data_endpoints16.endpoints_r_index != field_data_endpoints28.endpoints_r_index) AND (field_data_endpoints16.endpoints_r_index != field_data_endpoints30.endpoints_r_index) AND (field_data_endpoints16.endpoints_r_index != field_data_endpoints32.endpoints_r_index) AND (field_data_endpoints16.endpoints_r_index != field_data_endpoints34.endpoints_r_index) AND (field_data_endpoints16.endpoints_r_index != field_data_endpoints36.endpoints_r_index) AND (field_data_endpoints16.endpoints_r_index != field_data_endpoints38.endpoints_r_index) AND (field_data_endpoints16.endpoints_r_index != field_data_endpoints40.endpoints_r_index) AND (field_data_endpoints16.endpoints_r_index != field_data_endpoints42.endpoints_r_index) AND (field_data_endpoints16.endpoints_r_index != field_data_endpoints44.endpoints_r_index) AND (field_data_endpoints16.endpoints_r_index != field_data_endpoints46.endpoints_r_index) AND (field_data_endpoints16.endpoints_r_index != field_data_endpoints48.endpoints_r_index) AND (field_data_endpoints16.endpoints_r_index != field_data_endpoints50.endpoints_r_index) AND (field_data_endpoints16.endpoints_r_index != field_data_endpoints52.endpoints_r_index) AND (field_data_endpoints16.endpoints_r_index != field_data_endpoints54.endpoints_r_index) AND (field_data_endpoints16.endpoints_r_index != field_data_endpoints56.endpoints_r_index) AND (field_data_endpoints16.endpoints_r_index != field_data_endpoints58.endpoints_r_index) AND (field_data_endpoints16.endpoints_r_index != field_data_endpoints60.endpoints_r_index) AND (field_data_endpoints16.endpoints_r_index != field_data_endpoints62.endpoints_r_index) AND (field_data_endpoints16.endpoints_r_index != field_data_endpoints64.endpoints_r_index) AND (field_data_endpoints16.endpoints_r_index != field_data_endpoints66.endpoints_r_index) AND (field_data_endpoints16.endpoints_r_index != field_data_endpoints68.endpoints_r_index) AND (field_data_endpoints16.endpoints_r_index != field_data_endpoints70.endpoints_r_index) AND (field_data_endpoints16.endpoints_r_index != field_data_endpoints72.endpoints_r_index) AND (field_data_endpoints16.endpoints_r_index != field_data_endpoints74.endpoints_r_index) AND (field_data_endpoints16.endpoints_r_index != field_data_endpoints76.endpoints_r_index) AND (field_data_endpoints16.endpoints_r_index != field_data_endpoints78.endpoints_r_index) AND (field_data_endpoints16.endpoints_r_index != field_data_endpoints80.endpoints_r_index) AND (field_data_endpoints18.endpoints_r_index != field_data_endpoints20.endpoints_r_index) AND (field_data_endpoints18.endpoints_r_index != field_data_endpoints22.endpoints_r_index) AND (field_data_endpoints18.endpoints_r_index != field_data_endpoints24.endpoints_r_index) AND (field_data_endpoints18.endpoints_r_index != field_data_endpoints26.endpoints_r_index) AND (field_data_endpoints18.endpoints_r_index != field_data_endpoints28.endpoints_r_index) AND (field_data_endpoints18.endpoints_r_index != field_data_endpoints30.endpoints_r_index) AND (field_data_endpoints18.endpoints_r_index != field_data_endpoints32.endpoints_r_index) AND (field_data_endpoints18.endpoints_r_index != field_data_endpoints34.endpoints_r_index) AND (field_data_endpoints18.endpoints_r_index != field_data_endpoints36.endpoints_r_index) AND (field_data_endpoints18.endpoints_r_index != field_data_endpoints38.endpoints_r_index) AND (field_data_endpoints18.endpoints_r_index != field_data_endpoints40.endpoints_r_index) AND (field_data_endpoints18.endpoints_r_index != field_data_endpoints42.endpoints_r_index) AND (field_data_endpoints18.endpoints_r_index != field_data_endpoints44.endpoints_r_index) AND (field_data_endpoints18.endpoints_r_index != field_data_endpoints46.endpoints_r_index) AND (field_data_endpoints18.endpoints_r_index != field_data_endpoints48.endpoints_r_index) AND (field_data_endpoints18.endpoints_r_index != field_data_endpoints50.endpoints_r_index) AND (field_data_endpoints18.endpoints_r_index != field_data_endpoints52.endpoints_r_index) AND (field_data_endpoints18.endpoints_r_index != field_data_endpoints54.endpoints_r_index) AND (field_data_endpoints18.endpoints_r_index != field_data_endpoints56.endpoints_r_index) AND (field_data_endpoints18.endpoints_r_index != field_data_endpoints58.endpoints_r_index) AND (field_data_endpoints18.endpoints_r_index != field_data_endpoints60.endpoints_r_index) AND (field_data_endpoints18.endpoints_r_index != field_data_endpoints62.endpoints_r_index) AND (field_data_endpoints18.endpoints_r_index != field_data_endpoints64.endpoints_r_index) AND (field_data_endpoints18.endpoints_r_index != field_data_endpoints66.endpoints_r_index) AND (field_data_endpoints18.endpoints_r_index != field_data_endpoints68.endpoints_r_index) AND (field_data_endpoints18.endpoints_r_index != field_data_endpoints70.endpoints_r_index) AND (field_data_endpoints18.endpoints_r_index != field_data_endpoints72.endpoints_r_index) AND (field_data_endpoints18.endpoints_r_index != field_data_endpoints74.endpoints_r_index) AND (field_data_endpoints18.endpoints_r_index != field_data_endpoints76.endpoints_r_index) AND (field_data_endpoints18.endpoints_r_index != field_data_endpoints78.endpoints_r_index) AND (field_data_endpoints18.endpoints_r_index != field_data_endpoints80.endpoints_r_index) AND (field_data_endpoints20.endpoints_r_index != field_data_endpoints22.endpoints_r_index) AND (field_data_endpoints20.endpoints_r_index != field_data_endpoints24.endpoints_r_index) AND (field_data_endpoints20.endpoints_r_index != field_data_endpoints26.endpoints_r_index) AND (field_data_endpoints20.endpoints_r_index != field_data_endpoints28.endpoints_r_index) AND (field_data_endpoints20.endpoints_r_index != field_data_endpoints30.endpoints_r_index) AND (field_data_endpoints20.endpoints_r_index != field_data_endpoints32.endpoints_r_index) AND (field_data_endpoints20.endpoints_r_index != field_data_endpoints34.endpoints_r_index) AND (field_data_endpoints20.endpoints_r_index != field_data_endpoints36.endpoints_r_index) AND (field_data_endpoints20.endpoints_r_index != field_data_endpoints38.endpoints_r_index) AND (field_data_endpoints20.endpoints_r_index != field_data_endpoints40.endpoints_r_index) AND (field_data_endpoints20.endpoints_r_index != field_data_endpoints42.endpoints_r_index) AND (field_data_endpoints20.endpoints_r_index != field_data_endpoints44.endpoints_r_index) AND (field_data_endpoints20.endpoints_r_index != field_data_endpoints46.endpoints_r_index) AND (field_data_endpoints20.endpoints_r_index != field_data_endpoints48.endpoints_r_index) AND (field_data_endpoints20.endpoints_r_index != field_data_endpoints50.endpoints_r_index) AND (field_data_endpoints20.endpoints_r_index != field_data_endpoints52.endpoints_r_index) AND (field_data_endpoints20.endpoints_r_index != field_data_endpoints54.endpoints_r_index) AND (field_data_endpoints20.endpoints_r_index != field_data_endpoints56.endpoints_r_index) AND (field_data_endpoints20.endpoints_r_index != field_data_endpoints58.endpoints_r_index) AND (field_data_endpoints20.endpoints_r_index != field_data_endpoints60.endpoints_r_index) AND (field_data_endpoints20.endpoints_r_index != field_data_endpoints62.endpoints_r_index) AND (field_data_endpoints20.endpoints_r_index != field_data_endpoints64.endpoints_r_index) AND (field_data_endpoints20.endpoints_r_index != field_data_endpoints66.endpoints_r_index) AND (field_data_endpoints20.endpoints_r_index != field_data_endpoints68.endpoints_r_index) AND (field_data_endpoints20.endpoints_r_index != field_data_endpoints70.endpoints_r_index) AND (field_data_endpoints20.endpoints_r_index != field_data_endpoints72.endpoints_r_index) AND (field_data_endpoints20.endpoints_r_index != field_data_endpoints74.endpoints_r_index) AND (field_data_endpoints20.endpoints_r_index != field_data_endpoints76.endpoints_r_index) AND (field_data_endpoints20.endpoints_r_index != field_data_endpoints78.endpoints_r_index) AND (field_data_endpoints20.endpoints_r_index != field_data_endpoints80.endpoints_r_index) AND (field_data_endpoints22.endpoints_r_index != field_data_endpoints24.endpoints_r_index) AND (field_data_endpoints22.endpoints_r_index != field_data_endpoints26.endpoints_r_index) AND (field_data_endpoints22.endpoints_r_index != field_data_endpoints28.endpoints_r_index) AND (field_data_endpoints22.endpoints_r_index != field_data_endpoints30.endpoints_r_index) AND (field_data_endpoints22.endpoints_r_index != field_data_endpoints32.endpoints_r_index) AND (field_data_endpoints22.endpoints_r_index != field_data_endpoints34.endpoints_r_index) AND (field_data_endpoints22.endpoints_r_index != field_data_endpoints36.endpoints_r_index) AND (field_data_endpoints22.endpoints_r_index != field_data_endpoints38.endpoints_r_index) AND (field_data_endpoints22.endpoints_r_index != field_data_endpoints40.endpoints_r_index) AND (field_data_endpoints22.endpoints_r_index != field_data_endpoints42.endpoints_r_index) AND (field_data_endpoints22.endpoints_r_index != field_data_endpoints44.endpoints_r_index) AND (field_data_endpoints22.endpoints_r_index != field_data_endpoints46.endpoints_r_index) AND (field_data_endpoints22.endpoints_r_index != field_data_endpoints48.endpoints_r_index) AND (field_data_endpoints22.endpoints_r_index != field_data_endpoints50.endpoints_r_index) AND (field_data_endpoints22.endpoints_r_index != field_data_endpoints52.endpoints_r_index) AND (field_data_endpoints22.endpoints_r_index != field_data_endpoints54.endpoints_r_index) AND (field_data_endpoints22.endpoints_r_index != field_data_endpoints56.endpoints_r_index) AND (field_data_endpoints22.endpoints_r_index != field_data_endpoints58.endpoints_r_index) AND (field_data_endpoints22.endpoints_r_index != field_data_endpoints60.endpoints_r_index) AND (field_data_endpoints22.endpoints_r_index != field_data_endpoints62.endpoints_r_index) AND (field_data_endpoints22.endpoints_r_index != field_data_endpoints64.endpoints_r_index) AND (field_data_endpoints22.endpoints_r_index != field_data_endpoints66.endpoints_r_index) AND (field_data_endpoints22.endpoints_r_index != field_data_endpoints68.endpoints_r_index) AND (field_data_endpoints22.endpoints_r_index != field_data_endpoints70.endpoints_r_index) AND (field_data_endpoints22.endpoints_r_index != field_data_endpoints72.endpoints_r_index) AND (field_data_endpoints22.endpoints_r_index != field_data_endpoints74.endpoints_r_index) AND (field_data_endpoints22.endpoints_r_index != field_data_endpoints76.endpoints_r_index) AND (field_data_endpoints22.endpoints_r_index != field_data_endpoints78.endpoints_r_index) AND (field_data_endpoints22.endpoints_r_index != field_data_endpoints80.endpoints_r_index) AND (field_data_endpoints24.endpoints_r_index != field_data_endpoints26.endpoints_r_index) AND (field_data_endpoints24.endpoints_r_index != field_data_endpoints28.endpoints_r_index) AND (field_data_endpoints24.endpoints_r_index != field_data_endpoints30.endpoints_r_index) AND (field_data_endpoints24.endpoints_r_index != field_data_endpoints32.endpoints_r_index) AND (field_data_endpoints24.endpoints_r_index != field_data_endpoints34.endpoints_r_index) AND (field_data_endpoints24.endpoints_r_index != field_data_endpoints36.endpoints_r_index) AND (field_data_endpoints24.endpoints_r_index != field_data_endpoints38.endpoints_r_index) AND (field_data_endpoints24.endpoints_r_index != field_data_endpoints40.endpoints_r_index) AND (field_data_endpoints24.endpoints_r_index != field_data_endpoints42.endpoints_r_index) AND (field_data_endpoints24.endpoints_r_index != field_data_endpoints44.endpoints_r_index) AND (field_data_endpoints24.endpoints_r_index != field_data_endpoints46.endpoints_r_index) AND (field_data_endpoints24.endpoints_r_index != field_data_endpoints48.endpoints_r_index) AND (field_data_endpoints24.endpoints_r_index != field_data_endpoints50.endpoints_r_index) AND (field_data_endpoints24.endpoints_r_index != field_data_endpoints52.endpoints_r_index) AND (field_data_endpoints24.endpoints_r_index != field_data_endpoints54.endpoints_r_index) AND (field_data_endpoints24.endpoints_r_index != field_data_endpoints56.endpoints_r_index) AND (field_data_endpoints24.endpoints_r_index != field_data_endpoints58.endpoints_r_index) AND (field_data_endpoints24.endpoints_r_index != field_data_endpoints60.endpoints_r_index) AND (field_data_endpoints24.endpoints_r_index != field_data_endpoints62.endpoints_r_index) AND (field_data_endpoints24.endpoints_r_index != field_data_endpoints64.endpoints_r_index) AND (field_data_endpoints24.endpoints_r_index != field_data_endpoints66.endpoints_r_index) AND (field_data_endpoints24.endpoints_r_index != field_data_endpoints68.endpoints_r_index) AND (field_data_endpoints24.endpoints_r_index != field_data_endpoints70.endpoints_r_index) AND (field_data_endpoints24.endpoints_r_index != field_data_endpoints72.endpoints_r_index) AND (field_data_endpoints24.endpoints_r_index != field_data_endpoints74.endpoints_r_index) AND (field_data_endpoints24.endpoints_r_index != field_data_endpoints76.endpoints_r_index) AND (field_data_endpoints24.endpoints_r_index != field_data_endpoints78.endpoints_r_index) AND (field_data_endpoints24.endpoints_r_index != field_data_endpoints80.endpoints_r_index) AND (field_data_endpoints26.endpoints_r_index != field_data_endpoints28.endpoints_r_index) AND (field_data_endpoints26.endpoints_r_index != field_data_endpoints30.endpoints_r_index) AND (field_data_endpoints26.endpoints_r_index != field_data_endpoints32.endpoints_r_index) AND (field_data_endpoints26.endpoints_r_index != field_data_endpoints34.endpoints_r_index) AND (field_data_endpoints26.endpoints_r_index != field_data_endpoints36.endpoints_r_index) AND (field_data_endpoints26.endpoints_r_index != field_data_endpoints38.endpoints_r_index) AND (field_data_endpoints26.endpoints_r_index != field_data_endpoints40.endpoints_r_index) AND (field_data_endpoints26.endpoints_r_index != field_data_endpoints42.endpoints_r_index) AND (field_data_endpoints26.endpoints_r_index != field_data_endpoints44.endpoints_r_index) AND (field_data_endpoints26.endpoints_r_index != field_data_endpoints46.endpoints_r_index) AND (field_data_endpoints26.endpoints_r_index != field_data_endpoints48.endpoints_r_index) AND (field_data_endpoints26.endpoints_r_index != field_data_endpoints50.endpoints_r_index) AND (field_data_endpoints26.endpoints_r_index != field_data_endpoints52.endpoints_r_index) AND (field_data_endpoints26.endpoints_r_index != field_data_endpoints54.endpoints_r_index) AND (field_data_endpoints26.endpoints_r_index != field_data_endpoints56.endpoints_r_index) AND (field_data_endpoints26.endpoints_r_index != field_data_endpoints58.endpoints_r_index) AND (field_data_endpoints26.endpoints_r_index != field_data_endpoints60.endpoints_r_index) AND (field_data_endpoints26.endpoints_r_index != field_data_endpoints62.endpoints_r_index) AND (field_data_endpoints26.endpoints_r_index != field_data_endpoints64.endpoints_r_index) AND (field_data_endpoints26.endpoints_r_index != field_data_endpoints66.endpoints_r_index) AND (field_data_endpoints26.endpoints_r_index != field_data_endpoints68.endpoints_r_index) AND (field_data_endpoints26.endpoints_r_index != field_data_endpoints70.endpoints_r_index) AND (field_data_endpoints26.endpoints_r_index != field_data_endpoints72.endpoints_r_index) AND (field_data_endpoints26.endpoints_r_index != field_data_endpoints74.endpoints_r_index) AND (field_data_endpoints26.endpoints_r_index != field_data_endpoints76.endpoints_r_index) AND (field_data_endpoints26.endpoints_r_index != field_data_endpoints78.endpoints_r_index) AND (field_data_endpoints26.endpoints_r_index != field_data_endpoints80.endpoints_r_index) AND (field_data_endpoints28.endpoints_r_index != field_data_endpoints30.endpoints_r_index) AND (field_data_endpoints28.endpoints_r_index != field_data_endpoints32.endpoints_r_index) AND (field_data_endpoints28.endpoints_r_index != field_data_endpoints34.endpoints_r_index) AND (field_data_endpoints28.endpoints_r_index != field_data_endpoints36.endpoints_r_index) AND (field_data_endpoints28.endpoints_r_index != field_data_endpoints38.endpoints_r_index) AND (field_data_endpoints28.endpoints_r_index != field_data_endpoints40.endpoints_r_index) AND (field_data_endpoints28.endpoints_r_index != field_data_endpoints42.endpoints_r_index) AND (field_data_endpoints28.endpoints_r_index != field_data_endpoints44.endpoints_r_index) AND (field_data_endpoints28.endpoints_r_index != field_data_endpoints46.endpoints_r_index) AND (field_data_endpoints28.endpoints_r_index != field_data_endpoints48.endpoints_r_index) AND (field_data_endpoints28.endpoints_r_index != field_data_endpoints50.endpoints_r_index) AND (field_data_endpoints28.endpoints_r_index != field_data_endpoints52.endpoints_r_index) AND (field_data_endpoints28.endpoints_r_index != field_data_endpoints54.endpoints_r_index) AND (field_data_endpoints28.endpoints_r_index != field_data_endpoints56.endpoints_r_index) AND (field_data_endpoints28.endpoints_r_index != field_data_endpoints58.endpoints_r_index) AND (field_data_endpoints28.endpoints_r_index != field_data_endpoints60.endpoints_r_index) AND (field_data_endpoints28.endpoints_r_index != field_data_endpoints62.endpoints_r_index) AND (field_data_endpoints28.endpoints_r_index != field_data_endpoints64.endpoints_r_index) AND (field_data_endpoints28.endpoints_r_index != field_data_endpoints66.endpoints_r_index) AND (field_data_endpoints28.endpoints_r_index != field_data_endpoints68.endpoints_r_index) AND (field_data_endpoints28.endpoints_r_index != field_data_endpoints70.endpoints_r_index) AND (field_data_endpoints28.endpoints_r_index != field_data_endpoints72.endpoints_r_index) AND (field_data_endpoints28.endpoints_r_index != field_data_endpoints74.endpoints_r_index) AND (field_data_endpoints28.endpoints_r_index != field_data_endpoints76.endpoints_r_index) AND (field_data_endpoints28.endpoints_r_index != field_data_endpoints78.endpoints_r_index) AND (field_data_endpoints28.endpoints_r_index != field_data_endpoints80.endpoints_r_index) AND (field_data_endpoints30.endpoints_r_index != field_data_endpoints32.endpoints_r_index) AND (field_data_endpoints30.endpoints_r_index != field_data_endpoints34.endpoints_r_index) AND (field_data_endpoints30.endpoints_r_index != field_data_endpoints36.endpoints_r_index) AND (field_data_endpoints30.endpoints_r_index != field_data_endpoints38.endpoints_r_index) AND (field_data_endpoints30.endpoints_r_index != field_data_endpoints40.endpoints_r_index) AND (field_data_endpoints30.endpoints_r_index != field_data_endpoints42.endpoints_r_index) AND (field_data_endpoints30.endpoints_r_index != field_data_endpoints44.endpoints_r_index) AND (field_data_endpoints30.endpoints_r_index != field_data_endpoints46.endpoints_r_index) AND (field_data_endpoints30.endpoints_r_index != field_data_endpoints48.endpoints_r_index) AND (field_data_endpoints30.endpoints_r_index != field_data_endpoints50.endpoints_r_index) AND (field_data_endpoints30.endpoints_r_index != field_data_endpoints52.endpoints_r_index) AND (field_data_endpoints30.endpoints_r_index != field_data_endpoints54.endpoints_r_index) AND (field_data_endpoints30.endpoints_r_index != field_data_endpoints56.endpoints_r_index) AND (field_data_endpoints30.endpoints_r_index != field_data_endpoints58.endpoints_r_index) AND (field_data_endpoints30.endpoints_r_index != field_data_endpoints60.endpoints_r_index) AND (field_data_endpoints30.endpoints_r_index != field_data_endpoints62.endpoints_r_index) AND (field_data_endpoints30.endpoints_r_index != field_data_endpoints64.endpoints_r_index) AND (field_data_endpoints30.endpoints_r_index != field_data_endpoints66.endpoints_r_index) AND (field_data_endpoints30.endpoints_r_index != field_data_endpoints68.endpoints_r_index) AND (field_data_endpoints30.endpoints_r_index != field_data_endpoints70.endpoints_r_index) AND (field_data_endpoints30.endpoints_r_index != field_data_endpoints72.endpoints_r_index) AND (field_data_endpoints30.endpoints_r_index != field_data_endpoints74.endpoints_r_index) AND (field_data_endpoints30.endpoints_r_index != field_data_endpoints76.endpoints_r_index) AND (field_data_endpoints30.endpoints_r_index != field_data_endpoints78.endpoints_r_index) AND (field_data_endpoints30.endpoints_r_index != field_data_endpoints80.endpoints_r_index) AND (field_data_endpoints32.endpoints_r_index != field_data_endpoints34.endpoints_r_index) AND (field_data_endpoints32.endpoints_r_index != field_data_endpoints36.endpoints_r_index) AND (field_data_endpoints32.endpoints_r_index != field_data_endpoints38.endpoints_r_index) AND (field_data_endpoints32.endpoints_r_index != field_data_endpoints40.endpoints_r_index) AND (field_data_endpoints32.endpoints_r_index != field_data_endpoints42.endpoints_r_index) AND (field_data_endpoints32.endpoints_r_index != field_data_endpoints44.endpoints_r_index) AND (field_data_endpoints32.endpoints_r_index != field_data_endpoints46.endpoints_r_index) AND (field_data_endpoints32.endpoints_r_index != field_data_endpoints48.endpoints_r_index) AND (field_data_endpoints32.endpoints_r_index != field_data_endpoints50.endpoints_r_index) AND (field_data_endpoints32.endpoints_r_index != field_data_endpoints52.endpoints_r_index) AND (field_data_endpoints32.endpoints_r_index != field_data_endpoints54.endpoints_r_index) AND (field_data_endpoints32.endpoints_r_index != field_data_endpoints56.endpoints_r_index) AND (field_data_endpoints32.endpoints_r_index != field_data_endpoints58.endpoints_r_index) AND (field_data_endpoints32.endpoints_r_index != field_data_endpoints60.endpoints_r_index) AND (field_data_endpoints32.endpoints_r_index != field_data_endpoints62.endpoints_r_index) AND (field_data_endpoints32.endpoints_r_index != field_data_endpoints64.endpoints_r_index) AND (field_data_endpoints32.endpoints_r_index != field_data_endpoints66.endpoints_r_index) AND (field_data_endpoints32.endpoints_r_index != field_data_endpoints68.endpoints_r_index) AND (field_data_endpoints32.endpoints_r_index != field_data_endpoints70.endpoints_r_index) AND (field_data_endpoints32.endpoints_r_index != field_data_endpoints72.endpoints_r_index) AND (field_data_endpoints32.endpoints_r_index != field_data_endpoints74.endpoints_r_index) AND (field_data_endpoints32.endpoints_r_index != field_data_endpoints76.endpoints_r_index) AND (field_data_endpoints32.endpoints_r_index != field_data_endpoints78.endpoints_r_index) AND (field_data_endpoints32.endpoints_r_index != field_data_endpoints80.endpoints_r_index) AND (field_data_endpoints34.endpoints_r_index != field_data_endpoints36.endpoints_r_index) AND (field_data_endpoints34.endpoints_r_index != field_data_endpoints38.endpoints_r_index) AND (field_data_endpoints34.endpoints_r_index != field_data_endpoints40.endpoints_r_index) AND (field_data_endpoints34.endpoints_r_index != field_data_endpoints42.endpoints_r_index) AND (field_data_endpoints34.endpoints_r_index != field_data_endpoints44.endpoints_r_index) AND (field_data_endpoints34.endpoints_r_index != field_data_endpoints46.endpoints_r_index) AND (field_data_endpoints34.endpoints_r_index != field_data_endpoints48.endpoints_r_index) AND (field_data_endpoints34.endpoints_r_index != field_data_endpoints50.endpoints_r_index) AND (field_data_endpoints34.endpoints_r_index != field_data_endpoints52.endpoints_r_index) AND (field_data_endpoints34.endpoints_r_index != field_data_endpoints54.endpoints_r_index) AND (field_data_endpoints34.endpoints_r_index != field_data_endpoints56.endpoints_r_index) AND (field_data_endpoints34.endpoints_r_index != field_data_endpoints58.endpoints_r_index) AND (field_data_endpoints34.endpoints_r_index != field_data_endpoints60.endpoints_r_index) AND (field_data_endpoints34.endpoints_r_index != field_data_endpoints62.endpoints_r_index) AND (field_data_endpoints34.endpoints_r_index != field_data_endpoints64.endpoints_r_index) AND (field_data_endpoints34.endpoints_r_index != field_data_endpoints66.endpoints_r_index) AND (field_data_endpoints34.endpoints_r_index != field_data_endpoints68.endpoints_r_index) AND (field_data_endpoints34.endpoints_r_index != field_data_endpoints70.endpoints_r_index) AND (field_data_endpoints34.endpoints_r_index != field_data_endpoints72.endpoints_r_index) AND (field_data_endpoints34.endpoints_r_index != field_data_endpoints74.endpoints_r_index) AND (field_data_endpoints34.endpoints_r_index != field_data_endpoints76.endpoints_r_index) AND (field_data_endpoints34.endpoints_r_index != field_data_endpoints78.endpoints_r_index) AND (field_data_endpoints34.endpoints_r_index != field_data_endpoints80.endpoints_r_index) AND (field_data_endpoints36.endpoints_r_index != field_data_endpoints38.endpoints_r_index) AND (field_data_endpoints36.endpoints_r_index != field_data_endpoints40.endpoints_r_index) AND (field_data_endpoints36.endpoints_r_index != field_data_endpoints42.endpoints_r_index) AND (field_data_endpoints36.endpoints_r_index != field_data_endpoints44.endpoints_r_index) AND (field_data_endpoints36.endpoints_r_index != field_data_endpoints46.endpoints_r_index) AND (field_data_endpoints36.endpoints_r_index != field_data_endpoints48.endpoints_r_index) AND (field_data_endpoints36.endpoints_r_index != field_data_endpoints50.endpoints_r_index) AND (field_data_endpoints36.endpoints_r_index != field_data_endpoints52.endpoints_r_index) AND (field_data_endpoints36.endpoints_r_index != field_data_endpoints54.endpoints_r_index) AND (field_data_endpoints36.endpoints_r_index != field_data_endpoints56.endpoints_r_index) AND (field_data_endpoints36.endpoints_r_index != field_data_endpoints58.endpoints_r_index) AND (field_data_endpoints36.endpoints_r_index != field_data_endpoints60.endpoints_r_index) AND (field_data_endpoints36.endpoints_r_index != field_data_endpoints62.endpoints_r_index) AND (field_data_endpoints36.endpoints_r_index != field_data_endpoints64.endpoints_r_index) AND (field_data_endpoints36.endpoints_r_index != field_data_endpoints66.endpoints_r_index) AND (field_data_endpoints36.endpoints_r_index != field_data_endpoints68.endpoints_r_index) AND (field_data_endpoints36.endpoints_r_index != field_data_endpoints70.endpoints_r_index) AND (field_data_endpoints36.endpoints_r_index != field_data_endpoints72.endpoints_r_index) AND (field_data_endpoints36.endpoints_r_index != field_data_endpoints74.endpoints_r_index) AND (field_data_endpoints36.endpoints_r_index != field_data_endpoints76.endpoints_r_index) AND (field_data_endpoints36.endpoints_r_index != field_data_endpoints78.endpoints_r_index) AND (field_data_endpoints36.endpoints_r_index != field_data_endpoints80.endpoints_r_index) AND (field_data_endpoints38.endpoints_r_index != field_data_endpoints40.endpoints_r_index) AND (field_data_endpoints38.endpoints_r_index != field_data_endpoints42.endpoints_r_index) AND (field_data_endpoints38.endpoints_r_index != field_data_endpoints44.endpoints_r_index) AND (field_data_endpoints38.endpoints_r_index != field_data_endpoints46.endpoints_r_index) AND (field_data_endpoints38.endpoints_r_index != field_data_endpoints48.endpoints_r_index) AND (field_data_endpoints38.endpoints_r_index != field_data_endpoints50.endpoints_r_index) AND (field_data_endpoints38.endpoints_r_index != field_data_endpoints52.endpoints_r_index) AND (field_data_endpoints38.endpoints_r_index != field_data_endpoints54.endpoints_r_index) AND (field_data_endpoints38.endpoints_r_index != field_data_endpoints56.endpoints_r_index) AND (field_data_endpoints38.endpoints_r_index != field_data_endpoints58.endpoints_r_index) AND (field_data_endpoints38.endpoints_r_index != field_data_endpoints60.endpoints_r_index) AND (field_data_endpoints38.endpoints_r_index != field_data_endpoints62.endpoints_r_index) AND (field_data_endpoints38.endpoints_r_index != field_data_endpoints64.endpoints_r_index) AND (field_data_endpoints38.endpoints_r_index != field_data_endpoints66.endpoints_r_index) AND (field_data_endpoints38.endpoints_r_index != field_data_endpoints68.endpoints_r_index) AND (field_data_endpoints38.endpoints_r_index != field_data_endpoints70.endpoints_r_index) AND (field_data_endpoints38.endpoints_r_index != field_data_endpoints72.endpoints_r_index) AND (field_data_endpoints38.endpoints_r_index != field_data_endpoints74.endpoints_r_index) AND (field_data_endpoints38.endpoints_r_index != field_data_endpoints76.endpoints_r_index) AND (field_data_endpoints38.endpoints_r_index != field_data_endpoints78.endpoints_r_index) AND (field_data_endpoints38.endpoints_r_index != field_data_endpoints80.endpoints_r_index) AND (field_data_endpoints40.endpoints_r_index != field_data_endpoints42.endpoints_r_index) AND (field_data_endpoints40.endpoints_r_index != field_data_endpoints44.endpoints_r_index) AND (field_data_endpoints40.endpoints_r_index != field_data_endpoints46.endpoints_r_index) AND (field_data_endpoints40.endpoints_r_index != field_data_endpoints48.endpoints_r_index) AND (field_data_endpoints40.endpoints_r_index != field_data_endpoints50.endpoints_r_index) AND (field_data_endpoints40.endpoints_r_index != field_data_endpoints52.endpoints_r_index) AND (field_data_endpoints40.endpoints_r_index != field_data_endpoints54.endpoints_r_index) AND (field_data_endpoints40.endpoints_r_index != field_data_endpoints56.endpoints_r_index) AND (field_data_endpoints40.endpoints_r_index != field_data_endpoints58.endpoints_r_index) AND (field_data_endpoints40.endpoints_r_index != field_data_endpoints60.endpoints_r_index) AND (field_data_endpoints40.endpoints_r_index != field_data_endpoints62.endpoints_r_index) AND (field_data_endpoints40.endpoints_r_index != field_data_endpoints64.endpoints_r_index) AND (field_data_endpoints40.endpoints_r_index != field_data_endpoints66.endpoints_r_index) AND (field_data_endpoints40.endpoints_r_index != field_data_endpoints68.endpoints_r_index) AND (field_data_endpoints40.endpoints_r_index != field_data_endpoints70.endpoints_r_index) AND (field_data_endpoints40.endpoints_r_index != field_data_endpoints72.endpoints_r_index) AND (field_data_endpoints40.endpoints_r_index != field_data_endpoints74.endpoints_r_index) AND (field_data_endpoints40.endpoints_r_index != field_data_endpoints76.endpoints_r_index) AND (field_data_endpoints40.endpoints_r_index != field_data_endpoints78.endpoints_r_index) AND (field_data_endpoints40.endpoints_r_index != field_data_endpoints80.endpoints_r_index) AND (field_data_endpoints42.endpoints_r_index != field_data_endpoints44.endpoints_r_index) AND (field_data_endpoints42.endpoints_r_index != field_data_endpoints46.endpoints_r_index) AND (field_data_endpoints42.endpoints_r_index != field_data_endpoints48.endpoints_r_index) AND (field_data_endpoints42.endpoints_r_index != field_data_endpoints50.endpoints_r_index) AND (field_data_endpoints42.endpoints_r_index != field_data_endpoints52.endpoints_r_index) AND (field_data_endpoints42.endpoints_r_index != field_data_endpoints54.endpoints_r_index) AND (field_data_endpoints42.endpoints_r_index != field_data_endpoints56.endpoints_r_index) AND (field_data_endpoints42.endpoints_r_index != field_data_endpoints58.endpoints_r_index) AND (field_data_endpoints42.endpoints_r_index != field_data_endpoints60.endpoints_r_index) AND (field_data_endpoints42.endpoints_r_index != field_data_endpoints62.endpoints_r_index) AND (field_data_endpoints42.endpoints_r_index != field_data_endpoints64.endpoints_r_index) AND (field_data_endpoints42.endpoints_r_index != field_data_endpoints66.endpoints_r_index) AND (field_data_endpoints42.endpoints_r_index != field_data_endpoints68.endpoints_r_index) AND (field_data_endpoints42.endpoints_r_index != field_data_endpoints70.endpoints_r_index) AND (field_data_endpoints42.endpoints_r_index != field_data_endpoints72.endpoints_r_index) AND (field_data_endpoints42.endpoints_r_index != field_data_endpoints74.endpoints_r_index) AND (field_data_endpoints42.endpoints_r_index != field_data_endpoints76.endpoints_r_index) AND (field_data_endpoints42.endpoints_r_index != field_data_endpoints78.endpoints_r_index) AND (field_data_endpoints42.endpoints_r_index != field_data_endpoints80.endpoints_r_index) AND (field_data_endpoints44.endpoints_r_index != field_data_endpoints46.endpoints_r_index) AND (field_data_endpoints44.endpoints_r_index != field_data_endpoints48.endpoints_r_index) AND (field_data_endpoints44.endpoints_r_index != field_data_endpoints50.endpoints_r_index) AND (field_data_endpoints44.endpoints_r_index != field_data_endpoints52.endpoints_r_index) AND (field_data_endpoints44.endpoints_r_index != field_data_endpoints54.endpoints_r_index) AND (field_data_endpoints44.endpoints_r_index != field_data_endpoints56.endpoints_r_index) AND (field_data_endpoints44.endpoints_r_index != field_data_endpoints58.endpoints_r_index) AND (field_data_endpoints44.endpoints_r_index != field_data_endpoints60.endpoints_r_index) AND (field_data_endpoints44.endpoints_r_index != field_data_endpoints62.endpoints_r_index) AND (field_data_endpoints44.endpoints_r_index != field_data_endpoints64.endpoints_r_index) AND (field_data_endpoints44.endpoints_r_index != field_data_endpoints66.endpoints_r_index) AND (field_data_endpoints44.endpoints_r_index != field_data_endpoints68.endpoints_r_index) AND (field_data_endpoints44.endpoints_r_index != field_data_endpoints70.endpoints_r_index) AND (field_data_endpoints44.endpoints_r_index != field_data_endpoints72.endpoints_r_index) AND (field_data_endpoints44.endpoints_r_index != field_data_endpoints74.endpoints_r_index) AND (field_data_endpoints44.endpoints_r_index != field_data_endpoints76.endpoints_r_index) AND (field_data_endpoints44.endpoints_r_index != field_data_endpoints78.endpoints_r_index) AND (field_data_endpoints44.endpoints_r_index != field_data_endpoints80.endpoints_r_index) AND (field_data_endpoints46.endpoints_r_index != field_data_endpoints48.endpoints_r_index) AND (field_data_endpoints46.endpoints_r_index != field_data_endpoints50.endpoints_r_index) AND (field_data_endpoints46.endpoints_r_index != field_data_endpoints52.endpoints_r_index) AND (field_data_endpoints46.endpoints_r_index != field_data_endpoints54.endpoints_r_index) AND (field_data_endpoints46.endpoints_r_index != field_data_endpoints56.endpoints_r_index) AND (field_data_endpoints46.endpoints_r_index != field_data_endpoints58.endpoints_r_index) AND (field_data_endpoints46.endpoints_r_index != field_data_endpoints60.endpoints_r_index) AND (field_data_endpoints46.endpoints_r_index != field_data_endpoints62.endpoints_r_index) AND (field_data_endpoints46.endpoints_r_index != field_data_endpoints64.endpoints_r_index) AND (field_data_endpoints46.endpoints_r_index != field_data_endpoints66.endpoints_r_index) AND (field_data_endpoints46.endpoints_r_index != field_data_endpoints68.endpoints_r_index) AND (field_data_endpoints46.endpoints_r_index != field_data_endpoints70.endpoints_r_index) AND (field_data_endpoints46.endpoints_r_index != field_data_endpoints72.endpoints_r_index) AND (field_data_endpoints46.endpoints_r_index != field_data_endpoints74.endpoints_r_index) AND (field_data_endpoints46.endpoints_r_index != field_data_endpoints76.endpoints_r_index) AND (field_data_endpoints46.endpoints_r_index != field_data_endpoints78.endpoints_r_index) AND (field_data_endpoints46.endpoints_r_index != field_data_endpoints80.endpoints_r_index) AND (field_data_endpoints48.endpoints_r_index != field_data_endpoints50.endpoints_r_index) AND (field_data_endpoints48.endpoints_r_index != field_data_endpoints52.endpoints_r_index) AND (field_data_endpoints48.endpoints_r_index != field_data_endpoints54.endpoints_r_index) AND (field_data_endpoints48.endpoints_r_index != field_data_endpoints56.endpoints_r_index) AND (field_data_endpoints48.endpoints_r_index != field_data_endpoints58.endpoints_r_index) AND (field_data_endpoints48.endpoints_r_index != field_data_endpoints60.endpoints_r_index) AND (field_data_endpoints48.endpoints_r_index != field_data_endpoints62.endpoints_r_index) AND (field_data_endpoints48.endpoints_r_index != field_data_endpoints64.endpoints_r_index) AND (field_data_endpoints48.endpoints_r_index != field_data_endpoints66.endpoints_r_index) AND (field_data_endpoints48.endpoints_r_index != field_data_endpoints68.endpoints_r_index) AND (field_data_endpoints48.endpoints_r_index != field_data_endpoints70.endpoints_r_index) AND (field_data_endpoints48.endpoints_r_index != field_data_endpoints72.endpoints_r_index) AND (field_data_endpoints48.endpoints_r_index != field_data_endpoints74.endpoints_r_index) AND (field_data_endpoints48.endpoints_r_index != field_data_endpoints76.endpoints_r_index) AND (field_data_endpoints48.endpoints_r_index != field_data_endpoints78.endpoints_r_index) AND (field_data_endpoints48.endpoints_r_index != field_data_endpoints80.endpoints_r_index) AND (field_data_endpoints50.endpoints_r_index != field_data_endpoints52.endpoints_r_index) AND (field_data_endpoints50.endpoints_r_index != field_data_endpoints54.endpoints_r_index) AND (field_data_endpoints50.endpoints_r_index != field_data_endpoints56.endpoints_r_index) AND (field_data_endpoints50.endpoints_r_index != field_data_endpoints58.endpoints_r_index) AND (field_data_endpoints50.endpoints_r_index != field_data_endpoints60.endpoints_r_index) AND (field_data_endpoints50.endpoints_r_index != field_data_endpoints62.endpoints_r_index) AND (field_data_endpoints50.endpoints_r_index != field_data_endpoints64.endpoints_r_index) AND (field_data_endpoints50.endpoints_r_index != field_data_endpoints66.endpoints_r_index) AND (field_data_endpoints50.endpoints_r_index != field_data_endpoints68.endpoints_r_index) AND (field_data_endpoints50.endpoints_r_index != field_data_endpoints70.endpoints_r_index) AND (field_data_endpoints50.endpoints_r_index != field_data_endpoints72.endpoints_r_index) AND (field_data_endpoints50.endpoints_r_index != field_data_endpoints74.endpoints_r_index) AND (field_data_endpoints50.endpoints_r_index != field_data_endpoints76.endpoints_r_index) AND (field_data_endpoints50.endpoints_r_index != field_data_endpoints78.endpoints_r_index) AND (field_data_endpoints50.endpoints_r_index != field_data_endpoints80.endpoints_r_index) AND (field_data_endpoints52.endpoints_r_index != field_data_endpoints54.endpoints_r_index) AND (field_data_endpoints52.endpoints_r_index != field_data_endpoints56.endpoints_r_index) AND (field_data_endpoints52.endpoints_r_index != field_data_endpoints58.endpoints_r_index) AND (field_data_endpoints52.endpoints_r_index != field_data_endpoints60.endpoints_r_index) AND (field_data_endpoints52.endpoints_r_index != field_data_endpoints62.endpoints_r_index) AND (field_data_endpoints52.endpoints_r_index != field_data_endpoints64.endpoints_r_index) AND (field_data_endpoints52.endpoints_r_index != field_data_endpoints66.endpoints_r_index) AND (field_data_endpoints52.endpoints_r_index != field_data_endpoints68.endpoints_r_index) AND (field_data_endpoints52.endpoints_r_index != field_data_endpoints70.endpoints_r_index) AND (field_data_endpoints52.endpoints_r_index != field_data_endpoints72.endpoints_r_index) AND (field_data_endpoints52.endpoints_r_index != field_data_endpoints74.endpoints_r_index) AND (field_data_endpoints52.endpoints_r_index != field_data_endpoints76.endpoints_r_index) AND (field_data_endpoints52.endpoints_r_index != field_data_endpoints78.endpoints_r_index) AND (field_data_endpoints52.endpoints_r_index != field_data_endpoints80.endpoints_r_index) AND (field_data_endpoints54.endpoints_r_index != field_data_endpoints56.endpoints_r_index) AND (field_data_endpoints54.endpoints_r_index != field_data_endpoints58.endpoints_r_index) AND (field_data_endpoints54.endpoints_r_index != field_data_endpoints60.endpoints_r_index) AND (field_data_endpoints54.endpoints_r_index != field_data_endpoints62.endpoints_r_index) AND (field_data_endpoints54.endpoints_r_index != field_data_endpoints64.endpoints_r_index) AND (field_data_endpoints54.endpoints_r_index != field_data_endpoints66.endpoints_r_index) AND (field_data_endpoints54.endpoints_r_index != field_data_endpoints68.endpoints_r_index) AND (field_data_endpoints54.endpoints_r_index != field_data_endpoints70.endpoints_r_index) AND (field_data_endpoints54.endpoints_r_index != field_data_endpoints72.endpoints_r_index) AND (field_data_endpoints54.endpoints_r_index != field_data_endpoints74.endpoints_r_index) AND (field_data_endpoints54.endpoints_r_index != field_data_endpoints76.endpoints_r_index) AND (field_data_endpoints54.endpoints_r_index != field_data_endpoints78.endpoints_r_index) AND (field_data_endpoints54.endpoints_r_index != field_data_endpoints80.endpoints_r_index) AND (field_data_endpoints56.endpoints_r_index != field_data_endpoints58.endpoints_r_index) AND (field_data_endpoints56.endpoints_r_index != field_data_endpoints60.endpoints_r_index) AND (field_data_endpoints56.endpoints_r_index != field_data_endpoints62.endpoints_r_index) AND (field_data_endpoints56.endpoints_r_index != field_data_endpoints64.endpoints_r_index) AND (field_data_endpoints56.endpoints_r_index != field_data_endpoints66.endpoints_r_index) AND (field_data_endpoints56.endpoints_r_index != field_data_endpoints68.endpoints_r_index) AND (field_data_endpoints56.endpoints_r_index != field_data_endpoints70.endpoints_r_index) AND (field_data_endpoints56.endpoints_r_index != field_data_endpoints72.endpoints_r_index) AND (field_data_endpoints56.endpoints_r_index != field_data_endpoints74.endpoints_r_index) AND (field_data_endpoints56.endpoints_r_index != field_data_endpoints76.endpoints_r_index) AND (field_data_endpoints56.endpoints_r_index != field_data_endpoints78.endpoints_r_index) AND (field_data_endpoints56.endpoints_r_index != field_data_endpoints80.endpoints_r_index) AND (field_data_endpoints58.endpoints_r_index != field_data_endpoints60.endpoints_r_index) AND (field_data_endpoints58.endpoints_r_index != field_data_endpoints62.endpoints_r_index) AND (field_data_endpoints58.endpoints_r_index != field_data_endpoints64.endpoints_r_index) AND (field_data_endpoints58.endpoints_r_index != field_data_endpoints66.endpoints_r_index) AND (field_data_endpoints58.endpoints_r_index != field_data_endpoints68.endpoints_r_index) AND (field_data_endpoints58.endpoints_r_index != field_data_endpoints70.endpoints_r_index) AND (field_data_endpoints58.endpoints_r_index != field_data_endpoints72.endpoints_r_index) AND (field_data_endpoints58.endpoints_r_index != field_data_endpoints74.endpoints_r_index) AND (field_data_endpoints58.endpoints_r_index != field_data_endpoints76.endpoints_r_index) AND (field_data_endpoints58.endpoints_r_index != field_data_endpoints78.endpoints_r_index) AND (field_data_endpoints58.endpoints_r_index != field_data_endpoints80.endpoints_r_index) AND (field_data_endpoints60.endpoints_r_index != field_data_endpoints62.endpoints_r_index) AND (field_data_endpoints60.endpoints_r_index != field_data_endpoints64.endpoints_r_index) AND (field_data_endpoints60.endpoints_r_index != field_data_endpoints66.endpoints_r_index) AND (field_data_endpoints60.endpoints_r_index != field_data_endpoints68.endpoints_r_index) AND (field_data_endpoints60.endpoints_r_index != field_data_endpoints70.endpoints_r_index) AND (field_data_endpoints60.endpoints_r_index != field_data_endpoints72.endpoints_r_index) AND (field_data_endpoints60.endpoints_r_index != field_data_endpoints74.endpoints_r_index) AND (field_data_endpoints60.endpoints_r_index != field_data_endpoints76.endpoints_r_index) AND (field_data_endpoints60.endpoints_r_index != field_data_endpoints78.endpoints_r_index) AND (field_data_endpoints60.endpoints_r_index != field_data_endpoints80.endpoints_r_index) AND (field_data_endpoints62.endpoints_r_index != field_data_endpoints64.endpoints_r_index) AND (field_data_endpoints62.endpoints_r_index != field_data_endpoints66.endpoints_r_index) AND (field_data_endpoints62.endpoints_r_index != field_data_endpoints68.endpoints_r_index) AND (field_data_endpoints62.endpoints_r_index != field_data_endpoints70.endpoints_r_index) AND (field_data_endpoints62.endpoints_r_index != field_data_endpoints72.endpoints_r_index) AND (field_data_endpoints62.endpoints_r_index != field_data_endpoints74.endpoints_r_index) AND (field_data_endpoints62.endpoints_r_index != field_data_endpoints76.endpoints_r_index) AND (field_data_endpoints62.endpoints_r_index != field_data_endpoints78.endpoints_r_index) AND (field_data_endpoints62.endpoints_r_index != field_data_endpoints80.endpoints_r_index) AND (field_data_endpoints64.endpoints_r_index != field_data_endpoints66.endpoints_r_index) AND (field_data_endpoints64.endpoints_r_index != field_data_endpoints68.endpoints_r_index) AND (field_data_endpoints64.endpoints_r_index != field_data_endpoints70.endpoints_r_index) AND (field_data_endpoints64.endpoints_r_index != field_data_endpoints72.endpoints_r_index) AND (field_data_endpoints64.endpoints_r_index != field_data_endpoints74.endpoints_r_index) AND (field_data_endpoints64.endpoints_r_index != field_data_endpoints76.endpoints_r_index) AND (field_data_endpoints64.endpoints_r_index != field_data_endpoints78.endpoints_r_index) AND (field_data_endpoints64.endpoints_r_index != field_data_endpoints80.endpoints_r_index) AND (field_data_endpoints66.endpoints_r_index != field_data_endpoints68.endpoints_r_index) AND (field_data_endpoints66.endpoints_r_index != field_data_endpoints70.endpoints_r_index) AND (field_data_endpoints66.endpoints_r_index != field_data_endpoints72.endpoints_r_index) AND (field_data_endpoints66.endpoints_r_index != field_data_endpoints74.endpoints_r_index) AND (field_data_endpoints66.endpoints_r_index != field_data_endpoints76.endpoints_r_index) AND (field_data_endpoints66.endpoints_r_index != field_data_endpoints78.endpoints_r_index) AND (field_data_endpoints66.endpoints_r_index != field_data_endpoints80.endpoints_r_index) AND (field_data_endpoints68.endpoints_r_index != field_data_endpoints70.endpoints_r_index) AND (field_data_endpoints68.endpoints_r_index != field_data_endpoints72.endpoints_r_index) AND (field_data_endpoints68.endpoints_r_index != field_data_endpoints74.endpoints_r_index) AND (field_data_endpoints68.endpoints_r_index != field_data_endpoints76.endpoints_r_index) AND (field_data_endpoints68.endpoints_r_index != field_data_endpoints78.endpoints_r_index) AND (field_data_endpoints68.endpoints_r_index != field_data_endpoints80.endpoints_r_index) AND (field_data_endpoints70.endpoints_r_index != field_data_endpoints72.endpoints_r_index) AND (field_data_endpoints70.endpoints_r_index != field_data_endpoints74.endpoints_r_index) AND (field_data_endpoints70.endpoints_r_index != field_data_endpoints76.endpoints_r_index) AND (field_data_endpoints70.endpoints_r_index != field_data_endpoints78.endpoints_r_index) AND (field_data_endpoints70.endpoints_r_index != field_data_endpoints80.endpoints_r_index) AND (field_data_endpoints72.endpoints_r_index != field_data_endpoints74.endpoints_r_index) AND (field_data_endpoints72.endpoints_r_index != field_data_endpoints76.endpoints_r_index) AND (field_data_endpoints72.endpoints_r_index != field_data_endpoints78.endpoints_r_index) AND (field_data_endpoints72.endpoints_r_index != field_data_endpoints80.endpoints_r_index) AND (field_data_endpoints74.endpoints_r_index != field_data_endpoints76.endpoints_r_index) AND (field_data_endpoints74.endpoints_r_index != field_data_endpoints78.endpoints_r_index) AND (field_data_endpoints74.endpoints_r_index != field_data_endpoints80.endpoints_r_index) AND (field_data_endpoints76.endpoints_r_index != field_data_endpoints78.endpoints_r_index) AND (field_data_endpoints76.endpoints_r_index != field_data_endpoints80.endpoints_r_index) AND (field_data_endpoints78.endpoints_r_index != field_data_endpoints80.endpoints_r_index) ;
Array ( [:db_condition_placeholder_0] => node [:db_condition_placeholder_1] => 226368 [:db_condition_placeholder_2] => node [:db_condition_placeholder_3] => 263113 [:db_condition_placeholder_4] => node [:db_condition_placeholder_5] => 260780 [:db_condition_placeholder_6] => node [:db_condition_placeholder_7] => 226369 [:db_condition_placeholder_8] => node [:db_condition_placeholder_9] => 260072 [:db_condition_placeholder_10] => node [:db_condition_placeholder_11] => 260600 [:db_condition_placeholder_12] => node [:db_condition_placeholder_13] => 260746 [:db_condition_placeholder_14] => node [:db_condition_placeholder_15] => 260900 [:db_condition_placeholder_16] => node [:db_condition_placeholder_17] => 263033 [:db_condition_placeholder_18] => node [:db_condition_placeholder_19] => 118392 [:db_condition_placeholder_20] => node [:db_condition_placeholder_21] => 121328 [:db_condition_placeholder_22] => node [:db_condition_placeholder_23] => 121490 [:db_condition_placeholder_24] => node [:db_condition_placeholder_25] => 200199 [:db_condition_placeholder_26] => node [:db_condition_placeholder_27] => 204067 [:db_condition_placeholder_28] => node [:db_condition_placeholder_29] => 209041 [:db_condition_placeholder_30] => node [:db_condition_placeholder_31] => 217473 [:db_condition_placeholder_32] => node [:db_condition_placeholder_33] => 217609 [:db_condition_placeholder_34] => node [:db_condition_placeholder_35] => 233172 [:db_condition_placeholder_36] => node [:db_condition_placeholder_37] => 233170 [:db_condition_placeholder_38] => node [:db_condition_placeholder_39] => 239050 [:db_condition_placeholder_40] => node [:db_condition_placeholder_41] => 237683 [:db_condition_placeholder_42] => node [:db_condition_placeholder_43] => 237682 [:db_condition_placeholder_44] => node [:db_condition_placeholder_45] => 237681 [:db_condition_placeholder_46] => node [:db_condition_placeholder_47] => 237680 [:db_condition_placeholder_48] => node [:db_condition_placeholder_49] => 235997 [:db_condition_placeholder_50] => node [:db_condition_placeholder_51] => 235996 [:db_condition_placeholder_52] => node [:db_condition_placeholder_53] => 232994 [:db_condition_placeholder_54] => node [:db_condition_placeholder_55] => 226471 [:db_condition_placeholder_56] => node [:db_condition_placeholder_57] => 226470 [:db_condition_placeholder_58] => node [:db_condition_placeholder_59] => 261230 [:db_condition_placeholder_60] => node [:db_condition_placeholder_61] => 116961 [:db_condition_placeholder_62] => node [:db_condition_placeholder_63] => 116962 [:db_condition_placeholder_64] => node [:db_condition_placeholder_65] => 116963 [:db_condition_placeholder_66] => node [:db_condition_placeholder_67] => 116964 [:db_condition_placeholder_68] => node [:db_condition_placeholder_69] => 116965 [:db_condition_placeholder_70] => node [:db_condition_placeholder_71] => 116966 [:db_condition_placeholder_72] => node [:db_condition_placeholder_73] => 116967 [:db_condition_placeholder_74] => node [:db_condition_placeholder_75] => 116968 [:db_condition_placeholder_76] => node [:db_condition_placeholder_77] => 116969 [:db_condition_placeholder_78] => node [:db_condition_placeholder_79] => 116970 [:db_condition_placeholder_80] => node [:db_condition_placeholder_81] => 116971 [:db_condition_placeholder_82] => 0 [:db_condition_placeholder_83] => translation [:db_condition_placeholder_84] => 41 [:db_condition_placeholder_85] => relation ) in field_sql_storage_field_storage_query() (line 584 of ~/modules/field_sql_storage/field_sql_storage.module).
The website encountered an unexpected error. Please try again later.
| Comment | File | Size | Author |
|---|---|---|---|
| #12 | join_table_limit_exceeded-1970156-12.patch | 767 bytes | burningdog |
| #15 | join_table_limit_exceeded-1970156-15.patch | 765 bytes | burningdog |
| #7 | join_table_limit_exceeded-1970156-7.patch | 522 bytes | burningdog |
| #4 | join_table_limit_exceeded-1970156-4.patch | 1006 bytes | burningdog |
| #3 | 1970156_dbquery_error1.txt | 127.22 KB | burningdog |
Comments
Comment #1
naught101 commentedWell, the SELECT DISTINCT kind of indicates that this is a relation_select thing, since the relation code doesn't have a distinct call in it, while relation select has
,
This bug is crazy, man. 61 Joins?
Comment #2
burningdog commentedRelated issues:
#1649398: Performance issues with many relations
#1859084: Conditions on multi-column fields in EntityFieldQuery
Looks like the bug happens around line 604 in relation.module - the comment reads:
So, each endpoint condition adds 2 joins to the query. 30 endpoints = 60 joins. I don't know the relation module well enough to figure out what is going on here.
I applied the patch at #14 at #1859084: Conditions on multi-column fields in EntityFieldQuery to core which seemed to solve the "too many tables" join error, but I got a new one instead:
(Full db query attached). This error happens too when simply saving a node which has existing relations, without making any changes.
Should I expect that patch to solve the "too many tables" join error?
Comment #3
burningdog commentedNext iteration: changing the above code in the relation module to:
...which then gives rise to this error:
Full sql query attached.
Comment #4
burningdog commentedThe problem now is that there are far less joins than query conditions. In the above query, the last condition is:
but the last join is
The solution is have the same amount of conditions - field_data_endpoints_delta_X's - as joins, like so:
The query then runs fine. Patch attached. Note: the automated test for this will probably fail because #14 from #1859084: Conditions on multi-column fields in EntityFieldQuery has to be applied to core first.
Comment #6
burningdog commentedOk, test failed, as expected: could this be because the core patch hasn't been applied on the testing server? How do we proceed?
Comment #7
burningdog commentedOk, I'm new to simpletest, so may be doing something wrong, but when I ran the tests for the Relation module locally using latest (7.22) drupal (without the core patch applied) and latest Relation (7.x-1.0-rc4, also unpatched) I couldn't get the basic
RelationAPITestCase->testRelationQuery()to pass, and I expected it to.From the simpletest table:
"The test did not complete due to a fatal error. | Completion check | RelationAPITestCase->testRelationQuery() | 227 | modules/relation/tests/relation.test |"Either I've done something screwy with my local setup, or there's something screwy with the testRelationQuery() test. Attached patch tests that.
Comment #8
burningdog commentedComment #9
burningdog commentedOk, so the test passes, so I must have something screwy in my local setup. /me scratches head...
Comment #10
mikran commentedI think that's not correct, this would basically only apply condition to half of endpoints. Correct fix is to remove the hack, *2 from table names, like:
But it's tricky situation. We can't rely on patch to core to be applied and once it's in core we have to make sure that Relation is functional with new core and old, at the same time.
Comment #11
mikran commentedAnd to answer your question whether #1859084: Conditions on multi-column fields in EntityFieldQuery will solve this issue or not. It won't. It just raises the limit to roughly double the amount of endpoints. Basically you'd need to avoid calling relation_relation_exists(), it's inefficient way to figure out if relation exists for relations with too many endpoints.
Comment #12
burningdog commentedYeah, I understand. What about a new 7.x-2.x branch which is compatible with the core patch (once/if it gets in)?
Patch attached with your fix. I tested locally; it fails on an unpatched core with
PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'field_data_endpoints_delta_0.endpoints_r_index' in 'where clause':but passes on patched core.Comment #14
burningdog commentedre: #11 and avoiding the call to relation_relation_exists() - I don't see any calls to that in relation.module, and I'm not sure how it's directly related to the big sql query that this issue opened with. Could you please point me to the file and code block you are referring to?
Comment #15
burningdog commentedComment #17
mikran commentedre: #14 relation_relation_exists() is only place that can cause relation_query_enforce_distinct_endpoints_alter() to be ran, by adding a tag to query obviously.
Comment #19
mikran commentedOk now we have two issues open with same fix while not really duplicates.
So I'll close this one as won't fix and the same patch will be made available at #1760026: self to self relation validation is broken for unique relations