Search by multiple criteria

An example for multiple criteria

Request

Method: POST
Route: api/idion/idion_mwe/multisearch
Example: api/idion/idion_mwe/multisearch
Input Value
lemma { "q": "αφήνω στον τόπο κάποιον" }
definition { "q": "σκοτώνω κάποιον" }
translation { "q": "to hush, to remain silent" }
Request Headers
host: api.greek.idion.athenarc.gr
user-agent: Symfony
accept: application/json
accept-language: en-us,en;q=0.5
accept-charset: ISO-8859-1,utf-8;q=0.7,*;q=0.7
content-length: 296
content-type: application/json

Response

200 JSON
Response Headers
cache-control: no-cache, private
date: Sat, 17 Feb 2024 20:58:08 GMT
content-type: application/json
x-ratelimit-limit: 60
x-ratelimit-remaining: 59
{
    "handler": "ApiResponse handler",
    "result": {
        "data": [
            {
                "id": 1,
                "variants": [
                    "αφήνω στον τόπο κάποιον"
                ],
                "description": null,
                "html_comment": null,
                "definitions": [
                    {
                        "id": 1,
                        "lemma_id": 1,
                        "definition": "σκοτώνω κάποιον",
                        "language": 1,
                        "definition_comment": "με δαρμό\/κρούση, με πυροβόλο όπλο",
                        "intensification": null,
                        "mitigation": null,
                        "languages": {
                            "id": 1,
                            "value": "Greek"
                        },
                        "style_tags": [],
                        "polarity_tags": [],
                        "emphasis_tags": [],
                        "idion_definition_translations": [
                            {
                                "id": 3179,
                                "language": {
                                    "id": 2,
                                    "value": "English"
                                },
                                "definition_id": 1,
                                "translation": "to knock someone off",
                                "definition_comment": "only by hitting"
                            },
                            {
                                "id": 3180,
                                "language": {
                                    "id": 2,
                                    "value": "English"
                                },
                                "definition_id": 1,
                                "translation": "to kill someone (outright)",
                                "definition_comment": "general"
                            },
                            {
                                "id": 3181,
                                "language": {
                                    "id": 3,
                                    "value": "French"
                                },
                                "definition_id": 1,
                                "translation": "assommer quelqu'un",
                                "definition_comment": "only by hitting"
                            },
                            {
                                "id": 3182,
                                "language": {
                                    "id": 3,
                                    "value": "French"
                                },
                                "definition_id": 1,
                                "translation": "abattre quelqu'un",
                                "definition_comment": "to kill someone using a gun"
                            },
                            {
                                "id": 3183,
                                "language": {
                                    "id": 3,
                                    "value": "French"
                                },
                                "definition_id": 1,
                                "translation": "tuer quelqu'un",
                                "definition_comment": "general"
                            }
                        ]
                    }
                ]
            },
            {
                "id": 8,
                "variants": [
                    "αφήνω σέκο κάποιον"
                ],
                "description": "βλ. και πολυλεκτική έκφραση με τη δεύτερη σημασία\r\nτο λήμμα σέκος προέρχεται από την ιταλική γλώσσα και σημαίνει ξηρός",
                "html_comment": null,
                "definitions": [
                    {
                        "id": 8,
                        "lemma_id": 8,
                        "definition": "παρατάω κάποιον αναίσθητο, σκοτώνω κάποιον",
                        "language": 1,
                        "definition_comment": null,
                        "intensification": null,
                        "mitigation": null,
                        "languages": {
                            "id": 1,
                            "value": "Greek"
                        },
                        "style_tags": [],
                        "polarity_tags": [],
                        "emphasis_tags": [],
                        "idion_definition_translations": [
                            {
                                "id": 113,
                                "language": {
                                    "id": 2,
                                    "value": "English"
                                },
                                "definition_id": 8,
                                "translation": "to knock someone off",
                                "definition_comment": "to kill someone"
                            },
                            {
                                "id": 401,
                                "language": {
                                    "id": 3,
                                    "value": "French"
                                },
                                "definition_id": 8,
                                "translation": "assommer quelqu'un",
                                "definition_comment": null
                            },
                            {
                                "id": 402,
                                "language": {
                                    "id": 3,
                                    "value": "French"
                                },
                                "definition_id": 8,
                                "translation": "abattre quelqu'un",
                                "definition_comment": null
                            },
                            {
                                "id": 403,
                                "language": {
                                    "id": 3,
                                    "value": "French"
                                },
                                "definition_id": 8,
                                "translation": "tuer quelqu'un",
                                "definition_comment": "general"
                            }
                        ]
                    }
                ]
            },
            {
                "id": 229,
                "variants": [
                    "δε βγάζω κιχ"
                ],
                "description": null,
                "html_comment": null,
                "definitions": [
                    {
                        "id": 223,
                        "lemma_id": 229,
                        "definition": "σωπαίνω",
                        "language": 1,
                        "definition_comment": null,
                        "intensification": null,
                        "mitigation": null,
                        "languages": {
                            "id": 1,
                            "value": "Greek"
                        },
                        "style_tags": [],
                        "polarity_tags": [],
                        "emphasis_tags": [],
                        "idion_definition_translations": [
                            {
                                "id": 1,
                                "language": {
                                    "id": 2,
                                    "value": "English"
                                },
                                "definition_id": 223,
                                "translation": "to hush, to remain silent",
                                "definition_comment": null
                            },
                            {
                                "id": 1152,
                                "language": {
                                    "id": 3,
                                    "value": "French"
                                },
                                "definition_id": 223,
                                "translation": "ne dire mot",
                                "definition_comment": null
                            },
                            {
                                "id": 1153,
                                "language": {
                                    "id": 3,
                                    "value": "French"
                                },
                                "definition_id": 223,
                                "translation": "se taire",
                                "definition_comment": null
                            },
                            {
                                "id": 1154,
                                "language": {
                                    "id": 3,
                                    "value": "French"
                                },
                                "definition_id": 223,
                                "translation": "la boucler",
                                "definition_comment": null
                            },
                            {
                                "id": 1636,
                                "language": {
                                    "id": 2,
                                    "value": "English"
                                },
                                "definition_id": 223,
                                "translation": "to not hear a peep",
                                "definition_comment": null
                            },
                            {
                                "id": 1637,
                                "language": {
                                    "id": 2,
                                    "value": "English"
                                },
                                "definition_id": 223,
                                "translation": "to not make a sound",
                                "definition_comment": null
                            }
                        ]
                    }
                ]
            },
            {
                "id": 330,
                "variants": [
                    "αφήνω τέζα κάποιον"
                ],
                "description": null,
                "html_comment": null,
                "definitions": [
                    {
                        "id": 322,
                        "lemma_id": 330,
                        "definition": "σκοτώνω κάποιον, τον παρατάω αναίσθητο",
                        "language": 1,
                        "definition_comment": null,
                        "intensification": null,
                        "mitigation": null,
                        "languages": {
                            "id": 1,
                            "value": "Greek"
                        },
                        "style_tags": [],
                        "polarity_tags": [],
                        "emphasis_tags": [],
                        "idion_definition_translations": [
                            {
                                "id": 49,
                                "language": {
                                    "id": 2,
                                    "value": "English"
                                },
                                "definition_id": 322,
                                "translation": "to knock somebody off",
                                "definition_comment": "to kill someone"
                            },
                            {
                                "id": 261,
                                "language": {
                                    "id": 3,
                                    "value": "French"
                                },
                                "definition_id": 322,
                                "translation": "assommer quelqu'un",
                                "definition_comment": null
                            },
                            {
                                "id": 637,
                                "language": {
                                    "id": 3,
                                    "value": "French"
                                },
                                "definition_id": 322,
                                "translation": "abattre quelqu'un",
                                "definition_comment": null
                            }
                        ]
                    }
                ]
            },
            {
                "id": 332,
                "variants": [
                    "αφήνω ξερό κάποιον"
                ],
                "description": null,
                "html_comment": null,
                "definitions": [
                    {
                        "id": 324,
                        "lemma_id": 332,
                        "definition": "σκοτώνω κάποιον, τον παρατάω αναίσθητο",
                        "language": 1,
                        "definition_comment": null,
                        "intensification": null,
                        "mitigation": null,
                        "languages": {
                            "id": 1,
                            "value": "Greek"
                        },
                        "style_tags": [],
                        "polarity_tags": [],
                        "emphasis_tags": [],
                        "idion_definition_translations": [
                            {
                                "id": 196,
                                "language": {
                                    "id": 2,
                                    "value": "English"
                                },
                                "definition_id": 324,
                                "translation": "to knock somebody off",
                                "definition_comment": "to kill someone"
                            },
                            {
                                "id": 643,
                                "language": {
                                    "id": 3,
                                    "value": "French"
                                },
                                "definition_id": 324,
                                "translation": "assommer quelqu'un",
                                "definition_comment": null
                            },
                            {
                                "id": 644,
                                "language": {
                                    "id": 3,
                                    "value": "French"
                                },
                                "definition_id": 324,
                                "translation": "abattre quelqu'un",
                                "definition_comment": null
                            }
                        ]
                    }
                ]
            },
            {
                "id": 910,
                "variants": [
                    "στέλνω στα θυμαράκια κάποιον"
                ],
                "description": null,
                "html_comment": null,
                "definitions": [
                    {
                        "id": 1286,
                        "lemma_id": 910,
                        "definition": "σκοτώνω κάποιον",
                        "language": 1,
                        "definition_comment": null,
                        "intensification": null,
                        "mitigation": null,
                        "languages": {
                            "id": 1,
                            "value": "Greek"
                        },
                        "style_tags": [
                            {
                                "id": 2,
                                "value": "Colloquial (λαϊκός)",
                                "pivot": {
                                    "definition_id": 1286,
                                    "style_id": 2
                                }
                            }
                        ],
                        "polarity_tags": [
                            {
                                "id": 1,
                                "value": "-",
                                "pivot": {
                                    "definition_id": 1286,
                                    "polarity_id": 1
                                }
                            }
                        ],
                        "emphasis_tags": [
                            {
                                "id": 2,
                                "value": "-",
                                "pivot": {
                                    "definition_id": 1286,
                                    "emphasis_id": 2
                                }
                            }
                        ],
                        "idion_definition_translations": [
                            {
                                "id": 2635,
                                "language": {
                                    "id": 2,
                                    "value": "English"
                                },
                                "definition_id": 1286,
                                "translation": "to knock someone off",
                                "definition_comment": "to kill someone"
                            },
                            {
                                "id": 2690,
                                "language": {
                                    "id": 3,
                                    "value": "French"
                                },
                                "definition_id": 1286,
                                "translation": "envoyer quelqu'un ad patres",
                                "definition_comment": "faire mourrir"
                            }
                        ]
                    }
                ]
            },
            {
                "id": 913,
                "variants": [
                    "κόβω το νήμα της ζωής σε κάποιον ",
                    "κόβω το νήμα της ζωής κάποιου",
                    "του κόβω το νήμα της ζωής"
                ],
                "description": null,
                "html_comment": null,
                "definitions": [
                    {
                        "id": 1269,
                        "lemma_id": 913,
                        "definition": "σκοτώνω κάποιον",
                        "language": 1,
                        "definition_comment": null,
                        "intensification": null,
                        "mitigation": null,
                        "languages": {
                            "id": 1,
                            "value": "Greek"
                        },
                        "style_tags": [
                            {
                                "id": 1,
                                "value": "Formal (τυπικός)",
                                "pivot": {
                                    "definition_id": 1269,
                                    "style_id": 1
                                }
                            }
                        ],
                        "polarity_tags": [
                            {
                                "id": 1,
                                "value": "-",
                                "pivot": {
                                    "definition_id": 1269,
                                    "polarity_id": 1
                                }
                            }
                        ],
                        "emphasis_tags": [
                            {
                                "id": 2,
                                "value": "-",
                                "pivot": {
                                    "definition_id": 1269,
                                    "emphasis_id": 2
                                }
                            }
                        ],
                        "idion_definition_translations": [
                            {
                                "id": 2636,
                                "language": {
                                    "id": 2,
                                    "value": "English"
                                },
                                "definition_id": 1269,
                                "translation": "to knock someone off",
                                "definition_comment": "to kill someone"
                            },
                            {
                                "id": 2689,
                                "language": {
                                    "id": 3,
                                    "value": "French"
                                },
                                "definition_id": 1269,
                                "translation": "couper le fil de la vie de quelqu'un",
                                "definition_comment": null
                            }
                        ]
                    }
                ]
            }
        ]
    },
    "system": {
        "messages": [],
        "status": 200,
        "status_text": "OK",
        "errors": [],
        "error_code": 0
    }
}

