query.sql

SELECT "message_images"."id" AS t0_r0,
       "message_images"."name" AS t0_r1,
       "message_images"."name_on_disk" AS t0_r2,
       "message_images"."entity_id" AS t0_r3,
       "message_images"."created_by" AS t0_r4,
       "message_images"."create_method" AS t0_r5,
       "message_images"."created_on" AS t0_r6,
       "message_images"."modified_by" AS t0_r7,
       "message_images"."updated_on" AS t0_r8,
       "message_images"."activate_at" AS t0_r9,
       "message_images"."version_id" AS t0_r10,
       "message_images"."status_id" AS t0_r11,
       "message_images"."image_type_id" AS t0_r12,
       "message_images"."text_coord_x" AS t0_r13,
       "message_images"."text_coord_y" AS t0_r14,
       "message_images"."text_width" AS t0_r15,
       "message_images"."text_height" AS t0_r16,
       "message_images"."include_text" AS t0_r17,
       "message_images"."message_type_group_id" AS t0_r18,
       "message_images"."include_secondary_text" AS t0_r19,
       "message_images"."secondary_text_width" AS t0_r20,
       "message_images"."secondary_text_height" AS t0_r21,
       "message_images"."secondary_text_coord_x" AS t0_r22,
       "message_images"."secondary_text_coord_y" AS t0_r23,
       "message_images"."library_id" AS t0_r24,
       "entities"."id" AS t1_r0,
       "entities"."entity_type_id" AS t1_r1,
       "entities"."name" AS t1_r2,
       "entities"."info" AS t1_r3,
       "entities"."enterprise" AS t1_r4,
       "entities"."lft" AS t1_r5,
       "entities"."rgt" AS t1_r6,
       "entities"."parent_id" AS t1_r7,
       "entities"."signature" AS t1_r8,
       "entities"."segment_type_id" AS t1_r9,
       "entities"."created_by" AS t1_r10,
       "entities"."create_method" AS t1_r11,
       "entities"."created_on" AS t1_r12,
       "entities"."modified_by" AS t1_r13,
       "entities"."updated_on" AS t1_r14,
       "entities"."update_sw_version" AS t1_r15,
       "entities"."store_number" AS t1_r16,
       "entities"."billing_status" AS t1_r17,
       "entities"."sign_up_date" AS t1_r18,
       "entities"."paid_date" AS t1_r19,
       "entities"."paid_through_date" AS t1_r20,
       "entities"."active_date" AS t1_r21,
       "entities"."cancel_date" AS t1_r22,
       "entities"."payment_method" AS t1_r23,
       "entities"."billing_interval" AS t1_r24,
       "entities"."fees_upfront" AS t1_r25,
       "entities"."fees_ongoing" AS t1_r26,
       "entities"."contact_name" AS t1_r27,
       "entities"."contact_email" AS t1_r28,
       "entities"."contact_phone" AS t1_r29,
       "entities"."street_address" AS t1_r30,
       "entities"."city" AS t1_r31,
       "entities"."state" AS t1_r32,
       "entities"."zipcode" AS t1_r33,
       "entities"."status" AS t1_r34,
       "entities"."cancel_reason" AS t1_r35,
       "entities"."account_number" AS t1_r36,
       "entities"."has_components" AS t1_r37,
       "entities"."lat" AS t1_r38,
       "entities"."lng" AS t1_r39,
       "entities"."street_address_2" AS t1_r40
FROM "message_images"
LEFT OUTER JOIN "entities" ON "entities".id = "message_images".entity_id
WHERE (message_images.image_type_id=1)
  AND (entities.id=1)
  AND (("message_images"."library_id" = '2'))
ORDER BY message_images.name LIMIT 50
OFFSET 0;