Sackgesicht VIP
Total posts: 1,636
15 Авг 2013 03:51

There is a query in article full view which will return the id of the record, while the record id is already known ....

SELECT fv2.record_id 

  FROM hsb0a_js_res_record_values AS fv2 

  WHERE fv2.section_id = 1 

  AND fv2.field_key = 'k8a53d8bb2823a3b402d48ef0435779ab' 

  AND fv2.field_value IN (SELECT fv1.field_value 

  FROM hsb0a_js_res_record_values fv1 

  WHERE fv1.field_key = 'k8a53d8bb2823a3b402d48ef0435779ab' 

  AND  fv1.record_id = 96762)

Последние изменения: 02 Март 2014


Sergey
Total posts: 13,748
19 Авг 2013 02:27

No this is search algorithm. It searched articles with the same valued in the fields.

For example you have field YEAR and values 2000, 2002. You what other articles with the same values. SUBQUERY search for values in field for current record and query search other records with the same values.

Работает на Cobalt