Time: 0.7

select * from `idion_mwe` limit 1

Time: 0.88

select * from `idion_definition` where `idion_definition`.`lemma_id` in (1)

Time: 0.76

select * from `language` where `language`.`id` in (1)

Time: 0.82

select `style_tag`.*, `definition_has_style`.`definition_id` as `pivot_definition_id`, `definition_has_style`.`style_id` as `pivot_style_id` from `style_tag` inner join `definition_has_style` on `style_tag`.`id` = `definition_has_style`.`style_id` where `definition_has_style`.`definition_id` in (1)

Time: 0.82

select `polarity_tag`.*, `definition_has_polarity`.`definition_id` as `pivot_definition_id`, `definition_has_polarity`.`polarity_id` as `pivot_polarity_id` from `polarity_tag` inner join `definition_has_polarity` on `polarity_tag`.`id` = `definition_has_polarity`.`polarity_id` where `definition_has_polarity`.`definition_id` in (1)

Time: 0.7

select `emphasis_tag`.*, `definition_has_emphasis`.`definition_id` as `pivot_definition_id`, `definition_has_emphasis`.`emphasis_id` as `pivot_emphasis_id` from `emphasis_tag` inner join `definition_has_emphasis` on `emphasis_tag`.`id` = `definition_has_emphasis`.`emphasis_id` where `definition_has_emphasis`.`definition_id` in (1)

