[
"sql" => "SELECT p0_.id AS id_0, p0_.nome AS nome_1, p0_.slug AS slug_2, p0_.descrizione AS descrizione_3, p0_.prezzo AS prezzo_4, p0_.prezzo_scontato AS prezzo_scontato_5, p0_.tipo AS tipo_6, p0_.stato_pittura AS stato_pittura_7, p0_.scala AS scala_8, p0_.sistema_gioco AS sistema_gioco_9, p0_.fazione AS fazione_10, p0_.quantita_stock AS quantita_stock_11, p0_.disponibile AS disponibile_12, p0_.in_evidenza AS in_evidenza_13, p0_.created_at AS created_at_14, p0_.updated_at AS updated_at_15, c1_.id AS id_16, c1_.nome AS nome_17, c1_.slug AS slug_18, c1_.immagine AS immagine_19, c1_.ordine AS ordine_20, c1_.attiva AS attiva_21, p2_.id AS id_22, p2_.url AS url_23, p2_.ordine AS ordine_24, p0_.categoria_id AS categoria_id_25, p0_.usato_richiesta_id AS usato_richiesta_id_26, c1_.parent_id AS parent_id_27, p2_.prodotto_id AS prodotto_id_28 FROM prodotti p0_ LEFT JOIN categorie c1_ ON p0_.categoria_id = c1_.id LEFT JOIN prodotti_immagini p2_ ON p0_.id = p2_.prodotto_id WHERE p0_.disponibile = 1 ORDER BY p0_.in_evidenza DESC, p0_.created_at DESC, p2_.ordine ASC"
]