Time: 0.74

select * from `idion_definition_translation` where `idion_definition_translation`.`definition_id` in (1)

Time: 0.63

select * from `language` where `language`.`id` in (2, 3)

Time: 0.7

select * from `idion_definition` limit 1

Time: 0.64

select * from `idion_definition_translation` limit 1

Time: 0.79

select * from `language` where `language`.`id` in (2)

Time: 0.87

select distinct `id` from `idion_mwe` where `hw` LIKE ?
Bindings
0: %αφήνω στον τόπο κάποιον%

Time: 0.68

select * from `idion_definition` where `idion_definition`.`lemma_id` in (1)

Time: 0.62

select * from `language` where `language`.`id` in (1)

Time: 0.74

select `style_tag`.*, `definition_has_style`.`definition_id` as `pivot_definition_id`, `definition_has_style`.`style_id` as `pivot_style_id` from `style_tag` inner join `definition_has_style` on `style_tag`.`id` = `definition_has_style`.`style_id` where `definition_has_style`.`definition_id` in (1)

Time: 0.73

select `polarity_tag`.*, `definition_has_polarity`.`definition_id` as `pivot_definition_id`, `definition_has_polarity`.`polarity_id` as `pivot_polarity_id` from `polarity_tag` inner join `definition_has_polarity` on `polarity_tag`.`id` = `definition_has_polarity`.`polarity_id` where `definition_has_polarity`.`definition_id` in (1)

Time: 0.64

select `emphasis_tag`.*, `definition_has_emphasis`.`definition_id` as `pivot_definition_id`, `definition_has_emphasis`.`emphasis_id` as `pivot_emphasis_id` from `emphasis_tag` inner join `definition_has_emphasis` on `emphasis_tag`.`id` = `definition_has_emphasis`.`emphasis_id` where `definition_has_emphasis`.`definition_id` in (1)

Time: 0.55

select * from `idion_definition_translation` where `idion_definition_translation`.`definition_id` in (1)

Time: 0.57

select * from `language` where `language`.`id` in (2, 3)

Time: 0.73

select distinct `lemma_id` from `idion_definition` where `definition` LIKE ?
Bindings
0: %σκοτώνω κάποιον%

Time: 0.75

select distinct `lemma_id` as `id` from `idion_definition` where exists (select * from `idion_definition_translation` where `idion_definition_translation`.`definition_id` = idion_definition.id and `idion_definition_translation`.`translation` like ?)
Bindings
0: %to hush, to remain silent%

Time: 0.71

select * from `idion_mwe` where `idion_mwe`.`id` in (229, 1, 8, 330, 332, 910, 913)

Time: 0.62

select * from `idion_definition` where `idion_definition`.`lemma_id` in (1, 8, 229, 330, 332, 910, 913)

Time: 0.62

select * from `language` where `language`.`id` in (1)

Time: 0.6

select `style_tag`.*, `definition_has_style`.`definition_id` as `pivot_definition_id`, `definition_has_style`.`style_id` as `pivot_style_id` from `style_tag` inner join `definition_has_style` on `style_tag`.`id` = `definition_has_style`.`style_id` where `definition_has_style`.`definition_id` in (1, 8, 223, 322, 324, 1269, 1286)

Time: 0.73

select `polarity_tag`.*, `definition_has_polarity`.`definition_id` as `pivot_definition_id`, `definition_has_polarity`.`polarity_id` as `pivot_polarity_id` from `polarity_tag` inner join `definition_has_polarity` on `polarity_tag`.`id` = `definition_has_polarity`.`polarity_id` where `definition_has_polarity`.`definition_id` in (1, 8, 223, 322, 324, 1269, 1286)

Time: 0.69

select `emphasis_tag`.*, `definition_has_emphasis`.`definition_id` as `pivot_definition_id`, `definition_has_emphasis`.`emphasis_id` as `pivot_emphasis_id` from `emphasis_tag` inner join `definition_has_emphasis` on `emphasis_tag`.`id` = `definition_has_emphasis`.`emphasis_id` where `definition_has_emphasis`.`definition_id` in (1, 8, 223, 322, 324, 1269, 1286)

Time: 0.74

select * from `idion_definition_translation` where `idion_definition_translation`.`definition_id` in (1, 8, 223, 322, 324, 1269, 1286)

Time: 0.59

select * from `language` where `language`.`id` in (2, 3)

Request

Method: POST
Route: api/idion/idion_mwe/multisearch
Example: api/idion/idion_mwe/multisearch
Input Value
lemma { "q": "αφήνω στον τόπο κάποιον" }
definition { "q": "σκοτώνω κάποιον" }
translation { "q": "to hush, to remain silent" }
Request Headers
host: api.greek.idion.athenarc.gr
user-agent: Symfony
accept: application/json
accept-language: en-us,en;q=0.5
accept-charset: ISO-8859-1,utf-8;q=0.7,*;q=0.7
content-length: 296
content-type: application/json